protected void Button1_Click(object sender, EventArgs e) { DataView dv = SqlDataSourceAdmin.Select(DataSourceSelectArguments.Empty) as DataView; if (dv != null) { bool exists = false; for (int i = 0; i < dv.Table.Rows.Count; i++) { if (username.Text.ToLower() == dv.Table.Rows[i]["Username"].ToString().ToLower() || emailid.Text == dv.Table.Rows[i]["Emailid"].ToString()) { exists = true; break; } } if (exists) { msg.Text = "Account already exists with Username or Email-id"; msg.CssClass = "text-danger"; } else { msg.Text = ""; SqlDataSourceAdmin.Insert(); msg.Text = "Account created successfully!"; msg.CssClass = "text-success"; } ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "$('#myModal').modal('hide');$('body').removeClass('modal-open');$('.modal-backdrop').remove();$('#myModal').modal('show');", true); } }
protected void insertButton_Click1(object sender, EventArgs e) { SqlDataSourceAdmin.InsertParameters["ID"].DefaultValue = ((TextBox)GridView1.FooterRow.FindControl("txtID")).Text; SqlDataSourceAdmin.InsertParameters["FirstName"].DefaultValue = ((TextBox)GridView1.FooterRow.FindControl("txtFname")).Text; SqlDataSourceAdmin.InsertParameters["LastName"].DefaultValue = ((TextBox)GridView1.FooterRow.FindControl("txtLname")).Text; SqlDataSourceAdmin.InsertParameters["Username"].DefaultValue = ((TextBox)GridView1.FooterRow.FindControl("txtUname")).Text; SqlDataSourceAdmin.InsertParameters["Password"].DefaultValue = ((TextBox)GridView1.FooterRow.FindControl("txtPword")).Text; SqlDataSourceAdmin.InsertParameters["Email"].DefaultValue = ((TextBox)GridView1.FooterRow.FindControl("txtEmail")).Text; SqlDataSourceAdmin.InsertParameters["Course"].DefaultValue = ((TextBox)GridView1.FooterRow.FindControl("txtCourse")).Text; SqlDataSourceAdmin.Insert(); }