protected void BtnSubmit_Click(object sender, EventArgs e) { int y = 0; String sql = "select * from tbAdmin where Name='" + userName.Text.ToString() + "' and Password='******'"; DataTable tbl = new DataTable(); tbl = obj.DataRecord(sql); if (tbl.Rows.Count > 0) { Response.Redirect("DashBoard.aspx"); } else { data.InnerHtml = "<script> alert('Invalid User Name or Password');</script>"; } userName.Text = ""; userPassword.Text = ""; }
protected void Page_Load(object sender, EventArgs e) { String data = ""; int y = 0; String sql = "select * from tbServices "; DataTable tbl = new DataTable(); tbl = obj.DataRecord(sql); if (tbl.Rows.Count > 0) { for (y = 0; y < tbl.Rows.Count - 1; y++) { data = data + "<div class='col - lg - 4 col - md - 6'><div class='img1 img-grid d-flex align-items-end justify-content-center p-3'><div class='img_text_w3ls'>"; data = data + "<h4>" + tbl.Rows[y]["Name"] + "</h4><span> </span>< p>" + tbl.Rows[y]["Des"] + "</p></div></div></div>"; } } record.InnerHtml = data; }