Set Default CheckListBox Item Checked using C# and VB.Net in Windows Application

smile

SOLVED CLOSED ACTIVE ANSWERED
User: smile
Posted: on Jun 05, 2020 04:38 AM
Forum: Windows Basics
Answer: 1
Views: 9523

How to Set Checkedbox on always by default for specific value in the Listbox in windows form

I have a listbox and bind it with the database by the following way

it may contains more than two values

Case 1:

Admission Fees

Others

Case 2:

Admission Fees

Tution Fees

Others

Now I want to set the Checked on always by default for "Others". I mean when I open this form then in the Form_Load event

the checkbox for the Others must b on always.

How to get the solution???

        private void ShowFeesHeadSec()
        {
            con = new SqlDbConnect();
            con.SqlQuery("select af.HeadID,HeadName,Amount from tblFeesAssign as af inner join tblAcademicYear as ay on af.YearID=ay.YearID inner join tblDefClass as dc on af.ClassID=dc.ClassID inner join tblDefSection as ds on af.SectionID= ds.SectionID inner join tblFeesHead as fh on af.HeadID=fh.HeadID where af.YearID=@YId and af.ClassID=@CId and af.SectionID=@SId order by FeeCatID desc;");
            con.Cmd.Parameters.Add(new SqlParameter("@YId", this.cmbYear.SelectedValue.ToString()));
            con.Cmd.Parameters.Add(new SqlParameter("@CId", this.cmbClass.SelectedValue.ToString()));
            con.Cmd.Parameters.Add(new SqlParameter("@SId", this.cmbSection.SelectedValue.ToString()));
            //con.Cmd.Parameters.Add(new SqlParameter("@Month", this.cmbMonth.SelectedValue.ToString()));
            sTable = new DataTable();
            paging.SelectCommand = con.Cmd;
            paging.Fill(sTable);
            chkHead.DataSource = sTable;
            chkHead.DisplayMember = "HeadName";
            chkHead.ValueMember = "HeadID";
        }

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

dharmend...

0 3

Reply
ANSWER
User: dharmendr
Replied: on Jun 05, 2020 07:12 AM
Report

Hi smile,

Refer below sample.

I have added a CheckedListBox control on the form.

Namespaces

using System.Data;

VB.Net

Imports System.Data

Code

public partial class Form1 : Form
{
    public Form1()
    {
        InitializeComponent();
    }

    private void Form1_Load(object sender, EventArgs e)
    {
        this.BindCheckedListBox();
    }

    private void BindCheckedListBox()
    {
        DataTable sTable = new DataTable();
        sTable.Columns.AddRange(new DataColumn[] { new DataColumn("HeadName"), new DataColumn("HeadID") });
        sTable.Rows.Add("Admission Fees", "Admission Fees");
        sTable.Rows.Add("Tution Fees", "Tution Fees");
        sTable.Rows.Add("Others", "Others");
        chkHead.DataSource = sTable;
        chkHead.DisplayMember = "HeadName";
        chkHead.ValueMember = "HeadID";
        for (int i = 0; i < chkHead.Items.Count; i++)
        {
            if ((chkHead.Items[i] as DataRowView).Row["HeadName"].ToString().ToLower() == "others")
            {
                chkHead.SetItemChecked(i, true);
            }
        }
    }
}

VB.Net

Public Class Form1
    Private Sub Form1_Load(sender As Object, e As EventArgs) Handles MyBase.Load
        Me.BindCheckedListBox()
    End Sub
    Private Sub BindCheckedListBox()
        Dim sTable As DataTable = New DataTable()
        sTable.Columns.AddRange(New DataColumn() {New DataColumn("HeadName"), New DataColumn("HeadID")})
        sTable.Rows.Add("Admission Fees", "Admission Fees")
        sTable.Rows.Add("Tution Fees", "Tution Fees")
        sTable.Rows.Add("Others", "Others")
        chkHead.DataSource = sTable
        chkHead.DisplayMember = "HeadName"
        chkHead.ValueMember = "HeadID"
        For i As Integer = 0 To chkHead.Items.Count - 1
            If (TryCast(chkHead.Items(i), DataRowView)).Row("HeadName").ToString().ToLower() = "others" Then
                chkHead.SetItemChecked(i, True)
            End If
        Next
    End Sub
End Class

Screenshot

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

Set Default CheckListBox Item Checked using C# and VB.Net in Windows Application

Company

Explore

Follow us

Contact Us