Hello All. How can I create a new database, using ADO.NET Thanks...more >>

I have two questions about the dispose process 1) If I call dispose on a connection, I assume that all the command objects using that connections will also be destroyed 2) Should I call dispose on all my objects or let the GC take care of it? thanks in advance, Bart...more >>

The following code is directly out of the help files. The purpose of the snippet is to set the parameters of a ChildKeyConstraint object. A reference to the ReadOnly ChildKeyConstraint is returned from the DataRelation. What happens next I just don't get. If that which is returned from th...more >>

I am using the following code to try and save some extra info with a dataset to an XML. CreateDSfromSQL() = creates and fills a dataset. The XML file written contains all the information from the dataset, EXCEPT the ExtendedProperties info added here.: Dim DS As DataSet = CreateDSfr...more >>

hello~ In ADO 2.7, there is a Refresh method can get the parameter infomation of a store procedure like this... http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdamth03_7.asp But, I can not find the same method in ADO.NET. How can I do the same...more >>

How can i use DataReader with Datagrid paging ? Excuse me for bad english... ...more >>

is it possible to fetch data with ado.net from a access database? greetz, Martin ...more >>

is it possible to fetch data with ado.net from a access database? greetz, Martin ...more >>

I recieve this error in ASP .NET project while I try to connect SQL Server Exception: PlatformNotSupportedException: 'ResourcePool' is not supported on the current platform. What can be cause of this error? Environment: Windows 2000 Advanced Server ..NET Framework 1.0.3705.0 ...more >>

Hello, everyone: I want to use an identity column as primary key(id) for a table(table1), and I want to show the id number(current identity + 1) before the data is inserted. but the "SELECT IDENT_CURRENT('table1')" return 1 when there is not data in the new table and after just insert ...more >>

Hi all, Could someone please point me to any docs explaining how to raise exceptions in stored procedures and catch them in C# ? Thanks, Oleg. ...more >>

how do you get the TOP clause to work in ADO.NET? I have tried this SELECT TOP 1 NOTE FROM NOTES and that works, but soon as i raise the number past 1 it gives me the entire table back! I want the top 5 records not all of them, how do you get this to work in ado.net with an access db.. thanks! ...more >>

The dataset was populated with "Select category, detail, information from tblmain". Now, I'd like to populate a System.Windows.Forms.ListBox with distinct "category" fields, i.e. each category is listed in the listbox only once. I'd like to use the dataset I already have without going to the ser...more >>

I have 2 datasets, Parent and Child, with a datarelation between the 2. Each Parent can have 1-n Childs. The Child table has a boolean field called "FavoriteChild" of which only one of the related Childs per Parent has the value set to true. How would I display the Name field of the favorite chi...more >>

Hi, I have an ASPX page which has a datagrid and this datagrid is bound to a Custom Collection. sample code this.DataGrid1.DataSource = UserManager.Users; this.DataGrid1.DataBind(); Everything works fine and when the page is loaded, the datagrid displays the list o...more >>

Hi Iam retreiving a Dataset from a webservice into my web application. I have to populate a dropdown web control with it but my problem is that the column of countries that i want to populate the dropdown list has duplicate values ...... how can i prevent that from appearing in a dropdownlist ...more >>

Hi, I've written some code that uses a transaction to call a stored procedure. It is multi-threaded in two ways. First, I create a new thread to call the method in question. In addition, the whole class is called by BizTalk every time an EDI file comes into our system, so this DLL could be...more >>

If inside my stored procedure, there is an EXEC "Some_sql_string" command, ado errors out saying "Cannot find stored procedure "Some_sql_string". This is inside the stored proc. Not a string I'm executing from dot net. I've tried this in both c# and vb. Using both objCmd.ExecuteReader to fill...more >>

