ASP.NET

if (_fileexten == ".csv")
            {
                string str = Path.GetFileName(_filename);
                OdbcConnection conn = new OdbcConnection("Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq=" + _fpath + "\\;Extensions=asc,csv,tab,txt;Persist Security Info=False");
                conn.Open();

                string sql_select = "select * from [" + str + "]";
                OdbcDataAdapter myCommand = new OdbcDataAdapter(sql_select, conn);

                myCommand.Fill(myDataSet, "csv");
                dt = myDataSet.Tables[0];

                conn.Close();
                myCommand.Dispose();

            }

<asp:UpdatePanel ID="UpdatePanel2" runat="server">
            <ContentTemplate>
        <asp:DropDownList ID="CompanyList"  runat="server"
            Height="22px" Width="155px" AutoPostBack="True" AppendDataBoundItems="true"
                    onselectedindexchanged="CompanyList_SelectedIndexChanged" >
                    <asp:ListItem Selected ="True" Text="--Please Select--"></asp:ListItem>
        </asp:DropDownList>
                <br />
         <asp:DropDownList ID="ProjectList" runat="server" AppendDataBoundItems="true"
            Height="23px" Width="155px" >
            <asp:ListItem Selected ="True" Text="--Please Select--"></asp:ListItem>
        </asp:DropDownList>
         </ContentTemplate>
        </asp:UpdatePanel>
         <asp:UpdateProgress ID="UpdateProgress2" AssociatedUpdatePanelID="UpdatePanel2" runat="server" >
        <ProgressTemplate>
        <span class="ProgressBar">
        Data Loading. Please Wait....</span></ProgressTemplate>
        </asp:UpdateProgress>