protected void BtnAddpy_Click(object sender, EventArgs e) { try { if (RadioPresentpy.Checked) { S_Attendance = "Present"; } else if (RadioAbsentpy.Checked) { S_Attendance = "Absent"; } var query = "Insert into Python_Table values('" + TxtRegnopy.Text + "','" + TxtSnamepy.Text + "','" + S_Attendance + "')"; using (var conn = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename='|DataDirectory|\Classes.mdf';Integrated Security=True")) { var comm = new SqlCommand(query, conn); conn.Open(); comm.ExecuteNonQuery(); conn.Close(); LblMessagepy.Text = "Student added successfully"; TxtSnamepy.Text = TxtRegnopy.Text = S_Attendance = ""; GvPy.DataBind(); } } catch (Exception ex) { LblMessagepy.Text = ex.Message; } RefreshPage(); }
private void RefreshPage() { BtnEditpy.Visible = false; BtnAddpy.Visible = true; BtnDeletepy.Visible = false; TxtSnamepy.Text = TxtRegnopy.Text = S_Attendance = ""; GvPy.DataBind(); ListSNamepy.DataBind(); }