SqlConnection conn = new SqlConnection("Data Source=TWS\\SQLEXPRESS; Database=db_umesh; Integrated Security=True;"); protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { fillgv(); } } private void fillgv() { string qry = "select * from tbl_course"; SqlCommand cmd = new SqlCommand(qry,conn); try { cmd.Connection.Open(); gv.DataSource = cmd.ExecuteReader(); gv.DataBind(); } catch (Exception ex) { ltrl_msg.Text = ex.ToString(); } finally { conn.Close(); } } protected void gv_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.DataItem. ==ListItemType.Item) { } //if (e.Row.RowType.ToString() == ListItemType.Item.ToString() || e.Row.RowType.ToString() == ListItemType.AlternatingItem.ToString()) //{ // //((HtmlInputHidden)e.Row.FindControl("hid")).Value = DataBinder.Eval(e.Row.RowType, "Course_id").ToString(); // ((Literal)e.Row.FindControl("ltrl")).Text = DataBinder.Eval(e.Row.RowType, "Course_name").ToString(); //} } }
<div> <asp:GridView runat="server" ID="gv" AutoGenerateColumns="false" PageSize="5" GridLines="None" Width="80%" align="center" onrowdatabound="gv_RowDataBound" > <HeaderStyle BackColor="#84A8C9" /> <AlternatingRowStyle BackColor="#F4FAFF" /> <RowStyle BackColor="#DBECFB" /> <Columns> <asp:TemplateField> <HeaderTemplate> <font color="#F4FAFF"><b>Action</b></font> </HeaderTemplate> <ItemTemplate> <asp:CheckBox runat="server" ID="chkid" Width="16" /> <asp:Button ID="Button1" runat="server" Text="Edit" CommandName="edit" /> <asp:Button ID="Button2" runat="server" Text="del" CommandName="del" /> <input id="hid" runat="server" type="hidden" /> </ItemTemplate> <ItemStyle Height="12%" Width="13%" /> </asp:TemplateField> <asp:TemplateField> <HeaderTemplate> <font color="#F4FAFF"><b>Name</b></font> </HeaderTemplate> <ItemTemplate> <font color="#034f94"> <%--<asp:Label ID="lblName" runat="server" Text='<%#Eval("Course_name") %>' />--%> <asp:Literal ID="ltrl" runat="server"></asp:Literal> </font> </ItemTemplate> <ItemStyle Height="12%" HorizontalAlign="Left" Width="28%" /> <HeaderStyle HorizontalAlign="Left" /> </asp:TemplateField> <asp:TemplateField> <HeaderTemplate> <font color="#F4FAFF"><b>Duration</b></font> </HeaderTemplate> <ItemTemplate> <font color="#034f94"> <asp:Literal ID="lt_fees" runat="server" ></asp:Literal> </font> </ItemTemplate> <ItemStyle Height="12%" HorizontalAlign="Left" Width="28%" /> <HeaderStyle HorizontalAlign="Left" /> </asp:TemplateField> </Columns> </asp:GridView> </div> <asp:Literal runat="server" ID="ltrl_msg"></asp:Literal>
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)