| Thread | Last Post | Replies |
|
| conditional processing inside a datagrid? | 26 Jun 2004 03:58 GMT | 3 |
I am trying to make the slow transition from asp to asp .net, I want to display datagrid items based on form name where form name is the only value that stays the same. How can I evaluate the text in (DataBinder.Eval(Container.DataItem,
|
| Row comparison | 26 Jun 2004 02:39 GMT | 3 |
Is there a way to compare the values of portions of two rows? For example, can I test if RowA, columns A,B,C are equal to RowB columns A,B,C and all the while ignoring columns D,E, and F?
|
| Identity columns | 26 Jun 2004 02:31 GMT | 1 |
In my case, the column is defined as PK in Enterprise Manager. My issue is adding a new row to a dataset which includes the PK/Auto increment column. Without setting a value for that column, I get a Null error on the column.add method. I'm going to get to reading your suggestion.
|
| updating data collated in one DataTable back to multiple source DBs | 25 Jun 2004 21:28 GMT | 1 |
I've created an object that collates data from multiple calls from separate databases. The primary key column is a string, the idea being that the most recent calls' values will possibly overwrite values from prior calls to other databases.
|
| Updating a value in a column in a datarow but not affecting RowState | 25 Jun 2004 20:58 GMT | 1 |
Is there a way that will allow a column to be updated within a DataRow without affecting the RowState? I have a Datatable filled with data, but need to be able to update a column with a new value for display purposes, but do not want it to affect the
|
| Newbie code example question | 25 Jun 2004 20:11 GMT | 3 |
I need to copy records from table A to a new table B (overwrite if exists) based on a flag field not set in table A. I then need to set flag for all records in table A that are also in table B. How can I do this in ado.net using vb.net?
|
| SqlConnection performance issues | 25 Jun 2004 18:59 GMT | 2 |
Where can I go to read about performance issues when dealing the sql connections in ADO.NET? Specifically, I am looking for some place that discusses the pros and cons of using a single connection vs. using multiple connections.
|
| row deletion in datagrid | 25 Jun 2004 17:57 GMT | 1 |
i've already sent a request concerning row deletion in a datagrid.my problem now is that i've succeded to delete a row from the datagrid, however the selected row is not actually deleted from the database.(i'm working with visual C++.NET). here is my code:
|
| Building a dataview.rowfilter | 25 Jun 2004 16:50 GMT | 2 |
How do I build a dataview.rowfilter that will return a row for each data field1 and the max in data field2? I tried the following, but it did not work(always returned one row - din 3 uniqueidentifier): dv.rowfilter = "field1 like '%' and max(field2)"
|
| DataView and Compute | 25 Jun 2004 16:11 GMT | 1 |
Is there a way to perform a compute using a DataView that is already Filtered? I am trying to do some statistics on data from a dataset, grouping by day. I have my DataView set up to filter out the appropriate range, project, etc.
|
| evaluate a null datagrid control? | 25 Jun 2004 16:07 GMT | 1 |
I have a stored procedure that returns a single row, depending on the condition the stored procedure will sometimes return some null columns. Is there a way to evaluate if the control is null and then suppress it from display.
|
| DataView Filtering | 25 Jun 2004 15:54 GMT | 1 |
I have a table in a dataset, and I want to find if a record or row exists in the table of the dataset where 3 separate columns have values I pass. I tried using the row filter property but I don't think I am using it right. any help?
|
| empty DataTable fields throw exception | 25 Jun 2004 15:47 GMT | 2 |
I'm having some trouble with a typed dataset that contains fields that should technically be considered null. I've loaded my typed dataset from SQL server. One particular table contains only one row. It has two fields: Agency and CaseType. In the SQL Server table, the Agency field ...
|
| Calling Clear() on empty dataset produces strange behavior. | 25 Jun 2004 14:49 GMT | 1 |
I have the following situation which I use often, but now produces strange behavior: - I have a class derived from a typed dataset. - In this class I defined a method Read for reading data from a web service.
|
| sql server isoloation levels | 25 Jun 2004 14:46 GMT | 1 |
how do I know what sql server isoloation level to use? i don't think i should post this in the sql group because my question is for developing in dot net vb. is anyone in this group setting isolation levels in their code? if so what level are you using?
|