Align data in listBox

Question

I load the database in listbox by this code:

using (SqlConnection myDatabaseConnection = new SqlConnection(myConnectionString.ConnectionString))
        {
            myDatabaseConnection.Open();
            using (SqlCommand SqlCommand = new SqlCommand("Select ID, LastName from Employee", myDatabaseConnection))
            {
                SqlDataReader dr = SqlCommand.ExecuteReader();
                while (dr.Read())
                {
                    listBox1.Items.Add((string)dr["LastName"] + "    " + dr["ID"]);
                }
            }
        }

Result:

How to align the data like this in listbox?

`\t` should do the trick. http://stackoverflow.com/a/366126/227646 Another answer here: http://stackoverflow.com/a/4449167/227646 — kush, Jun 07 '13 at 18:51

score 1 · Answer 1 · answered Jun 07 '13 at 19:36

using (SqlConnection myDatabaseConnection = new SqlConnection(myConnectionString.ConnectionString))
    {
        myDatabaseConnection.Open();
        using (SqlCommand SqlCommand = new SqlCommand("Select ID, LastName from Employee", myDatabaseConnection))
        {
            SqlDataReader dr = SqlCommand.ExecuteReader();
            while (dr.Read())
            {
                int lastNameLength = dr["LastName"].Length;
                int idLength = dr["ID"].Length;
                int numberOfSpaces = 30 - lastNameLength - idLength;
                string spaces = string.Empty;
                for (int i = 0; i < numberOfSpaces; i++)
                {
                    spaces = spaces + " "; 
                }                    
                listBox1.Items.Add((string)dr["LastName"] + spaces + dr["ID"]);
            }
        }
    }

This should work for you. Please note that the 30 in the line "int numberOfSpaces = 30 - lastNameLength - idLength;", the 30 is just a hard coded value for the number of characters that can fit on a single line in your text box. You can play with that number or pull in it from your text box too. But this method should now set the last name to left of the box and id should be pinned to the right of the box. I hope this helps.

Regards,

Kyle

does not contain a definition for 'Lenght' and no extension method 'Lenght'accepting a first argument of type 'object' could be found — Karlx Swanovski, Jun 08 '13 at 06:34

score 0 · Answer 2 · answered Jun 07 '13 at 19:13

0

I think you should add your data in a dataGridView component and work with table events.

Read this article about Datagridview, up to your discription its what you need

answered Jun 07 '13 at 19:13

Vahid

354
1
3
10

score -1 · Answer 3 · edited Oct 14 '17 at 08:03

-1

while (dr.Read())
{
    listBox1.Items.Add((string)dr["LastName"] + "    " + dr["ID"],HorizontalAlignment.Right);
}

edited Oct 14 '17 at 08:03

FelixSFD

6,052
10
43
117

answered Oct 14 '17 at 05:57

user8774629

1

1

format your code properly and maybe add a bit of explanation – Paweł Łukasik Oct 14 '17 at 06:03

Align data in listBox

3 Answers3