Advertisement
DavidBawden1

insert all values

Jan 29th, 2016
66
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C# 2.57 KB | None | 0 0
  1. //FROM INSIDE SQL CONFIG CLASS !!!!!
  2.  public void InsertMember(string firstname, string lastname, string phonenumber, string dob, string postcode, int memstatus, string memregdate)
  3.         {
  4.             SqlConnection FelicityConn = new SqlConnection(ConnectionString);
  5.            
  6.             SqlCommand Insertmembercmd = new SqlCommand();
  7.  
  8.  
  9.             //INSERT STATEMENT USING PREDEFINED STRING VARIABLES
  10.  
  11.             Insertmembercmd.CommandText = string.Format("INSERT INTO  MemberTable (MemFirstname, MemLastname, MemPhonenumber, MemDOB, MemPostcode, MemStatus, MemRegDate) VALUES ('{0}','{1}','{2}','{3}','{4}','{5}','{6}')", firstname,
  12.             lastname, phonenumber, dob, postcode, memstatus, memregdate, FelicityConn);
  13.  
  14.  
  15.             Insertmembercmd.Parameters.AddWithValue("@MemFirstname", firstname.ToUpper());//PARAMETER 0
  16.             Insertmembercmd.Parameters.AddWithValue("@MemLastname", lastname.ToUpper());//PARAMETER 1
  17.             Insertmembercmd.Parameters.AddWithValue("@MemPhonenumber", phonenumber);//PARAMETER 2
  18.             Insertmembercmd.Parameters.AddWithValue("@MemDOB", dob);//PARAMETER 3
  19.             Insertmembercmd.Parameters.AddWithValue("@MemPostcode", postcode);//PARAMETER 4
  20.             Insertmembercmd.Parameters.AddWithValue("@MemStatus", memstatus);//PARAMETER 5
  21.             Insertmembercmd.Parameters.AddWithValue("@MemRegDate", memregdate);//PARAMETER 6
  22.  
  23.  
  24.  
  25.             /*OPEN THE CONNECTION
  26.             EXECUTE THE INSERT QUERY
  27.             CLOSE CONNECTION*/
  28.  
  29.             Insertmembercmd.Connection = FelicityConn;
  30.             FelicityConn.Open();
  31.             Insertmembercmd.ExecuteNonQuery(); //EXECUTE THE INSERT STATEMENT COMMAND
  32.             FelicityConn.Close();
  33.  
  34.             //END OF METHOD
  35.  
  36.         }
  37.  
  38. //FROM THE FORM OF THE INSERT BUTTON
  39.  private void BtnAddMem_Click(object sender, EventArgs e)
  40.         {
  41.             DateTime RegDate = DateTime.Parse(RegMemDate.ToString());
  42.             DateTime DOB = DateTime.Parse(RegMemDate.ToString());
  43.  
  44.             if (TxtFirstName.Text != "" && TxtLastName.Text != "" && TxtPhoneNumber.Text != "" && TxtPostCode.Text != "" && DobMem.Text != "" && RegMemDate.Text != "")
  45.              {
  46.  
  47.                  SQLConfig sqlclass = new SQLConfig();
  48.                  if (sqlclass.InsertMember(TxtFirstName.Text.ToString(),TxtLastName.Text.ToString(), TxtPhoneNumber.Text.ToString(),TxtPostCode.Text.ToString(), DOB.ToString(), RegDate.ToString()))
  49.                  {
  50.                      MessageBox.Show("Registered a new member" + TxtFirstName);
  51.                  }
  52.  
  53.              }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement