Grid View - disconnected datasource

[sspost]

i used Grid view and here is the code i wrote:

Protected Sub ButtonAddFile_Click(ByVal sender As Object, ByVal e As EventArgs)
Dim gv As New GridView
        gv.Style.Add("position", "absolute")
        gv.Style.Add("left", "575px")
        gv.Style.Add("top", "220px")
        gv.EnableViewState = False
        form1.Controls.Add(gv)
        gv.DataSource = GetDataTable()
        gv.DataBind()
        Dim lbl As New Label
        lbl.Style.Add("position", "absolute")
        lbl.Style.Add("left", "575px")
        lbl.Style.Add("top", "20px")
End Sub
Private Function GetDataTable() As DataTable 
    Dim doc As New DataTable("Document")
    Dim id As New DataColumn("Document") 
 
    id.DataType = GetType(String)
    id.Unique = True
    id.AllowDBNull = False
    id.Caption = "Document"
 
    doc.Columns.Add(id)
 
    Dim filing As New DataColumn("Type") 
    filing.DataType = GetType(String)
    'filing.MaxLength = 35
    filing.AllowDBNull = False
 
    doc.Columns.Add(filing)
    doc.PrimaryKey = New DataColumn() {id} 
    'add data to data table
 
    Dim newdoc As DataRow = doc.NewRow() 
    newdoc("Document") = FileToUpload.PostedFile.FileName
    newdoc("Type") = listDocType.SelectedValue
 
    doc.Rows.Add(newdoc)
    Return doc 
End Function
 

1. But it adds only one row everytime i click the AddFile button and overrides the previous row, it doesnt add on after another, whats going wrong here?
2. Also If I have to add a delete button of GridView , what code should i write so that it deletes that particular row every time i click delete

[Frinavale]

Hi Sspost,

I have moved your question to the .NET Forums section. The .NET Articles section is reserved for "how-tos" and other informational articles and is not meant for your questions. You will receive help with your problems in the .NET Forums section so please post any further questions here (Blue menu: Forums->.NET)

Thanks,

-Moderator

[Plater]

You need to be adding your rows to your dataobject, everytime you change the datasource property it wipes out all your old values and re-creates from the new ones.
Maintain a DataTable object and add rows to that.

[sspost]

[Ok , I used dataobject and can add rows one after another, but i added delete button but still cant get the delete to delete the rows from gridview ...here is the code i wrote:

<asp:datagrid id="DataGrid1" runat="server" Width="100%" AutoGenerateColumns="False">
                 <AlternatingItemStyle BackColor="beige"></AlternatingItemStyle>
                 <ItemStyle Font-Size="Smaller" HorizontalAlign="Center" BackColor="LightGray"></ItemStyle>
                 <HeaderStyle Font-Size="Smaller" Font-Bold="True" HorizontalAlign="Center" ForeColor="White"
                     BackColor="DimGray"></HeaderStyle>
                   <Columns>
                      <asp:BoundColumn DataField="Document" HeaderText="Document"></asp:BoundColumn>
                     <asp:BoundColumn DataField="Document Title" HeaderText="Document Title"></asp:BoundColumn>
                     <asp:ButtonColumn commandname="Delete" headertext="Delete" Text="Delete"></asp:ButtonColumn>
                   </Columns>
           </asp:datagrid>
 

here is the code:

Protected Sub ButtonDeleteFile_Click(ByVal sender As Object, ByVal e As DataGridCommandEventArgs) Handles DataGrid1.ItemCommand
        If Not e.CommandName <> "Delete" Then
            Return
 
            Dim sessionObject As Object = Session("docDataTable")
 
            If Not (sessionObject Is Nothing) Then
                Dim idValue As String = e.Item.Cells(0).Text
 
                Dim doc As DataTable = CType(sessionObject, DataTable)
                Dim sqlFilter As String = "Document = '" + idValue + "'"
                Dim filteredArray As DataRow() = doc.Select(sqlFilter)
                If filteredArray.Length > 0 Then
                    Dim filteredRow As DataRow = filteredArray(0)
                    doc.Rows.Remove(filteredRow)
                End If
            End If
        End If
 
    End Sub
 

But this doesnt even get to the if stmt and i dont know why VisualStudio is says "unused local variable" for each and every varaible used here.

[Plater]

Do you have more then one function handling that event?

[sspost]

No I dont
Now I am getting this :
at the following line:

doc.Rows.Remove(filteredRow)

it gives me exception: System.IndexOutOfRangeException - The given DataRow is not in the current DataRowCollection. , even though the search row is the primary key one........does anyone has any idea why its giving it? even though the comparing row is the correct one.....