C#

protected void Submit_click(object sender, EventArgs e)
       {
           // Create connection string variable. Modify the "Data Source"
           // parameter as appropriate for your environment.
           string path = @"C:\TEMP\ExcelSearchWebApp\OneWayContainers.xlsx";
           string connStr = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + path + ";Extended Properties=Excel 12.0;";

           // Create connection object by using the preceding connection string.
           OleDbConnection objConn = new OleDbConnection(connStr);

           // Open connection with the database.
           objConn.Open();

           // The code to follow uses a SQL SELECT command to display the data from the worksheet.

           // Create new OleDbCommand to return data from worksheet.
           OleDbCommand objCmdSelect = new OleDbCommand("SELECT * FROM MyRange", objConn);

           // Create new OleDbDataAdapter that is used to build a DataSet
           // based on the preceding SQL SELECT statement.
           OleDbDataAdapter objAdapter1 = new OleDbDataAdapter();

           // Pass the Select command to the adapter.
           objAdapter1.SelectCommand = objCmdSelect;

           // Create new DataSet to hold information from the worksheet.
           DataSet objDataset1 = new DataSet();

           // Fill the DataSet with the information from the worksheet.
           objAdapter1.Fill(objDataset1, "XLData");

           string strExcelContainerInfo;
           string strContainerInfoText= Convert.ToString(txtCntrInfo.Text).ToUpper();


           if (objDataset1.Tables[0].Rows.Count > 0)
           {
               for (int i = 0; i < objDataset1.Tables[0].Rows.Count; i++)
               {
                   strExcelContainerInfo = Convert.ToString(objDataset1.Tables[0].Rows[i]["OneWayContainers"].ToString());       //fetch Name clm from db

                   if (strContainerInfoText == strExcelContainerInfo )
                   {
                       ScriptManager.RegisterStartupScript(this, this.GetType(),"alert","alert('OneWayContainer');window.location ='RedirectPage.aspx';",true);

                   }
                   else
                   {
                       //Submit form logic;
                   }
               }
           }
           // Clean up objects.
           objConn.Close();
       }

<form id="form1" runat="server">
    <div>
        <table class="style1">
            <tr>
                <td>
                    <table>
                        <tr>
                            <td>
                                <asp:Label ID="Label1" runat="server" Text="ContainerInfo: "></asp:Label>
                            </td>
                            <td>
                                <asp:TextBox ID="txtCntrInfo" runat="server"></asp:TextBox>
                            </td>
                        </tr>
                        <tr>
                            <td colspan="2" align="center">
                                <asp:Button ID="Button1" runat="server" Text="Submit" onclick="Submit_click" />
                            </td>
                        </tr>
                    </table>
                </td>
            </tr>
        </table>
    </div>
    </form>

form.Icon = Properties.Resources.mainIcon;