Add SQL query on button using C#

Question

I created a Windows Forms application in C# and my database in Visual Studio. I want to know how, if it's possible, to sort one of the columns in the table by clicking a button? Or how can I sort this column automatically without using a button?

I've tried to implement this sort in the code below, but it doesn't work :(

private c void button5_Click(object sender, EventArgs e)
{
    SqlConnection sqlConnection = new SqlConnection("Here is my connecting string");

    SqlCommand myCommand = new SqlCommand("SELECT * FROM [Information] ORDER BY (Перевозчик)", sqlConnection);

    sqlConnection.Open();
    myCommand.ExecuteNonQuery();
}

Answer 1

You need to do ExecuteDatareader then process the result coming from this call. ExecuteNonQuery cannot be used to retrieve data.

Answer 2

As found here: https://www.w3schools.com/sql/sql_orderby.asp

Sine we don't know what you want to oder we can only guess here.

But with the query you could try:

SELECT column1, column2, ...
FROM table_name
ORDER BY column1, column2, ... ASC

In your case:

"SELECT * FROM [Information] ORDER BY (Перевозчик) ASC"

Best would be to use the visual query builder where you can query against your database. When you are happy with your result you can at least be sure that the query is correct. How you can do that is explained here:

https://www.c-sharpcorner.com/article/connect-to-a-database-from-visual-studio/

Since the sqlconnection and the sqlcommand is disposable you should consider putting it in a using tag, like in this example. https://learn.microsoft.com/en-us/dotnet/api/system.data.sqlclient.sqlcommand?view=netframework-4.8

private static void ReadOrderData(string connectionString)
{
    string queryString = 
        "SELECT OrderID, CustomerID FROM dbo.Orders;";
    using (SqlConnection connection = new SqlConnection(
               connectionString))
    {
        SqlCommand command = new SqlCommand(
            queryString, connection);
        connection.Open();
        using(SqlDataReader reader = command.ExecuteReader())
        {
            while (reader.Read())
            {
                Console.WriteLine(String.Format("{0}, {1}",
                    reader[0], reader[1]));
            }
        }
    }
}

There is 2 way for sort data

1) sorting just data and fill into grid:

DataGridView datagridview1 = new DataGridView(); // for show data
DataTable dt1 = new DataTable(); // have data
DataTable dt2 = new DataTable(); // temp data table
DataRow[] dra = dt1.Select("", "ID DESC");
if (dra.Length > 0)
    dt2 = dra.CopyToDataTable();
datagridview1.DataSource = dt2;

2) sort default view that is like of sort with grid column header:

DataGridView datagridview1 = new DataGridView(); // for show data
DataTable dt1 = new DataTable(); // have data
dt1.DefaultView.Sort = "ID DESC";
datagridview1.DataSource = dt1;

I found this solution here: Sorting rows in a data table

For a listbox you could give this a shot

ArrayList q = new ArrayList(); 
foreach (object o in listBox4.Items) 
        q.Add(o);
} 
q.Sort(); 
listBox5.Items.Clear();
foreach(object o in q){
    listBox5.Items.Add(o); 
}

I found this solution here: Sorting a list of items in a list box