gridview连接mysql_gridview实现数据库绑定

最新推荐文章于 2021-02-15 22:01:07 发布

原创最新推荐文章于 2021-02-15 22:01:07 发布 · 239 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#gridview连接mysql

本文档展示了如何使用C#编程语言将GridView控件与MySQL数据库进行连接和绑定，包括加载数据、更新记录、编辑和取消编辑操作。通过示例代码详细解释了在ASP.NET页面中如何实现数据的动态显示和交互。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

using System;

using System.Data;

using System.Configuration;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Web.UI.HtmlControls;

using System.Data.SqlClient;

public partial class _Default : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

BindGridView();

}

private void BindGridView()

{

SqlConnection conn = new SqlConnection("server=(local);Initial Catalog=week;Integrated Security=true");

SqlDataAdapter sda = new SqlDataAdapter("select * from week1 ", conn);

DataSet ds = new DataSet();

sda.Fill(ds,"week1");

DataTable dt = ds.Tables["week1"];

GridView1.DataKeyNames = new string[] { "id" };

GridView1.DataSource = dt;

GridView1.DataBind();

}

protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)//更新

{

string strsql="update week1 set Monday='"+((TextBox)(GridView1.Rows[e.RowIndex].Cells[0].Controls[0])).Text.ToString().Trim()+"',Tuesday='"+((TextBox)(GridView1.Rows[e.RowIndex].Cells[1].Controls[0])).Text.ToString().Trim()+"',Wensday='"+((TextBox)(GridView1.Rows[e.RowIndex].Cells[2].Controls[0])).Text.ToString().Trim()+"',Thursday='"+((TextBox)(GridView1.Rows[e.RowIndex].Cells[3].Controls[0])).Text.ToString().Trim()+"',Friday='"+((TextBox)(GridView1.Rows[e.RowIndex].Cells[4].Controls[0])).Text.ToString().Trim()+"',Saturday='"+((TextBox)(GridView1.Rows[e.RowIndex].Cells[5].Controls[0])).Text.ToString().Trim()+"',Sunday='"+((TextBox)(GridView1.Rows[e.RowIndex].Cells[6].Controls[0])).Text.ToString().Trim()+"' where id='"+GridView1.DataKeys[e.RowIndex].Value.ToString()+"'";

SqlConnection conn=new SqlConnection("server=.;Initial Catalog=week;Integrated Security=true");

SqlCommand comm=new SqlCommand(strsql,conn);

conn.Open();

comm.ExecuteNonQuery();

conn.Close();

GridView1.EditIndex=-1;

BindGridView();

}

protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)

{

GridView1.EditIndex=e.NewEditIndex;

BindGridView();