I have been using SQL Connections, DataAdapters etc to work with data from SQL Server 2000 but notice that MS wizards seem to autogenerate OleDB. The SQL does seem to be rather slow. Not want to start a vigourous debate but... Is OleDb better? Is OleDb MS's preferred option? Why do the wizard...more >>

Hi all I am having problem in sqldataadapter. In my sql database i have one table containing column name as 'Name and address'. Here 'and' is reserved word which i am using in column name. In sql server at a time of inserting data into the table it is working properly. But when i try to ...more >>

Thanks Paul & Jay I am finding VB .Net VERY daunting after VB6. If something can be done in VB6 in one line VB.Net does it in 20 or more. Terry ...more >>

The following line binds a Date from sql Server to a text box control Me.txtRequestedDate.DataBindings.Add(New Binding("Text", ds, "tblRequests.RequestDate")) However, the date returned includes the time. Only the DATE part is required. The Text box no longer has a Format property so how do yo...more >>

Hi I have a sub method that has been passed a dataset as parameter. I need to insert this dataset into a table. What is the code that I need to do this? The dataset does not have any conflicting keys so it is a very easy scenario from conflict resolution point of view. Thanks Regards ...more >>

A chicken and egg question... Using VS and SQL Server.... is it appropriate to use sp's to update the data store first, then update the Dataset ? ...more >>

Hi all, I have a problem regarding use of manualreset events in .net. I have a developed a sample appliation in which entries from the listview which I say is a queue for my processes.I want to schedule these processes in my queue. I also want to stop the processing by selcting the pause ...more >>

Hi all, I have parent/child datagrid (showing transactions and transaction details when the (+) sign is clicked on the grid. There is a method to "expand" the row, and an event to fire when you click "back to parent record", but i see nothing (no property or event) in this stupid grid to...more >>

Ok, I'm back. I have another question (probably an easy one, even to non-experts). I was inspired to expand this little program (thanks to all of your help). If I was using the following code to create a game that prompts the user to guess a number from 1-100, and wanted to have the console wr...more >>

Hi, I have an application that connects to an Access DB and uses a DataAdapter to fill a DataSet with records meeting set criteria and displays them in a DataGrid and also fills a ComboBox with one of the fields. The Access Table has between 40,000 and 80,000+ records and the form takes sometim...more >>

I have a situation where I have two recorsets that should be identical. I need to compare them and find out which, if any rows are different. I have set it up to Loop through the outer Recordset and perform a query on the inner loop seeing if the record exists. Bsically DB1 is an Access...more >>

Hi Everyone! I'm in need of help again! I'm just wondering if WinForm DataGrid can have Excel like AutoFilter? Here's an example: http://www.dotnetforce.com/Content.aspx?t=a&n=210 But again, this only in ASP.NET DataGrid. Does anyone know the easiet way to implement this feature in WinFo...more >>

We have an Access MDB database. We are writing a .NET application to automatically add users and assign the users to groups to an MS Access database that uses workgroup security. Can this be done? We need to be able to add the user, the pID for the user and password. We then need to assi...more >>

Hi All! I would like to make my WinForm DataGrid control so that user could easily edit the items in the **related table**. For instance, I have customers table and it has one-to-many relationship with the customerType table. I would like the WinForm DataGrid to display a column with "Cu...more >>

I am using vb.net and SQL Server 2000. Hopefully i will soon be using VB.net 2005. I would like to prevent users from having direct access to a SQL Server database, and require them to access the database through an application. Application roles seem like a good solution, but I read that...more >>

Hi I am using batch commands against Ms-Access and getting an error Message "Characters found after end of SQL statement." String Here is my sql Dim str_screens As String = "Select * from Screens Order by ScreenName;Select * from Functions" How can I fix this problem. Any help is greatly ap...more >>

Hi. I'm trying to pass many parameters to an Update SQL Stored Procedure on = just one line for code tidyness. =20 Does anyone know the syntax for this approach? Ray. This is the style that I do not want to use Dim sampParm As SqlParameter =3D = sampleCMD.Parameters.Add("RETURN_VALUE"...more >>

I'm just getting to grips with the new SQL Database file concept in VS 2005 and have a couple of questions in the hope that someone can clarify my understanding. I understand that I can now add both the <dbname>.mdf and <dbname>.ldf files traditionally associated with a SQL Server into my a...more >>

I have a program that takes an Excel file and makes a dataset out of it. This program will then take that dataset and update an oracle table with it. The problem is that sometimes a record will exist in the Excel dataset that has teh same primary Key as the Oracle table. Oracle will not let ...more >>

I have two tables that are identical (well as best I can make them) One is in a database on a SQL Server and the other in a database on a Unix box. In VB.NET code I would like to execute the insert into sql statement to move records directly from the unix database table to the sql server da...more >>