Hi, Using Visual Studio 2005 and SQL Server 2005: I am trying to understand the stored procedures that Strongly Typed Datasets wizard generates for me. When we create a new strongly typed Datasets, and choose the following path: Choose connection-> Create new stored procedures -> Enter...more >>

In my client Windows application, I am receiving a DataSet containing one DataTable. This comes to my client via the business tier on a different physical machine (we're using WCF if that matters). After I make changes to the data in the underlying DataTable, I send the DataSet back to the...more >>

i am facing the probleum in running asp onmy machine. i am using window xp 2000 and also i have installed iis on my machine but the asp does't work plese guide me how can i remove this probleum...more >>

Hi, I'm trying to use an EnterpriseLibrary 3.1 and return recordset from oracle database using stored procedure. As you may know, oracle stored procedures have out parameter of type cursor in order to return a dataset. It seems like I need to add a paramenter of type cursor to execute this ...more >>

Is there an easy way to copy rows from one data set to another other than field by field copy? Thanks Brad ...more >>

Hi group, I have put some validation logic in a trigger and when it doesn't validate I do a rollback + raiserror. So for so good but how do I detect this in ADO.NET ? Is there a way to use raiserror or some othe mechanism to communicate to ado.net/asp.net that someting went wrong? Current...more >>

Hello, Am I correct in thinking that it is currently not possible to perform an SQL JOIN across multiple DataTables in a DataSet in .NET? I have a typed DataSet with three relational tables which need to be placed into one flat table, e.g.: Table A: PK, Table A Col 1, Table A Col 2......more >>

In SQL, I can write: SELECT * FROM Product ORDER BY ISNULL(ProductRank,255) To return: Alpha 1 Delta 2 Golf 3 Foxtrot 4 Charlie 5 Echo NULL Bravo NULL But how can I do this in ADO.NET in a DataView? Right now I just have: view.Sort = "Th...more >>

Hello, I have a asp.net application in which users can create content and then save everything to a SQLServer2000 database. When they hit the save button on the form here is what I do : Dim conn As SqlClient.SqlConnection = New SqlClient.SqlConnection( myconnectionstring ) Dim tx As SqlClien...more >>

I have two seperate .net programs that are working with the same table in a SQL database. Both programs are using TableAdapters to read/ write to the table. Both programs can create a record in their TableAdapters using the same primary key. If this happens and one program updates the databas...more >>

I have a DataTable with column "Sequence". Values are like: Sequence -------- 5 1 3 (blank/null) 7 6 (blank/null) 4 When I create a DataView and do a sort, I get Sequence -------- (blank/null) (blank/null) 1 2 3 4 5 6 7 But I need the blank/nulls to be at the end li...more >>

Is it possible to treat the tables in the dataset the same as any other tables, i.e. run queries on them, etc. ? -- Using Opera's revolutionary e-mail client: http://www.opera.com/mail/...more >>

I feel like I'm forgetting something. Assume Visual Studio 2005 (VB) and assume you have created a data source and dataset by the usual means. Assume multiple tables. Now you have a designer.vb module associated with the dataset containing an InitConnection sub for each table, as well ...more >>

I'm interested in knowing the runtime complexity of the DataTable.Find method in 2.0 when attempting to find a row by the primary key. The MSDN documentation is vague...probably intentionally. I used .NET Reflector to examine the DataTable and what I found is that the primary key index is impl...more >>

I am using an OledbDataReader to read each record into an array of objects, as usual. My question is: is it ever possible that one of the values contained in the array be Nothing. I have never seen it happen and I would believe it is impossible. Can anyone confirm that ...more >>

WTF did Microsoft do when it came to ADO.NET???????????????????????? Using an OLEDB connection and Dataset it took hours to iterate through 5000+ records in one simple table. That is horrible. If I go into Access 2003 and do the same thing with old ADO and create a standard ADO resultset ...more >>

..NET 2.0 I'm working on .NET 2.0 project which contains a DataSet. On this DataSet I can right click on the tables and select "preview data" and I can a preview of table data - which to me shows that VS2005 somehow is connected to the project database. The problem comes when I want to a...more >>

Hello. I'm trying to write to an Excel file via an OleDbConnection. It always fails with the error "Operation must use an updateable query". The Excel file is not read-only and the process has enough rights to write data to the filesystem. Additionally, reading from the file is possible but ...more >>

1. Connection String needs to be customizable by users during runtime. 2. Source of Connection String can be changed programmatically. 3. Tables can be modified by users. 4. Use table adapters or use data adapters 5. How to update all data tables for all datasets with changes in a Wi...more >>

Hi, I am using VS2005, using c++ to build a CLR DLL as an extended stored procedure for an SQL2005 instance. My VS2005 is running on Vista. I built a dll using clr and am tring to use the "deploy" feature from the list of options: BUILD, REBUILD, DEPLOY, CLEAN, ... After some time I ...more >>

Anyone know why the RowFilter has to be double-escaped? Anticipating names with apostrophes, a single escape does not provide the proper name to filter on. For example, this would cause an exception: Dim strname As String strname = txtContact.Text strname.Replace("'", "''") dv.RowFilter =...more >>

Hi, i'm copying a table from one SQL server to another. here i'm just selecting all rows from source table and selecting 0 row from dest table just to create the commands for insert/update/delete etc...now problem is when i do dataadapter.update it will try to insert all new rows in dest tabl...more >>

How may I use the IN operator when using a RowFilter on a DataView? - Such that I can query whether a value is in a column from the Table associated with the DataView. Suppose I have the following table myTable = new DataTable(); myTable.Columns.Add("ActivityID", typ...more >>

Is it possible to process data as it is pulled back in asyc mode? I want to process records as they come back from the SQL Server basically and convert them to local objects... which right now takes a lot of time doing it like this Load data table from SQL Reader Loop through each data row...more >>

Hi. In a WinForms App, I have a DataGridView. My SELECT command uses data from Table A in a SQL Server database plus 4 calculated columns using data from tables TableB and TableC. This works OK. The calculated values are not stored in TableA, of course. I seem to have problems with updati...more >>

Hello all: I hope I'm simply missing something obvious... I have a windows form, on which is a list box and a text box. I have the MouseDown event of the ListBox coded to initiate a drag-and-drop operation: Me.DoDragDrop(ListBox.SelectedItem, DragDropEffects.Copy) and the text box DragDr...more >>

Does Table Adapter contain Data Adapter or the other way around? It seems that Table Adapter exists in VS2005 but not VS2003. ...more >>

I have written a multi threaded Windows service in c#, .net 2.0. The application sends data to a database using stored procedures. The application works fine on a LAN, but I cannot stabilize it over our WAN links. The WAN connectivity is fairly high speed (DS3), but has a high latency (average 2...more >>

I have some complex objects that inherit from DataTable. I want to copy the actual data along with the custom properties and etc, so I don't think I can use the .Copy() method in DataTable. Do I need to override it in some way to make sure the object is truly copies to a new instance when I need...more >>

Simple question for you all. I'm new to ADO.net and i'm trying to run a querry on a SQL 2000 database and return all the rows found to a listbox. Below the code i have returns one item to the listbox and if i run my querry it otherwise should add another 3 items. Is there anyway i can make ...more >>