[Solved] bit filed in UI

[Mohamed]

Hi

i have gridview that bind to database
in database there are bit filed in UI i want to display it as YES or NO
how can do this ? or eny samples like that

[Princy]

Hi Mohamed,

Try the following code snippet to achieve the desired scenario.

ASPX:

 <rad:GridBoundColumn UniqueName="Bit" HeaderText="Bit" DataField="Bit" ></rad:GridBoundColumn>

CS:

 protected void RadGrid1_ItemDataBound(object sender, GridItemEventArgs e)
    {
        if (e.Item is GridDataItem)
        {
            GridDataItem item = (GridDataItem)e.Item;
            string strtxt = item["Bit"].Text.ToString();
            if (strtxt == "True")
            {
             item["Bit"].Text="Yes";
            }
            else
                item["Bit"].Text = "No";

        }
  }

Hope this helps..
Princy.

[Mohammad Bourisly]

Hi Princy

thanks
this is work in desplay mode but in editing mode i want to desplay it as redio button or things like that

[Shinu]

Hello,

You can bind the bit field to a GridCheckBox column.

ASPX:

 <rad:GridCheckBoxColumn HeaderText="BitField" DataField="BitField" UniqueName="BitField">
    </rad:GridCheckBoxColumn>

You can also go through the following demo link to get details about the Column types supported by RadGrid.
Column types

Shinu.

[Mohammad Bourisly]

Hello Shinu

i have this senario
i have filed in table called Status integer type it has only values (0,1 or 2)
in UI
i want to map
0 to YES
1 to No
2 to NOT SURE

gridview 
in display mode show text of (YES,NO or NOTSURE) depends on binding

in editing mode 
show dropdwonlist to select from this values (YES,NO or NOTSURE) and bind it to database

[Princy]

Hi,

Try the following code snippet to achieve the desired scenario.

ASPX:

<rad:GridTemplateColumn HeaderText="Status" UniqueName="Status" DataField="Status" >
    <ItemTemplate>
        <asp:Label ID="Label2" runat="server" Text=' <%#Eval("Status") %>' ></asp:Label>

    </ItemTemplate>
    <EditItemTemplate>
        <asp:DropDownList ID="DropDownList2" runat="server">
          <asp:ListItem Text="YES" ></asp:ListItem>
          <asp:ListItem Text="NO" ></asp:ListItem>
          <asp:ListItem Text="NOT SURE" ></asp:ListItem>
        </asp:DropDownList>
    </EditItemTemplate>
  </rad:GridTemplateColumn>

CS:

protected void RadGrid1_ItemDataBound(object sender, GridItemEventArgs e)
    {

        if (e.Item is GridDataItem)
        {
            GridDataItem item = (GridDataItem)e.Item;
            Label lbl = (Label)item["Status"].FindControl("Label2");
            string strxt = lbl.Text.ToString();
            if (strxt == "1")
            {
                item["Status"].Text = "YES";
            }
            else if (strxt == "0")
            {
                item["Status"].Text = "NO";
            }
            else
                item["Status"].Text = "NOT SURE";

        }
   }

Hope this helps..
Princy.