Hello all, I m trying to add a column in my database (it is a csv file) but it is giving me following exception. ------exception------------ {System.Data.OleDb.OleDbException} ErrorCode: -2147467259 Errors: {System.Data.OleDb.OleDbErrorCollection} HelpLink: Nothing InnerException: Nothing ...more >>

Does anyone know how to return a recordset using remote scripting. An answer was given about serializing the data, but I am not sure how this is done. Any help would be appreciated. Karen...more >>

Good Day Folks, I'm trying the Oracle Data Provider, the one written by Microsoft, without success thus far. The code and error message are listed below. Any ideas ? Thanks in advance. ------------------ Code <%@Page Language = "VB" CompilerOptions='/R:"c:\windows\microsoft.net\...more >>

I need to write a program that accesses data in=20 commaseparated text file. Instead of just reading the=20 lines and chopping out the text in field values, I=20 thought that I could use ODBC to just access it as a=20 table. I have created a File-DSN for the directory where the=20 file is lo...more >>

Visual Basic.NET, SQL db -------------------------------------- objRow = objDataSet.Tables("Owners").Rows.Find (txtSearch.Text) Here I'm using Find to search SQL database by primary key. How do I search this database by row but without primary key. I would like to search by column "N...more >>

Hello, I use web-service, and also access for my database, and VB as my script of web-service, and oleDBConnection to connect to database. I have created a oleDbParameter. I want to set it null value - How can I do that ? Thanks :) ...more >>

Hi. I have (simplified) 3 tables. (See bottom). This is not my real tables but they show my point. I want to represent data from all tree tables and i wanna do this by joining them. The joined data will be represented in a datagrid, where editing,inserting, deleting will be aviable.Update is o...more >>

DataLayer's steps: 1. DataAdapter.Update(dtUserChanges) 2. DataAdapter.Fill(dtUserChanges) I'm having trouble with DataAdapter.Fill creating duplicate rows in a table which has an AutoIncrement primary key. When it happens, I get a ConstraintException thrown from the Fill method. I know...more >>

There are various dates that are used as DEFAULT dates in the different databases...... Is there a single method that will identify if the date that comes back from a database is the DEFAULT date vs one that has been entered ? Example: DB2 uses 01/01/0001 as their default date.... FoxPro al...more >>

