数据的查询,更改和删除
来源:互联网 发布:apache插件 编辑:程序博客网 时间:2024/05/29 18:16
private void DataLoad()
{
#region 连接数据库查询数据
string sqlserstr = ConfigurationManager.ConnectionStrings["sqlname"].ConnectionString;
SqlConnection conn = new SqlConnection(sqlserstr);
conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = "select * from StudentInto where Stu_Name=@name or Stu_Mobile=@mobile";
cmd.Parameters.AddWithValue("@name", txbQuery.Text);
cmd.Parameters.AddWithValue("@mobile", txbQuery.Text);
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
adapter.Fill(dt);
cmd.Dispose();
conn.Close();
conn.Dispose();
this.dataGridView1.DataSource = dt;
#endregion
}
private void button1_Click(object sender, EventArgs e)
{
#region 连接数据库查询数据
string sqlserstr = ConfigurationManager.ConnectionStrings["sqlname"].ConnectionString;
SqlConnection conn = new SqlConnection(sqlserstr);
conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = "select * from StudentInto where Stu_Name=@name or Stu_Mobile=@mobile";
cmd.Parameters.AddWithValue("@name", txbQuery.Text);
cmd.Parameters.AddWithValue("@mobile", txbQuery.Text);
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
adapter.Fill(dt);
cmd.Dispose();
conn.Close();
conn.Dispose();
this.dataGridView1.DataSource = dt;
#endregion
}//查询数据
private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)//抽取文本的值
{
if (this.dataGridView1.SelectedRows.Count > 0)
{
DataGridViewRow row = this.dataGridView1.SelectedRows[0];
#region 获取选中行的内容并填充到文本框中
this.txbId.Text = row.Cells[0].Value.ToString();
this.txbName.Text = row.Cells[1].Value.ToString();
this.txbMobile.Text = row.Cells[6].Value.ToString();
this.txbAddress.Text = row.Cells[5].Value.ToString();
this.txbGrade.Text = row.Cells[3].Value.ToString();
this.cmbAward.Text = "";
this.cmbAward.Text = row.Cells[7].Value.ToString();
this.cmbClass.Text = "";
this.cmbClass.Text = row.Cells[4].Value.ToString();
string gender = row.Cells[4].Value.ToString();
if (gender == "女")
{
radioWoman.Checked = true;
}
if (gender == "男")
{
radioMan.Checked = true;
}
#endregion
}
}
private void button2_Click(object sender, EventArgs e)//更改数据库数据
{
#region 获取用户输入
string Id = this.txbId.Text; //获取学号
string name = this.txbName.Text; //获取姓名
string gender = ""; //获取性别
if (radioMan.Checked)
{
gender = radioMan.Text;
}
if (radioWoman.Checked == true)
{
gender = radioWoman.Text;
}
string mobile = this.txbMobile.Text; //获取手机
string address = this.txbAddress.Text; //获取地址
string grade = this.txbGrade.Text; //获取高考成绩
string award = this.cmbAward.Text; //获取奖品
string stu_class = this.cmbClass.Text; //获取系别
#endregion
#region 将更改结果保存到数据库
string sqlserstr = ConfigurationManager.ConnectionStrings["sqlname"].ConnectionString;
SqlConnection conn = new SqlConnection(sqlserstr);
conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = "update StudentInto set Stu_Name=@name,Stu_Mobile=@moile,Stu_Address=@address,Stu_Gender=@gender,Stu_Class=@class,Stu_Grade=@grade,Stu_Award=@award where Stu_Id=@id";
#region 参数替换
cmd.Parameters.AddWithValue("@name", name);
cmd.Parameters.AddWithValue("@moile", mobile);
cmd.Parameters.AddWithValue("@address", address);
cmd.Parameters.AddWithValue("@gender", gender);
cmd.Parameters.AddWithValue("@class", stu_class);
cmd.Parameters.AddWithValue("@grade", grade);
cmd.Parameters.AddWithValue("@award", award);
cmd.Parameters.AddWithValue("@id", Id);
#endregion
int result = cmd.ExecuteNonQuery();
cmd.Dispose();
conn.Close();
cmd.Dispose();
if (result > 0)
{
MessageBox.Show("更改成功");
}
#endregion
DataLoad();
}
private void button3_Click(object sender, EventArgs e)//删除数据
{
DataGridViewRow row = this.dataGridView1.SelectedRows[0];
#region 删除数据库中的数据
string sqlserstr = ConfigurationManager.ConnectionStrings["sqlname"].ConnectionString;
SqlConnection conn = new SqlConnection(sqlserstr);
conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = "delete from StudentInto where Stu_Id=@id";
cmd.Parameters.AddWithValue("@id", row.Cells[0].Value.ToString());
cmd.ExecuteNonQuery();
cmd.Dispose();
conn.Close();
conn.Dispose();
MessageBox.Show("删除成功");
#endregion
this.dataGridView1.Rows.Remove(row);//删除表中行
{
#region 连接数据库查询数据
string sqlserstr = ConfigurationManager.ConnectionStrings["sqlname"].ConnectionString;
SqlConnection conn = new SqlConnection(sqlserstr);
conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = "select * from StudentInto where Stu_Name=@name or Stu_Mobile=@mobile";
cmd.Parameters.AddWithValue("@name", txbQuery.Text);
cmd.Parameters.AddWithValue("@mobile", txbQuery.Text);
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
adapter.Fill(dt);
cmd.Dispose();
conn.Close();
conn.Dispose();
this.dataGridView1.DataSource = dt;
#endregion
}
private void button1_Click(object sender, EventArgs e)
{
#region 连接数据库查询数据
string sqlserstr = ConfigurationManager.ConnectionStrings["sqlname"].ConnectionString;
SqlConnection conn = new SqlConnection(sqlserstr);
conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = "select * from StudentInto where Stu_Name=@name or Stu_Mobile=@mobile";
cmd.Parameters.AddWithValue("@name", txbQuery.Text);
cmd.Parameters.AddWithValue("@mobile", txbQuery.Text);
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
adapter.Fill(dt);
cmd.Dispose();
conn.Close();
conn.Dispose();
this.dataGridView1.DataSource = dt;
#endregion
}//查询数据
private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)//抽取文本的值
{
if (this.dataGridView1.SelectedRows.Count > 0)
{
DataGridViewRow row = this.dataGridView1.SelectedRows[0];
#region 获取选中行的内容并填充到文本框中
this.txbId.Text = row.Cells[0].Value.ToString();
this.txbName.Text = row.Cells[1].Value.ToString();
this.txbMobile.Text = row.Cells[6].Value.ToString();
this.txbAddress.Text = row.Cells[5].Value.ToString();
this.txbGrade.Text = row.Cells[3].Value.ToString();
this.cmbAward.Text = "";
this.cmbAward.Text = row.Cells[7].Value.ToString();
this.cmbClass.Text = "";
this.cmbClass.Text = row.Cells[4].Value.ToString();
string gender = row.Cells[4].Value.ToString();
if (gender == "女")
{
radioWoman.Checked = true;
}
if (gender == "男")
{
radioMan.Checked = true;
}
#endregion
}
}
private void button2_Click(object sender, EventArgs e)//更改数据库数据
{
#region 获取用户输入
string Id = this.txbId.Text; //获取学号
string name = this.txbName.Text; //获取姓名
string gender = ""; //获取性别
if (radioMan.Checked)
{
gender = radioMan.Text;
}
if (radioWoman.Checked == true)
{
gender = radioWoman.Text;
}
string mobile = this.txbMobile.Text; //获取手机
string address = this.txbAddress.Text; //获取地址
string grade = this.txbGrade.Text; //获取高考成绩
string award = this.cmbAward.Text; //获取奖品
string stu_class = this.cmbClass.Text; //获取系别
#endregion
#region 将更改结果保存到数据库
string sqlserstr = ConfigurationManager.ConnectionStrings["sqlname"].ConnectionString;
SqlConnection conn = new SqlConnection(sqlserstr);
conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = "update StudentInto set Stu_Name=@name,Stu_Mobile=@moile,Stu_Address=@address,Stu_Gender=@gender,Stu_Class=@class,Stu_Grade=@grade,Stu_Award=@award where Stu_Id=@id";
#region 参数替换
cmd.Parameters.AddWithValue("@name", name);
cmd.Parameters.AddWithValue("@moile", mobile);
cmd.Parameters.AddWithValue("@address", address);
cmd.Parameters.AddWithValue("@gender", gender);
cmd.Parameters.AddWithValue("@class", stu_class);
cmd.Parameters.AddWithValue("@grade", grade);
cmd.Parameters.AddWithValue("@award", award);
cmd.Parameters.AddWithValue("@id", Id);
#endregion
int result = cmd.ExecuteNonQuery();
cmd.Dispose();
conn.Close();
cmd.Dispose();
if (result > 0)
{
MessageBox.Show("更改成功");
}
#endregion
DataLoad();
}
private void button3_Click(object sender, EventArgs e)//删除数据
{
DataGridViewRow row = this.dataGridView1.SelectedRows[0];
#region 删除数据库中的数据
string sqlserstr = ConfigurationManager.ConnectionStrings["sqlname"].ConnectionString;
SqlConnection conn = new SqlConnection(sqlserstr);
conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = "delete from StudentInto where Stu_Id=@id";
cmd.Parameters.AddWithValue("@id", row.Cells[0].Value.ToString());
cmd.ExecuteNonQuery();
cmd.Dispose();
conn.Close();
conn.Dispose();
MessageBox.Show("删除成功");
#endregion
this.dataGridView1.Rows.Remove(row);//删除表中行
}
- 数据的查询,更改和删除
- 由mysql数据库基础上的php程序实现单词的查询、删除、更改和查询
- JAVA对数据库进行操作,实现数据库中数据的插入,查询,更改,删除操作
- litepal查询和删除数据
- ORACLE查询表最近更改的数据
- oracle查询表最近更改的数据
- ORACLE查询表最近更改的数据
- 查询和删除数据表中重复数据的sql
- 数据更改与查询
- 数据库的删除和更改操作
- Sql 查询和删除重复数据
- sql 查询和删除冗余数据
- 实现datagridview中数据的添加,更改,删除功能
- Mysql 查询表中重复数据和删除表中重复的数据
- mysql查询表里的重复数据方法和删除重复数据
- ORACLE查询表最近更改的数据记录
- 向数据库查询或者更改String类型数据的问题
- CListCtrl(数据的插入、删除、查询)
- Exercise4.3 E2
- Win7开自带的虚拟WIFI
- 将pygame文件打包成.exe文件
- g斯蒂芬格式的
- 位运算的实例
- 数据的查询,更改和删除
- python simplejson模块的使用方法
- Notification应用(包括添加为“正在进行的”)
- 15个步骤创立技术公司,并收获千万用户(完结)
- system center 2012sp1
- UVa 10773 Back to Intermediate Math (数学&速度的分解&陷阱)
- Linux 物理内存减少了原因说明
- 第一次
- 向Python女神推荐这些年我追过的经典书籍