<asp:GridView ID="gv_addrow" runat="server" AutoGenerateColumns="False" CellPadding="4" ForeColor="#333333" GridLines="None"> <AlternatingRowStyle BackColor="White" /> <Columns> <asp:TemplateField HeaderText="S.NO."> <ItemTemplate> <%# ((GridViewRow) Container).RowIndex + 1 %> </ItemTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="ID "> <ItemTemplate> <asp:Label ID="Label1" runat="server" Text='<%# Bind("EMPNO") %>'></asp:Label> </ItemTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="Name"> <ItemTemplate> <asp:Label ID="Label2" runat="server" Text='<%# Bind("NAME") %>'></asp:Label> </ItemTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="Checked Date"> <ItemTemplate> <asp:Label ID="Label3" runat="server"></asp:Label> <%=System.DateTime.Now%> </ItemTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="Time"> <ItemTemplate> <asp:Label ID="Label4" runat="server"></asp:Label> <%=System.DateTime.Now.Month %> </ItemTemplate> </asp:TemplateField> </Columns> <EditRowStyle BackColor="#2461BF" /> <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" /> <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" /> <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" /> <RowStyle BackColor="#EFF3FB" /> <SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" /> <SortedAscendingCellStyle BackColor="#F5F7FB" /> <SortedAscendingHeaderStyle BackColor="#6D95E1" /> <SortedDescendingCellStyle BackColor="#E9EBEF" /> <SortedDescendingHeaderStyle BackColor="#4870BE" /> </asp:GridView>
public void ADD_getDetail() { SqlConnection con = new SqlConnection(s); con.Open(); SqlCommand cmd = new SqlCommand("select EMPNO, NAME from zemp_s_web_al where EMPNO = " + "'" + EmpCode.Trim() + "'", con); //List<sqlparameter> paramList = new List<sqlparameter>(); //paramList.Add(new SqlParameter("@EMPCODE", EmpCode)); //cmd.Parameters.AddRange(paramList.ToArray()); SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); gv_addrow.DataSource = dt; gv_addrow.DataBind(); con.Close(); }</sqlparameter></sqlparameter>
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)