passing values to one form to another form

Sathya Narayan

hi,

I am passing the values from one form to another using datagridview.In form1 i have taken 2textboxs and in form2 i have taken the datagridview.Which hasn't been binding the values to the textboxes.Can anyone help me???

Here is code.

private void Display()

{

SqlConnection con = new SqlConnection(connectionString);

DataTable dt = new DataTable();

SqlDataAdapter sda = new SqlDataAdapter("SELECT slno,sname,deptid,Department from Student_View where stu='A' order by sname", con);

sda.Fill(dt);
}

private void DataGridView3_CellContentClick(object sender, DataGridViewCellEventArgs e)

{

SemisterUpgradeMaster r = new SemisterUpgradeMaster();

DataGridViewRow row = new DataGridViewRow();

row = DataGridView3.Rows[e.RowIndex];

// Will put the value of the first column of the selected row into the textbox

r.label2.Text = row.Cells[0].Value.ToString();

r.txtsn.Text = row.Cells[1].Value.ToString();

r.txtdep.Text = row.Cells[3].Value.ToString();

this.Close();

}

9 Replies

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

Vulpes12y ago
There's a 'readable' version of the above code in this thread:

http://www.c-sharpcorner.com/Forums/Thread/245848/condition-is-not-satisfying.aspx

0
Sathya Narayan12y ago
hi , I took attandance field in my table tbl_Attandance,so i need to satisfy the condition of the attandance out of 100.Its not satisfying..Wats the problem in this code .Can anyone help me This is my Code. private void SaveData() { int attendance = 100; if (txtsn.Text == "") { MessageBox.Show("Select The Student Name"); txtsn.Focus(); } else if (cbosem.Text == "---Select Semister---") { MessageBox.Show("Select The Semister"); cbosem.Focus(); } else if (txtdep.Text == "") { MessageBox.Show("Select The Department"); txtdep.Focus(); } else if (cbosub.Text == "---Select Subject---") { MessageBox.Show("Select The Subject"); cbosub.Focus(); } else if (txtattnd.Text == "") { MessageBox.Show("Enter The Attandance"); txtattnd.Focus(); } else if (attendance >= 80) { MessageBox.Show("Eligible for The Exam "); } else if (attendance >= 75) { MessageBox.Show("Not Eligible for The Exam "); } else if (attendance == 40){ MessageBox.Show("Shortage Of Attandance"); } else { MessageBox.Show("Do You Like To Insert Into Attandance Record?", "Save", MessageBoxButtons.YesNo); SqlConnection con = new SqlConnection(connectionString); try { string Query = "insert into tbl_attendance(studentid,semid,subjectid,attend)values('" + label15.Text + "','" + label6.Text + "','" + label5.Text + "','"+txtattnd .Text +"') "; SqlCommand cmd = new SqlCommand(Query, con); cmd.CommandText = Query; con.Open(); int i = cmd.ExecuteNonQuery(); if (i > 0) { MessageBox.Show("Successfully Inserted..."); return; } } catch { MessageBox.Show("Error in Connection"); } Display(); clear(); //close the connection con.Close(); GroupBox1.Enabled = false; } }
0
Vulpes12y ago
The highlighted lines are superfluous (because of the immediately following 'if' statements) and won't compile anyway as you're trying to assign a string to a bool property:

private void DataGridView3_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
DataGridViewRow row = new DataGridViewRow();
row = DataGridView3.Rows[e.RowIndex];
// Will put the value of the first column of the selected row into the textbox
label14.Text = row.Cells[0].Value.ToString();
txtsn.Text = row.Cells[1].Value.ToString();
txtsem.Text = row.Cells[2].Value.ToString();
cbosub.Text = row.Cells[3].Value.ToString();
rdbtn_present.Checked = row.Cells[4].Text;
rdbtn_absent.Checked = row.Cells[4].Text;
if (row.Cells[4].Text.Equals("Present"))
rdbtn_present.Checked = true;
else
rdbtn_present.Checked = false;
if (row.Cells[4].Text.Equals("Absent"))
rdbtn_absent.Checked = true;
else
rdbtn_absent.Checked = false;
Btn_Save.Enabled = false;
Btn_Modify.Enabled = true;
label14.Text = "";
label6.Text = "";
label5.Text = "";
label11.Text = "";
}

0
Sathya Narayan12y ago
hi , I need to bind the datagridview values to radiobutton,its not fetching the values from datagridview. This is my code private void DataGridView3_CellContentClick(object sender, DataGridViewCellEventArgs e) { DataGridViewRow row = new DataGridViewRow(); row = DataGridView3.Rows[e.RowIndex]; // Will put the value of the first column of the selected row into the textbox label14.Text = row.Cells[0].Value.ToString(); txtsn.Text = row.Cells[1].Value.ToString(); txtsem.Text = row.Cells[2].Value.ToString(); cbosub.Text = row.Cells[3].Value.ToString(); rdbtn_present.Checked = row.Cells[4].Text; rdbtn_absent.Checked = row.Cells[4].Text; if (row.Cells[4].Text.Equals("Present")) rdbtn_present.Checked = true; else rdbtn_present.Checked = false; if (row.Cells[4].Text.Equals("Absent")) rdbtn_absent.Checked = true; else rdbtn_absent.Checked = false; Btn_Save.Enabled = false; Btn_Modify.Enabled = true; label14.Text = ""; label6.Text = ""; label5.Text = ""; label11.Text = ""; } can any one help me???
0
Vulpes12y ago
Yes, public or internal, it doesn't really matter which :)

Not sure what you mean about the values being passed as an integer. If you're going to assign them to the Text property of a Label or TextBox, then they'll need to be in string format anyway which is what the ToString() method gives you.
0
Sathya Narayan12y ago
hi, Thank you very much your code worked me o lot
0
Sathya Narayan12y ago
Instead of private i had took the public,but i need the values to be passed in integer through label,for both the text box txtsn and txtdep.
0
Vulpes12y ago
If I've understood the problem correctly, try the following.

For it to work, you'll need to change the Modifiers property of label2, txtsn and txtdep from private to internal so they can be directly accessed from another form in the project:

private void Display()
{
SqlConnection con = new SqlConnection(connectionString);
DataTable dt = new DataTable();
SqlDataAdapter sda = new SqlDataAdapter("SELECT slno,sname,deptid,Department from Student_View where stu='A' order by sname", con);
sda.Fill(dt);
DataGridView3.DataSource = dt; // bind to datatable
}

private void DataGridView3_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
SemisterUpgradeMaster r = null;

foreach(Form f in Application.OpenForms)
{
if (f is SemisterUpgradeMaster)
{
r = (SemisterUpgradeMaster)f;
break;
}
}

if (r == null) return;

DataGridViewRow row = DataGridView3.Rows[e.RowIndex];

r.label2.Text = row.Cells[0].Value.ToString();
r.txtsn.Text = row.Cells[1].Value.ToString();
r.txtdep.Text = row.Cells[3].Value.ToString();
this.Close();
}
0
JobPencil12y ago
Hai,

Try This Link It May Help You.

http://social.msdn.microsoft.com/Forums/windows/en-US/3bfb7fbf-0dc0-4540-b712-625acd09784c/passing-data-back-to-called-form?forum=winformsdesigner

http://www.jobpencil.com
0