1
Q:

mysql C# select pk and all columns datareader

// Fill orderIDsList with OrderID's
        private void btnStart_Click(object sender, System.EventArgs e)
        {
            int iOrderID;

            // Create a command to select the Order IDs from the ORDERS table
            SqlCommand command = new SqlCommand
                ("SELECT OrderID from ORDERS", con);

            // Open the connection
            con.Open();

            // Get the data reader
            SqlDataReader reader = command.ExecuteReader();

            // Process each result
            while (reader.Read())
            {
                // Add each order ID in the result to the list
                // view containing the orders IDs. We have only
                // selected a single column in this code so we
                // can be pretty save in using reader.GetInit32(0)
                // there are no more columns in the data reader.
                iOrderID = reader.GetOrdinal("OrderID");
                orderIDsList.Items.Add (reader.GetInt32(iOrderID));
            }

            // Close the reader and the connection
            reader.Close();
            this.con.Close();
        }
0

New to Communities?

Join the community