62,047
社区成员
发帖
与我相关
我的任务
分享
int claId = Convert.ToInt32(Request.QueryString["claID"]);
for (int i = 0; i < dsDeta.Tables[0].Rows.Count; i++)
{
TextBox txXuhao = this.form1.FindControl("txtXuhao"+i) as TextBox;
int a =Convert.ToInt32(txXuhao.Text.ToString());
DropDownList dpte = this.form1.FindControl("dptea" + i) as DropDownList;
int b =Convert.ToInt32(dpte.SelectedValue);
TextBox txtBe = this.form1.FindControl("txtBegin"+i) as TextBox;
DateTime c = Convert.ToDateTime("2013-07-01 11:30:00.000");
TextBox txten = this.form1.FindControl("txtEnd" + i) as TextBox;
DateTime d = Convert.ToDateTime("2013-07-01 11:30:00.000");
TextBox txtco = this.form1.FindControl("txtCode" + i) as TextBox;
string e = txtco.Text;
string sql2 = "UPDATE tbl_Class_Profile_Detail SET Class_ID = @claid , Class_Sequence = @seq"
+ ", Teacher_ID =@tead , Class_Time_Begin =@begin , Class_Time_End =@end , Course_Code = @code WHERE Detail_ID=@detailid ";
SqlParameter[] sqlpa2 = new SqlParameter[]
{
new SqlParameter("@seq",a),
new SqlParameter("@claid",claId),
new SqlParameter("@tead",b),
new SqlParameter("@begin",c),
new SqlParameter("@end",d),
new SqlParameter("@code",e),
new SqlParameter("@detailid",Convert.ToInt32(dsDeta.Tables[0].Rows[i]["Detail_ID"].ToString()))
};
cmd.CommandText = sql2;
cmd.Parameters.AddRange(sqlpa2);
cmd.ExecuteNonQuery();
}