populating a datagrid

29 Mar 2005 3:21 PM

viktor9990

I have a datagrid with 2 item templates inside a hyperlink and a label (which
will show the file name and creation date of files which resides on a folder
on the server. I'm using a procedure (GetScannedFiles()) to loop and get the
required information from the folder but don't know how to show this info
inside my datagrid ( dynamically or from my aspx page). I appreciate any
help.
Look my code below.

Here is the code for( MyDatagrid.aspx):

<asp:datagrid id="DGFileScanned" runat="server" Autogeneratecolumns="false" >
<Columns>

<asp:TemplateColumn HeaderText="File Name">
<ItemTemplate>
<div>
<asp:hyperlink ForeColor="blue" Font-Size="10" id="FileName" runat="server" >
.....
</asp:hyperlink></div>
</ItemTemplate>
</asp:TemplateColumn>
<asp:TemplateColumn>
<ItemTemplate>
<div>
<asp:Label ID="FileDate" Visible="true" Text="...." Runat="server" />
</div>
</ItemTemplate>
</asp:TemplateColumn>
</Columns>
</asp:datagrid>

Here is the code behind for (Mydatagrid.aspx.vb)

Private Sub GetScannedFiles()
        'Name of the folder which holds the scanned TIFF files (agreements
images)
        Dim FolderPath As String =
Server.MapPath("/TrackerAggreement/admin/FilesTIFF/")
        Dim source As DirectoryInfo = New DirectoryInfo(FolderPath)

        'Get an array of all scanned TIFF files in the source direcotry
        Dim sourceFiles As FileInfo() = source.GetFiles("*.tiff")
        'Loop to get File Names and Creation Time of the TIFF files in the
source direcotry
        Dim i As Integer
        For i = 0 To i < (sourceFiles.Length)
            'Get the File Name of every scanned TIFF file
            Dim FileName As String = Path.GetFileName(sourceFiles(i).FullName)
            'Get the Creation Time of every scanned TIFF file
            Dim FileDate As String =
Path.GetFileName(sourceFiles(i).CreationTime)
            i = i + 1
        Next
    End Sub

29 Mar 2005 6:35 PM

Elton Wang

You can use a datatable to save FileName and FileDate in
it, and then bind the datagrid's data source with the
datatable. In the datagrid you can use a HyperLinkColumn
and a BoundColumn to show file name and file date.

HTH

Elton Wang
elton_w***@hotmail.com

>-----Original Message-----
>I have a datagrid with 2 item templates inside a

