.NET Framework - ADO.NET

Thread preview

Thread	Last Post	Replies

DataGrid in VB.NET	08 Mar 2004 11:09 GMT	1
I have a datagrid that I am populating, and on my tab and I have a select/Deselect all checkboxes. The only column in my grid that is readable is the first column and it is a bit field displaying checkboxes. I want to cycle through and select/deselect the datagrid
Merge Columns from different DataTables?	08 Mar 2004 10:18 GMT	3
How do you merge columns from different datatables into one DataGrid? thank
Query with actual values of parameters	08 Mar 2004 07:13 GMT	3
I'm defining a query as "INSERT INTO Table (Col1, Col2) VALUES (@Val1, @Val2)" Then I'm creating a SqlCommand and adding the parameters @Var1 and @Var2 and their corresponding values using sqlCommand.Parameters.Add(....) I
Is MDAC required on client for Windows app on shared drive?	08 Mar 2004 02:29 GMT	5
I've looked on the MSDN site and in all of the news groups and can't find the specific issue so I'm posting it to try to find an answer. I have a Windows .NET 1.1 application that accesses data from a SQL Server 2000 database on a network server.
ma access query to assign pk	08 Mar 2004 01:24 GMT	2
Is there a way in MS Access to assign a PK to a table through a query. I am creating the table with 'select .... into <tablename> from etc' which works fine, once executed with executenonquery. But I need to give it a pk as well - how can this be done?
DataSet.Merge()	08 Mar 2004 01:05 GMT	2
If I have an empty DataSet and a DataSet with data in it and I do EmptyDataSet.Merge(FullDataSet) Then all the rows from FullDataSet get added to EmptyDataSet right?
SQLDataAdapter.Update troubles.	07 Mar 2004 23:34 GMT	1
Anyone have any suggestions? I'm using stored procedures to save and retrieve records to the database. The problem is in the code for the SqlCommands being used in the dataadapter.. Select works perfectly.
datetime format	07 Mar 2004 23:29 GMT	1
my sql server have this datetime format ( yyyy-mm-dd ) how could i change it to dd.mm.yyyy format thanks
Error when running a sproc	07 Mar 2004 16:56 GMT	4
I am trying to run a sproc that retrieves a single booking number from my database However i keep getting the following message and the booking No is not displayed Can anyone tell me how to fix this? system.InvalidCastExceptio
using xsd and datasets with XmlDataDocument	07 Mar 2004 15:01 GMT	1
I have the following xml: <message> <envelope> <body key="" value="" />
DataRelations	07 Mar 2004 13:13 GMT	1
Hey All, I have a form that connects to a Access database, and I have a combo box on this form (this combo box has a list of Access Levels, a user would be able to choose one Access Level out of the combo box).
New col. in a dataview	07 Mar 2004 12:43 GMT	1
I have created a new col. in a dataview of type int. For the value of this col. related to the different records, I need to call a function - GetReports(m_ReportSiteKey, 'value of col["FolderKey"]); where 'value of col["FolderKey"] is the value for each row relevant to col.
Error filling typed DataSet with relations	07 Mar 2004 12:15 GMT	1
Hey guys, In my schema I have created various relationships between tables in my dataset. However when I attempt to fill the data set I get a ConstraintException with the message Failed to
Easy way to access a Pervasive database?	07 Mar 2004 11:09 GMT	6
Does anybody have a sample I could see of a simple way to access Pervasive in Visual Studio?
how to insert record using dataset?	07 Mar 2004 08:40 GMT	1
i'm wondering how can i insert record into my sql server 2000. i have already created a connection to my sql server 2000 using the wizard. i added 4 sqldataadapter and 1 dataset. because i am an expert in ms access i created this first in access and i have done this in a couple