[asemshahen5]

تفضل هذا الكود بعد التعديلات التي طلبتها :

PHP كود :

       private void dgvEmployee_CellValueChanged(object sender, DataGridViewCellEventArgs e)
        {
            if (dgvEmployee.CurrentRow != null)
            {
                using (SqlConnection sqlCon = new SqlConnection(@"server=.; Database=Accounts; Integrated Security=true"))
                {
                    DataGridViewRow dgvRow = dgvEmployee.CurrentRow;
                    SqlCommand sqlCmd = new SqlCommand();
                    sqlCmd.CommandType = CommandType.Text;
                    string SqlStr = string.Empty;
                    if (dgvRow.Cells[0].Value == DBNull.Value)//Insert
                    {
                        SqlStr = "INSERT INTO Employee(Name,PositionID,Office,Age)VALUES (@Name,@PositionID,@Office,@Age)";
                        sqlCmd = new SqlCommand(SqlStr, sqlCon);
                    }
                    else //update
                    {
                        SqlStr = "UPDATE Employee SET Name = @Name,PositionID = @PositionID,Office = @Office,Age = @Age WHERE EmployeeID = @EmployeeID";
                        sqlCmd = new SqlCommand(SqlStr, sqlCon);
                        sqlCmd.Parameters.AddWithValue("@EmployeeID", Convert.ToInt32(dgvRow.Cells[0].Value));
                    }
                    sqlCmd.Parameters.AddWithValue("@Name", dgvRow.Cells[1].Value == DBNull.Value ? "" : dgvRow.Cells[1].Value.ToString());
                    sqlCmd.Parameters.AddWithValue("@PositionID", Convert.ToInt32(dgvRow.Cells[2].Value == DBNull.Value ? "0" : dgvRow.Cells[2].Value.ToString()));
                    sqlCmd.Parameters.AddWithValue("@Office", dgvRow.Cells[3].Value == DBNull.Value ? "" : dgvRow.Cells[3].Value.ToString());
                    sqlCmd.Parameters.AddWithValue("@Age", Convert.ToInt32(dgvRow.Cells[4].Value == DBNull.Value ? "0" : dgvRow.Cells[4].Value.ToString()));
                    sqlCon.Open();
                    sqlCmd.ExecuteNonQuery();
                    sqlCon.Close();
                    PopulateDataGridView();
                }

            }
        }
        private void PopulateDataGridView() 
        {
            using (SqlConnection sqlCon = new SqlConnection(@"server=.; Database=Accounts; Integrated Security=true"))
            {
                SqlDataAdapter sqlAdp = new SqlDataAdapter("Select * From Employee", sqlCon);
                DataTable dt = new DataTable();
                sqlAdp.Fill(dt);
                dgvEmployee.DataSource = dt;
            }
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            using (SqlConnection sqlCon = new SqlConnection(@"server=.; Database=Accounts; Integrated Security=true"))
            {
                SqlDataAdapter sqlAdp = new SqlDataAdapter("Select * From Employee", sqlCon);
                DataTable dt = new DataTable();
                sqlAdp.Fill(dt);
                dgvEmployee.DataSource = dt;
            }

        }