اینم یه نمونه کوچیک از کدهام :
ConnectionStringSettingsCollection connections = ConfigurationManager.ConnectionStrings;
string connectionstring = connections["Connectionstring"].ConnectionString;
SqlConnection CONLoad;
SqlCommand CMDLoad;
string STRLoad;
STRLoad = "SELECT * FROM mayor";
CONLoad = newSqlConnection();
CONLoad.ConnectionString = connectionstring;
CMDLoad = newSqlCommand();
CMDLoad.Connection = CONLoad;
CMDLoad.CommandTimeout = 60;
CMDLoad.CommandType = CommandType.Text;
CMDLoad.CommandText = STRLoad;
if (CONLoad.State != ConnectionState.Open)
CONLoad.Open();
{
try
{
dgmayor.DataSource = CMDLoad.ExecuteReader();
dgmayor.DataBind();
}
catch
{
lblerror.Text = " .";
}
}
if (CMDLoad != null)
{
CMDLoad.Dispose();
CMDLoad = null;
}
if (CONLoad != null)
{
if (CONLoad.State != System.Data.ConnectionState.Closed)
CONLoad.Close();
CONLoad.Dispose();
CONLoad = null;
}