Following is Function Filling dataset through dataadapter
public DataSet ExecuteQueryReturnDS(string stQuery)
{
DataSet ds = new DataSet();
using (SqlConnection sqlCon = new SqlConnection(connStr))
{
SqlCommand sqlCmd = new SqlCommand(stQuery, sqlCon);
SqlDataAdapter sqlAda = new SqlDataAdapter(sqlCmd);
sqlCmd.CommandTimeout = 999999;
sqlCmd.CommandType = CommandType.Text;
sqlAda.Fill(ds);
}
return ds;
}
Monday, September 19, 2011
Fill Data which return dataset in C#
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment