我将Acc数据库account1填充comboBox1控件(选择帐号).代码如下:private void Loading_Load(object sender, EventArgs e)
{
this.accTableAdapter.Fill(this.account1_DataDataSet.Acc);
string sqlstring = "select * from Account1_Data";
string tbname = "Acc";
string member = "accnumber";//帐号列
cmboxBind(sqlstring, tbname, member, comboBox1);
}然后在该form中建了TextBox1控件.//密码输入框功能:在comboBox1下拉列表中选择数据库中已有(accnumber列),在TextBox1控件中输入密码,然后将TextBox1中的密码与数据库中该帐号行的code列(即密码列)判断输入密码是否正确.
并且TextBox1显示的是*号(能实现这个功能那就太最好了)
{
this.accTableAdapter.Fill(this.account1_DataDataSet.Acc);
string sqlstring = "select * from Account1_Data";
string tbname = "Acc";
string member = "accnumber";//帐号列
cmboxBind(sqlstring, tbname, member, comboBox1);
}然后在该form中建了TextBox1控件.//密码输入框功能:在comboBox1下拉列表中选择数据库中已有(accnumber列),在TextBox1控件中输入密码,然后将TextBox1中的密码与数据库中该帐号行的code列(即密码列)判断输入密码是否正确.
并且TextBox1显示的是*号(能实现这个功能那就太最好了)
accnumber 为帐号列
code 为密码列控件ComboBox1为帐号选择筐
空间TextBox为密码输入筐已有实例accTableAdapter,account1_DataDataSet
数据库名为:Acc
表名为:accounts
:TextBox1 PasswordChar 属性里放 *
string sqlstring = "select * from Account1_Data";
string tbname = "Acc";
string member = "accnumber";//帐号列
cmboxBind(sqlstring, tbname, member, comboBox1);
因为我觉得this.accTableAdapter.Fill(this.account1_DataDataSet.Acc);应该包含在 cmboxBind()方法里;或者是string sqlstring = "select * from Account1_Data";
string tbname = "Acc";
string member = "accnumber";//帐号列
cmboxBind(sqlstring, tbname, member, comboBox1);
this.accTableAdapter.Fill(this.account1_DataDataSet.Acc);
string tbname = "Acc"; //Acc 为表名
string member = "accnumber";//列名表示帐号
cmboxBind(sqlstring, tbname, member, comboBox1); 自己写的方法,填充comboBox1控件
this.accTableAdapter.Fill(this.account1_DataDataSet.Acc);
一点用都没有.
既然你在自己的函数里实现取数据库内容(因为你传的参数是sql语句)