Set CheckBox checked based on comma separated value from Database using C# and VB.Net in ASP.Net

itsme

SOLVED CLOSED ACTIVE ANSWERED
User: itsme
Posted: on Sep 16, 2019 01:20 AM
Forum: ASP.Net Web Forms
Answer: 1
Views: 6432
Sample Code: Download

I am trying to set the value of checked checkbox from database when user click on edit button.

In Database it is storing all the checked value in a single field by seperating them with "," for example: Monday,Tuesday,Wednesday,Thrusday...etc

In string weeks database value is fetched but I dont know how to set them in checkbox. I tried doing this manually but It will take a lot of time for doing this for all the combinations.

please help.

<div class="checkbox checkbox-primary">
    <asp:CheckBox ID="mon" Text="Monday" runat="server" CssClass="styled" /><br />
    <asp:CheckBox ID="tues" Text="Tuesday" runat="server" CssClass="styled" /><br />
    <asp:CheckBox ID="wed" Text="Wednesday" runat="server" CssClass="styled" /><br />
    <asp:CheckBox ID="thrus" Text="Thrusday" runat="server" CssClass="styled" /><br />
    <asp:CheckBox ID="fri" Text="Friday" runat="server" CssClass="styled" /><br />
    <asp:CheckBox ID="sat" Text="Saturday" runat="server" CssClass="styled" /><br />
    <asp:CheckBox ID="sun" Text="Sunday" runat="server" CssClass="styled" /><br />
</div>

<asp:TemplateField HeaderText="Weeks Opens">
    <ItemTemplate>
        <asp:Label ID="lblweeks" runat="server" Text='<%#Eval("Days") %>'></asp:Label>
    </ItemTemplate>
</asp:TemplateField>

