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#
how to increase session timeout at application Level in ASP.NET
Add Global.asax in your Project
Then following method write for session time out
void Session_Start(object sender, EventArgs e)
{
// Code that runs when a new session is started
Session.Timeout = 240;
}
Subscribe to:
Posts (Atom)