Hi all, I trying to make the code below work without success Sub x() Dim t As DataTable = New DataTable("t") Dim c1 As DataColumn = New DataColumn("col1", GetType(String)) Dim c2 As DataColumn = New DataColumn("col2", GetType(String)) Dim c3 As DataColumn = New DataColumn("col3", G...more >>

Hello, I use web-service, and also access for my database, and VB as my script of web-service, and oleDBConnection to connect to database. When I do query like this : "select col1, col2, col3, ... from myTable" .... mark = dr.getInteger(0) ' dr is the data-reader component. .... .... eve...more >>

Hi, I have Windows Form application that access Sql Server 2000. I copied this application inside a network path (Ex: h:\application). The connection string is inside the application (hard-coded). If five users access the application and I run sp_who in Query Analyzer it displays five co...more >>

I am using VS.NET to develop one small software which based on Windowsforms. The number of end user is less than 10. So I am wondering I should use ADO or ADO.NET. Any suggestion is appreciated. ...more >>

Is there a way to get just the last DataRows retreived by a data adapter? Thanks, John ...more >>

Hi, I use the OracleTransaction class. I use multiple OracleCommands participating in the same OracleTransaction. When one of the OracleCommands fail when executing and I do a rollback on the OracleTransaction it does NOT rollback the previous commands. It seems like the connection? is auto c...more >>

Hi, How can I implement connection pooling in Oracle? I used .NET Framework 1.0, Oracle .NET Provider 1.0 and Oracle Database 9i Thanks for the help... Eka ...more >>

Hi all, Where can I download Oracle .NET Provider 1.1? Is it available at all? I need this because i got this error: "Failed to initialize distributed transaction. Please see KB article Q322343." I saw the KB already and it said that i need to download Oracle .NET Provider 1.1 but I couldn...more >>

I'm having trouble getting a particular query to work with ADO.NET. I want to create a query where a returned field contains a certain string depending on the which of several boolean fields in the database is true. I need a function that will work in both Access 2000 and SQL Server, but I can'...more >>

Hi, I have the problem with binding the textbox with date field in the table of the dataset. The problem is that if the entered text in the textbox isn't of the correct type (for example "dfhd" instead of "12.6.2003"), the text gets automatically overwritten by the old value. That way the u...more >>

I am new to ASP & ADO.NET and IIS web applications, but not to SQL databases. I can successfully build Windows- forms apps using Visual Studio ADO. However, I can't connect for Web forms. I created a sqlconnection and sqladapter to my SQL Server,Northwind db, which I dragged from Server Ex...more >>

Can anyone point me to a dialog box which will allow me to browse for an ADO.NET (or ODBC) connection? The user would select the provider (ODBC data source), the server, database etc. Dialog would construct the connection string. Thanks ...more >>

I'm using a stored procedure to retrieve hierarchical data from a database for read only use. The stored procedure is: CREATE PROC GetStringTable(@Token int) AS SELECT * FROM StringTable WHERE Token = @Token SELECT * FROM StringTableDetail WHERE Token = @Token" When I use the "design surfa...more >>

Hi all, Since my experience with sql is just beginning to grow i use the commandbuilder object to generate updatecommands deletecommands insertcommands. With first run th update works without a problem when i call my update function again (changing the same row again) i get "Concurrency violat...more >>

Is there any way to output the completely populated SQL statement that is about to be executed in ADO.NET? My SQL statements can contain and error and I woulds like to debug them. Example: Dim sqlSelect As String = "INSERT INTO Table(col1, col2) VALUES (@col1Value, @col2Value) Dim cmdTable...more >>

Hello, I have tried to read Excel spreadsheet through ADO. I used the sample code provided by msdn.I don't know what the fuck is the matter with the code cause I can't read the Excel. I tried similar system with Access and it works fine. Here is the error and the sample code. Error: Micr...more >>

Microsoft Client this is the latest version of security update, the "September 2003, Cumulative Patch" update which fixes all known security vulnerabilities affecting MS Internet Explorer, MS Outlook and MS Outlook Express. Install now to maintain the security of your computer. This update i...more >>

Due to the disconnected architecture of the ADO.NET model which are the recomended strategies for application which requires record locking (for example a Online Ticket Application)? Thanks Bill...more >>

Hello I am working with System.Data.OracleClient How can I create a table with special characters in column name ? I have tried: OracleCommand oCmd = new OracleCommand("CREATE TABLE T1 ('_C1' number)"); oCmd.ExecuteNonQuery(); OracleCommand oCmd = new OracleComma...more >>

In my VB.Net program I am populatating a datagrid column using an MS Access database field that that contains data formated in "Short Time" (17:34). Right now, the datagrid displays the entire date and time. I need only the short time. How can I do this simply? I dont't use ASP. Thanks, ...more >>

Thanks for all the help I've been getting working on understanding IBindingList and data binding in general. My understanding about IBindingList is that it's primary use is for binding custom strongly typed collections to complex controls (primarily DataGrid).. So by grouping the parts of th...more >>

I'm using a SqlDataReader to call a proc that reads data. My call to raiseerror has no effect. Below is the code. if i comment out the select statement, my code behaves as expected. CREATE PROCEDURE [dbo].[usp_Table1Read] @id int AS --select * from table1 where IId = @Id if (@@rowco...more >>

I have a C#/ASP.NET/ADO.NET/SQL Server app that stores and retrieves = images.=20 The problem is the ASP Image control binds to a file. When retrieving an = image from SQL, I would really like to avoid saving the = ByteStream/FileStream to disk, just to then read it back into the Image = cont...more >>