string sqlConnection = ConfigurationSettings.AppSettings["ConnString"]; SqlConnection sqlConn = new SqlConnection(sqlConnection);
SqlConnection conn1 = new SqlConnection(sqlConnection); SqlCommand cmd1 = new SqlCommand("select * from productsmallkind where Kind='"+tbBigKidName.Text.Trim().Replace("'","")+"' order by num desc", conn1); SqlDataAdapter adapter1 = new SqlDataAdapter(cmd1); DataSet ds1=new DataSet(); adapter1.Fill(ds1,"data"); conn1.Close();