Go homepage(回首页)
Upload pictures (上传图片)
Write articles (发文字帖)

The author:(作者)delv
published in(发表于) 2014/1/23 2:48:15
.Net+MySQL组合开发(二)，数据访问篇_[Asp.Net教程]

为了方便，把对数据的访问封装到一个类中：
1// 执行sql
2public int ExecuteSql(string strSql, MySqlParameter [] myPar)
3 {
4 try
5 {
6 myConnection.Open();
7 MySqlCommand cmd = new MySqlCommand(strSql, myConnection);
8 if (myPar != null)
9 {
10 foreach (MySqlParameter spar in myPar)
11 {
12 cmd.Parameters.Add(spar);
13 }
14 }
15 int result = cmd.ExecuteNonQuery();
16 myConnection.Close();
17 return result;
18 }
19 catch
20 {
21 return 0;
22 }
23 }获取数据：
1 public DataSet GetDataSet(string strSql)
2 {
3 try
4 {
5 MySqlDataAdapter da = new MySqlDataAdapter(strSql, myConnection);
6 DataSet ds = new DataSet();
7 da.Fill(ds);
8 return ds;
9 }
10 catch
11 {
12 return null;
13 }
14 }

在页面中我们用一个gridview实现数据的读取、写入、编辑、删除等操作：


数据绑定：
1 //databind
2 protected void BindGrid()
3 {
4 DataSet ds = obj.GetDataSet("SELECT * FROM book ORDER BY bid");
5 GridView1.DataSource = ds;
6 GridView1.DataBind();
7 ds.Dispose();
8 }添加数据：
1 string strSQL = "INSERT INTO book (bname,author,publish) VALUES (?bname,?author,?publish)";
2 MySqlParameter[] mysp =
3 {
4 new MySqlParameter ("?bname",MySqlDbType.VarChar ),
5 new MySqlParameter ("?author",MySqlDbType.VarChar),
6 new MySqlParameter ("?publish",MySqlDbType.VarChar)
7 };
8 mysp[0].Value = txtName.Text.Trim();
9 mysp[1].Value = txtAuthor.Text.Trim();
10 mysp[2].Value = txtPublish.Text.Trim();
11 if (obj.ExecuteSql(strSQL, mysp) == 1)
12 {
13 Response.Write("
alert('提交成功');
");
14 BindGrid();
15 txtName.Text = txtAuthor.Text = txtPublish.Text = "";
16 }

注意参数符号是"?"而不是"@"，这一点不同于sql server
其它编辑等操作代码等请下载文件
下载详细完整的代码文件/Files/chy710/MySQL_ADONET.rar

来源：chy710的blog

赞

---

If you have any requirements, please contact webmaster。(如果有什么要求，请联系站长)

---

QQ:154298438
QQ:417480759