[ali_ahmed12]

PHP كود :

   If ComboBox1.SelectedIndex < 0 Then
            MessageBox.Show("الرجاء اختيار اسم المستخدم ")
            Exit Sub
        End If
        Module1.con.Open()
        cmd = New SqlCommand("select *from users where user_name=@user_name and user_password=@user_password", Module1.con)
        cmd.Parameters.AddWithValue("@user_name", ComboBox1.Text)
        cmd.Parameters.AddWithValue("@user_password", Textpass.Text)
        rdr = cmd.ExecuteReader
        rdr.Read()
        If rdr.HasRows() Then
            str_username = rdr("user_name").ToString()
            With Form_main
                .btn_sales.Enabled = rdr("btn_sales").ToString()
                .btn_customer.Enabled = rdr("btn_customer").ToString()
                .btn_product.Enabled = rdr("btn_product").ToString()
                .btn_users.Enabled = rdr("btn_users").ToString()
                .btn_con.Enabled = rdr("btn_con").ToString()
                .Show()
                Me.Hide()
            End With
        Else
            MessageBox.Show("كلمة المرور خطأ")
            Textpass.Select()
        End If
        rdr.Close()
        Module1.con.Close() 


السلام عليكم ممكن تحويل كود تالي الي لغه سي شارب وبارك الله فيكم

[bidaya]

كود :

if (ComboBox1.SelectedIndex < 0)
            {
                MessageBox.Show("الرجاء اختيار اسم المستخدم ");
                return;
            }
            Module1.con.Open();
            cmd = new SqlCommand("select *from users where user_name=@user_name and user_password=@user_password", Module1.con);
            cmd.Parameters.AddWithValue("@user_name", ComboBox1.Text);
            cmd.Parameters.AddWithValue("@user_password", Textpass.Text);
            rdr = cmd.ExecuteReader;
            rdr.Read();
            if (rdr.HasRows())
            {
                str_username = rdr("user_name").ToString();
                var with_1 = Form_main;
                with_1.btn_sales.Enabled = rdr("btn_sales").ToString();
                with_1.btn_customer.Enabled = rdr("btn_customer").ToString();
                with_1.btn_product.Enabled = rdr("btn_product").ToString();
                with_1.btn_users.Enabled = rdr("btn_users").ToString();
                with_1.btn_con.Enabled = rdr("btn_con").ToString();
                with_1.Show();
                this.Hide();
            }
            else
            {
                MessageBox.Show("كلمة المرور خطأ");
                Textpass.Select();
            }
            rdr.Close();
            Module1.con.Close();

[ali_ahmed12]

(10-01-23, 03:56 AM)bidaya كتب :

كود :

if (ComboBox1.SelectedIndex < 0)
            {
                MessageBox.Show("الرجاء اختيار اسم المستخدم ");
                return;
            }
            Module1.con.Open();
            cmd = new SqlCommand("select *from users where user_name=@user_name and user_password=@user_password", Module1.con);
            cmd.Parameters.AddWithValue("@user_name", ComboBox1.Text);
            cmd.Parameters.AddWithValue("@user_password", Textpass.Text);
            rdr = cmd.ExecuteReader;
            rdr.Read();
            if (rdr.HasRows())
            {
                str_username = rdr("user_name").ToString();
                var with_1 = Form_main;
                with_1.btn_sales.Enabled = rdr("btn_sales").ToString();
                with_1.btn_customer.Enabled = rdr("btn_customer").ToString();
                with_1.btn_product.Enabled = rdr("btn_product").ToString();
                with_1.btn_users.Enabled = rdr("btn_users").ToString();
                with_1.btn_con.Enabled = rdr("btn_con").ToString();
                with_1.Show();
                this.Hide();
            }
            else
            {
                MessageBox.Show("كلمة المرور خطأ");
                Textpass.Select();
            }
            rdr.Close();
            Module1.con.Close();

هدا كود صح للتحويل 

PHP كود :

if (comboBox2.SelectedIndex < 0)
            {
                MessageBox.Show("الرجاء اختيار اسم المستخدم ");
                return;
            }
            Class1.con.Open();
          SqlCommand  cmd = new SqlCommand("select *from users where user_name=@user_name and user_password=@user_password", Class1.con);
            cmd.Parameters.AddWithValue("@user_name", comboBox2.Text);
            cmd.Parameters.AddWithValue("@user_password", Textpass.Text);
            rdr = cmd.ExecuteReader();
            rdr.Read();
            if (rdr.HasRows)
            {
                Class1.str_username = rdr["user_name"].ToString();
           
                Form_main frm = new Form_main();
                frm.button1.Enabled = Convert.ToBoolean( rdr["btn_sales"].ToString());
                frm.button2.Enabled = Convert.ToBoolean(rdr["btn_customer"].ToString());
                frm.button3.Enabled = Convert.ToBoolean(rdr["btn_product"].ToString());
                frm.button4.Enabled = Convert.ToBoolean(rdr["btn_users"].ToString());
                frm.button5.Enabled = Convert.ToBoolean(rdr["btn_con"].ToString());

                
                frm.Show();
                this.Hide();
            }
            else
            {
                MessageBox.Show("كلمة المرور خطأ");
                Textpass.Select();
            }
            rdr.Close();
            Class1.con.Close();