protected void GridView1_RowDeleting1(object sender, GridViewDeleteEventArgs e) { Label lblId = (Label)GridView1.Rows[e.RowIndex].FindControl("Label1"); string query = @"DELETE FROM [dbo].[event_details] WHERE event_name='" + lblId.Text + "'"; if (dOps.executionquery(query) == 1) { loaderGrid(); } }
protected void Btnsave_Click(object sender, EventArgs e) { DataOps dOps = new DataOps(); string query = @"INSERT INTO [dbo].[event_details]([event_name] ,[event_type] ,[location] ,[date]) VALUES ('" + Texteventname.Text + "','" + Texteventtype.Text + "','" + Textlocation.Text + "','" + Textdate.Text + "')"; int r = dOps.executionquery(query); }
protected void Button1_Click(object sender, EventArgs e) { DataOps dOps = new DataOps(); string query = @"INSERT INTO [dbo].[student_reg]([sportsname] ,[student_id] ,[email] ,[mobile] ,[dob] ,[password]) VALUES ('" + Texteventname.Text + "','" + Textstudentid.Text + "','" + Textemail.Text + "','" + Textmobile.Text + "','" + Textdob.Text + "','" + Textpassword.Text + "')"; int r = dOps.executionquery(query); Label1.Text = "Successfully register"; }
protected void btnsubmit_Click(object sender, EventArgs e) { DataOps dOps = new DataOps(); string query = @"INSERT INTO [dbo].[register]([email],[password]) VALUES ('" + txtentermail.Text + "','" + txtpassword.Text + "')"; int r = dOps.executionquery(query); if (txtpassword.Text == repassword.Text) { Label1.Text = "Successfully register"; } else { Label2.Text = "password doesn't match"; } }