Hello, I'm using ado.net in my newest project, but their is a little strange thing going on. In form1 I'm having a list of record, by a button a change something in form2 (in fact, its a different data adapter, on a different connection object). But the changes only appear after 2 refreshes (2...more >>

I am deleting my row in this manner: CurrentDataRowView.Delete() CurrentDataRowView.Row.Table.AcceptChanges() Is this way valid? The row is not being removed from the database although it is being removed from the dataset. What else do I have to do? Thanks...more >>

Dear friends After have succesfully create a new account on MSDE using a stored procedure, I have create a new database: Dim sql As String = "CREATE DATABASE " & NomeDB & " ON PRIMARY (name=test, filename = '" & Percorso & "\" & NomeDB & ".mdf')" Dim ConnessioneDiCreazione As String = "Integr...more >>

Hi to all the ADO.NET developers. I have a simple question : Is there a way to choose which columns in the data grid that is bound to a data table are to be visible ? I want to hide some columns that I use only for setting a data relation with another data table. Thanks....more >>

Hi. My code generates a datatable using data from a sqlserver database. I generate a Dataview from this Datatable and bind it to a Datagrid. From the Dataview I can see if my user changed records in the grid, but how can I update the underlying database table? Is it possible to generate a dat...more >>

Hi, I have a typed DataSet with several parent-child relationships that include identity values for primary keys. DataRelations are also set for Update and Delete (Cascade) and Accept/Reject (None). When I update the DataSet with a SqlDataAdapter.Update, the SQL database has the correct reco...more >>

is there a way to open an ADO connection to a user-level secured MS Access database? in order to open the database i am using a command line instruction to direct it to a custom .mdw file. i chose this option rather than customizing the system .mdw file. however when i try to establish the...more >>

In .NET (pref. c#) how does one get a list of all available SQL Servers, databases and tables. I need to allow the connection to a database, etc, on the fly. kind of like what happens in SQL Query Analyzer thanks m ...more >>

Hi, I have a Windows forms datagrid which uses a dataset as its data source. I load my dataset dynamically and the number of columns in the dataset differs depending upon my input. I want to let the user drag and drop a column at a particular position (something similar to Cut and Insert a colu...more >>

Is it possible to use ADO.NET to query Exchange 5.5 to obtain recipient attributes, such as name, phone number, etc.? And if so, how? And if not, any suggestions? thanks, --marc ...more >>

I have a mapped drive Z:\ setup on my client machine, with a permission of 'Everone' = full. I am able to access the database with no problems using VB.NET (desktop application) but I am unable to access it using an ASP.NET verision of my desktop app. It tells me that the 'Z:\' is not a val...more >>

I need advice on correct usage of ADO.NET in an ASP.Net environment. I have an ASP.Net application that accesses data through a referenced class library. Things start to break down when multiple web clients attempt to use the application at the same time. A common error that gets returned is "...more >>

I thought after I set the "RowFilter" property on a dataview, that if I then interated through the view, that I would only see those rows which met the row filter. I am not finding that to be the case. I am putting values in the rowfilter that I know are not present, yet when I iterate through ...more >>

Anyone got code to determine what version(97,2000,2002) a .MDB access database is? Is there a string in the header of the file? ...more >>

Hi, I have 2 datatables with the same schema. One table has data in it and one is empty, I want to add all the rows from table1 to table2 where the column iVolume is positive. My code is below, when i execute this it tells me that the row is already assigned to a table, how do i get aro...more >>

Hi everyone, is there any way to conect to SQL Server by using Windows Autentication, but providing the user and password? I mean, the user need to type the same windows user login and password. How could I write the connection string? Regards, Marco ...more >>

Hello, I have tried a couple of techniques and the ones I have tried have failed and the ones that work, I don't like, so I thought I would see if there is a better way of doing this. I am attempting to copy a variable number of records in a dataview, change the "keys" to a new value and inser...more >>

Hi: I wish to use a system that supports real-time stock control via a WinForms application. How can I use ADO.NET in a connected fashion (as opposed to disconnected)? Am I going about this in the correct manner? TIA, Martin. ...more >>

Hi, I have a table which contains a column called iVolume, which contains positive and negative integers. I want to get hold of the column iVolume and pass it to a method, however I only want the positive values in my DataColumn. I thought I would be able to accomplish this with the Ex...more >>

Hi, I have three Access tables: tblInvestor, tblProject and tblInvestorProject. It is a many to many relation between tblProject and tblInvestor. The tables look something like this: tblInvestor tblProject tblInvestorProject ----------- ------------ ------------------ I...more >>