problem in change values of datagridview using c#

Naeem Khan

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

8 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nilanka Dharmadasa17y ago

Accepted 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 raj16y ago

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 Patel17y ago
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 " :)
0
Naeem Khan17y ago
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
0
Nilanka Dharmadasa17y ago
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];
0
Nilanka Dharmadasa17y ago
Hi Naim,

My code is not working for you?

If so paste you code here. Ill give you the exact solution. :)
0
Naeem Khan17y ago
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
0
Naeem Khan17y ago
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
0