SqlDataReader myreader = null;
SqlConnection sqlConn = null;
cmbCat.Items.Clear();
sqlConn = new SqlConnection("Data Source=tin;Initial Catalog=sample;Trusted_Connection=yes;");
sqlConn.Open();
SqlCommand sqlComm = new SqlCommand("SELECT members FROM dbo.tbl_Category", sqlConn);
myreader = sqlComm.ExecuteReader();
if (myreader != null)
{
while (myreader.Read())
{
cmbCat.Items.Add(myreader["members"]);
}
}
{
if (myreader != null)
myreader.Close();
if (sqlConn != null)
{
if (sqlConn.State == ConnectionState.Open)
sqlConn.Close();
}
}
SqlDataReader myreader = null;
SqlConnectio