c# - Textbox value to database using stored procedure -

I am learning business logic and data logic and programmability.

I have 1 DL (data logic) class with all stored procedures, so I have a BL (business logic) which connects DL and BL, then I have a form class where I Can I add new users to the database? How do I add forms, BL and DL? DL Class stored procedure:

  Insert a public dataset (string created by Int ROTID, String Rolesdesk) {DataSet mydataset = new DataSet (); SqlCommand cmdclubroles = New SqlCommand (); // Find the stored procedure cmdclubroles.CommandText = "usp_insertrlubroles"; Cmdclubroles.CommandType = CommandType.StoredProcedure; // Connect cmdclubroles.Connection = jadcoreConnection.GetConnection (); // parameter cmdclubroles.Parameters.AddWithValue ("@RillID", Convert.ToInt32 (RoleID)); Cmdclubroles.Parameters.AddWithValue ("@Roledesc", Roledek); Cmdclubroles.Parameters.AddWithValue ("Manufactured by", manufactured by); SqlDataAdapter mySqlDataAdapter = New SqlDataAdapter (cmdclubroles); MySqlDataAdapter.Update (mydataset); Returns mydataset; } Business logic:  
  Insert public datasetClubLo (built-in ROTID, string rolledsk, created by string) {DataSet ID = new dataset (); ID = new GetClubRoles () InsertClubRoles (RoleID, Roledesc, created); Return id; }   
 Finally, here is the submit button and to save the role method in a different form:  
  Private Zero Savebtn_Click (Object Sender, EventArgs e) {Try {saverole (); MessageBox.Show ("The club role was successfully saved"); } Hold (exception er) {message box. Show (er message. Toaster ()); }} Public Zero Severol () {ClubRoles CR = new Clabrol (); Cr.insertingclubroles (2, "as", "me"); / // Description is required for details / which client is selected)   
 How can I add three? I know that the textbox values ​​need to be assigned to the stored procedure parameters, but how?  
 Thanks in advance, if it is too long, then I am trying to explain as much as I can.  
  
 
 
 Acutally for  INSERT  data, you  .executeNonQuery  should be used on  SqlCommand :  
  Public Zero InsertClubRoles (string created by Int RoleID, String Roledeks) {Use (SqlCommand cmdclubroles = New SqlCommand ()) {// Collect stored procedure cmdclubroles.CommandText = "usp_insertrlubroles"; Cmdclubroles.CommandType = CommandType.StoredProcedure; // Connection cmdclubroles.Connection = jadcoreConnection.GetConnection (); // parameter cmdclubroles.Parameters.AddWithValue ("@RillID", Convert.ToInt32 (RoleID)); Cmdclubroles.Parameters.AddWithValue ("@Roledesc", Roledek); Cmdclubroles.Parameters.AddWithValue ("Manufactured by", manufactured by); // execute INSERT statement cmdclubroles.Connection.Open (); Cmdclubroles.ExecuteNonQuery (); Cmdclubroles.Connection.Close (); }}   
  Update:  To pass values ​​from your text box in the  SaveRole  method - add some parameters!    Public Zero Save Roll (Int ROTID, String Rollsk, String Created) {ClubRoles cr = new Clabrol (); Cr.insertingclubroles (RoleID, RoleDesc, Created By); / /  
    set for private zones    
 and then by saving your form,  
  Savebtn_Click {Try Save (convert (OIF 32 (TBXROLITTIC), TBXROLDCCText, TBXcrated text); MessageBox.Show ("Club role successfully Saved ");} catch (exception error) {message box. Show (er message. Toastring ());}}