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); }