مساعدة c#

[B.Djemàa]

السلام عايكم



كيف الحال ????







salut

cv?
SVP
j' ai besoin d'aide en c#
voila ce procedure là
quand je veux inserer les numero des client sans repeter le meme numero en autre insertion
mais la procedure stop apres verifier si le numero exist ou no
merci en avance

[__الهاوي__]

السلام عليكم
ملاحظات على السريع مدونة ضمن البرنامج
أتمنى أن تجدي مبتغاك فيه

كود PHP:

private void button1_Click(object sender, EventArgs e)
        {
            if (textBox1.Text == "")
            {
                MessageBox.Show("Inserer le Numero");
            }
            else
                if (textBox1.Text != "") // هذا السطر زائد فلا منفعة من الشرط
                {
                    for (int row = 0; row < dataGridView1.Rows.Count; row++)
                    {
                        for (int col = 0; col < dataGridView1.Columns.Count; col++)
                        {
                            if (dataGridView1.Rows[row].Cells[col].Value != null &&
                                dataGridView1.Rows[row].Cells[col].Value.Equals(textBox1.Text.Trim()))
                            {
                                MessageBox.Show(" Le numero exist dejà ");
                            }
                        }
                    }
                }
                else //وجودها خاطئ، ينبغي حذفها
                    if (textBox2.Text == "")
                    {
                        MessageBox.Show("Inserer le Nom");
                    }
                    else
                        if (textBox3.Text == "")
                        {
                            MessageBox.Show("Inserer le Prenom");
                        }
                        else
                        {
                        //try-catch-finally يستحسن في قواعد البيانات استخدام 
                            cazoranConn.Open();// في بداية البرنامج connection stringعلى افتراض أنك ذكرت ال
                            OleDbCmd.Connection = cazoranConn;
                            OleDbCmd.CommandText = "insert into persoone (Numero, Nom ,Prenom,Etat) values ('" + this.textBox1.Text + "','" + this.textBox2.Text + "','" + this.textBox3.Text + "' ,'" + this.comboBox1.Text + "')";//خطأ في وجود فاصلة منقوطة إضافية

                            int temp = OleDbCmd.ExecuteNonQuery();
                            if (temp > 0)
                            {
                                textBox1.Text = null;//TextBox.Clear();من الافضل كتابة 
                                textBox2.Text = null;
                                textBox3.Text = null;

                                // show all 

                                MessageBox.Show("Record Successfuly Added");
                                dataGridView1.DataSource = null;
                                dataGridView1.Rows.Clear();
                                dataGridView1.*******();

                                OleDbDataAdapter dAdapter = new OleDbDataAdapter("select * from persoone", connParam);
                                OleDbCommandBuilder cBuilder = new OleDbCommandBuilder(dAdapter);

                                DataTable dataTable = new DataTable();
                                DataSet ds = new DataSet();

                                dAdapter.Fill(dataTable);

                                //dataGridView1.DataSource=dataTable يمكن الاستغناء عن كل هذا العمل ب
                                for (int i = 0; i < dataTable.Rows.Count; i++)
                                {
                                    dataGridView1.Rows.Add(dataTable.Rows[i][0], dataTable.Rows[i][1], dataTable.Rows[i][2], dataTable.Rows[i][3]);
                                }
                            }
                            else
                            {
                                MessageBox.Show("Record Fail to Added");
                            }
                           cazoranConn.Close();
                        }
        }