public void save_btn_Click(object sender, EventArgs e)
{
SqlCommand cmdinsert = new SqlCommand("insert into TimeSheet (Project_Name,Activity_Name, Monday,Tuesday,Wednesday,Thursday,Friday,Saturday,Sunday) values (@Project_Name,@Activity_Name, @Monday,@Tuesday,@Wednesday,@Thursday,@Friday,@Saturday,@Sunday) ", con);
cmdinsert.Parameters.AddWithValue("@Project_Name", add.project_cbox.SelectedIndex);
cmdinsert.Parameters.AddWithValue("@Activity_Name", activity_cb.SelectedIndex);
cmdinsert.Parameters.AddWithValue("@Monday", add.monday_txt.Text);
cmdinsert.Parameters.AddWithValue("@Tuesday", add.tuesday_txt.Text);
cmdinsert.Parameters.AddWithValue("@Wednesday", add.wednesday_txt.Text);
cmdinsert.Parameters.AddWithValue("@Thursday", add.thursday_txt.Text);
cmdinsert.Parameters.AddWithValue("@Friday", add.friday_txt.Text);
cmdinsert.Parameters.AddWithValue("@Saturday", add.saturday_txt.Text);
cmdinsert.Parameters.AddWithValue("@Sunday", add.sunday_txt.Text);
con.Open();
cmdinsert.ExecuteNonQuery();
con.Close();
}
I tried accessing using properties ,I want to if there is a way to access the value in usercontrol without having to create an new instance of usercontrol in the form,also textboxes created are dynamic,any help will be much appreciated

New Topic/Question
Reply



MultiQuote





|