How to retrieve data from parent form to Child form

Question

Hello How to retrieve data from parent form to Child form?? I am posting image also just check reply me any one pls. i need it very badly.. Thanks & Regards Vishnu Vardhan

Vulpes · Answer

I think the reason why it's not saving is that you have your if and else clauses the wrong way around. Note also that by default the Text property of a TextBox is an empty sting not null. So try this: private void btnAdd_Click(object sender EventArgs e) { if (btnAdd.Text==Save) { try { string MyConString = SERVER=localhost; + DATABASE=bookshop; + UID=root; + PWD=password;; MySqlConnection Con = new MySqlConnection(MyConString); MySqlCommand Cmd = Con.CreateCommand(); string S = Insert into bookinventory values(' + txtBookId.Text + '' + DTPDate.Text + ' + txtQtyBefore.Text +  + txtQtyReceived.Text +  + txtQtyAfter.Text +  + txtOrderNum.Text + ); Cmd = new MySqlCommand(S Con); Con.Open(); Cmd.ExecuteNonQuery(); Con.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } } else if (txtBookId.Text != ) { txtBookId.Enabled = true; DTPDate.Enabled = true; btnShowBookId.Enabled = true; txtQtyBefore.Enabled = true; txtQtyReceived.Enabled = true; txtQtyAfter.Enabled = true; txtOrderNum.Enabled = true; btnAdd.Text = Save; } }

vishnu vardhan · Answer

Thanks for the solution it's working now.. actually i am trying this code previously private void DGVBook_CellContentClick(object sender DataGridViewCellEventArgs e) { var form = new BookInventory(); form.txtBookId.Text = this.DGVBook.CurrentRow.Cells[0].Value.ToString(); form.Show(); } to save the records into data base i am using this code but it's not saving see.. private void btnAdd_Click(object sender EventArgs e) { if (txtBookId.Text != null) { txtBookId.Enabled = true; DTPDate.Enabled = true; btnShowBookId.Enabled = true; txtQtyBefore.Enabled = true; txtQtyReceived.Enabled = true; txtQtyAfter.Enabled = true; txtOrderNum.Enabled = true; btnAdd.Text = Save; } else if (btnAdd.Text==Save) { try { string MyConString = SERVER=localhost; + DATABASE=bookshop; + UID=root; + PWD=password;; MySqlConnection Con = new MySqlConnection(MyConString); MySqlCommand Cmd = Con.CreateCommand(); string S = Insert into bookinventory values(' + txtBookId.Text + '' + DTPDate.Text + ' + txtQtyBefore.Text +  + txtQtyReceived.Text +  + txtQtyAfter.Text +  + txtOrderNum.Text + ); Cmd = new MySqlCommand(S Con); Con.Open(); Cmd.ExecuteNonQuery(); Con.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } } } My requirements are when i click on add button the text on button has to change save and the when i click on save it has to save the details into database i.e bookinventory database. i am using above code for that but it's not saving the data into database. just check and give me some solution Thanks.

Vulpes · Answer

Without seeing any code I can only guess. But it looks to me like you may be creating a new instance of the BookInventory form and transferring the Book Id to that rather than to the existing instance of the form assuming it's still open. If you're using code like this at the moment: BookInventory bi = new BookInventory(); bi.txtBookId.Text = bookId.ToString(); bi.txtBookId.Enabled = false; then I'd try instead: BookInventory bi = Application.OpenForms[BookInventory] as BookInventory; if (bi != null) { bi.txtBookId.Text = bookId.ToString(); bi.txtBookId.Enabled = false; bi.txtQuantityBefore.Focus(); } I'm assuming here that you've changed the Modifier property of the relevant controls on the BookInventory form from private to public (or internal) so that they can be directly accessed from other forms in the application.

vishnu vardhan · Answer

sorry i forgot to upload image see there my problem and image just check. pls Open Image in New Tab. thanks

Vulpes · Answer

You've forgotten to attach the image.