ASP.NET

<asp:ListView ID="ListView1" runat="server"
    DataSourceID="LinqDataSource1"
    onselectedindexchanged="ListView1_SelectedIndexChanged"
    OnItemInserting="ListView1_ItemInserting" DataKeyNames="Id">

    <EditItemTemplate>
        <tr style="">
            <td>
                <asp:Button ID="UpdateButton" runat="server" CommandName="Update"
                    Text="Update" />
                <asp:Button ID="CancelButton" runat="server" CommandName="Cancel"
                    Text="Cancel" onclick="OperationCanceled" onclientclick="return confirm('Are You Sure You Wish To Cancel? You will Lose Any Changes Made.');"  />
            </td>



            <td>
                <asp:LinkButton ID="lnkSelect" runat="server" CommandName="Select"
                    Text="Select" />
            </td>
            <td>
                <asp:TextBox ID="LongDescriptionTextBox2" runat="server"
                    Text='<%# Bind("LongDescription") %>' />
            </td>
            <td>
                <asp:TextBox ID="DescriptionTextBox" runat="server"
                    Text='<%# Bind("Description") %>' />
            </td>
        </tr>
    </EditItemTemplate>
    <EmptyDataTemplate>
        <table runat="server" style="">
            <tr>
                <td>
                    No data was returned.</td>
            </tr>
        </table>
    </EmptyDataTemplate>
    <InsertItemTemplate>
        <tr style="background-color: #336699; color: White;">
            <td>
                <asp:Button ID="InsertButton" runat="server" CommandName="Insert"
                    Text="Insert" />
                <asp:Button ID="CancelButton2" runat="server" CommandName="Cancel"
                    Text="Clear" />
            </td>
            <td>
                <asp:LinkButton ID="lnkSelect2" runat="server" CommandName="Select"
                    Text="Select" />
            </td>
            <td>
                <asp:TextBox ID="LongDescriptionTextBox3" runat="server"
                    Text='<%# Bind("LongDescription") %>' />
            </td>
            <td>
                <asp:TextBox ID="DescriptionTextBox3" runat="server"
                    Text='<%# Bind("Description") %>' />
            </td>
        </tr>
    </InsertItemTemplate>
    <ItemTemplate>
        <tr style="">
            <td>
                <asp:LinkButton ID="lnkSelect3" runat="server" CommandName="Select"
                    Text="Select" />

                <asp:LinkButton ID="LinkButtonEditQuiz" runat="server" CommandName="Edit"
                    Text="Edit" />
            </td>


                         <td>      <asp:Button ID="DeleteButton3"
                         Text="Delete"
                         OnClick="DeleteButton_Click"
                         runat="server" />
                         <br /></td>
            <td>
                <asp:Label ID="LongDescriptionLabel2" runat="server"
                    Text='<%# Eval("LongDescription") %>' />
            </td>
            <td>
                <asp:Label ID="DescriptionLabel2" runat="server"
                    Text='<%# Eval("Description") %>' />
            </td>
        </tr>
    </ItemTemplate>
    <LayoutTemplate>
        <table runat="server" cellpadding="3" cellspacing="0" rules="all"
            style="border: solid 2px #336699;">
            <tr runat="server">
                <td runat="server">
                    <table ID="itemPlaceholderContainer" runat="server" border="0" style="">
                        <tr runat="server" style="background-color: #336699; color: White;">
                            <th ID="Th1" runat="server">
                                Select</th>

                            <th  runat="server">
                                Delete</th>

                            <th runat="server">
                                LongDescription</th>
                            <th runat="server">
                                Description</th>
                        </tr>
                        <tr ID="itemPlaceholder" runat="server">
                        </tr>
                    </table>
                </td>
            </tr>
            <tr runat="server">
                <td runat="server" style="">
                </td>
            </tr>
        </table>
    </LayoutTemplate>
    <SelectedItemTemplate>
        <tr style="background-color: #336699; color: White;">

            <td>
                <asp:LinkButton ID="lnkSelect4" runat="server" CommandName="Select"
                    ForeColor="White" Text="Select" />

                <asp:LinkButton ID="LinkButtonEditQuiz2" runat="server" CommandName="Edit"
                    ForeColor="White" Text="Edit" />
            </td>

                        <td>      <asp:Button ID="DeleteButton2"
                         Text="Delete"
                         OnClick="DeleteButton_Click"
                         runat="server" />
                         <br /></td>

            <td>
                <asp:Label ID="LongDescriptionLabel" runat="server"
                    Text='<%# Eval("LongDescription") %>' />
            </td>
            <td>
                <asp:Label ID="DescriptionLabel" runat="server"
                    Text='<%# Eval("Description") %>' />
            </td>
        </tr>
    </SelectedItemTemplate>
</asp:ListView>
<asp:LinqDataSource ID="LinqDataSource1" runat="server"
    ContextTypeName="HW4.Model1Container" EntityTypeName="" TableName="Quizs"
    EnableUpdate="True"
    EnableInsert="True">
</asp:LinqDataSource>

<%Dim DeckName, DeckNo
DeckName = Request.QueryString("DeckName")
DeckNo = Request.QueryString("DeckNo")
If Request.QueryString("Change") = "Y" then %>
<script language="VBScript">
Msgbox "Would you like to also update UMID Deck Rev Number?", vbYesNo 

'And if the user selects Yes, then Response.Redirect("UMID_EditDeck.asp?DeckNum=" & DeckNo)
</script>
<% End If %>

protected void ExcelConnection(string filename)
{
	string xConnStr = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + Server.MapPath(Session["foldername"].ToString() + filename) + ";" + "Extended Properties=Excel 8.0;";
    // create your excel connection object using the connection string
    OleDbConnection objXConn = new OleDbConnection(xConnStr);
    // Create a new Adapter
    OleDbDataAdapter objDataAdapter = new OleDbDataAdapter();   
    string query;
    grdViewUserIDs.DataSource = "";
    try
    {
        objXConn.Open();
        query = "select * from [Sheet1$]";
        OleDbCommand objCommand = new OleDbCommand(query, objXConn);
        objDataAdapter.SelectCommand = objCommand;
        // Create a DataSet
        DataSet objDataSet = new DataSet();
        // Populate the DataSet with the spreadsheet worksheet data
        objDataAdapter.Fill(objDataSet);
        // Bind the data to the GridView
        grdViewUserIDs.DataSource = objDataSet.Tables[0].DefaultView;
        grdViewUserIDs.DataBind();
        query = "";
        objDataSet.Clear();
    }
    catch (Exception ex)
    {
        string t;
        t = ex.ToString();                    
    }
    finally
    { 
		objXConn.Close();
	}         
}