更新数据库问题,在线
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 ();
}