我有2个数据库,它们之间具有关系,我想更新其中一个。 我想我也应该更新另一个,我只是不知道如何。
能帮我吗?
[WebMethod]
public void UpdateUserDetails(User u,string username)
{
string sql = "UPDATE [Users] SET [username] = '" + u.username +"',[Ufname] = '" + u.Fname + "',[Ulname] = '" + u.Lname + "',[Upass] = '" + u.Password + "',[Uemail] = '" + u.Email + "',[Uaddress] = '" + u.Address + "',[Ucity] = '" + u.City + "',[Ustate] = '" + u.State + "',[Urating] = '" + u.Rating + "',[Upic] = '" + u.Picture + "',[Uzip] = '" + u.Zipcode + "',[Uphone] = '" + u.Phone + "' WHERE [username] = '" + username + "'";
OleDbCommand cmd = new OleDbCommand(sql);
Connect.Takeaction(cmd,Getdbpath());
}
这是错误。
public static void Takeaction(OleDbCommand cmd,string path)
{
ConnectMe(path);
cmd.Connection = my_con;
my_con.Open();
cmd.ExecuteNonQuery();
my_con.Close();
}
这是我服务中的更新功能。
{{1}}
我在connect类中使用的函数。