如何在两个组合框中的数据库中生成列 [英] How Can I Generate A Column In A Database In A Two Combo Boxes

问题描述

MySqlConnection con = new MySqlConnection（Server = localhost; UID = root; Database = db_cignal）;

con.Open（）;

MySqlCommand cmd = con .CreateCommand（）;

cmd.CommandText =从库存中选择日期;

MySqlDataReader阅读器;



reader = cmd.ExecuteReader（）;

DataTable dt = new DataTable（）;

DataTable dtt = new DataTable（）;

dt .Columns.Add（Date，typeof（String））;

dtt.Columns.Add（Date，typeof（String））;

dt.Load （读者）;



cbTo.DisplayMember =日期;

cbTo.ValueMember =日期;

cbFrom.DisplayMember =Date;

cbFrom.ValueMember =Date;

cbFrom.DataSource = dtt;

cbTo。 DataSource = dt;



con.Close（）;

解决方案

MySqlConnection con = new MySqlConnection（connection ...）;

con.Open（） ;

MySqlCommand cmd = con.CreateCommand（）;

cmd.CommandText =从库存中选择日期;

MySqlDataReader reader;



reader = cmd.ExecuteReader（）;

DataTable dt = new DataTable（）;

dt.Columns。添加（日期，类型（字符串））;

dt.Load（读者）;



cbFrom.ValueMember =日期 ;

cbFrom.DisplayMember =日期;

cbFrom.DataSource = dt;



cbTo.BindingContext = new BindingContext（）;

cbTo.ValueMember =Date;

cbTo.DisplayMember =Date;

cbTo.DataSource = DT;

MySqlConnection con = new MySqlConnection("Server=localhost;UID=root;Database=db_cignal");
con.Open();
MySqlCommand cmd = con.CreateCommand();
cmd.CommandText = "select Date from inventoryout";
MySqlDataReader reader;

reader = cmd.ExecuteReader();
DataTable dt = new DataTable();
DataTable dtt = new DataTable();
dt.Columns.Add("Date", typeof(String));
dtt.Columns.Add("Date", typeof(String));
dt.Load(reader);

cbTo.DisplayMember = "Date";
cbTo.ValueMember = "Date";
cbFrom.DisplayMember = "Date";
cbFrom.ValueMember = "Date";
cbFrom.DataSource = dtt;
cbTo.DataSource = dt;

con.Close();

解决方案

MySqlConnection con = new MySqlConnection("connection...");
con.Open();
MySqlCommand cmd = con.CreateCommand();
cmd.CommandText = "select Date from inventoryout";
MySqlDataReader reader;

reader = cmd.ExecuteReader();
DataTable dt = new DataTable();
dt.Columns.Add("Date", typeof(String));
dt.Load(reader);

cbFrom.ValueMember = "Date";
cbFrom.DisplayMember = "Date";
cbFrom.DataSource = dt;

cbTo.BindingContext = new BindingContext();
cbTo.ValueMember = "Date";
cbTo.DisplayMember = "Date";
cbTo.DataSource = dt;

这篇关于如何在两个组合框中的数据库中生成列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！