code

SqlConnection conn = new SqlConnection();
        string constr = @"Server=tcp:XXX.database.windows.net,1433;Initial Catalog=mydb;Persist Security Info=False;User ID=XXX;Password=XXX;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;";

		SqlCommand cmd = new SqlCommand();

        protected void Page_Load(object sender, EventArgs e)
        {
            cust_list.Focus();
            if(!IsPostBack)
            {
                conn.ConnectionString = constr;
                conn.Open();
                string query = "select empid from cuser";
                cmd.CommandText = query;
                cmd.Connection = conn;
                id = (int)cmd.ExecuteScalar();
                Console.Write("eid is: " + id);
                query = "select [fname] from [emp] where [empid] = " + id + "";
                cmd.CommandText = query;
                ufname = (string)cmd.ExecuteScalar();
                query = "select [lname] from [emp] where [empid] = " + id + "";
                cmd.CommandText = query;
                ulname += (string)cmd.ExecuteScalar();
                usrname_lbl.Text = "Logged-in as: " + ufname + " " + ulname + "<br />Employee Code: E00" + id;
                usrname_lbl.Font.Bold = true;

                /* order generation*/
                query = "select custname from customer";
                cmd.CommandText = query;
                SqlDataReader dr;
                dr = cmd.ExecuteReader();

                if (dr.HasRows)
                {
                    while (dr.Read())
                    {
                        cust_list.Items.Add(dr[0].ToString()); //adding customers to dropdown

                    }
                }
                conn.Close();


            }



            conn.ConnectionString = constr;
            conn.Open();
            cmd.Connection = conn;

            //getting empid
            cmd.CommandText = "select empid from cuser";
            cmd.Connection = conn;
            id = (int)cmd.ExecuteScalar();

            //getting orderid
            cmd.CommandText = "select COALESCE(max(orderid), 0) FROM [order]";
            oid = (int)cmd.ExecuteScalar();
            oid = oid + 1; //incerase oid to next oid
            shit.Text = "<br /><br />current orderid = " + oid;
            conn.Close();
        }