[asemshahen5]

أضف الكود التالي :

PHP كود :

       private void cmbaccountnameIndexChanged()
        {
            if (cmbaccountname.Text != "System.Data.DataRowView" && cmbprojectnumber.Text != "")
            {
                string SqlStr = "SELECT * FROM CHEQUES WHERE S_N in (SELECT MAX(S_N) AS S_N FROM CHEQUES AS CHEQUES_1 WHERE Beneficiary_Name = N'" + cmbaccountname.Text + "' AND Project_Number = " + cmbprojectnumber.Text + ")";
                DataTable Dtx = new DataTable();
                SqlDataAdapter SqlAdapter = new SqlDataAdapter(SqlStr, sqlcon);
                SqlAdapter.Fill(Dtx);
                textBox5.Clear();
                foreach (DataRow item in Dtx.Rows)
                {
                    if (item["Beneficiary_Name"].ToString() == cmbaccountname.Text && item["Project_Number"].ToString() == cmbprojectnumber.Text)
                    {
                        textBox5.Text = item["Description"].ToString();
                    }
                }
                int k = 0;
                int n = 0;
                if (textBox5.TextLength > 0)
                {
                    string newString = Regex.Replace(textBox5.Text, "[^.0-9]", "");
                    k = int.Parse(newString);
                }
                n = k;
                n += 1;
                textBox5.Text = textBox5.Text.Replace(k.ToString(), n.ToString());
                if (textBox5.Text.Length == 0)
                {
                    textBox5.Text = "payment 1";
                }
            }
        } 


عدل كود cmbaccountname_SelectedIndexChanged ليصبح هكذا :

PHP كود :

       private void cmbaccountname_SelectedIndexChanged(object sender, EventArgs e)
        {
            cmbaccountnameIndexChanged();
        } 


عدل كود زر الحفظ ليصبح هكذا :

PHP كود :

       private void button1_Click(object sender, EventArgs e)
        {
            if (string.IsNullOrWhiteSpace(textBox2.Text))
            {
                try
                {
                    dat.Add_Cheque(Convert.ToInt32(textBox1.Text), cmbaccountname.Text, textBox3.Text, textBox4.Text, textBox5.Text, Convert.ToInt32(cmbprojectnumber.Text), textBox7.Text);
                    MessageBox.Show("Add Successful", "Add", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    this.dataGridView1.DataSource = dat.Get_Cheque_Data();
                    cmbaccountnameIndexChanged();
                }
                catch
                {
                    return;
                }
            }
            else
            {
                try
                {
                    dat.Add_Cheque(Convert.ToInt32(textBox1.Text), textBox2.Text, textBox3.Text, textBox4.Text, textBox5.Text, Convert.ToInt32(cmbprojectnumber.Text), textBox7.Text);
                    MessageBox.Show("Add Successful", "Add", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    this.dataGridView1.DataSource = dat.Get_Cheque_Data();
                    cmbaccountnameIndexChanged();
                }
                catch
                {
                    return;
                }
            }
        } 


و بكدا تكون مشكلتك انحلت باذن الله .