Prompt message if Excel column has some value in asp net c

Question

I have an option where users can submit Excel files. Therefore, I want to make sure that the Replacement SAP ID cannot be empty if the column Is Replacement (Y/N) has values of Y. When the column is empty, an alert message is displayed. The image for the same is seen below.

System.Data.OleDb.OleDbConnection connExcel = new System.Data.OleDb.OleDbConnection(conStr);
            System.Data.OleDb.OleDbCommand cmdExcel = new System.Data.OleDb.OleDbCommand();
            System.Data.OleDb.OleDbDataAdapter oda = new System.Data.OleDb.OleDbDataAdapter();
            cmdExcel.Connection = connExcel;
            connExcel.Open();

            System.Data.DataTable dtExcelSchema = connExcel.GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Tables, null);
            System.Data.DataTable dtExcelColumnsTable = connExcel.GetSchema("Columns");
            string SheetName = dtExcelSchema.Rows[0]["TABLE_NAME"].ToString().Replace('\'', ' ').Trim();  //nadeem
            cmdExcel.CommandText = "SELECT * From [" + SheetName + "]";
            oda.SelectCommand = cmdExcel;
            oda.Fill(dtExcelRows);

I take all columns in dtExcelRows. 

Answer 1

I believe it is wise to use your business exception and to raise the exception when the replacement SAP ID is empty.

foreach(var item in dtExcelRows["ColumnName"]){
    if(string.IsEmptyOrNull(item){
           throw new HttpException((int)HttpStatusCode.BadRequest, "SAP ID is Empty.");
      }
}

I'm only writing some pseudo-Code. Regarding reading data from a column, I'm unsure.

Additionally, you can send a client alert message if you handle the BadRequest exception in the front end.