I am trying to get access to Form1’s public method on another form Form2 as below. I have a textbox6
control on form1 and there is public method to bind it. But I want to bind it by form2 as below.
Form1
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private void button1_Click(object sender, EventArgs e)
{
Form2 f2 = new Form2();
f2.Show();
}
public void amount_sum()
{
string connstr = " server=.;initial catalog=maa;uid=mah;pwd=mah";
SqlConnection con = new SqlConnection(connstr);
con.Open();
string sql = " select sum(amount)as amount from method";
SqlDataAdapter dap = new SqlDataAdapter(sql, con);
DataSet ds = new DataSet();
dap.Fill(ds);
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
textBox6.Text = Convert.ToString(ds.Tables[0].Rows[i]["amount"]);
}
}
}
Form2
private void button1_Click(object sender, EventArgs e)
{
Form1 f1 = new Form1();
f1.amount_sum();
this.Close();
}
The above method-call is wrong. Please suggest how to correct it.
I want to bind Form1’s textBox6
control from Form2's Button_Click
event-handler by calling the public method, and when Form2 is closed, then Form1’s textbox6
should be bound. Is that possible by calling the public method from Form2?