How can I open a new from in datagridview cell click

Pavithra L

11y5.7k.NET

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

34 Replies

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

Munesh Sharma11y ago
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 L11y ago
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 < ds.Tables[0].Rows.Count; 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 Sahoo11y ago
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 L11y ago
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 < ds.Tables[0].Rows.Count; 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 Sahoo11y ago
kindly post your code you have written to get the data from database
Pavithra L11y ago
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 L11y ago
Hai RajeshKumar,

I will try your code and reply to you .

Thanks for your reply for this question.
Rajesh Sahoo11y ago
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 L11y ago
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 T11y ago
Hi, Sry add new column in table...like role column
Raja T11y ago
Dear Upendra ,

Here using c# windows application not using web application.
Pavithra L11y ago
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 Shahi11y ago
http://www.c-sharpcorner.com/UploadFile/77a82c/open-another-gridview-in-pop-up-using-bootstrap-modal-pop-up/
Raja T11y ago
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 L11y ago
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 L11y ago
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 T11y ago
Hi,

I am not getting your point ?
Pavithra L11y ago
Hai Raja,

Is there any possibilities for my question. I don't know how can I explain this. Please give me any suggestion.
Pavithra L11y ago
Hai,
But it's not working . will please give me any other suggestion .
Raja T11y ago
try like this

try //This is created in datagridview cell click.
{
m.y1 = dataGridView1.CurrentRow.Cells[0].Value.ToString();
m.ShowDialog();
}
catch
{
}
Raja T11y ago
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 L11y ago
Hai,
Will you please reply quickly.
Pavithra L11y ago
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 T11y ago
Hi, i will check you code and let you know.
Raja T11y ago
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 L11y ago
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 L11y ago
Hai Raja,

Can you find my attachment.
Pavithra L11y ago
Hai Raja,

Here I will attach both forms will you please view that and ask a question.
Raja T11y ago
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 L11y ago
Hai,

Anybody can help my question. Please It's urgent.
Pavithra L11y ago
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 L11y ago
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 T11y ago
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 Menoth11y ago
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..!!!