Example #1
0
 public SC_User()
     : base()
 {
     ProcedureName = "appuser";
     MySqlParameterCommand.AddWithValue("_username", "");
     MySqlParameterCommand.AddWithValue("_fullname", "");
     MySqlParameterCommand.AddWithValue("_email", "");
     MySqlParameterCommand.AddWithValue("_password", "");
 }
 public SC_PayeeData()
     : base()
 {
     ProcedureName = "payeedata";
     MySqlParameterCommand.AddWithValue("_name", "");
     MySqlParameterCommand.AddWithValue("_amount", "");
     MySqlParameterCommand.AddWithValue("_datetime", "");
     MySqlParameterCommand.AddWithValue("_dateformat", "");
     MySqlParameterCommand.AddWithValue("_bank", "");
     MySqlParameterCommand.AddWithValue("_word", "");
 }
Example #3
0
        public CommonState()
        {
            MySqlCommand com = new MySqlCommand();

            MySqlParameterCommand = com.Parameters;
            MySqlParameterCommand.AddWithValue("_id", "");
            MySqlParameterCommand.AddWithValue("_user_name", ConnectionStr.User_Name);


            MySqlCommand sel = new MySqlCommand();

            MysqlParameterSelect = sel.Parameters;
            MysqlParameterSelect.AddWithValue("_user_name", ConnectionStr.User_Name);

            MySqlParameter _out = new MySqlParameter("_out", MySqlDbType.Int16);

            _out.Direction = System.Data.ParameterDirection.Output;
            MySqlParameterCommand.Add(_out);

            MySqlParameter text_output = new MySqlParameter("_output", MySqlDbType.String);

            text_output.Direction = System.Data.ParameterDirection.Output;
            MySqlParameterCommand.Add(text_output);
        }