学步园

using System;<br /> using System.Data;<br /> using System.Configuration;<br /> using System.Web;<br /> using System.Web.Security;<br /> using System.Web.UI;<br /> using System.Web.UI.WebControls;<br /> using System.Web.UI.WebControls.WebParts;<br /> using System.Web.UI.HtmlControls;<br /> using System.Data.SqlClient;</p> <p>public partial class _Default : System.Web.UI.Page<br /> {<br /> protected void Page_Load(object sender, EventArgs e)<br /> {<br /> if (!IsPostBack)<br /> {<br /> BindGridView();<br /> }<br /> }<br /> private void BindGridView()<br /> {<br /> SqlConnection conn = new SqlConnection("server=(local);Initial Catalog=week;Integrated Security=true");<br /> SqlDataAdapter sda = new SqlDataAdapter("select * from week1 ", conn);<br /> DataSet ds = new DataSet();<br /> sda.Fill(ds,"week1");<br /> DataTable dt = ds.Tables["week1"];<br /> GridView1.DataKeyNames = new string[] { "id" };<br /> GridView1.DataSource = dt;<br /> GridView1.DataBind();</p> <p> }</p> <p> protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)<br /> {<br /> 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()+"'";</p> <p> SqlConnection conn=new SqlConnection("server=.;Initial Catalog=week;Integrated Security=true");<br /> SqlCommand comm=new SqlCommand(strsql,conn);<br /> conn.Open();<br /> comm.ExecuteNonQuery();<br /> conn.Close();<br /> GridView1.EditIndex=-1;<br /> BindGridView();</p> <p> }<br /> protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)<br /> {<br /> GridView1.EditIndex=e.NewEditIndex;<br /> BindGridView();<br /> }<br /> protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)<br /> {<br /> GridView1.EditIndex=-1;<br /> BindGridView();<br /> }<br /> protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)<br /> {<br /> GridView1.PageIndex = e.NewPageIndex;<br /> BindGridView();<br /> }<br /> }</p> <p>

连接数据库，用gridview实现动态绑定