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