insert data to single table from multiple textboxes of form

Question

Language : C# Platform : Desktop application I've a form which is of format: The user inputs the values of buyer name buyer address buyer rank in the form in the given textboxes. formId >> 1409 buyer name buyer address buyer rank B1 ADD1 1 // textboxes B2 ADD2 2 B3 ADD3 3 B4 ADD4 4 submit_btn The data goes to the table buyer_choice (b_name b_address b_rank). How can i insert the whole data of the form to the single table buyer_choice on submit_btn click.

Govinda Rajulu Yemineni · Answer

Hi try below code private void btnSubmit_Click(object sender EventArgs e) { string result = Please Enter ; if (txtBuyerName.Text == string.Empty) { result += Buyer Name; } if (txtBuyerAddress.Text == string.Empty) { result += Buyer Address; } if (txtBuyerRank.Text == string.Empty) { result += Buyer Rank; result = result.Remove(result.LastIndexOf('')); } else { if (result.Contains('')) { result = result.Remove(result.LastIndexOf('')); } } if (result != Please Enter ) { MessageBox.Show(result); } else { string constr = Server=servername;User Id=uid;Password=pwd;database=dbname; string query = insert into buyer_choice values(' + txtBuyerName.Text + '' + txtBuyerAddress.Text + '' + txtBuyerRank.Text + '); SqlConnection con = new SqlConnection(constr); SqlCommand cmd = new SqlCommand(query con); con.Open(); if(cmd.ExecuteNonQuery()>0) { con.Close(); txtBuyerName.Text = ; txtBuyerAddress.Text = ; txtBuyerRank.Text = ; MessageBox.Show(Record Inserted Successfully); } } } If you find anything helpful please accept my answer .

Raja T · Answer

hi Try this code private void btnSubmit_Click(object sender EventArgs e) { try { if (txt_buyerName.Text == ) { MessageBox.Show(please enter name); txt_buyerName.Focus(); return; } else if (txt_BuyerAddress.Text == ) { MessageBox.Show(please enter address); txt_BuyerAddress.Focus(); return; } else if (txt_BuyerRank.Text == ) { MessageBox.Show(please enter rank); txt_BuyerRank.Focus(); return; } else { string constr = Data Source=test;Initial Catalog=TestDemo;User Id=sa;Password=passwd@123;; string query = ; query = insert into buyer_choice values(' + txt_buyerName.Text + '' + txt_BuyerAddress.Text + '' + txt_BuyerRank.Text + '); SqlConnection con = new SqlConnection(constr); SqlCommand cmd = new SqlCommand(query con); con.Open(); cmd.ExecuteNonQuery(); con.Close(); MessageBox.Show(Record Inserted Successfully); txt_buyerName.Text = ; txt_BuyerAddress.Text = ; txt_BuyerRank.Text = ; } } catch (Exception ex) { MessageBox.Show(ex.Message); } }

Raja T · Answer

Okay

hadoop hadoop · Answer

No each record should go in separate rows of the table. B1 row record in one row. B2 row record in second row likewise

Raja T · Answer

Hi As per my understanding you need comined all data insert into single record in table buyer_choice ? like below buyername buyeraddress buyerrank ---------- - ----------------- ----------- B1B2B3B4 Add1Add2Add3Add4 1234 Please confirm or describe your question clearly ?