How can I open a new from in datagridview cell click

Question

In my project after get a report details in datagridview ,I can click in any cell it will show the curret details form in mdiparent control using c# windows application

Munesh Sharma · Answer

void dataGridView1_DoubleClick(object sender, EventArgs e) { if (e.RowIndex > -1 && e.ColumnIndex > -1) { string value1 = dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString(); string value2 = dataGridView1.Rows[e.RowIndex].Cells[1].Value.ToString(); string value3 = dataGridView1.Rows[e.RowIndex].Cells[2].Value.ToString(); form1 frm = new Form1( value1,value2,value3); // from here you have pass value through as cconstructor perameters frm.Show(); } } public class Form1(string value1, string value2 , string value3) { here you take value in perameters and assign value }

Pavithra L · Answer

Hai, I got an answer for this question . I put two textboxes in my mdi form and in login button .I wrote this code con.Open(); SqlCommand cmd=new SqlCommand("select username,password from Login ",con); SqlDataAdapter da=new SqlDataAdapter (cmd); DataSet ds=new DataSet (); da.Fill (ds,"Login"); string v1,v2; for (int i = 0; i { v1 = ds.Tables[0].Rows[i][0].ToString(); v2 = ds.Tables[0].Rows[i][1].ToString(); if ((v1 == textBox1.Text) && (v2 == textBox2.Text)) { MDIParent1 m = new MDIParent1(); m.textBox1.Text = textBox1.Text; m.textBox2.Text = textBox2.Text; m.ShowDialog(); goto outer; } goto outer; MessageBox.Show("Incorrect value"); textBox1.Text = ""; textBox2.Text = ""; outer: v1 = ""; v2 = ""; } con.Close (); It was working correctly. Thanks for your reply.

Rajesh Sahoo · Answer

you have to add that column(which have the data like 1 ot 0) name in your sql query like SqlCommand cmd=new SqlCommand("select username,password,coulmnname from Login ",con); put your column name

Pavithra L · Answer

Hai Rajeshkumar, Here is my code please review this and tell the answer. con.Open(); SqlCommand cmd=new SqlCommand("select username,password from Login ",con); SqlDataAdapter da=new SqlDataAdapter (cmd); DataSet ds=new DataSet (); da.Fill (ds,"Login"); string v1,v2,v3; for (int i = 0; i { v1 = ds.Tables[0].Rows[i][0].ToString(); v2 = ds.Tables[0].Rows[i][1].ToString(); //v3 = ds.Tables[0].Rows[i][2].ToString(); if ((v1 == textBox1.Text) && (v2 == textBox2.Text))// && (v3 == textBox3 .Text )) { // v3 = ds.Tables[0].Rows[i][2].ToString(); MDIParent1 m = new MDIParent1(); m.Show(); goto outer; // string role = text; if (m.inHouseStockToolStripMenuItem.Visible == true) { In_House_Issues h = new In_House_Issues(); h.btn_update.Enabled = false; h.btn_print.Enabled = false; h.btn_delete.Enabled = false; } else { In_House_Issues h = new In_House_Issues(); h.btn_update.Visible = true; h.btn_print.Visible = true; h.btn_delete.Visible = true; } } goto outer; MessageBox.Show("Incorrect value"); textBox1.Text = ""; textBox2.Text = ""; outer: v1 = ""; v2 = ""; } con.Close (); Thanks for your reply.

Rajesh Sahoo · Answer

kindly post your code you have written to get the data from database

Pavithra L · Answer

Hai Rajeshkumar, Here I have one error. During data retrieve from database table, It cannot retrieve the 1 or 0 . It was throw error message like, cannot find column 2. How can I correct this. Please give me any other suggestion related this issue. Thanks

Pavithra L · Answer

Hai RajeshKumar, I will try your code and reply to you . Thanks for your reply for this question.

Rajesh Sahoo · Answer

Hi Pavitra L ok you have created that column in your login table now set 1 for Admin type and 0 for others and in the code page just retrive the data from database based on the login username and password then match the type with this column it's 1 or 0 then only can define admin or user. any problem feel free to write

Pavithra L · Answer

Hai Raja, I create that column in my login table , but I don't know how to call this 0 and 1 in my coding . will you please help me.

Raja T · Answer

Hi, Sry add new column in table...like role column

Raja T · Answer

Dear Upendra , Here using c# windows application not using web application.

Pavithra L · Answer

Hai, Sorry I can't get it clearly . Where I have to create role as bit(0,1).In my project.Please do some example coding in c# windows application .

Upendra Pratap Shahi · Answer

http://www.c-sharpcorner.com/UploadFile/77a82c/open-another-gridview-in-pop-up-using-bootstrap-modal-pop-up/

Raja T · Answer

Hi, Create one column like role as bit(0,1) in db, Admin as 1 and User as 0. When your login time check role is 0 or 1 based on you can do it.

Pavithra L · Answer

Hai Raja, Ok leave that question today, will tell you that on tomorrow. I have another question to set login privilege for different kind of user login's . How can I do this? I have one mdi form,login form and three more forms.Here I want to login with admin and user based login. I will give the privilege to both users ,admin can delete and update the data's but user cannot delete and update the data's. How can I disable these two button while user login into the form. Please help me?

Pavithra L · Answer

Hai, Can you find my attachment copy in previous message. If you not getting an attachment means , tell me i will send you once again.

Raja T · Answer

Hi, I am not getting your point ?

Pavithra L · Answer

Hai Raja, Is there any possibilities for my question. I don't know how can I explain this. Please give me any suggestion.

Pavithra L · Answer

Hai, But it's not working . will please give me any other suggestion .

Raja T · Answer

try like this try //This is created in datagridview cell click. { m.y1 = dataGridView1.CurrentRow.Cells[0].Value.ToString(); m. ShowDialog(); } catch { }

Raja T · Answer

Hi, Am not sure you exactly problem, But i wil give suggstion. Please check out bellow url about mdi http://www.codeproject.com/Articles/7571/Creating-MDI-application-using-C-Walkthrough

Pavithra L · Answer

Hai, Will you please reply quickly.

Pavithra L · Answer

Hai, Here I have attached the correct form. First form is In_House_Issues report form second form is In_House_Issues form. Here I will click the datagrid cell V No in fist form it will showing the second form. My question is how to show this second form with in the mdiparent frame. I mean it will be showing inside the mdiparent form,here we can also access other forms, which is located in mdi parent menustrip. This is what I need. I hope you can understand my question. Please Kindly find my attachment and will see the form details and give me the proper answer for this question. Thanks for your co-operation.

Raja T · Answer

Hi, i will check you code and let you know.

Raja T · Answer

Hi,You need click on datagridview will show the existing form. try like try //This is created in datagridview cell click. { m.y1 = dataGridView1.CurrentRow.Cells[0].Value.ToString(); m. ShowDialog(); } catch { }

Pavithra L · Answer

Hai Raja, Here I am using this code for opening a form ,it's already working but I want to open that form with in the mdi form. this is an exact concept. In_House_Issuse m=new In_House_Issues();this line is created in public declaration. try //This is created in datagridview cell click. { m.y1 = dataGridView1.CurrentRow.Cells[0].Value.ToString(); m.Show(); } catch { } Please help me related this.

Pavithra L · Answer

Hai Raja, Can you find my attachment.

Pavithra L · Answer

Hai Raja, Here I will attach both forms will you please view that and ask a question.

Raja T · Answer

Hi Pavithra, You have two form like In_House_Issues , Report Form. When click on Report Form datagridview cell value based displaying in existing form In_House_Issues am i right.? Please confirm In_House_Issues contain any datagridview or controls like textbox,radiobutton,etc? how to display in In_House_Issues?

Pavithra L · Answer

Hai, Anybody can help my question. Please It's urgent.

Pavithra L · Answer

Hai Rajeesh, I tried your code ,But it's not working . It was showing an error like Index was out of range, Values must be non-negative or less than the size of zero. How to solve this.

Pavithra L · Answer

Hai, Yeah in cell click I want to open a form not a new from , in that datgridcell contain values know , that values specified form .I mean an existing form in my project, Not a new form . For an Example: I have a form, Name is In_House_Issues in my project and I create a Report Form for this form.In that report form i can filter all the data of In _House_Issues Form ,based on the date.In report form showing all the data's of In _House _Issues From. At that time ,I can click in report form gridcell that will showing this In_House_Issues form with a specified data.That was in report form datagrid row. This In_House_Issues form will show inside the mdiparent . This is the concept.

Raja T · Answer

Hi, You mean datagridview contains data whenever click on any cell at the time get the corresponding row will displaying in new form or corresponding row will displaying in new form with edit mode ? Please confirm?

Rajeesh Menoth · Answer

Hi Pavithra L , void dataGridView1_DoubleClick(object sender, EventArgs e) { string id= dataGridView1.SelectedRows[0].Cells["id"].ToString(); NewForm frm = new NewForm(id); //passing id into constructor of the new form frm.Show(); } The answer is helpful please accept it ..!!!