Anyone can tell me the difference between DataTable.Reset() and DataTable.RejectChanges()?...more >>

Hello, This is actually a question about ADO but in the context of the Microsoft Data Access Block. So, if I am posting this in the wrong place...excuse me in advance and someone point me in the right direction. Ever since upgrading to VSStudio.NET 2003, I keep getting these errors after execu...more >>

I'm trying to identify a col in sql that is empty when calling the select method of a datatable. For example: For Each irow In dsspship.Tables(0).Select("(qrange_e - qrange_s) > 0 and len(pubcode) > 0") This doesn't work - if a row's qrange_e - qrange_s is greater than 0, I get the row, even...more >>

I found this on a bulletin board and decided to try it. A little while back, I was browsing through newsgroups and came across an article similar to this that said you could make thousands of dollars within weeks with only an initial investment of 6.00 So I thought, "Yeah right, th...more >>

Hi, I wanted to ask how i could run a stored procedure against my dataset. At present i am using a datareader to fill the values of my combobox from my database. As i have created a dataset with all my databse tables, it makes more sense to run my SQL command against the dataset. Does anyone have...more >>

Hi, I wanted to know if anyone has any examples of how i can bind a combobox to a datatable. I have found example for how to do this for a textbox but not for a combobox. Can anyone help...more >>

Hi i amtrying to create a datatable with numerous tables in it. I have created each datatable in turn and then coded all the reltionships between them after. However when i run the application i get the following error message: An unhandled exception of type 'System.ArgumentNullException' occur...more >>

Hello: Firebird .NET Data Provider 1.5 Release Candidate 4 available for download. Release Changes: - Bug fixes. --------------------------------------------------- You can read the Changelog at: https://sourceforge.net/project/shownotes.php?release_id=213908 You ...more >>

Is there a simple way to make either an entire dataset or a datatable readonly/not readonly with a single command? (Without setting the readonly property of every textbox or datacolumn to true?) Thanks, Denise...more >>

Is there a way to detect if any changes have been made to bound textbox controls without first called the BindingManager EndCurrentEdit, then checking ds.HasChanges? (Besides the obvious of connecting a change event to every textbox on the form?) Thanks, Denise...more >>

Hi, the new ADO.Net does not support SQL cursors. So how can i loop through the entire set of records of a table. The fetching of all data into a DataSet is (of course) not a solution. Is there a recommended way? thanks and best regards, Jan...more >>

I have a C# console application that uses OleDbConnection, OleDbDataReader, and OleDbCommand to directly read from a local Access database through the "Microsoft.Jet.OLEDB.4.0" provider. (WinXP Pro w/ 512mb RAM and .Net 1.1 system) The first time the app executes the SELECT statement show ...more >>

Hello, The books on C# I have read, talk of using the DataSets in disconnected mode, and Adding/Removing/Updating records from it, and letting it handle all the updating on the Database in one batch finale... But the examples were all based on using auto-increment columns. Lately I've been...more >>

Hello: Have a nagging question about creating disconnected DataSet queries... If you have a table called INodes of 10,000 records, and a Table called Clients of again 10,000 and a table called EditLog of 40,000 records... And if you could, via a DataReader join these and get back a recordset...more >>

Hi I am working on migrating data from one table to another identical table. Though the field names are same in both the tables, their order in both the tables need not be the same Could anyone suggest a good way to identify the corresponding fields of the tables The user may go to the database ...more >>

hi, I got a problem. I just want to know why. I use Data adapter configuration wizard to build a strongly typed data adapter. But it always fails to generate data adapter. Since the table has more than one hundred columns, is this reason ? Because when I select less than 100 columns, it will...more >>

