public static int AddUser(Users user) { OleDbParameter prmName = new OleDbParameter("@name", OleDbType.VarWChar,100);//datatype Text prmName.Value = user.Name; OleDbParameter prmPass = new OleDbParameter("@pass", OleDbType.VarWChar,100); prmPass.Value = user.Password; OleDbParameter prmEmail = new OleDbParameter("@email", OleDbType.VarWChar,100); prmEmail.Value = user.Email; return DataAccess.Execute("INSERT INTO User([Name],[Pass],[Email]) VALUES(@name,@pass,@email)", prmName, prmPass, prmEmail); }
public static int Execute(string SPName, params OleDbParameter[] Parameters) { int intErr = 0; OleDbConnection cn = new OleDbConnection(ConnectionString); OleDbCommand cmd = new OleDbCommand(SPName, cn); cmd.CommandText = SPName; //cmd.CommandType = CommandType.Text; if (Parameters != null) foreach (OleDbParameter item in Parameters) { cmd.Parameters.Add(item); } cn.Open(); try { cmd.ExecuteNonQuery(); } catch { intErr = 1; if (cn != null) cn.Close(); } cn.Close(); cmd = null; cn = null; return intErr; }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)