hyperlink and a label (which

>will show the file name and creation date of files which

resides on a folder

>on the server. I'm using a procedure (GetScannedFiles())

to loop and get the

>required information from the folder but don't know how

to show this info

>inside my datagrid ( dynamically or from my aspx page).

I appreciate any

>help.
>Look my code below.
>
>Here is the code for( MyDatagrid.aspx):
>
><asp:datagrid id="DGFileScanned" runat="server"

Autogeneratecolumns="false" >

><Columns>
>
><asp:TemplateColumn HeaderText="File Name">
><ItemTemplate>
><div>
><asp:hyperlink ForeColor="blue" Font-Size="10"

id="FileName" runat="server" >

> .....
></asp:hyperlink></div>
></ItemTemplate>
></asp:TemplateColumn>
><asp:TemplateColumn>
><ItemTemplate>
><div>
><asp:Label ID="FileDate" Visible="true" Text="...."

Runat="server" />
Show quoteHide quote

></div>
></ItemTemplate>
></asp:TemplateColumn>
></Columns>
></asp:datagrid>
>
>Here is the code behind for (Mydatagrid.aspx.vb)
>
> Private Sub GetScannedFiles()
>        'Name of the folder which holds the scanned TIFF
files (agreements
>images)
>        Dim FolderPath As String =
>Server.MapPath("/TrackerAggreement/admin/FilesTIFF/")
>        Dim source As DirectoryInfo = New DirectoryInfo
(FolderPath)
>
>        'Get an array of all scanned TIFF files in the

source direcotry

> Dim sourceFiles As FileInfo() = source.GetFiles
("*.tiff")
> 'Loop to get File Names and Creation Time of the

TIFF files in the

>source direcotry
>        Dim i As Integer
>        For i = 0 To i < (sourceFiles.Length)
>            'Get the File Name of every scanned TIFF file
>            Dim FileName As String = Path.GetFileName

(sourceFiles(i).FullName)
Show quoteHide quote

>            'Get the Creation Time of every scanned TIFF
file
>            Dim FileDate As String =
>Path.GetFileName(sourceFiles(i).CreationTime)
>            i = i + 1
>        Next
>    End Sub
>.
>

30 Mar 2005 6:59 AM

viktor9990

In my solution I need to populate the datagrid without using the database. Is
there any solution?Thanks

Show quoteHide quote

"Elton Wang" wrote:

> You can use a datatable to save FileName and FileDate in
> it, and then bind the datagrid's data source with the
> datatable. In the datagrid you can use a HyperLinkColumn
> and a BoundColumn to show file name and file date.
>
> HTH
>
> Elton Wang
> elton_w***@hotmail.com
>
> >-----Original Message-----
> >I have a datagrid with 2 item templates inside a
> hyperlink and a label (which
> >will show the file name and creation date of files which
> resides on a folder
> >on the server. I'm using a procedure (GetScannedFiles())
> to loop and get the
> >required information from the folder but don't know how
> to show this info
> >inside my datagrid ( dynamically or from my aspx page).
> I appreciate any
> >help.
> >Look my code below.
> >
> >Here is the code for( MyDatagrid.aspx):
> >
> ><asp:datagrid id="DGFileScanned" runat="server"
> Autogeneratecolumns="false" >
> ><Columns>
> >
> ><asp:TemplateColumn HeaderText="File Name">
> ><ItemTemplate>
> ><div>
> ><asp:hyperlink ForeColor="blue" Font-Size="10"
> id="FileName" runat="server" >
> > .....
> ></asp:hyperlink></div>
> ></ItemTemplate>
> ></asp:TemplateColumn>
> ><asp:TemplateColumn>
> ><ItemTemplate>
> ><div>
> ><asp:Label ID="FileDate" Visible="true" Text="...."
> Runat="server" />
> ></div>
> ></ItemTemplate>
> ></asp:TemplateColumn>
> ></Columns>
> ></asp:datagrid>
> >
> >Here is the code behind for (Mydatagrid.aspx.vb)
> >
> > Private Sub GetScannedFiles()
> >        'Name of the folder which holds the scanned TIFF
> files (agreements
> >images)
> >        Dim FolderPath As String =
> >Server.MapPath("/TrackerAggreement/admin/FilesTIFF/")
> >        Dim source As DirectoryInfo = New DirectoryInfo
> (FolderPath)
> >
> >        'Get an array of all scanned TIFF files in the
> source direcotry
> >        Dim sourceFiles As FileInfo() = source.GetFiles
> ("*.tiff")
> >        'Loop to get File Names and Creation Time of the
> TIFF files in the
> >source direcotry
> >        Dim i As Integer
> >        For i = 0 To i < (sourceFiles.Length)
> >            'Get the File Name of every scanned TIFF file
> >            Dim FileName As String = Path.GetFileName
> (sourceFiles(i).FullName)
> >            'Get the Creation Time of every scanned TIFF
> file
> >            Dim FileDate As String =
> >Path.GetFileName(sourceFiles(i).CreationTime)
> >            i = i + 1
> >        Next
> >    End Sub
> >.
> >
>

30 Mar 2005 3:07 PM

Elton Wang

In addition from database, the DataTable can also be
populated from other data source. Following code snippet
shows how to fill datatable from a loop:

DataTable myTable = new DataTable();
Dim myColumn As DataColumn = New DataColumn
myColumn.DataType = System.Type.GetType("System.String")
myColumn.ColumnName = "FileName"
myTable.Columns.Add(myColumn)
myColumn New DataColumn
myColumn.DataType = System.Type.GetType("System.String")
myColumn.ColumnName = "FileDate"
myTable.Columns.Add(myColumn)
Dim row As DataRow
For i As Integer = 0 To sourceFiles.Length - 1
    'Get the File Name of every scanned TIFF file
    Dim FileName As String = Path.GetFileName(sourceFiles
(i).FullName)
    'Get the Creation Time of every scanned TIFF file
    Dim FileDate As String = Path.GetFileName(sourceFiles
(i).CreationTime)
        ' filling data to datatable
    row = myTable.NewRow()
    row("FileName")    = FileName
    row("FileDate")    = FileDate
    myTable.Rows.Add(row)
Next

HTH

Elton Wang

>-----Original Message-----
>In my solution I need to populate the datagrid without

using the database. Is
Show quoteHide quote

>there any solution?Thanks
>
>"Elton Wang" wrote:
>
>> You can use a datatable to save FileName and FileDate
in
>> it, and then bind the datagrid's data source with the
>> datatable. In the datagrid you can use a
HyperLinkColumn
>> and a BoundColumn to show file name and file date.
>>
>> HTH
>>
>> Elton Wang
>> elton_w***@hotmail.com
>>
>> >-----Original Message-----
>> >I have a datagrid with 2 item templates inside a
>> hyperlink and a label (which
>> >will show the file name and creation date of files
which
>> resides on a folder
>> >on the server. I'm using a procedure (GetScannedFiles
())
>> to loop and get the
>> >required information from the folder but don't know
how
>> to show this info
>> >inside my datagrid ( dynamically or from my aspx
page).
>> I appreciate any
>> >help.
>> >Look my code below.
>> >
>> >Here is the code for( MyDatagrid.aspx):
>> >
>> ><asp:datagrid id="DGFileScanned" runat="server"
>> Autogeneratecolumns="false" >
>> ><Columns>
>> >
>> ><asp:TemplateColumn HeaderText="File Name">
>> ><ItemTemplate>
>> ><div>
>> ><asp:hyperlink ForeColor="blue" Font-Size="10"
>> id="FileName" runat="server" >
>> > .....
>> ></asp:hyperlink></div>
>> ></ItemTemplate>
>> ></asp:TemplateColumn>
>> ><asp:TemplateColumn>
>> ><ItemTemplate>
>> ><div>
>> ><asp:Label ID="FileDate" Visible="true" Text="...."
>> Runat="server" />
>> ></div>
>> ></ItemTemplate>
>> ></asp:TemplateColumn>
>> ></Columns>
>> ></asp:datagrid>
>> >
>> >Here is the code behind for (Mydatagrid.aspx.vb)
>> >
>> > Private Sub GetScannedFiles()
>> >        'Name of the folder which holds the scanned
TIFF
>> files (agreements
>> >images)
>> >        Dim FolderPath As String =
>> >Server.MapPath("/TrackerAggreement/admin/FilesTIFF/")
>> >        Dim source As DirectoryInfo = New DirectoryInfo
>> (FolderPath)
>> >
>> >        'Get an array of all scanned TIFF files in the
>> source direcotry
>> >        Dim sourceFiles As FileInfo() = source.GetFiles
>> ("*.tiff")
>> >        'Loop to get File Names and Creation Time of
the
>> TIFF files in the
>> >source direcotry
>> >        Dim i As Integer
>> >        For i = 0 To i < (sourceFiles.Length)
>> >            'Get the File Name of every scanned TIFF
file
>> >            Dim FileName As String = Path.GetFileName
>> (sourceFiles(i).FullName)
>> >            'Get the Creation Time of every scanned
TIFF
>> file
>> >            Dim FileDate As String =
>> >Path.GetFileName(sourceFiles(i).CreationTime)
>> >            i = i + 1
>> >        Next
>> >    End Sub
>> >.
>> >
>>
>.
>

30 Mar 2005 1:16 PM

Ken Cox [Microsoft MVP]

Here's some code that populates a datagrid from file list. Perhaps it will
give you the idea?

Ken
Microsoft MVP [ASP.NET]
Toronto

    Private Sub Page_Load _
    (ByVal sender As System.Object, _
    ByVal e As System.EventArgs) Handles MyBase.Load
        'create file list
        Dim imagepath As String
        imagepath = Server.MapPath("")
        dgfiles.DataSource = _
        System.IO.Directory.GetFiles(imagepath)
        dgfiles.DataBind()

    End Sub

    Private Sub dgfiles_ItemDataBound _
    (ByVal sender As Object, _
    ByVal e As System.Web.UI.WebControls.DataGridItemEventArgs) _
    Handles dgfiles.ItemDataBound
        If e.Item.ItemType = ListItemType.Header Then
            e.Item.Cells(0).Text = "File Name"
            Exit Sub
        End If
        If e.Item.ItemType = ListItemType.AlternatingItem Or _
                e.Item.ItemType = ListItemType.Item Then
            Dim strFilename As String
            strFilename = System.IO.Path.GetFileName(e.Item.Cells(0).Text)
            e.Item.Cells(0).Text = strFilename
        End If
    End Sub

            <asp:datagrid id="dgfiles" runat="server"></asp:datagrid>

Show quoteHide quote

"viktor9990" <viktor9***@discussions.microsoft.com> wrote in message
news:779FDFF5-1A66-40CF-B3BF-8E355B33A0D2@microsoft.com...
>I have a datagrid with 2 item templates inside a hyperlink and a label
>(which
> will show the file name and creation date of files which resides on a
> folder
> on the server. I'm using a procedure (GetScannedFiles()) to loop and get
> the
> required information from the folder but don't know how to show this info
> inside my datagrid ( dynamically or from my aspx page). I appreciate any
> help.
> Look my code below.
>
> Here is the code for( MyDatagrid.aspx):
>
> <asp:datagrid id="DGFileScanned" runat="server"
> Autogeneratecolumns="false" >
> <Columns>
>
> <asp:TemplateColumn HeaderText="File Name">
> <ItemTemplate>
> <div>
> <asp:hyperlink ForeColor="blue" Font-Size="10" id="FileName"
> runat="server" >
> .....
> </asp:hyperlink></div>
> </ItemTemplate>
> </asp:TemplateColumn>
> <asp:TemplateColumn>
> <ItemTemplate>
> <div>
> <asp:Label ID="FileDate" Visible="true" Text="...." Runat="server" />
> </div>
> </ItemTemplate>
> </asp:TemplateColumn>
> </Columns>
> </asp:datagrid>
>
> Here is the code behind for (Mydatagrid.aspx.vb)
>
> Private Sub GetScannedFiles()
>        'Name of the folder which holds the scanned TIFF files (agreements
> images)
>        Dim FolderPath As String =
> Server.MapPath("/TrackerAggreement/admin/FilesTIFF/")
>        Dim source As DirectoryInfo = New DirectoryInfo(FolderPath)
>
>        'Get an array of all scanned TIFF files in the source direcotry
>        Dim sourceFiles As FileInfo() = source.GetFiles("*.tiff")
>        'Loop to get File Names and Creation Time of the TIFF files in the
> source direcotry
>        Dim i As Integer
>        For i = 0 To i < (sourceFiles.Length)
>            'Get the File Name of every scanned TIFF file
>            Dim FileName As String =
> Path.GetFileName(sourceFiles(i).FullName)
>            'Get the Creation Time of every scanned TIFF file
>            Dim FileDate As String =
> Path.GetFileName(sourceFiles(i).CreationTime)
>            i = i + 1
>        Next
>    End Sub

30 Mar 2005 3:51 PM

viktor9990

This has helped a lot but I still have difficulties in showing the embedded
radio buttons and linking the filename(which is embedded too) which must be a
link too in this datagrid. Thanks for further help.

Show quoteHide quote

"Ken Cox [Microsoft MVP]" wrote:

> Here's some code that populates a datagrid from file list. Perhaps it will
> give you the idea?
>
> Ken
> Microsoft MVP [ASP.NET]
> Toronto
>
>     Private Sub Page_Load _
>     (ByVal sender As System.Object, _
>     ByVal e As System.EventArgs) Handles MyBase.Load
>         'create file list
>         Dim imagepath As String
>         imagepath = Server.MapPath("")
>         dgfiles.DataSource = _
>         System.IO.Directory.GetFiles(imagepath)
>         dgfiles.DataBind()
>
>     End Sub
>
>     Private Sub dgfiles_ItemDataBound _
>     (ByVal sender As Object, _
>     ByVal e As System.Web.UI.WebControls.DataGridItemEventArgs) _
>     Handles dgfiles.ItemDataBound
>         If e.Item.ItemType = ListItemType.Header Then
>             e.Item.Cells(0).Text = "File Name"
>             Exit Sub
>         End If
>         If e.Item.ItemType = ListItemType.AlternatingItem Or _
>                 e.Item.ItemType = ListItemType.Item Then
>             Dim strFilename As String
>             strFilename = System.IO.Path.GetFileName(e.Item.Cells(0).Text)
>             e.Item.Cells(0).Text = strFilename
>         End If
>     End Sub
>
>
>             <asp:datagrid id="dgfiles" runat="server"></asp:datagrid>
>
>
>
> "viktor9990" <viktor9***@discussions.microsoft.com> wrote in message
> news:779FDFF5-1A66-40CF-B3BF-8E355B33A0D2@microsoft.com...
> >I have a datagrid with 2 item templates inside a hyperlink and a label
> >(which
> > will show the file name and creation date of files which resides on a
> > folder
> > on the server. I'm using a procedure (GetScannedFiles()) to loop and get
> > the
> > required information from the folder but don't know how to show this info
> > inside my datagrid ( dynamically or from my aspx page). I appreciate any
> > help.
> > Look my code below.
> >
> > Here is the code for( MyDatagrid.aspx):
> >
> > <asp:datagrid id="DGFileScanned" runat="server"
> > Autogeneratecolumns="false" >
> > <Columns>
> >
> > <asp:TemplateColumn HeaderText="File Name">
> > <ItemTemplate>
> > <div>
> > <asp:hyperlink ForeColor="blue" Font-Size="10" id="FileName"
> > runat="server" >
> > .....
> > </asp:hyperlink></div>
> > </ItemTemplate>
> > </asp:TemplateColumn>
> > <asp:TemplateColumn>
> > <ItemTemplate>
> > <div>
> > <asp:Label ID="FileDate" Visible="true" Text="...." Runat="server" />
> > </div>
> > </ItemTemplate>
> > </asp:TemplateColumn>
> > </Columns>
> > </asp:datagrid>
> >
> > Here is the code behind for (Mydatagrid.aspx.vb)
> >
> > Private Sub GetScannedFiles()
> >        'Name of the folder which holds the scanned TIFF files (agreements
> > images)
> >        Dim FolderPath As String =
> > Server.MapPath("/TrackerAggreement/admin/FilesTIFF/")
> >        Dim source As DirectoryInfo = New DirectoryInfo(FolderPath)
> >
> >        'Get an array of all scanned TIFF files in the source direcotry
> >        Dim sourceFiles As FileInfo() = source.GetFiles("*.tiff")
> >        'Loop to get File Names and Creation Time of the TIFF files in the
> > source direcotry
> >        Dim i As Integer
> >        For i = 0 To i < (sourceFiles.Length)
> >            'Get the File Name of every scanned TIFF file
> >            Dim FileName As String =
> > Path.GetFileName(sourceFiles(i).FullName)
> >            'Get the Creation Time of every scanned TIFF file
> >            Dim FileDate As String =
> > Path.GetFileName(sourceFiles(i).CreationTime)
> >            i = i + 1
> >        Next
> >    End Sub
>
>