textbox value

ta mu

An object reference is required for the non-static field, method, or property 'login.add_reminder.textBox1'

i am getting this error. textbox is on other form. access modifire is public but still error. how to resolve this error.

private void ok_Click(object sender, EventArgs e)
{

SqlConnection my = new SqlConnection(@"Data Source=heaven_prince20;Initial Catalog=final_pr;Integrated Security=True");
my.Open();
SqlCommand cmd = new SqlCommand("INSERT INTO reminder(messaq,date,time) VALUES ('" + add_reminder.textBox1.Text + "''" + monthCalendar1.SelectionRange.Start + "','" + dateTimePicker1.Value + "')", my);
cmd.ExecuteNonQuery();

}

8 Replies

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

Iftikar Hussain13y ago
Accepted answer
try like this

private void ok_Click(object sender, EventArgs e)
{
add_reminder addRem=new add_reminder();
SqlConnection my = new SqlConnection(@"Data Source=heaven_prince20;Initial Catalog=final_pr;Integrated Security=True");
my.Open();
SqlCommand cmd = new SqlCommand("INSERT INTO reminder(messaq,date,time) VALUES ('" + addRem.textBox1.Text + "''" + monthCalendar1.SelectionRange.Start + "','" + dateTimePicker1.Value + "')", my);
cmd.ExecuteNonQuery();

}

Regards,
Iftikar
0
ta mu13y ago
yes other problem is when i click ok my add_reminder form display again when i make comment that change you have made above add_reminder addrem=new add_reminder() then working fine.
0
Iftikar Hussain13y ago
have you entered the textbox value in the other form?

Regards,
Iftikar
0
ta mu13y ago
error gone but mesag is not saved in database. while date and time are ok
whats wrong
0
ta mu13y ago
its compelete code. i want when i press button text of textform which is on other form is to save in database
0
Iftikar Hussain13y ago
Please share the complete code.

Regards,
Iftikar
0
ta mu13y ago
its the name of other form having textbox1
0
Iftikar Hussain13y ago
Hi,
What is add_reminder? Have you created the instance of this form?

Regards,
Iftikar
0