<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="stafflogin.aspx.cs" Inherits="gatepass.stafflogin" %> <title> <div> <br><br> <div> </div> <center> <asp:gridview id="GridView1" runat="server" autogeneratecolumns="False" backcolor="LightGoldenrodYellow" style="margin-right: 190px" width="680px" autogenerateeditbutton="True" datakeynames="regno" datasourceid="SqlDataSource1" onselectedindexchanged="GridView1_SelectedIndexChanged"> <columns> <asp:boundfield datafield="regno" headertext="regno" sortexpression="regno" readonly="True"> <asp:boundfield datafield="reason" headertext="reason" sortexpression="reason"> <asp:boundfield datafield="type" headertext="type" sortexpression="type"> <asp:boundfield datafield="dol" headertext="dol" sortexpression="dol"> <asp:boundfield datafield="tol" headertext="tol" sortexpression="tol"> <asp:boundfield datafield="dor" headertext="dor" sortexpression="dor"> <asp:boundfield datafield="tor" headertext="tor" sortexpression="tor"> <asp:templatefield headertext="Approval"> <itemtemplate> <asp:textbox id="tb1" runat="server"> <asp:templatefield headertext="Submit"> <itemtemplate> <asp:button id="btn1" runat="server" text="Submit"> <br> <asp:label id="Label1" runat="server" text=""> </center> <br> This is my code behind using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Data; using System.Data.SqlClient; namespace gatepass { public partial class stafflogin : System.Web.UI.Page { SqlConnection con = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;Integrated Security=True"); protected void Page_Load(object sender, EventArgs e) { con.Open(); string checkusr = "select * from day"; SqlCommand cmd = new SqlCommand(checkusr, con); SqlDataReader reader = cmd.ExecuteReader(); GridView1.DataSource = reader; GridView1.DataBind(); con.Close(); } } }</div>
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)