SqlConnection MyConnection;
MyConnection =new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]);
MyConnection.Open();
String strCom1= "SELECT subid,sub FROM sub ORDER BY subid ASC";
DataSet myDataSet1= new DataSet();
SqlDataAdapter myCommand1=new SqlDataAdapter(strCom1,MyConnection);
myCommand1.Fill(myDataSet1,"sub");
sub_list.DataSource = myDataSet1.Tables["sub"].DefaultView;
sub_list.Visible=true;
sub_list.DataBind();其中sub_list为Dropdownlist id.
MyConnection =new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]);
MyConnection.Open();
String strCom1= "SELECT subid,sub FROM sub ORDER BY subid ASC";
DataSet myDataSet1= new DataSet();
SqlDataAdapter myCommand1=new SqlDataAdapter(strCom1,MyConnection);
myCommand1.Fill(myDataSet1,"sub");
sub_list.DataSource = myDataSet1.Tables["sub"].DefaultView;
sub_list.Visible=true;
sub_list.DataBind();其中sub_list为Dropdownlist id.
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货