//skapa order yes/no

                DialogResult dialogResult = MessageBox.Show("Är du säker på att du vill skapa ordern?", "Skapa order", MessageBoxButtons.YesNo);
                if (dialogResult == DialogResult.No)
                {
                    return;
                }

_--------under denna---------------------

                //få fram empNr utifrån userName
                SqlConnection con5 = new SqlConnection(@"Data Source=KURSMSSQL.ad.liu.se\KURSMSSQL;Initial Catalog=725G75;User id =725G79MASTER;Password = jiSU6qiCM");
                SqlDataAdapter sda5 = new SqlDataAdapter("SELECT empNr FROM Users WHERE userName ='" + name + "'", con5);
                DataTable dt5 = new DataTable();
                try
                {
                    sda5.Fill(dt5);
                }
                catch (SqlException)
                {
                }

                string empNr = dt5.Rows[0][0].ToString();