Hi Guys, I am building a small web application using .NET technologies with SQL Server as my database server. My web application consists of several web forms which access the database and update it. I am using the Windows Integrated Security for my SQL Server access and I am able to a...more >>

I have an SQL table with the primary key set as autoincrement. My goal is to insert a new row using a dataset and then retrieve the primary key of the row just created. My code works some of the time, but the primary key I get back from the dataset is not always in sync with the SQL server's ...more >>

I have a stored procedure that will return a dataset that contains the first n records of a select statement. I use a DataReader to retrieve the records to write them to a file. When the SP only returns 10,000 records, it can process those records at a linear processing rate 1000 records in 2 ...more >>

if i have a table like this ID Name Accessable 1 Me yes in access with accessable as a yes/no field (or a boolean) how do i write a statement in ado.net to check that? obviously yes or no wont work in a query builder for criteria... it kicks it out... i had select us...more >>

dataview.rowfilter="lcase(mycolumn1)='aaaa'" ...more >>

Hi, I am working with .Net Framework 1.1 for weeks, using OraOleDb provider. Suddenly I got the following message: 'OraOLEDB.OleDb' provider is not registered on the local machine No idea of what happend. Any clues welcome. Dominique ...more >>

I must admit, this is all new to me, so this may seem a bit remedial, = but I'm having a tough time finding helpful documentation dealing with = my problem. I'm writing a small group calendar to display members exceptions to = being in office. The first page is a login page, and following a = ...more >>

Hello. The cancel command interrupts the current query being executed... but when I run another query using the same connection (or another connection using connection pooling) sometimes I get another "Operation Cancelled by user" exception. It appears that the Cancel command runs asynchronously...more >>

Hi Is there some general way to figure out reason for SqlException. 1) constraints: PK, FK or other - may be it is possible to find out with on? like in case of triggers and constraints 2) missing objects 3) no connections, identity problem or lost connection with server. Thanks Shimon ...more >>

Hello, I've been successful changing general datagrid format through the interface provided in VS.NET. Nice tool. However, I now need to have different cells within a datagrid have different background colors, depending on the numerical value displayed in the cell. I can't figure out h...more >>

Hi, I need to be able to read data from an Excel spread sheet via ado.net My problem is that the names of the worksheets are not standardized. Also, there may be more than one worksheet in an excel file, and I need to let the operator select the proper worksheet from a list. What I am tr...more >>

I have a DataTable that I've filled from a query, it has five columns and eight rows. Three of the columns comprise the primary key and I want to remove two of them. Here is what I'm trying and it is almost working... table.PrimaryKey = null; // so we can delete primary key columns C...more >>

Hi Gurus, We have a requirement for multiple huge report (over 50 page each) that needs to be outputted on excel. Data item for the report comes from two different sources; one from a UI where users can define their items and change values (name value pair kind of scenario) and some data from d...more >>

Hi, I want to store my connection parameters in a UDL-file. The building of the file was easy, but I can't use the file. In an example I found this: myConnection.ConnectionString = "File Name=GenesisNET.udl"; but when I try to open the connection I get this error message: An unhand...more >>

Hi, My stored procedure returns FirstName and LastName fields. I want to bind a DropDownList to the results of this stored procedure and combine two those fields. Although it would be very easy to make a database view (SELECT FirstName + ' ' + LastName ....) I don't want to do that. Is...more >>

This is frustrating the heck out of me... I have an OleDbConnection, DataAdapter, and DataSet and I want to want to map some columns before I fill the schema of the datatable. For example: .... do all the initial stuff like set up connection, instantiate the dataadapter, etc... acc...more >>

Hi: I have an ASP page that creates a VB dll which in turn calls a Class Libraries created in .NET. This set up works fine in my development machine. When I try to deploy this to the Web Server ( I installed the VB dll and copied the Bin directory of the .NET class library into the Web Server ...more >>

Hello - Im new to ADO.NET so bear with me here. I have an Access DB, simplified as follows: TABLE Person person_ID autonumber PK last_name text first_name text person_type number FK TABLE Person_Types person_type number PK person_type_desc text The second table is just a Lo...more >>

I'm writing a web application that exports and imports excel files. The application gets a list of users and their info and displays it in a datagrid .The user then selects to save the file as a tab delimited file or an excel file. The application then saves the file in the correct format. The...more >>

Hello, Does anyone which provider should be used when connecting to a MySQL database. Thanks, Gary ...more >>

Hi, I have a datatable in my application. Now I need copy data from column 1 to column 2. Because the table has thousands of rows, I can't do this by copying data one by one. Thanks a lot for your help. philin...more >>

Hi, Can sb tell me is there any diff b/n object == System.DBNull.Value and Convert.IsDBNull( object ) TIA Kishore...more >>

Hi, I have the following SQL code : SELECT null AS Fred from Debtors This is part of the SelectCommand.CommandText for an OleDbAdapter (Jet 4). When I test this SQL within Visual Studio I get a binary value, not a blank field. I also get the following error when the SQL is parsed : ...more >>

Hi all, What is the fastest way to insert data using ADO.Net? I have to insert more than 500.000 records and calling xCommand.ExecuteNonQuery is no good. I also tried filling a data table first and then updating it. SQL Server's Bulk insert operation is even more than good bu it re...more >>

how the connecting string will look like? ...more >>