How do I fill a checkedlistbox with values saved in SQL

Question

0.00/5 (No votes)

See more:

I need to fill one checkbox with some values I saved inside an SQL database.

C#

var numfatura = _transaction.TransDocument + _transaction.TransSerial + _transaction.TransDocNumber;

The variable I need it this one and I saved it inside the SQL like this:

C#

using (SqlConnection conn = new SqlConnection(@"Data source = 2c4138928627\Sage ; Database=ARMINDOData ; User Id=sa ; Password=sage2008+"))
{
 SqlCommand command = new SqlCommand("IF OBJECT_ID('UXFaturas', 'U') IS NULL CREATE TABLE UXFaturas(NumFaturas char(250), Cont1 char(250), Cont2 char(250));", conn);
 conn.Open();
 SqlCommand insertCommand = new SqlCommand("INSERT INTO UXFaturas(NumFaturas, Cont1, Cont2) VALUES (numfatura, cont, cont2)", conn);
    command.ExecuteNonQuery();
    command.Connection = conn;
    command.CommandType = System.Data.CommandType.StoredProcedure;
    //command.CommandText = "USP_InsertFile";
    command.Parameters.AddWithValue("@numfaturas", numfatura);
    command.Parameters.AddWithValue("@cont1", cont);
    command.Parameters.AddWithValue("@cont2", cont2);

  //command.ExecuteNonQuery();
 }
}

What I have tried:

I've tried to seach in internet but didnt find anything that was my problem and I have no clue on what should I start. I had this back in the day but I changed my project so this doesnt work anymore but may help:

C#

string path = @"C:\Users\HP8200\Desktop\";
 var files = System.IO.Directory.GetFiles(path, "*.txt");
 foreach (var item in files)
 {
 string fileNameOnly = "";
 fileNameOnly = Path.GetFileNameWithoutExtension(item);
 checkedListBox1.Items.Add(fileNameOnly); 
}

I'm using c#.

Posted 16-Aug-17 23:37pm

Member 13356973

Updated 17-Aug-17 7:25am

RickZeeland

v2

Add a Solution

Comments

Prifti Constantine 17-Aug-17 5:57am

The database is the txt file that you read with GetFiles() method?

Member 13356973 17-Aug-17 6:32am

The GetFiles() method is what I used when I created the textfile, now i dont create any textfile, I just save it into the sql server.

Prifti Constantine 17-Aug-17 6:37am

Lets say that the data is already in the sql server.... The command you are using here is an Insert Command... In order to fill the checkboxes you need to retrieve Data from the database, not insert it which in this case it is a simple Select Statement. Is this the appropriate (for you) code that you wish to provide? Maybe you forgot something?

Member 13356973 17-Aug-17 6:48am

The insert that you see in the question is to insert the data into the sql database. I think I didnt forget anything, but if you need something else I can provide you.

Locura The Exile 17-Aug-17 6:48am

As mentioned by @Prifti, the code you provided is for inserting, can you also provide the code with which you are currently retrieving the data and what errors/problems you are getting from it?

Member 13356973 17-Aug-17 7:07am

At the moment I dont have any code for retrieving the data. I did this question to make sure what should I do. And I added my previous code because it could be helpful. If you need any code I'll adding it without any problem

ZurdoDev 17-Aug-17 8:11am

Just google how to select data from sql using c#. Very simple.

Member 13356973 17-Aug-17 7:35am

Any help is appreciated

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sheila Pontes · Accepted Answer · 2017-08-17T03:54:00

Hi,

An Example to help you.

C#

private DataTable SelectData()
{ 
            DataTable dt = null;
            using (SqlConnection conn = new SqlConnection(@"Data source = 2c4138928627\Sage ; Database=ARMINDOData ; User Id=sa ; Password=sage2008+"))
            {
                SqlCommand command = new SqlCommand("SELECT myfieldtext, myfieldvalue FROM mytable", conn);
                conn.Open();
                SqlDataAdapter da = new SqlDataAdapter(command);
                da.Fill(dt);
            }

            return dt;
}

private void FillListBoxCheck()
{
            DataTable dt = this.SelectData();

            this.CheckBoxList1.DataTextField = "myfieldtext";
            this.CheckBoxList1.DataValueField = "myfieldvalue";
            this.CheckBoxList1.DataSource = dt;
            this.CheckBoxList1.DataBind();
 
}