1、三:实验目的:实现查询我的好友信息,实现增,删,改功能四:实验内容及步骤:(1)创建数据库(2)登录界面: 登录成功登录按钮单击代码:private void button1_Click(object sender, EventArgs e) if (textBox1.Text = string.Empty | textBox2.Text = string.Empty) MessageBox.Show(信息不完整!, 登录); return; if (textBox1.Text.Equals(admin) | textBox2.Text.Equals() MessageBox.Show(登录成
2、功! this.Hide(); new Form2().Show(); else 用户名或密码错误!退出按钮单击代码:private void button2_Click(object sender, EventArgs e) this.Close();(3)浏览/查找界面:private void Form2_Load(object sender, EventArgs e) string connStr = Data Source=.;Initial Catalog=通讯录;Persist Security Info=True;User ID=ftf;Password=935285641;
3、string _sql = select XM as 姓名,XB as 性别,DH as 电话,DZ as 地址,QQ as QQfrom TongXun SqlConnection conn = new SqlConnection(connStr); SqlDataAdapter sda = new SqlDataAdapter(_sql, conn); DataSet ds = new DataSet(); sda.Fill(ds); dataGrid.DataSource = ds.Tables0.DefaultView;产生SQL语句代码:private void MakeSqlStr
4、() sql = if (name.Text.Trim() != string.Empty) and XM like % + name.Text.Trim() + % if (xingbie.Text.Trim() ! sql += and XB like + xingbie.Text.Trim() + 查询按钮单击代码: MakeSqlStr();from TongXun where 1=1+sql;添加删除按钮单击代码:private void button3_Click(object sender, EventArgs e) new Form6().Show();/ Form1.Clos
5、e();(3)浏览界面:界面更改联系人删除联系人添加联系人private void Form3_Load(object sender, EventArgs e) dataGridView1.DataSource = ds.Tables0.DefaultView;单击GridView1表格代码:private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e) DataGridViewRow dgvRow = dataGridView1.Rowse.RowIndex; DataGridVi
6、ewCellCollection dgvCC = dgvRow.Cells; xingming.Text = dgvCC0.Value.ToString(); if (dgvCC1.Value.ToString().Contains(男 nan.Checked = true; else nv.Checked = true; dianhua.Text = dgvCC2.Value.ToString(); dizhi.Text = dgvCC3.Value.ToString(); qq.Text = dgvCC4.Value.ToString();更新按键单击代码:select count(*)
7、from TongXun where XM= + xingming.Text + ; SqlCommand cmd = new SqlCommand(_sql, conn); try conn.Open(); int cnt = (int)cmd.ExecuteScalar();string sex = nan.Checked ? :女 if (cnt = 1) cmd = new SqlCommand(_sql, conn); _sql = update TongXun set XM=,XB= + sex + ,DH= + dianhua.Text + ,DZ= + dizhi.Text +
8、 ,QQ= + qq.Text + where XM=insert into TongXun values(,) cmd.ExecuteNonQuery(); Form3_Load(null, null);if (cnt = 1) MessageBox.Show(xingming.Text.Trim()+更新成功!更新提示 MessageBox.Show(xingming.Text.Trim() + 添加成功!添加提示 finally conn.Close();备注:单击可选择可内容,单击更新若姓名相同更改内容,否者增加联系人。删除按键单击代码: DialogResult ret = MessageBox.Show(确定要删除 + xingming.Text.Trim()+ 的记录吗?删除, MessageBoxButtons.OKCancel, MessageBoxIcon.Question); if (ret = DialogResult.Cancel) return; string _sql = delete from TongXun where XM=+xingming.Text+and DZ=+dizhi.Text+ SqlCommand cmd= new SqlCommand(_sql, conn); int rows =
copyright@ 2008-2022 冰豆网网站版权所有
经营许可证编号:鄂ICP备2022015515号-1