as title thanks ...more >>

Hi all I want to change datagrid's row color depending on a cell value How can I do this? I think that I must write some code in bind method but I dont know How I do this. please help me!! thanks... -------------------------------- From: Mathi Vairavan ----------------------- Posted by a us...more >>

Hi, there is no explanation I found in MSDN for choosing sqlprovider instead of oledb privider. Could someone explain in which sqlprovider is optimized? If i change of version for Sql Server ( SQL 2000 -> SQL 2005 ) I' ll have to change my sqlclient. Whereas choosing Oledb provider would a...more >>

I m trying to insert a record ina database access and I m getting the folowing exception: Syntax error in INSERT INTO statement however there's no error in the sql statement. i copied it and pasted it in a query in the access database then i ran the query and that resulted in inserting th...more >>

When updating an access table using the ADD COLUMN sql statement, my routine may encounter an OleDbException stating that the field already exists. How can I test for this error to allow the continuation while still catching other OleDbExceptions? The only way I can think of is to test for a...more >>

I have an application that has a function that executes a number of UPDATE queries using the following function: Public Function ExecuteSQLStatement(ByVal MyConnCatalog As String, ByVal MyConnDataSource As String, ByVal SQL2ExeCute As String) As String Dim conn As New Syste...more >>

I have an application that, upon exiting, has to update upwards of 300+ records in a SQL Server database. The update statements are very basic ones, following textbook update guidelines. I am programming in Visual Basic .Net 2003 There are issues with timeouts due to network traffic an...more >>

Hi all, I have a question about combobox. After I made a dataset and setting the combobox. I try to run the form, the combobox didn't so anything. The following is my code. ' connection already made Dim sql1 As String = "select code,name,description from vendor" Dim vds As DataSet ...more >>

I have an app for tracking company vehicle mileage. I can add a vehicle to the database but I need to figure out how to delete a vehicle from that database and then delete any records that correspond to that vehicle as well. The records could be as many as 100. I have tried to figure it out...more >>

Hi all, I have a question regarding the SqlCommand and ExecuteReader. Here's the deal - I'm using a basic While loop and reading my results into an Object array for a table that contains about 25 million records. As each record is read in, it's processed, split up and normalized, and then...more >>