nmd
30-11-2002, 08:17
Mình muốn insert/ delete row tu 1 table co sẵn. Mình đã thử theo sách ADO.NET nhưng gặp lỗi. Xin moi người xem dum:
SqlConnection conn= new SqlConnection("Initial Catalog=QLDT;Data Source=localhost;Integrated Security=SSPI");
SqlCommand cmd=new SqlCommand();
//cmd.CommandText="INSERT INTO KHACHHANG VALUES(18,'ABC','123','HO CHI MINH','123','NAM')";
]
cmd.CommandText="DELETE FROM KHACHHANG WHERE MAKH='5'";
cmd.Connection=conn;
conn.Open();
int j=cmd.ExecuteNonQuery();
//MessageBox.Show(j.ToString());
conn.Close();
Cứ đến chỗ int j=cmd. Ẽcute thi bi lỗi: system error. Lỗi chỗ nào?
SqlConnection conn= new SqlConnection("Initial Catalog=QLDT;Data Source=localhost;Integrated Security=SSPI");
SqlCommand cmd=new SqlCommand();
//cmd.CommandText="INSERT INTO KHACHHANG VALUES(18,'ABC','123','HO CHI MINH','123','NAM')";
]
cmd.CommandText="DELETE FROM KHACHHANG WHERE MAKH='5'";
cmd.Connection=conn;
conn.Open();
int j=cmd.ExecuteNonQuery();
//MessageBox.Show(j.ToString());
conn.Close();
Cứ đến chỗ int j=cmd. Ẽcute thi bi lỗi: system error. Lỗi chỗ nào?