protected void btnEdit_Click(object sender, EventArgs e)
{
    try
    {
        Button btn = sender as Button;
        GridViewRow grow = btn.NamingContainer as GridViewRow;
        string category = (grow.FindControl("lblcat") as Label).Text;
        string suCategory = (grow.FindControl("lblBname") as Label).Text;
        string s = (grow.FindControl("lblstate") as Label).Text;
        string c = (grow.FindControl("lblcity") as Label).Text;
        Id.Value = (grow.FindControl("Id") as Label).Text;
        Image img = (grow.FindControl("img") as Image);
        txt_email.Text = (grow.FindControl("lblemail") as Label).Text;
        txt_link.Text = (grow.FindControl("lblweb") as Label).Text;
        txt_img.Text = (grow.FindControl("lblimg") as Label).Text;
        txt_name.Text = (grow.FindControl("lblname") as Label).Text;

        txt_toll.Text = (grow.FindControl("lbltoll") as Label).Text;
        txt_Address.Text = (grow.FindControl("lblAddress") as Label).Text;
        Image1.ImageUrl = img.ImageUrl;
        btnUpdate.Visible = true;

        if (drpcat2.Items.FindByText(category) != null)
        {
            drpcat2.ClearSelection();
            drpcat2.Items.FindByText(category).Selected = true;
            Session["iid"] = drpcat2.SelectedValue.ToString();
        }

        if (drppp.Items.FindByText(suCategory) != null)
        {
            drppp.ClearSelection();
            drppp.Items.FindByText(suCategory).Selected = true;
        }

        if (state.Items.FindByText(s) != null)
        {
            state.ClearSelection();
            state.Items.FindByText(s).Selected = true;
            Session["sid"] = state.SelectedValue.ToString();
        }

        if (city.Items.FindByText(c) != null)
        {
            city.ClearSelection();
            city.Items.FindByText(c).Selected = true;
        }
        string from = (grow.FindControl("lblopen") as Label).Text;
        string[] parts = from.Split(',');
        ddlTimeFrom.ClearSelection(); ddlTimeTo.ClearSelection();
        ddlTimeFrom.Items.FindByValue(parts[0].Trim()).Selected = true;
        ddlTimeTo.Items.FindByValue(parts[1].Trim()).Selected = true;

        string pay = (grow.FindControl("lblpay") as Label).Text;
        if (pay == "Cash")
        {
            Cashpay.Checked = true;
            Cardpay.Checked = false;
        }
        if (pay == "Card,Cash")
        {
            Cashpay.Checked = true;
            Cardpay.Checked = true;
        }
        if (pay == "Cash,Card")
        {
            Cashpay.Checked = true;
            Cardpay.Checked = true;
        }
        if (pay == "Card")
        {
            Cardpay.Checked = true;
            Cashpay.Checked = false;
        }

        string weeks = (grow.FindControl("lblweeks") as Label).Text;
        string[] parts1 = weeks.Split(',');
        if (weeks == "Monday")
        {
            mon.Checked = true;
            tues.Checked = false;
            wed.Checked = false;
            thrus.Checked = false;
            fri.Checked = false;
            sat.Checked = false;
            sun.Checked = false;
        }
        if (weeks == "Tuesday")
        {
            mon.Checked = false;
            tues.Checked = true;
            wed.Checked = false;
            thrus.Checked = false;
            fri.Checked = false;
            sat.Checked = false;
            sun.Checked = false;
        }
        if (weeks == "Wednesday")
        {
            mon.Checked = false;
            tues.Checked = false;
            wed.Checked = true;
            thrus.Checked = false;
            fri.Checked = false;
            sat.Checked = false;
            sun.Checked = false;
        }
        if (weeks == "Thrusday")
        {
            mon.Checked = false;
            tues.Checked = false;
            wed.Checked = false;
            thrus.Checked = true;
            fri.Checked = false;
            sat.Checked = false;
            sun.Checked = false;
        }
        if (weeks == "Friday")
        {
            mon.Checked = false;
            tues.Checked = false;
            wed.Checked = false;
            thrus.Checked = false;
            fri.Checked = true;
            sat.Checked = false;
            sun.Checked = false;
        }
        if (weeks == "Saturday")
        {
            mon.Checked = false;
            tues.Checked = false;
            wed.Checked = false;
            thrus.Checked = false;
            fri.Checked = false;
            sat.Checked = true;
            sun.Checked = false;
        }
        if (weeks == "Sunday")
        {
            mon.Checked = false;
            tues.Checked = false;
            wed.Checked = false;
            thrus.Checked = false;
            fri.Checked = false;
            sat.Checked = false;
            sun.Checked = true;
        }
        if (weeks == "Sunday")
        {
            mon.Checked = false;
            tues.Checked = false;
            wed.Checked = false;
            thrus.Checked = false;
            fri.Checked = false;
            sat.Checked = false;
            sun.Checked = true;
        }
    }
    catch (Exception ex)
    {
        Response.Write(ex);
    }
}

Download FREE API for Word, Excel and PDF in ASP.Net

pandeyis...

0 3

Reply
ANSWER
User: pandeyism
Replied: on Sep 16, 2019 06:59 AM
Report

Hi itsme,

Refer below sample.

HTML

<asp:CheckBox ID="mon" Text="Monday" runat="server" /><br />
<asp:CheckBox ID="tues" Text="Tuesday" runat="server" /><br />
<asp:CheckBox ID="wed" Text="Wednesday" runat="server" /><br />
<asp:CheckBox ID="thrus" Text="Thrusday" runat="server" /><br />
<asp:CheckBox ID="fri" Text="Friday" runat="server" /><br />
<asp:CheckBox ID="sat" Text="Saturday" runat="server" /><br />
<asp:CheckBox ID="sun" Text="Sunday" runat="server" /><br />
<asp:GridView runat="server" AutoGenerateColumns="false" ID="gvDays">
    <Columns>
        <asp:TemplateField HeaderText="Days">
            <ItemTemplate>
                <asp:Label ID="lblweeks" runat="server" Text='<%#Eval("Days") %>'></asp:Label>
            </ItemTemplate>
        </asp:TemplateField>
        <asp:TemplateField HeaderText="Edit">
            <ItemTemplate>
                <asp:Button Text="Edit" runat="server" OnClick="Edit" />
            </ItemTemplate>
        </asp:TemplateField>
    </Columns>
