using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Configuration;
using System.Web.Security;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.Collections;
using System.Xml.Linq;
namespace 考勤管理系統
{
public partial class WebForm3 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{
string str = "Server=.;Database=WAMS;User id=sa;PWD=123456";
SqlConnection conn = new SqlConnection(str);
conn.Open();
string sql = "select stu_num as '學生學號',teacher_num as '老師編號',course_num as '課程編號', course_time as'上課時間',stu_status as '出勤狀態' from work_record where course_num='" + TextBox2.Text + "' and course_time ='" + TextBox3.Text + "' and teacher_num='" + TextBox1.Text + "'";
SqlCommand cmd = new SqlCommand(sql, conn);
SqlDataReader dr = cmd.ExecuteReader();
GridView1.DataSource = dr;
GridView1.DataBind();
dr.Close();
conn.Close();
}
private void Bind()
{
string str = "Server=.;Database=WAMS;User id=sa;PWD=123456";
SqlConnection conn = new SqlConnection(str);
conn.Open();
string sql = "select stu_num as '學生學號',teacher_num as '老師編號',course_num as '課程編號', course_time as'上課時間',stu_status as '出勤狀態' from work_record where course_num='" + TextBox2.Text + "' and course_time ='" + TextBox3.Text + "' and teacher_num='" + TextBox1.Text + "'";
SqlCommand cmd = new SqlCommand(sql, conn);
SqlDataReader dr = cmd.ExecuteReader();
GridView1.DataSource = dr;
GridView1.DataBind();
dr.Close();
conn.Dispose();
}
protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
{
GridView1.EditIndex = e.NewEditIndex;
Bind();
}
protected void GridView1_Rowupdating(object sender, GridViewUpdateEventArgs e)
{
GridViewRow row =GridView1.Rows[e.RowIndex];
string stu_num = row.Cells[1].Text;
string teacher_num = row.Cells[2].Text;
string course_num = row.Cells[3].Text;
string course_time = row.Cells[4].Text;
string stu_status = ((TextBox)row.Cells[5].Controls[0]).Text;
updategridview(stu_num, teacher_num, course_num, course_time, stu_status);
}
private void updategridview(string stu_num, string teacher_num, string course_num, string course_time, string stu_status)
{
string sql = @" update work_record set stu_status=@stu_status
where stu_num =@stu_num and teacher_num =@teacher_num and course_num=@course_num and course_time=@course_time";
string str = "Server=.;Database=WAMS;User id=sa;PWD=123456";
SqlConnection conn = new SqlConnection(str);
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.AddWithValue("@stu_num", stu_num);
cmd.Parameters.AddWithValue("@teacher_num", teacher_num);
cmd.Parameters.AddWithValue("@course_num", course_num);
cmd.Parameters.AddWithValue("@course_time", course_time);
cmd.Parameters.AddWithValue("@stu_status", stu_status);
cmd.ExecuteNonQuery();
cmd.CommandText = @"select stu_num as '學生學號',teacher_num as '老師編號',course_num as '課程編號', course_time as'上課時間',stu_status as '出勤狀態' from work_record where course_num='" + TextBox2.Text + "' and course_time ='" + TextBox3.Text + "' and teacher_num='" + TextBox1.Text + "'";
cmd.Parameters.Clear();
SqlDataReader dr = cmd.ExecuteReader();
GridView1.DataSource = dr;
GridView1.EditIndex = -1;
GridView1.DataBind();
dr.Close();
cmd.Dispose();
}
protected void GridView11_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
{
GridView1.EditIndex = -1;
Bind();
}
}
}
uj5u.com熱心網友回復：
你的代碼不報錯嗎？update更新多個欄位用逗號隔開，不是and 連接的uj5u.com熱心網友回復：
除錯看看int n = cmd.ExecuteNonQuery();執行后n是多少，如果為0就是你的條件不正確，比如時間被格式化了，匹配不上。難道你的表里沒有設定key?要用那么多的條件去確定更新的行？
再說了，你這GridView本來就可以在資料源里設定更新陳述句后自動更新的，不必后臺自己寫方法。
轉載請註明出處，本文鏈接：https://www.uj5u.com/net/90700.html
標籤：ASP.NET