ASP.NET

<ig:WebDataGrid ID="grdUsers" runat="server" Height="175px" Width="650px" AutoGenerateColumns="False"<br />
                            BorderWidth="2px" OnLoad="grdUsers_Load" DataKeyFields="User_ID" OnRowsDeleting="grdUsers_RowDeleting"<br />
                            OnCellSelectionChanged="grdUsers_CellSelectionChanged" OnItemCommand="grdUsers_ItemCommand"<br />
                            OnRowUpdating="grdUsers_RowUpdating" EnableAjax="False" Enabled="true" <br />
                            onprerender="grdUsers_PreRender"><br />
                            <EditorProviders><br />
                                <ig:WebTextEditProvider ID="BasicTextProvider" /><br />
                                <ig:WebNumericEditProvider ID="numPhoneNumber" /><br />
                                <ig:DropDownProvider ID="drpRoles"><br />
                                    <EditorControl ID="editorRoles" runat="server" DisplayMode="DropDownList" TextField="VALUE"<br />
                                        ValueField="ID" Width="200px" DataKeyFields="User_ID"><br />
                                        <DropDownItemBinding TextField="VALUE" ValueField="ID" /><br />
                                    </EditorControl><br />
                                </ig:DropDownProvider><br />
                            </EditorProviders><br />
                            <Columns><br />
                                <ig:BoundDataField DataFieldName="Role_Name" Header-Text="User Role" Key="keyRoleName"><br />
                                    <Header Text="User Role"></Header><br />
                                </ig:BoundDataField><br />
                                <ig:BoundDataField DataFieldName="First_Name" Header-Text="First Name" Key="keyFirstName"><br />
                                    <Header Text="First Name"></Header><br />
                                </ig:BoundDataField><br />
                                <ig:BoundDataField DataFieldName="Last_Name" Header-Text="Last Name" Key="keyLastName"><br />
                                    <Header Text="Last Name"></Header><br />
                                </ig:BoundDataField><br />
                                <ig:BoundDataField DataFieldName="User_Email" Header-Text="Email Address" Key="keyUserEmail"><br />
                                    <Header Text="Email Address"></Header><br />
                                </ig:BoundDataField><br />
                                <ig:BoundDataField DataFieldName="Mobile_Number" Header-Text="Mobile Number" Key="keyMobileNumber"><br />
                                    <Header Text="Mobile Number"></Header><br />
                                </ig:BoundDataField><br />
                                <ig:TemplateDataField Key="UpdateItem" Width="60px"><br />
                                    <ItemTemplate><br />
                                        <asp:Button runat="server" ID="btnUpdate" Text="Update" CommandName="UpdateID" OnClick="btnUpdate_Click1"<br />
                                            UseSubmitBehavior="false"/><br />
                                    </ItemTemplate><br />
                                </ig:TemplateDataField><br />
                                <ig:TemplateDataField Key="DeleteItem" Width="60px"><br />
                                    <ItemTemplate><br />
                                        <asp:Button runat="server" ID="btnDelete" Text="Delete" OnClientClick="javascript:alert('The user is deleted.');"<br />
                                            UseSubmitBehavior="false"/><br />
                                    </ItemTemplate><br />
                                </ig:TemplateDataField><br />
                            </Columns><br />
                            <Behaviors><br />
                                <ig:Activation /><br />
                                <ig:Selection RowSelectType="Multiple" CellClickAction="Row" /><br />
                                <ig:EditingCore AutoCRUD="True"><br />
                                    <Behaviors><br />
                                        <ig:RowDeleting Enabled="true"></ig:RowDeleting><br />
                                        <ig:CellEditing Enabled="true"><br />
                                            <EditModeActions EnableF2="true" EnableOnActive="true" MouseClick="Single" /><br />
                                            <ColumnSettings><br />
                                                <ig:EditingColumnSetting ColumnKey="keyRoleName" EditorID="drpRoles" /><br />
                                                <ig:EditingColumnSetting ColumnKey="keyFirstName" EditorID="BasicTextProvider" /><br />
                                                <ig:EditingColumnSetting ColumnKey="keyLastName" EditorID="BasicTextProvider" /><br />
                                                <ig:EditingColumnSetting ColumnKey="keyMobileNumber" EditorID="BasicTextProvider" /><br />
                                            </ColumnSettings><br />
                                        </ig:CellEditing><br />
                                    </Behaviors><br />
                                </ig:EditingCore><br />
                            </Behaviors><br />
                        </ig:WebDataGrid>

private void insdata()
       {
           try
           {
               string filename = "~\\Documents\\" + ViewState["MissionCat"];
               string excelConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath(filename) + "; Extended Properties=\"Excel 8.0;HDR=YES;IMEX=1;\"";

               // Create Connection to Excel Workbook
               using (OleDbConnection connection = new OleDbConnection(excelConnectionString))
               {
                   connection.Open();

                   OleDbCommand command = new OleDbCommand("Select [Mission] ,[Civilian] ,[Military] ,[Police]" +
                    ",[Unknown] ,[Non-UN] ,[Total] FROM [Sheet1$]", connection);

                   string sqlConnectionString = ConfigurationManager.ConnectionStrings["conn"].ToString();

                   //truncate the table before inserting new data.
                   SqlConnection cnntrunc = new SqlConnection(sqlConnectionString);
                   SqlCommand truntbleBU = new SqlCommand();
                   truntbleBU.Connection = cnntrunc;
                   string trunsqlBU = null;
                   trunsqlBU = "TRUNCATE TABLE MissionCatReport";
                   truntbleBU.CommandText = trunsqlBU;
                   cnntrunc.Open();
                   truntbleBU.ExecuteNonQuery();
                   cnntrunc.Close();

                   // Create DbDataReader to Data Worksheet
                   using (DbDataReader dr = command.ExecuteReader())
                   {
                       // Bulk Copy to SQL Server
                       using (SqlBulkCopy bulkCopy = new SqlBulkCopy(sqlConnectionString))
                       {
                           bulkCopy.DestinationTableName = "MissionCatReport";
                           bulkCopy.WriteToServer(dr);
                       }
                   }
               }
           }
           catch (Exception ex)
           {
               throw ex;
           }
       }