private void button1_Click(object sender, EventArgs e)
{
//string sql = "select * from type";
SqlConnection con = new SqlConnection("server=XXXX;pwd=XXXXX;uid=sa;database=web1");
con.Open();
SqlCommand com = new SqlCommand("select * from type", con);
SqlDataReader dr = com.ExecuteReader();
while (dr.Read())
{
ListViewItem lv = new ListViewItem(dr[0].ToString()); //注意对象中的数据也可以独立写到语句中
lv.SubItems.Add(dr[1].ToString());
lv.SubItems.Add(dr[2].ToString());
listView1.Items.Add(lv);
}
dr.Close();
}
private void GetEdit(string username)//获取指定信息指向修改界面
{
sql = ""; //根据用户名筛选其余信息
SqlCommand cmd = new SqlCommand(sql, SqlHelper.GetCon());
SqlDataReader re = cmd.ExecuteReader();
listView1.GridLines = true;
listView1.View = View.Details;
while (re.Read()) //把数据赋值到相应的控件中
{
txtId.Text = re[0].ToString(); //可以直接使用整数进行索引或者使用 列明
txtName.Text = re["人员姓名"].ToString();
txtEmpty.Text = re.GetString(2); //通过索引直接获取数据值不需要进行装箱拆箱动作
txtAge.Text = re["年龄"].ToString();
txtSex.Text = re["性别"].ToString();
txtXueLi.Text = re["学历"].ToString();
txtTeching.Text = re["技术职称"].ToString();
}
}
string userName；
private void listView1_Click(object sender, EventArgs e) //获取用户名
{
userName = listView1.SelectedItems[0].SubItems[0].Text; //选中值给到变量
if (userName != null)
{
GetEdit(userName);
}
}
ListView 更改两个属性
.GridLines=true; .view=details;
/// <summary>
/// 判断用户名是否重复
/// </summary>
/// <param name="userName"></param>
public void UserNameRepeatList()
{
if (!String.IsNullOrEmpty(textBox1.Text))
{
object userNameResult = SqlHelper.UserNameRepeat(textBox1.Text);
if (userNameResult!=null&&userNameResult!="")
{
foreach (ListViewItem item in listView1.Items)//遍历集合
{
if (userNameResult.ToString() == item.Text)
{
MessageBox.Show("用户名重复，请重新输入");
textBox1.Clear();
textBox1.Focus();
return;
}
}
}
}