更新数据库问题，在线

NFJ 2003-07-23 02:10:19

不能更新，请各位指教。程序如下
先把表中数据调到页面来
private void Page_Load(object sender, System.EventArgs e)
{
string bb=this.Request["a"].ToString ();

string sql="select * from T_DfEmployee where C_EmpId='"+bb+"'";
string co="server=prgserver;user id=prg;password=prg;database=aq";
SqlConnection conn=new SqlConnection (co);

SqlCommand comm=new SqlCommand(sql,conn);
conn.Open ();
SqlDataReader dr=comm.ExecuteReader();

while(dr.Read())
{　
　　　TextBox1.Text =dr.GetString(0);
　　　TextBox2.Text =dr.GetString(1);
TextBox3.Text =dr.GetString(2);
TextBox4.Text =dr.GetString(3);
TextBox5.Text =dr.GetInt32(4).ToString ();
TextBox6.Text =dr.GetString(5);
TextBox7.Text =dr.GetDateTime(6).ToString ();
TextBox8.Text =dr.GetDateTime(7).ToString () ;
TextBox9.Text =dr.GetString (8);

}

dr.Close ();
conn.Close ();｝

再更新记录
private void Button1_Click(object sender, System.EventArgs e)
{

string strName = TextBox1.Text.ToString ();

string t1 = TextBox4.Text.ToString ();
string t22= TextBox5.Text.ToString ();
int t2=System.Convert .ToInt32 (t22);
string t3 = TextBox6.Text.ToString ();
string t44 = TextBox7.Text.ToString ();
DateTime t4=System.Convert .ToDateTime(t44);
string t55 = TextBox8.Text.ToString ();
DateTime t5=System.Convert .ToDateTime(t55);
string t6 = TextBox9.Text.ToString ();

string co="server=prgserver;user id=prg;password=prg;database=aq";
SqlConnection conn=new SqlConnection (co);
string strUpdate = "update T_DfEmployee set C_EmpState="+"'"+t1+"'"+",C_BookId="+"+t2+"+",C_CheckOrg="+"'"+t3+"'"+",C_CheckDate= "+"+t4+"+",C_WCheckDAte="+" '"+t5+"'"+",C_Class="+"'"+t6+"'"+" Where C_EmpId="+"'"+strName+"'";

SqlCommand MyComm = new SqlCommand(strUpdate,conn);

conn.Open ();
MyComm.ExecuteNonQuery();
conn.Close ();

}

...全文