Himanshu Hajariwala

SQL Server Session State in ASP.NET 2.0 The Following Command is used to install Sql Server Session state for ASP.NET 2.0 c:\Program Files\Microsoft Visual Studio 8\VC>aspnet_regsql.exe -C "Data Source=PC8\SQLEXPRESS;Initial Catalog=AdventureWorks;Integrated Security=True" -ssadd -sstype c Start adding session state. .......... Finished. To use this custom session state database in your web application, please specify it in the configuration file by using the 'allowCustomSqlDatabase' and 'sqlConnectionString' attributes in the \ section. c:\Program Files\Microsoft Visual Studio 8\VC> The Following statement is needed to add in WEb.config File < system.web > < sessionstate allowcustomsqldatabase="true" timeout="20" mode="SQLServer" cookieless="false" sqlconnectionstring="Data Source=PC8\SQLEXPRESS;Initial Catalog=AdventureWorks;Integrated Security=True" > < /sessionstate > < /SYSTEM.W

To Query on Sql Server With Parameter- The Best Way string sqlCon = ConfigurationManager.ConnectionStrings["AdventureWorksConnectionString"].ConnectionString; SqlConnection con = new SqlConnection(sqlCon); SqlCommand com = new SqlCommand("select * from Test1 where ID=@ID", con); com.Parameters.Add("@ID", SqlDbType.Int).Value = 6; SqlDataAdapter adp = new SqlDataAdapter(com); DataSet ds = new DataSet(); adp.Fill(ds); GridView1.DataSource = ds; GridView1.DataBind();