[asemshahen5]

PHP كود :

       public void Save_Departments_Direct()
        {
            DataTable dt = new DataTable();
            SqlCommand cmd = new SqlCommand();
            dt.Clear();
            cmd = new SqlCommand("Select * from Departments Where DepartmentID =" + Convert.ToInt32(DepartmentID.Text), Con);
            Con.Open();
            dt.Load(cmd.ExecuteReader());
            Con.Close();
            if (dt.Rows.Count > 0)
            {
                MessageBox.Show("هذا السجل مسجل من قبل");
            }
            else
            {
                SqlCommand cmd1 = new SqlCommand();
                cmd1 = new SqlCommand("INSERT INTO Departments (DepartmentID ,DepartmentName) Values (" + DepartmentID.Text + " ,'" + DepartmentName.Text + "')", Con);
                Con.Open();
                cmd1.ExecuteNonQuery();
                Con.Close();
                MessageBox.Show("تم الحفظ بنجاح");
            }
        }
        private void button1_Click(object sender, EventArgs e)
        {
            Save_Departments_Direct();
        }