Fill Data which return dataset in C#

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;
}

Leia Mais…

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;

}

Leia Mais…

Two way to declare Connection string in Web config

Replace "(" with "<" and ")" with ">"

1) First way to define under Connectionstrings tag

(add connectionstring="Server=servername;Database=databaseName;uid=useridofdatabase;pwd=passwordofdatabase;Connection Timeout=5000"
name="CnName" providername="System.Data.SqlClient")(/connectionstrings)


2) second way in Under appsettings tag

(appsettings)
(add key="Servername" value="Server Name")
(add key="DatabaseName" value="databasevalue")
(add key="UserName" value="UserNameofdatabase")
(add key="Password" value="passwordofdatabase")
(/appsettings)

Leia Mais…