check out the link below, hope it's useful http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnwinforms/html/printwinforms.asp regards:cool:

Antonius_r3 wrote: My concern was, the network load of the select command. I was afraid that the ADO.NET select command retreive all the data and rows even I only selected one column or row. And then the client applied filter to the retreived data to get the data I wanted. But I guess I'm wrong. Just as a clarification: It is SQL Server that is lowering your network traffic not ADO.Net. If you sent the same query to a remote MSAccess MDB database (via ADO.Net) you would experience a much heavier network hit since the filtering would happen on the client.

That's a lot of garbage to go through when all you need for a Login Form is wheather or not the user was successfully logged in or not. I like this in the main form better: frmLoginForm myLoginForm = new frmLoginForm; DialogResult loginResult = myLoginForm.ShowDialog(); if (loginResult == DiaglogResult.OK) { // The login was OK. Enable the controls as needed. } else { // The login failed. Disable the controls as needed. // Or might want to quit the application. } RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Does anyone know how to Filter a PKey that is a GUID? For some reason, the standard way of treating GUIDs like Strings (which works great in SQL Server) does not work on DataViews! Anyone have a Clue? :wtf:

I figured out the problem already. It was the dataset. I tried to delete and start from beginning again, create the dataadapter, but this time, I did not generate dataset. So, First I delete the table from SQL Server, and then create new one with the same name. I change the property of the table in design mode, Identity = Yes, Identity Seed = 1, and Identity Increment= 1. And then create Dataadapter in design mode, without generating dataset. I ran the compiler, and it worked fine. I guess what I did previously was correct but probably messed up in the middle. Nevertheless, thank you very much Dave. You explained to me how the autonumber works.