I am having a grid and below is the code which I had written for it. In my grid for this column i.e. \[code\]<asp:BoundField DataField = "IsNOWEnabled" HeaderText = "Enabled/Disabled" HtmlEncode = "true"/>\[/code\] , from the database either 1 or 0 is coming. I want that while the binding the grid replace 1 by enabled and 0 by disabled for this column so that when the grid binds it display 1 as enabled and 0 as disabled for column Enabled/Disabled.Please guide me , how i achieve this.\[code\]<asp:UpdatePanel ID="UpdatePanel1" runat="server"><ContentTemplate> <asp:GridView ID="GridView1" runat="server" Width = "550px" AutoGenerateColumns = "false" AlternatingRowStyle-BackColor = "#C2D69B" HeaderStyle-BackColor = "green" AllowPaging ="true" OnPageIndexChanging = "OnPaging" PageSize = "10" > <Columns> <asp:BoundField DataField = "NatureOfWorkID" HeaderText = "Nature Of WorkID" HtmlEncode = "true" Visible="false" /> <asp:BoundField DataField = "NatureOFWorkName" HeaderText = "Nature Of Work Name" HtmlEncode = "true" /> <asp:BoundField DataField = "IsNOWEnabled" HeaderText = "Enabled/Disabled" HtmlEncode = "true"/> <asp:TemplateField ItemStyle-Width = "30px" HeaderText = "NatureOfWorkID"> <ItemTemplate> <asp:LinkButton ID="lnkEdit" runat="server" Text = "Edit" OnClick = "Edit"></asp:LinkButton> </ItemTemplate> </asp:TemplateField> </Columns> <AlternatingRowStyle BackColor="#C2D69B" /> </asp:GridView> <asp:Button ID="btnAdd" runat="server" Text="Add" OnClick = "Add" /> <asp
anel ID="pnlAddEdit" runat="server" CssClass="modalPopup" style = "display:none"> <asp:Label Font-Bold = "true" ID = "Label4" runat = "server" Text = "Nature Of Work Details" ></asp:Label> <br /> <table align = "center"> <tr> <td> <asp:Label ID = "Label2" runat = "server" Text = "Nature Of Work Name" ></asp:Label> </td> <td> <asp:TextBox ID="txtNOWname" runat="server"></asp:TextBox> </td> </tr> <tr> <td> <asp:RadioButton id="RBEnable" Text="Enabled" runat="server"/> <br> <asp:RadioButton id="RBDisable" Text="Disabled" runat="server"/> <br> </td> </tr> <tr> <td> <asp:Button ID="btnSave" runat="server" Text="Save" OnClick = "Save" /> </td> <td> <asp:Button ID="btnCancel" runat="server" Text="Cancel" OnClientClick = "return Hidepopup()"/> </td> </tr> </table> </aspanel> <asp:LinkButton ID="lnkFake" runat="server"></asp:LinkButton> <cc1:ModalPopupExtender ID="popup" runat="server" DropShadow="false" PopupControlID="pnlAddEdit" TargetControlID = "lnkFake" BackgroundCssClass="modalBackground"> </cc1:ModalPopupExtender></ContentTemplate> <Triggers> <asp:AsyncPostBackTrigger ControlID = "GridView1" /> <asp:AsyncPostBackTrigger ControlID = "btnSave" /> </Triggers> \[/code\] The code behind is :-\[code\]private String strConnString = ConfigurationManager.ConnectionStrings["TempConnectionString"].ConnectionString; protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { this.BindData(); } } private void BindData() { string strQuery = "select NatureOfWorkID,NatureOfWorkName,IsNOWEnabled" + " from NatureOfWork"; SqlCommand cmd = new SqlCommand(strQuery); GridView1.DataSource = GetData(cmd); GridView1.DataBind(); } private DataTable GetData(SqlCommand cmd) { DataTable dt = new DataTable(); using (SqlConnection con = new SqlConnection(strConnString)) { using (SqlDataAdapter sda = new SqlDataAdapter()) { cmd.Connection = con; con.Open(); sda.SelectCommand = cmd; sda.Fill(dt); return dt; } } } protected void OnPaging(object sender, GridViewPageEventArgs e) { this.BindData(); GridView1.PageIndex = e.NewPageIndex; GridView1.DataBind(); }\[/code\]
anel ID="pnlAddEdit" runat="server" CssClass="modalPopup" style = "display:none"> <asp:Label Font-Bold = "true" ID = "Label4" runat = "server" Text = "Nature Of Work Details" ></asp:Label> <br /> <table align = "center"> <tr> <td> <asp:Label ID = "Label2" runat = "server" Text = "Nature Of Work Name" ></asp:Label> </td> <td> <asp:TextBox ID="txtNOWname" runat="server"></asp:TextBox> </td> </tr> <tr> <td> <asp:RadioButton id="RBEnable" Text="Enabled" runat="server"/> <br> <asp:RadioButton id="RBDisable" Text="Disabled" runat="server"/> <br> </td> </tr> <tr> <td> <asp:Button ID="btnSave" runat="server" Text="Save" OnClick = "Save" /> </td> <td> <asp:Button ID="btnCancel" runat="server" Text="Cancel" OnClientClick = "return Hidepopup()"/> </td> </tr> </table> </aspanel> <asp:LinkButton ID="lnkFake" runat="server"></asp:LinkButton> <cc1:ModalPopupExtender ID="popup" runat="server" DropShadow="false" PopupControlID="pnlAddEdit" TargetControlID = "lnkFake" BackgroundCssClass="modalBackground"> </cc1:ModalPopupExtender></ContentTemplate> <Triggers> <asp:AsyncPostBackTrigger ControlID = "GridView1" /> <asp:AsyncPostBackTrigger ControlID = "btnSave" /> </Triggers> \[/code\] The code behind is :-\[code\]private String strConnString = ConfigurationManager.ConnectionStrings["TempConnectionString"].ConnectionString; protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { this.BindData(); } } private void BindData() { string strQuery = "select NatureOfWorkID,NatureOfWorkName,IsNOWEnabled" + " from NatureOfWork"; SqlCommand cmd = new SqlCommand(strQuery); GridView1.DataSource = GetData(cmd); GridView1.DataBind(); } private DataTable GetData(SqlCommand cmd) { DataTable dt = new DataTable(); using (SqlConnection con = new SqlConnection(strConnString)) { using (SqlDataAdapter sda = new SqlDataAdapter()) { cmd.Connection = con; con.Open(); sda.SelectCommand = cmd; sda.Fill(dt); return dt; } } } protected void OnPaging(object sender, GridViewPageEventArgs e) { this.BindData(); GridView1.PageIndex = e.NewPageIndex; GridView1.DataBind(); }\[/code\]