problem in change values of datagridview using c#

Question

Hello every one well i have one problem i have combo box which is bind from the database. when the user select from combo box after that focus should be cell number 3 of datagrid view i dont know which event should be used for it and what is the code for it. hope you understand what i want thanks in Advance

Nilanka Dharmadasa · Answer

Hi Naim What do you mean by cell 3? Anyway let's say you want to select cell with rowindex 2 and column index 3. And the name of datagridview is 'datagrid'. Then try this code. foreach (DataGridViewRow row in datagrid.SelectedRows) { row.Selected = false; } datagrid.Rows[2].Selected = true; datagrid.CurrentCell = datagrid.Rows[2].Cells[3];

daniel raj · Answer

Hi Nikhil Kumar i have one problem i have combo box which is bind from the database. when the user select from combo box after that focus should be cell number 2 of datagrid view i dont know which event should be used for it and what is the code for it. hope you understand what i want thanks in Advance

Kirtan Patel · Answer

Friend you can not Directly Add new item to Combo box that is Bound to Some Database items but you need to insert One Extra Row in Ds.Table[0] Which Will Contain this Select party Name before Binding ds.Table[0] to Combo Box Code like Below private void get_party_details() { cb_party_name.Items.Add( Select Party Name ); try { DataSet ds = new DataSet (); ds = gBL.show_party_details_name(); //Insert Row Here DataRow r = new DataRow (); // Here Instad of r[3] use the Index of Column Party Name according to your Database Table Structure r[3 ] = Select Party Name ; ds.Tables[0].Rows.InsertAt(r 0); //After Adding New Row Now you can bind and It Will Show Select Party Name in Combobox :) cb_party_name.DataSource = ds.Tables[0]; cb_party_name.DisplayMember = Party_Name ; } catch ( Exception ) { //MessageBox.Show(Error!:  + ex.Message.ToString() + . Please contact PSR Computers for Support); } if my answer Helps you then Check  Do you like this answer check box  :)

Naeem Khan · Answer

hello mam i have solved my problem but other my major problem is that i have Combo box which is bind from database. what i want to show that in combo box text should be written Select Party Name. but party name is Also coming from data Base. that is why it is not showing me Select Party Name this is the text of Combo Box. when i m running my project first value is coming from database not the text value of Combo box. but i want to show text value of Combo Box if you have any idea how to sole it then tell me and when i m select party list then should be do other works not at form load this is Function for binding in combo Box hope you understand mam private void get_party_details() { cb_party_name.Items.Add(Select Party Name); try { ds = new DataSet(); ds = gBL.show_party_details_name(); cb_party_name.DataSource = ds.Tables[0]; cb_party_name.DisplayMember = Party_Name; } catch (Exception) { //MessageBox.Show(Error!:  + ex.Message.ToString() + . Please contact PSR Computers for Support); } } thankx in Advance

Nilanka Dharmadasa · Answer

Try this. //In your combo box selected index changed event write this datagrid.CurrentCell = datagrid.CurrentRow.Cells[3]; //Then do the calcualtion datagrid.CurrentCell = datagrid.CurrentRow.Cells[5];

Nilanka Dharmadasa · Answer

Hi Naim My code is not working for you? If so paste you code here. Ill give you the exact solution. :)

Naeem Khan · Answer

hello mam thanks to come again well mam my problem is that i have datagridview with checkboxes which is bound from the database. and there is row selected . what i want if i select value from combo box which is also bind from database. then my focus should be in datagridview's cell no 3 . there i m calculating something and when he set the value of cell after that it should be go to other cell like 5. i don't know how to focus of cursor in datagridview please help me mam i need your help thanks in advance

Naeem Khan · Answer

hello sir well i m using your code but it is not working it is showing me this exception Error creating window handle.i don't know where did i mistake. and i have selected row when i comes in form . not cell so please tell me what should i do for it. thanks in advance