一、思维导图
二、知识点描述+示例(运行截图)
1.输出:声明并实例化SQL数据适配器,同时借助构造函数,将其SelectCommand属性设为先前创建的SQL命令,然后SQL数据适配器利用FILL方法读取数据,之后调用SQL命令的方法ExecuteReader来执行命令,并获取数据阅读器,最后在数据阅读器的索引器中指定列名,从而访问当前记录的指定列的值,并赋予相应控件,即输出数据成功。
SqlConnection sqlConnection = new SqlConnection();
sqlConnection.ConnectionString =
ConfigurationManager.ConnectionStrings["Sql"].ConnectionString;
SqlCommand sqlCommand = new SqlCommand();
SqlCommand sqlCommand2 = new SqlCommand();
sqlCommand.Connection = sqlConnection;
sqlCommand2.Connection = sqlConnection;
sqlCommand.CommandText = "SELECT * FROM tb_Province;";
sqlCommand2.CommandText = "SELECT * FROM tb_Drug WHERE DrugNo=@DrugNo;";
sqlCommand2.Parameters.AddWithValue("@DrugNo", this.txb_DrugNo.Text.Trim());
SqlDataAdapter sqlDataAdapter = new SqlDataAdapter();
sqlDataAdapter.SelectCommand = sqlCommand;
DataTable provinceTable = new DataTable();
sqlConnection.Open();
sqlDataAdapter.Fill(provinceTable);
this.cmb_ProducingArea.DataSource = provinceTable;
this.cmb_ProducingArea.DisplayMember = "Name";
this.cmb_ProducingArea.ValueMember = "No";