Create a database connection in web. config

Find the web. config file in the asp.net application and add the following code before <system. web>:
<? Xml version = "1.0" encoding = "UTF-8"?>
<Configuration>
<Deleetask>
<Add key = "ConnectionString" value = "server = jeff; uid = sa; pwd = btk; database = msg"/>
</AppSettings>

<System. web>
......
</System. web>
</Configuration>
Create a connection in the aspx file:
Public SqlDataReader GetReviews (int productID ){
// Create a Connection and Command object instance
SqlConnection myConnection = new SqlConnection (System. Configuration. ConfigurationSettings. etettings ["ConnectionString"]);
SqlCommand myCommand = new SqlCommand ("ReviewsList", myConnection );
MyCommand. CommandType = CommandType. StoredProcedure;
// Parameters
SqlParameter parameterProductID = new SqlParameter ("@ ProductID", SqlDbType. Int, 4 );
ParameterProductID. Value = productID;
MyCommand. Parameters. Add (parameterProductID );
// Execute
MyConnection. Open ();
SqlDataReader result = myCommand. ExecuteReader (CommandBehavior. CloseConnection );
// Return results
Return result;
}