title: GridView DevExpress check if any cell is null
body: <p><img src="https://i.stack.imgur.com/hGSq1.jpg" alt="enter image description here"></p>
  
  <p>I need to check if a cell is empty and store a message to then create a new cell in every row that contains all the messages</p>
  
  <p>But I don't know know how to work with DevExpress can someone help with my code</p>
  
  <pre><code>    string Name = "First Name";
      string FName = "Father Name";
      string LName = "Last Name";
      string EmpCode = "Employee Code";
      string Tax = "Tax#";
      string SocSec = "Soc.Sec#";
      string EmpType = "Employment Type";
      string DepCode = "Department Code";
      string DepDesc = "Department Description";
      private void simpleButton1_Click(object sender, System.EventArgs e)
      {
          try
          {
              OleDbConnection con = new OleDbConnection();
              con.ConnectionString = "Provider=Microsoft.Ace.OLEDB.12.0;Data Source=C:\\Users\\pc\\Documents\\Emp.xlsx;Extended Properties=\"Excel 12.0;HDR=Yes\"";
  
              con.Open();
              DataTable dtSchema;
              dtSchema = con.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] { null, null, null, "TABLE" });
              OleDbCommand Command = new OleDbCommand ("select * FROM [" + dtSchema.Rows[0]["TABLE_NAME"].ToString() + "]", con);
              OleDbDataAdapter da = new OleDbDataAdapter(Command);
              DataSet ds = new DataSet ();
              da.Fill(ds);
              dataGrid1.DataSource = ds.Tables[0];
          }
          catch (Exception ex)
          {
              MessageBox.Show(ex.Message);
          }
  </code></pre>
  
  <p>This loop isn't giving me the right message about empty cells I think it's not right what i wrote maybe there's another better way...</p>
  
  <pre><code>        for (int rows = 0 ; rows &lt; gridView3.RowCount ; rows ++)
          {
              string[] msg = new string[50];
  
              if ((gridView3.GetRowCellValue(rows, gridView3.Columns["LName"])) == null)
              {
                  msg[rows] = "name missing";
              }
          }
  </code></pre>