Hi group, i`ve looked everywhere now and i think i know less than i did before i started, im getting so frustrated with this now:( This must be so Simple i just don`t know how to do it tho:( I want to be able to have a ComboBox on a normal WinForm select it and pull a list of all Sites from ...more >>

I need to translate a (proprietary format) data file and store the data in both a dataset and an SQL database. It seems that the 'best' way to do this may be to: 1 Create the SQL database tables/schemas first 2 Create the dataset internals from those 3 Load the datasets with the new d...more >>

Hi everyone, Can someone tell me the best class to use in order to execute insert statements on an access database? Should I use a data adapter, or something else? I don't want to use a dataset, and I only want to insert data, as opposed to selecting data. Thanks everyone Simon ...more >>

Hello All, I am working on a windows application which will talk to the database through the Web services. So i need to enhaance the performance, for which i m using connection pooling. I want to use pooling at the Web services end and not the default SQL server pooling. ...more >>

I have a question about the life of the connection used by SQLHelper. When I execute the lines below it looks as if it keeps the connection to the database. _sConnString = "Server=.;Database=tester;Integrated Security=SSPI;" SqlHelper.ExecuteNonQuery(_sConnString, CommandType.Text, "select 1")...more >>

Hi all, I am a newbie in Ado.net. I have a question on the usage of sqlcommandbuilder. I know it will generated a update statement automatically. Is there a way to override this. The update statement it generate is not very efficent because it checks every fields. For my application, I ...more >>

Hello, I'm building data loader application that uploads data from excel files to SqlServer. I'm using OleDbReader to read excel file into dataset and then displaying it to user for configuration purposes. My problem is, the target schema is different from the one found in the excel files....more >>

I'm trying to connect to a SQL 2000 db and i'm getting the following error: 'Login failed for user 'sa'. Reason: Not associated with a trusted sql server connection' Here is my connection string: dim conStr as string = "server=localhost;database=TechForum;uid=sa;password=;" am i miss...more >>

Hi, Could somebody point me as to how to connect to a secured access database? I understand that you need to point to the MDW file (the user level security) But so far I have been unable to do that. Any help is greatly appreciated. Cheers. ...more >>

Is there any direct way to fill a datatable from a datareader? Or do we -have- to use a dataadapter? Tom ...more >>

We've experienced problems whereby our database gets into some state that casues queries to timeout when executed by ADO.NET, but they same queries still run fine in tools like Query Analyzer. By running the DBCC commands to update indexes, the problem goes away. However, if indexes were the r...more >>

Hi Group, Anybody got any links where i could read up on how table relationships within VB and ADO.NET. Preferably with Access Many Thanks Si ...more >>

Hi, I've got a C# Component to which I've added an OleDbConnection and two OleDbDataAdapters, using the VS.NET designer, with no problems. Adding a third, whose data is not substantially different from the others--SELECT Table.* FROM Table--the designer gives the following error in the final ...more >>

has anyone tried to connect to a Pervasive database using ADO.Net? I get a message saying cannot use an OLE DB providerfor ODBC drivers or if I try and use SQL adapter I get "The connection you have created does not work with this adpater" What am I doing wrong? (Other than using a NON-M...more >>

We've experienced timeout problems with ADO.NET and SQL Server. The queries being executed via ADO.NET run fine (1-2 seconds) in tools like Query Analyzer. When DBCC commands are run to re-index tables, the problem in ADO.NET execution goes away. However, if indexing was really the root cause...more >>

Microsoft is in the process of testing Oracle 9i client software on Microsoft Windows operating systems. Microsoft recommends using Oracle 8.1.7 client software, with the latest patches, because it is known to be a stable build. This client version is able to connect to Oracle 8i and 9i servers; how...more >>

Background ------------- I have attempted to use the "SetColumnError" and/or "RowError" methods in order to post error text about specific error conditions that were found during the editing of rows that were either added or updated in an ADO.NET dataset->datatable->datarow... I'm using 'type...more >>

Hi I have a dataset/dataadpter scenario with an access table with auto number id. The select command has a condition (where clause). The problem is that when I add a new record, I don't get the highest id +1 in the id field rather the highest id in the current selection + 1. This creates dup...more >>

Ok Gang, I'm throwing my hands up in the air right now... I've got two access databases with identical schemas. All I'm trying to do is to use C# to copy the information from one to the other. Now here is where the problems crop up: Some of these tables don't correspond to good "Relati...more >>

Hi, I have two tables with one relation in a dataAdapter, I pass all the records to a couple datagrids. After add, update and delete records.... I'm trying to update the dataAdapter with the all changes. I read in my book that I need to do it in particular order: 1.Submit New rows for both tab...more >>

When I test examples in KB 815672 step by step. In "Test the Disconnected ADO.NET Windows Application" section Step 4. Application crash. This is the error message ¡°An unhandled exception of type 'System.Web.Services.Protocols.SoapException' occurred in system.web.services.dll...more >>

What may cause this problem? error message: ¡°An unhandled exception of type 'System.Web.Services.Protocols.SoapException' occurred in system.web.services.dll Additional information: System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Data.Sql...more >>

I've heard talk of being able to move all sql connection strings to the web.config file and simply referencing them as opposed to inputting the string everytime you need to use it. Can someone give me an example of this please? ...more >>

I've posted this in the aspnet group, but i think this is the more appropriate group. I have the code below which receives an error. The code gets invoked when a button is clicked. Dim row As DataRow Try row = ds.Tables("TestTable").Select("emp_id=" & txtEmpID.Value )(0) row.Dele...more >>

Win2003 and VS2003 using ASP access to SQL Server msg: Login failed for user 'NT AUTHORITY/NETWORK SERVICE'. I added IWAN as a login and user to DB that I am accessing in my app and still get same msg. I must use integrated security. I have looked at all the related issues that I can find. What ...more >>

I am writing a program using a Dataview to populate a Datagrid (using Tablestyles for formating columns for display). Everything displays fine but any changes made to the grid are reflected in the Dataview (confirmed using Dataview.Listchanged event) but not in the Dataset (confirmed using the D...more >>

Hi, I have been working through this Microsoft support article http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B310350. I have adapted it slight in that I am not using in the context of a web service. However whenever I make a change to the data via a bound DataGrid the GetChanges...more >>

I have a table that has a unique numeric field named ID. It want to build a list of records that match a criteria. I would rather not store all the record contents in the list. I would like to just store the ID value in a list. Then when I need the full record data, I would like to "Seek" to that...more >>

Hi- I have 3 tables Prod_Docs (many-to-many) [ProdId (fk) ] [DocId(fk) ] Docs_Main [DocId(pk)] [CatId(fk)] Docs_Categories [CatId(pk)] I want to select all the records in Docs_Categories that are linked by the Prod_Docs many-to-many table. I can't figure out how to ac...more >>

Hello, we have a strange problem with a stored procedure on MS SQL Server 2000 SP3. The procedure is pretty complex and use temporary tables to create XML with FOR XML EXPLICIT. We read the XML data with ExecuteXmlReader in our ASP.NET application (.NET Framework 1.1). Most of time everythi...more >>

Hi, I am looking for a DataSet Explorer tool to help me diagnose dataset realted problems. At this point I use breakpoint and command window which is not very convenient. Thanks, Ali ...more >>

Hi, I'm trying to make a query to search a pattern in a SQL Server database. I need something like this: SELECT * FROM Table WHERE title LIKE @value ORDER BY title. Then, I create a parameter for @value, and when I set its value I use: "%" + value + "%". The result of the query is the sam...more >>

Hello there I am using the following code to query data from Excel shee try { string strConn; strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" +"DataSource=C:\\Temp\\MSFT.xls" +"Extended Properties=Excel 8.0;"; OleDbDataAdapter myCommand ...more >>

Hi all, I am able to find examples/documentation on typed datasets (which consist of typed datatables). But once I want to use dataviews of the tables I am stuck with the regulare DataView which is not typed(or custom). Does anyone have an example/documentation on how to effectively do this?...more >>