C#关于ComboBox控件链接数据库的应用操作
string lianjieshujuku ="Provider=Microsoft.Jet.OLEDB.4.0;Jet OLEDB:Data Source=数据库名称";
OleDbConnectioncon=new OleDbConnection(lianjieshujuku);
con.Open();
DataSet ds =new DataSet();
OleDbDataAdapter da= new OleDbDataAdapter("select stuId from tb_student",con);
Da.Fill(ds);
comboBox1.DataSource=ds.Tables[0].DefaultView;
comboBox1.DisplayMember = "stuId";
注意:需要引用using System.Data.OleDb;命名空间
C#关于ComboBox控件查询功能的应用操作
comboBox1.Items.Clear();
comboBox1.Items.Add("你好");
comboBox1.Items.Add("大海");
comboBox1.Items.Add("天空");
comboBox1.Items.Add("中国");
comboBox1.Items.Add("小三");
comboBox1.Items.Add("小四");
comboBox1.Items.Add("本世纪");
comboBox1.Items.Add("功臣");
this.comboBox1.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
this.comboBox1.AutoCompleteSource = AutoCompleteSource.ListItems;
C#关于ListBox控件连接数据库并添加选项功能应用操作
private System.Windows.Forms.ListBox lbSocure;
private System.Windows.Forms.ListBox lbChoose;
SqlConnection con = new SqlConnection("server=(local);uid=sa;pwd=sa;database=数据库名称");
con.Open();
SqlCommand com = new SqlCommand("select * from 表名", con);
SqlDataReader dr = com.ExecuteReader();
this.Items.Clear();
while (dr.Read())
{
this.lbSocure.Items.Add(dr[1].ToString());
}
private void button2_Click(object sender, EventArgs e)//全部添加到选择的项中
{
for (int i = 0; i < lbSocure.Items.Count; i++)
{
lbSocure.SelectedIndex=i;
lbChoose.Items.Add(lbSocure.SelectedItem.ToString());
}
lbSocure.Items.Clear();
}
private void button3_Click(object sender, EventArgs e)//全部添加到数据源中
{
for (int i = 0; i < lbChoose.Items.Count; i++)
{
lbChoose.SelectedIndex = i;
lbSocure.Items.Add(lbChoose.SelectedItem.ToString());
}
lbChoose.Items.Clear();
}
注意:需要引用using System.Data. SqlClient;命名空间
C#关于ListBox控件连接数据库的功能应用操作
SqlConnection con = new SqlConnection("server=(local);uid=sa;pwd=;database=数据库名称");
con.Open();
SqlCommand com = new SqlCommand("select * from 表名", con);
SqlDataReader dr = com.ExecuteReader();
while (dr.Read())
{
this.listBox1.Items.Add(dr[1].ToString());
}
注意:需要引用using System.Data. SqlClient;命名空间
C#关于ListBox控件借助绑定实现数据选择录入功能应用
private void Form1_Load(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection("server=(local);uid=sa;pwd=;database=数据库名称");
con.Open();
SqlCommand com = new SqlCommand("select * from 表名", con);
SqlDataReader dr = com.ExecuteReader();
while (dr.Read())
{
this.listBox1.Items.Add(dr[1].ToString());
}
}
private void listBox1_SelectedIndexChanged(object sender, EventArgs e)
{
if (listBox1.SelectedItem.ToString() != null)
{
textBox2.Text = listBox1.SelectedItem.ToString();
}
}
private void button2_Click(object sender, EventArgs e)
{
textBox1.Text = "";
textBox2.Text = "";
}
private void listBox1_SelectedIndexChanged_1(object sender, EventArgs e)
{
if (listBox1.SelectedItem.ToString() != null)
{
textBox2.Text = listBox1.SelectedItem.ToString();
}
}
注意:需要引用using System.Data. SqlClient;命名空间
C#关于ListBox控件拒绝加入重复信息的功能应用
if (textBox1.Text == "")
{
button3.Text = "商品名称不能为空";
button3.ForeColor = Color.Red;
textBox1.Focus();
}
else
{
if (listBox1.Items.Count > 0)
{
for (int i = 0; i < listBox1.Items.Count; i++)
{
if (listBox1.Items[i].ToString() == textBox1.Text)
{
button3.Text = "商品名称已存在";
button3.ForeColor = Color.Red;
textBox1.Text = "";
textBox1.Focus();
return;
}
}
listBox1.Items.Add(textBox1.Text);
textBox1.Text = "";
return;
}
listBox1.Items.Add(textBox1.Text);
textBox1.Text = "";
}
C#关于ListBox控件利用选择控件实现复杂查询功能应用
public void GetScoure( string strSql)
{
SqlConnection con = new SqlConnection("server=(local);pwd=;uid=sa;database=数据库名称");
con.Open();
SqlCommand com = new SqlCommand(strSql, con);
dataGridView1.Rows.Clear();
SqlDataReader dr = com.ExecuteReader();
while (dr.Read())
{
dataGridView1.Rows.Add(dr[0].ToString(), dr[1].ToString(), dr[2].ToString(), dr[3].ToString(), dr[4].ToString(), dr[5].ToString());
}
dr.Close();
con.Close();
}
private void bntEsce_Click(object sender, EventArgs e)
{
ckClass.Checked = false;
ckName.Checked = false;
ckId.Checked = false;
rdbMan.Checked = false;
rdbWoMan.Checked = false;
}
private void ckId_CheckedChanged(object sender, EventArgs e)
{
if (ckId.Checked == true)
{
txtstuId.Enabled = true;
txtstuId.Focus();
}
else
}
private void ckClass_CheckedChanged(object sender, EventArgs e)
{
if (ckClass.Checked == true)
{
txtClasss.Enabled = true;
txtClasss.Focus();
}
else
{
txtClasss.Text = "";
txtClasss.Enabled = false;
}
}
private void ckName_CheckedChanged(object sender, EventArgs e)
{
if (ckName.Checked == true)
{
txtName.Enabled = true;
txtName.Focus();
}
else
{
txtName.Text = "";
txtName.Enabled = false;
}
}
public string strSql;//用于存储SQL语句
public string strId;//用于存学生编号
public string strName;//用于存储学生姓名
public string strClass;//用于存储学生班级
public string strSex;//用于存储学生姓别
public static int intCount=0;//控制数据组索引
public string[] strScoure = new string[4];
public int intAdd ;//用来判断SQL语句数组
private void bntSearch_Click(object sender, EventArgs e)
{
intCount = 0;
if (txtstuId.Text != "")
strId = "学生编号
strScoure[intCount]=strId;
intCount++;
}
{
strName = "学生姓名 like '%" + txtName.Text + "%' ";
strScoure[intCount]= strName;
intCount++;
}
strClass = "所在年级 like '%" + txtClasss.Text + "%'";
strScoure[intCount]= strClass;
intCount++;
strSex = "学生性别 like '%" + rdbWoMan.Text + "%'";
strSql += strScoure[i];
intAdd++;
}
}// end
switch (intAdd)
{
case 0:
strSql = "select * from tb_01";
break;
case 1:
strSql = "select * from tb_01 where "+ strScoure[0];
break;
break;
case 3:
strSql = "select * from tb_01 where " + strScoure[0] + " and " + strScoure[1] + " and " + strScoure[2];
break;
case 4:
strSql = "select * from tb_01 where " + strScoure[0] + " and " + strScoure[1] + " and " + strScoure[2] + " and " + strScoure[3];
break;
}
GetScoure(strSql);
intAdd = 0;
intCount = 0;
strSql = "";
for (int i = 0; i < strScoure.Length; i++)
{
if (strScoure[i] != null)
{
strScoure[i] = null;
}
}// end
}
public void getScoure(string str_name)
{
SqlConnection con = new SqlConnection("server=.;uid=sa;pwd=;database=数据库名称");
con.Open();
SqlCommand com = new SqlCommand("select * from 表名 where 列名= '" + 输入控件名称 + "'", con);
SqlDataReader dr = com.ExecuteReader();//
while (dr.Read())
{
txtId.Text = dr[0].ToString();
txtName.Text = dr[1].ToString();
txtEmpty.Text = dr[2].ToString();
txtSex.Text = dr[3].ToString();
txtAge.Text = dr[4].ToString();
txtXueLi.Text = dr[5].ToString();
txtTeching.Text = dr[6].ToString();
}
dr.Close();
C#关于ListView控件连接数据库功能应用
#region 数据库连接字符串
//string findatabase = Application.StartupPath + "//数据库名称";
string lianjieshujuku = "Provider=Microsoft.Jet.OLEDB.4.0;Jet OLEDB:Database Password=密码;Data Source=数据库名称";
#endregion
#region 连接数据库
OleDbConnection con = new OleDbConnection(lianjieshujuku);
OleDbCommand cmd = new OleDbCommand("Select * from 表名", con);
con.Open();
OleDbDataReader read = cmd.ExecuteReader();
while (read.Read())
{
ListViewItem item = new ListViewItem(read[0].ToString());
item.SubItems.Add(read[1].ToString());
this.listView1.Items.Add(item);
}
con.Close();
con.Dispose();
}
#endregion