iramg wrote:
i have read a example in it they use ADODB but when i use it in my code it gives me error.
That's the old ADO library used by VB6 and older versions. To use ADO.NET, you need to add a reference to the System.Data.dll in your project. In Visual Studio 2003, you can do this by right clicking on your project's References folder, select Add References, select System.Data.dll in the listbox, click Select, and then click OK. This will give you access to the System.Data namespace and all of its classes. You'll need to use the System.Data.Odbc.OdbcConnection class to connect to the database. The below link to MSDN will show you a quick example on how to use this class. http://msdn.microsoft.com/library/en-us/cpref/html/frlrfSystemDataOdbcOdbcConnectionClassTopic.asp[^] I hope this helps!