I want to create a separate class that defines the db connections. then call it in my application(ASP.NET 2005). so pls send me the code For SQL connection and also the code to call the class in the code behind in a submit button click.

First create Connection with database and then Dim databaseRecord As SqlDataAdapter Dim dstRecord As DataSet databaseRecord = New SqlDataAdapter("Select * from ", con) dstRecords = New DataSet databaseRecord .Fill(dstRecords) dropdownlistname.DataSource = dstRecords dropdownlistname.DataTextField = "" dropdownlistname.DataValueField = "" dropdownlistname.DataBind() I hope this will workout ash83

*grin* Christian Graus - Microsoft MVP - C++ "I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

Don't repost. For Details of including a file to your project Get it[^] Regards, Satips.:rose:

what do you expect from a brillant boy ;P:-D