Rohit Sharma

 Profile Answers by Rohit Sharma Questions by Rohit Sharma

• Jan 12th, 2007

 

//Check the following example. I am using Orders table of Northwind database from SQL server.

public Dataset MyFunction()

{

SqlConnection objConnection = new SqlConnection(ConnectionString)

SqlCommand objCommand = null;

SqlDataAdapter objAdapter = null;

DataSet objDataSet = new DataSet ();

try

{

//Open the connection

objConnection.Open();

strQuery = "select * from orders where orderdate between '1996-07-04 00:00:00.000' and '1996-11-26 00:00:00.000'";

objCommand = new SqlCommand(strQuery, objConnection);

objAdapter = new SqlDataAdapter(objCommand);

objAdapter.Fill(objDataSet);

return objDataSet;

}

catch (Exception exc)

{

new Exception(exc.Message, exc);

return null;

}

finally

{

//Closes the connection

objConnection.Close();

if (objCommand != null)

{

objCommand = null;

}

if (objAdapter != null)

{

objAdapter = null;

}

}

}