public void kn_csdl()
{
try
{
kn.ConnectionString = Mahoa.Decrypt(ConfigurationManager.ConnectionStrings["project"].ConnectionString);
kn.Open();
}
catch (Exception)
{
Console.WriteLine("Không thể kết nối máy chủ");
}
}
public int UpdateData(string sql, string[] Name, object[] value, int Nparameter)
{
sql = Mahoa.Decrypt(ConfigurationManager.ConnectionStrings["project"].ConnectionString);
SqlConnection con = new SqlConnection();
if (con.State == ConnectionState.Closed)
{
con.Open();
}
SqlCommand Command = new SqlCommand(sql, con);
for (int i = 0; i < Nparameter; i++)
{
Command.Parameters.AddWithValue(Name[i], value[i]);
}
Command.CommandType = CommandType.StoredProcedure;
int kq = Command.ExecuteNonQuery();
return(kq);
}
