DataBindings between a TextBox and a DataGridView

Question

I have a form which includes a DataGridView and some TextBoxes. Most of the TextBoxes are filled with a classic query to an Oracle database (with an OleDbConnection object). The DataGridView is well filled with an OleDbDataAdapter. I want to complete 4 of my text boxes with a DataBinding linked to my DataGridView. I did this :

txtDepIdDep.DataBindings.Add("Text", dgridDepart[0, e.RowIndex], "Value", false, DataSourceUpdateMode.OnPropertyChanged);

where txtDepIdDep is my TextBox, dgridDepart is my DataGridView and e.RowIndex my current row (I run this command in a CellEventHandler, ie each time I selected a new row, I have to update these 4 text boxes).

The problem is : when I add these DataBindings, the other text boxes (those who are filled with a classic connection) do not work anymore : there is not text inside them, although with no DataBindings objects, it works very well.

Why a property of a TextBox can affect properties of other TextBoxes ?

Thanks a lot for your replies.

Allan Mark · Answer

Thanks! I followed the example and now have teh bindings working poerfectly (see code below). What I am still stuck with is how to Insert. When the user clicks the INSERT button I want them to enter the data into the textboxes. Then when is clicked the Insert (or edit) is droped and when is clicked the record is saved. Therafter focus returns to the grid and the currently or newly inserted record. Any ideas? allanmark ---------------------------------------------------------------------- BindingSource bSource = new BindingSource(); bSource.DataSource = dsLevelDetails; bSource.DataMember = Levels; dgvLevels.DataSource = bSource; private void dgvLevels_CellClick(object sender DataGridViewCellEventArgs e) { if (txtTitle.DataBindings.Count > 0) { updnLevel.DataBindings.RemoveAt(0); txtTitle.DataBindings.RemoveAt(0); updnCertify.DataBindings.RemoveAt(0); txtComments.DataBindings.RemoveAt(0); } BindTextFields(e.RowIndex); } private void BindTextFields(int theRow) { updnLevel.DataBindings.Add(Text dgvLevels[1 theRow] Value false); txtTitle.DataBindings.Add(Text dgvLevels[2 theRow] Value false); updnCertify.DataBindings.Add(Text dgvLevels[3 theRow] Value false); txtComments.DataBindings.Add(Text dgvLevels[6 theRow] Value false); }

Eugene Crampon · Answer

Hi Allan Otherwise you have a nice how-to here : http://blog.paranoidferret.com/index.php/2007/09/05/c-tutorial-binding-a-datagridview-to-a-database/ I used it for this part of my work.

Allan Mark · Answer

Thanks Satish Have printed it and will go through this evening. How do I add a record: 1. myRow = ds.Tables[emp[].NewRow(); 2. Allow the user to enter into the tetxboxes 3. ds.Tables[emp].Rows.Add(myRow); Will this save the record to the ds and hence reflect teh new details in the grid? allan

Satish Kathi · Answer

Hi Allan You can do this by using BindingSource. Here is the sample code. Hope this helps. public partial class Binding : Form { System.Windows.Forms. BindingSource bs1; DataSet ds; public Binding() { InitializeComponent(); } private void Binding_Load( object sender EventArgs e) { textBox1.Validated += new EventHandler (textBox_Validated); textBox2.Validated += new EventHandler (textBox_Validated); ds = new DataSet (); bs1 = new System.Windows.Forms. BindingSource (); using ( SqlConnection conn = new SqlConnection ( your connection string )) { using ( SqlCommand cmd = new SqlCommand ()) { cmd.CommandType = CommandType .Text; cmd.CommandText = select * from employee ; cmd.Connection = conn; SqlDataAdapter adp = new SqlDataAdapter (cmd); conn.Open(); adp.Fill(ds emp ); } } bs1.RaiseListChangedEvents = false ; bs1.DataSource = ds; bs1.DataMember = emp ; dataGridView1.DataSource = bs1; textBox1.DataBindings.Add( new System.Windows.Forms. Binding ( text  bs1 emp_id  true )); textBox2.DataBindings.Add( new System.Windows.Forms. Binding ( text  bs1 ename  true )); bs1.RaiseListChangedEvents = true ; bs1.ResetBindings( false ); } private void textBox_Validated( object sender EventArgs e) { ds.AcceptChanges(); } }

Allan Mark · Answer

Hi Eugene I'm very interested in your solution - have a similiar scenario and been struggling for a couple of days. I have a Dataset linked to a DataGridview. Underneath the grid the users wants to be able to edit the currently selected record. When they click a save button I need to update the dataset so that at the end of the session all the changes can be applied to the database. In your situation you are returning the change to the Grid. How do you get the changes back into your datastore (be it dataset databale or whatever)? Hoping you have an idea .... many thanks Allanmark

Eugene Crampon · Answer

I found the solution. In fact each time I select a row the TextBox has to be updated with the new value from the DataGridView. But to update the TextBox with a DataBinding object the previous link has to be removed with the command txtBox.DataBindings.RemoveAt(0). I did this and now it works.

Eugene Crampon · Answer

Yes you're right this is a solution. But I really need to use DataBinding objects because by this way I can automatically update my DataGridView by changing the text value of my TextBox. Then because the DataGridView has an other sort of binding with the database this database will be updated with a single command. I have to use TextBoxes I can't just change the values directly in my DataGridView this is the will of the customer !

Ryan Alford · Answer

the DataGridView has an event CellMouseClick. inside that event get the row and data from the row.. dataGridView1_CellMouseClick(object sender DataGridViewCellMouseEventArgs e) { DataGridViewRow row = new DataGridViewRow(); row = dataGridView1.Rows[e.RowIndex]; // Will put the value of the first column of the selected row into the textbox textBox1.Text = row.Cells[0].Value.ToString(); // Will put the value of the selected column(selected cell) of the selected row into the textbox textBox2.Text = row.Cells[e.ColumnIndex].Value.ToString(); }