</asp:GridView>

Namespaces

using System.Data;

VB.Net

Imports System.Data

Code

protected void Page_Load(object sender, EventArgs e)
{
    if (!this.IsPostBack)
    {
        DataTable dt = new DataTable();
        dt.Columns.Add("Days");
        dt.Rows.Add("Monday,Tuesday,Wednesday");
        dt.Rows.Add("Monday,Tuesday,Wednesday,Thrusday");
        dt.Rows.Add("Monday,Thrusday");
        dt.Rows.Add("Tuesday,Sunday");
        gvDays.DataSource = dt;
        gvDays.DataBind();
    }
}

protected void Edit(object sender, EventArgs e)
{
    Button btn = sender as Button;
    GridViewRow row = btn.NamingContainer as GridViewRow;
    string weeks = (row.FindControl("lblweeks") as Label).Text;
    string[] parts1 = weeks.Split(',');
    mon.Checked = false;
    tues.Checked = false;
    wed.Checked = false;
    thrus.Checked = false;
    fri.Checked = false;
    sat.Checked = false;
    sun.Checked = false;
    for (int i = 0; i < parts1.Length; i++)
    {
        if (parts1[i].ToUpper() == "MONDAY")
        {
            mon.Checked = true;
        }
        if (parts1[i].ToUpper() == "TUESDAY")
        {
            tues.Checked = true;
        }
        if (parts1[i].ToUpper() == "WEDNESDAY")
        {
            wed.Checked = true;
        }
        if (parts1[i].ToUpper() == "THRUSDAY")
        {
            thrus.Checked = true;
        }
        if (parts1[i].ToUpper() == "FRIDAY")
        {
            fri.Checked = true;
        }
        if (parts1[i].ToUpper() == "SATURDAY")
        {
            sat.Checked = true;
        }
        if (parts1[i].ToUpper() == "SUNDAY")
        {
            sun.Checked = true;
        }
    }
}

VB.Net

Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) Handles Me.Load
    If Not Me.IsPostBack Then
        Dim dt As DataTable = New DataTable()
        dt.Columns.Add("Days")
        dt.Rows.Add("Monday,Tuesday,Wednesday")
        dt.Rows.Add("Monday,Tuesday,Wednesday,Thrusday")
        dt.Rows.Add("Monday,Thrusday")
        dt.Rows.Add("Tuesday,Sunday")
        gvDays.DataSource = dt
        gvDays.DataBind()
    End If
End Sub

Protected Sub Edit(ByVal sender As Object, ByVal e As EventArgs)
    Dim btn As Button = TryCast(sender, Button)
    Dim row As GridViewRow = TryCast(btn.NamingContainer, GridViewRow)
    Dim weeks As String = (TryCast(row.FindControl("lblweeks"), Label)).Text
    Dim parts1 As String() = weeks.Split(","c)
    mon.Checked = False
    tues.Checked = False
    wed.Checked = False
    thrus.Checked = False
    fri.Checked = False
    sat.Checked = False
    sun.Checked = False

    For i As Integer = 0 To parts1.Length - 1
        If parts1(i).ToUpper() = "MONDAY" Then
            mon.Checked = True
        End If
        If parts1(i).ToUpper() = "TUESDAY" Then
            tues.Checked = True
        End If
        If parts1(i).ToUpper() = "WEDNESDAY" Then
            wed.Checked = True
        End If
        If parts1(i).ToUpper() = "THRUSDAY" Then
            thrus.Checked = True
        End If
        If parts1(i).ToUpper() = "FRIDAY" Then
            fri.Checked = True
        End If
        If parts1(i).ToUpper() = "SATURDAY" Then
            sat.Checked = True
        End If
        If parts1(i).ToUpper() = "SUNDAY" Then
            sun.Checked = True
        End If
    Next
End Sub

Screenshot

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Set CheckBox checked based on comma separated value from Database using C# and VB.Net in ASP.Net

Company

Explore

Follow us

Contact Us