Datagrid and datareader

[Bart Schelkens]

Hi,

I have 2 more questions :

1. Can I fill a datagrid by using a DataReader or does it have to be a
DataSet or a DataView?

2. In my datagrid I need to display two images and one of does images has te
be a link to a new page. How would you do that ?

Thanks.

[Jared]

1:) You can use a datareader to fill a datalist/datagrid.

Dim Conn As New System.Data.Sql Client.SqlConne ction
Conn.Connection String = "Server=YourSer ver;
Database=Northw ind;Trusted_Con nection=True;"

Conn.Open()

Dim cmd As New SqlClient.SqlCo mmand("SELECT * FROM Employees", Conn)
Me.DataGrid2.Da taSource = cmd.ExecuteRead er
Me.DataGrid2.Da taBind()

Conn.Close()

2:)
If no one else answers your question, before I get home from work I will
throw together an example for you. Is your e-mail address valid?

Jared

"Bart Schelkens" <BS********@hot mail.com> wrote in message
news:%2******** ********@TK2MSF TNGP09.phx.gbl. ..

Hi,

I have 2 more questions :

1. Can I fill a datagrid by using a DataReader or does it have to be a
DataSet or a DataView?

2. In my datagrid I need to display two images and one of does images has
te
be a link to a new page. How would you do that ?

Thanks.

[Bart Schelkens]

Jared,

thx for the answer.
My email is a valid address BS********@hotm ail.com
So there's no problem in sending me a reply there.

Thx.
Bart

"Jared" <VB***********@ email.com> wrote in message
news:10******** *****@corp.supe rnews.com...

1:) You can use a datareader to fill a datalist/datagrid.

Dim Conn As New System.Data.Sql Client.SqlConne ction
Conn.Connection String = "Server=YourSer ver;
Database=Northw ind;Trusted_Con nection=True;"

Conn.Open()

Dim cmd As New SqlClient.SqlCo mmand("SELECT * FROM Employees", Conn)
Me.DataGrid2.Da taSource = cmd.ExecuteRead er
Me.DataGrid2.Da taBind()

Conn.Close()

2:)
If no one else answers your question, before I get home from work I will
throw together an example for you. Is your e-mail address valid?

Jared

"Bart Schelkens" <BS********@hot mail.com> wrote in message
news:%2******** ********@TK2MSF TNGP09.phx.gbl. ..

Hi,

I have 2 more questions :

1. Can I fill a datagrid by using a DataReader or does it have to be a
DataSet or a DataView?

2. In my datagrid I need to display two images and one of does images has te
be a link to a new page. How would you do that ?

Thanks.

[Nick]

This is a very good article with extra datagrid info:

http://aspnet.4guysfromrolla.com/articles/040502-1.aspx

"Bart Schelkens" <BS********@hot mail.com> wrote in message
news:Om******** *****@TK2MSFTNG P12.phx.gbl...

Jared,

thx for the answer.
My email is a valid address BS********@hotm ail.com
So there's no problem in sending me a reply there.

Thx.
Bart

"Jared" <VB***********@ email.com> wrote in message
news:10******** *****@corp.supe rnews.com...

1:) You can use a datareader to fill a datalist/datagrid.

Dim Conn As New System.Data.Sql Client.SqlConne ction
Conn.Connection String = "Server=YourSer ver;
Database=Northw ind;Trusted_Con nection=True;"

Conn.Open()

Dim cmd As New SqlClient.SqlCo mmand("SELECT * FROM Employees", Conn)
Me.DataGrid2.Da taSource = cmd.ExecuteRead er
Me.DataGrid2.Da taBind()

Conn.Close()

2:)
If no one else answers your question, before I get home from work I will
throw together an example for you. Is your e-mail address valid?

Jared

"Bart Schelkens" <BS********@hot mail.com> wrote in message
news:%2******** ********@TK2MSF TNGP09.phx.gbl. ..

Hi,

I have 2 more questions :

1. Can I fill a datagrid by using a DataReader or does it have to be a
DataSet or a DataView?

2. In my datagrid I need to display two images and one of does images has te
be a link to a new page. How would you do that ?

Thanks.

[Bart Schelkens]

Thx for the info
but i can't find the section where they explain how to display images in the
grid.
Nor can i find the section where they tell me how to display an image that
serves as a link for a new page.

"Nick" <Ni**@NTWorks.n o.spam.fsnet.co .uk> wrote in message
news:%2******** ********@tk2msf tngp13.phx.gbl. ..

This is a very good article with extra datagrid info:

http://aspnet.4guysfromrolla.com/articles/040502-1.aspx

"Bart Schelkens" <BS********@hot mail.com> wrote in message
news:Om******** *****@TK2MSFTNG P12.phx.gbl...

Jared,

thx for the answer.
My email is a valid address BS********@hotm ail.com
So there's no problem in sending me a reply there.

Thx.
Bart

"Jared" <VB***********@ email.com> wrote in message
news:10******** *****@corp.supe rnews.com...

1:) You can use a datareader to fill a datalist/datagrid.

Dim Conn As New System.Data.Sql Client.SqlConne ction
Conn.Connection String = "Server=YourSer ver;
Database=Northw ind;Trusted_Con nection=True;"

Conn.Open()

Dim cmd As New SqlClient.SqlCo mmand("SELECT * FROM Employees", Conn) Me.DataGrid2.Da taSource = cmd.ExecuteRead er
Me.DataGrid2.Da taBind()

Conn.Close()

2:)
If no one else answers your question, before I get home from work I will throw together an example for you. Is your e-mail address valid?

Jared

"Bart Schelkens" <BS********@hot mail.com> wrote in message
news:%2******** ********@TK2MSF TNGP09.phx.gbl. ..
> Hi,
>
> I have 2 more questions :
>
> 1. Can I fill a datagrid by using a DataReader or does it have to be a > DataSet or a DataView?
>
> 2. In my datagrid I need to display two images and one of does

images has

> te
> be a link to a new page. How would you do that ?
>
> Thanks.
>
>

[Nick]

Part 5 - Template Columns.

Then in the code for the ItemDataBound event you add the HTML for the image.
If you want the image to be a link as well, then add the <A> tags. Eg:

Sub AddImage(ByVal sender As Object, ByVal e As DataGridItemEve ntArgs)
If e.Item.ItemType <> ListItemType.He ader And e.Item.ItemType <>
ListItemType.Fo oter Then
e.Item.Cells(4) .Text() = "<img src='../images/picture.gif'></img>"
End If
End Sub

Don't forget you need to add a template column to the datagrid, and set the
OnItemDataBound ="AddImage" property for the datagrid.
(For the above code, the template column would need to be the 4th column)

<Columns>
<asp:BoundColum n......></asp:BoundColumn >
<asp:BoundColum n......></asp:BoundColumn >
<asp:BoundColum n......></asp:BoundColumn >
<asp:TemplateCo lumn HeaderText="No. ">
<ItemTemplate >
</ItemTemplate>
</asp:TemplateCol umn>
</Columns>
Nick
"Bart Schelkens" <BS********@hot mail.com> wrote in message
news:eN******** ********@TK2MSF TNGP09.phx.gbl. ..

Thx for the info
but i can't find the section where they explain how to display images in the grid.
Nor can i find the section where they tell me how to display an image that
serves as a link for a new page.

"Nick" <Ni**@NTWorks.n o.spam.fsnet.co .uk> wrote in message
news:%2******** ********@tk2msf tngp13.phx.gbl. ..

This is a very good article with extra datagrid info:

http://aspnet.4guysfromrolla.com/articles/040502-1.aspx

"Bart Schelkens" <BS********@hot mail.com> wrote in message
news:Om******** *****@TK2MSFTNG P12.phx.gbl...

Jared,

thx for the answer.
My email is a valid address BS********@hotm ail.com
So there's no problem in sending me a reply there.

Thx.
Bart

"Jared" <VB***********@ email.com> wrote in message
news:10******** *****@corp.supe rnews.com...
>
> 1:) You can use a datareader to fill a datalist/datagrid.
>
> Dim Conn As New System.Data.Sql Client.SqlConne ction
> Conn.Connection String = "Server=YourSer ver;
> Database=Northw ind;Trusted_Con nection=True;"
>
> Conn.Open()
>
> Dim cmd As New SqlClient.SqlCo mmand("SELECT * FROM Employees", Conn) > Me.DataGrid2.Da taSource = cmd.ExecuteRead er
> Me.DataGrid2.Da taBind()
>
> Conn.Close()
>
> 2:)
> If no one else answers your question, before I get home from work I will > throw together an example for you. Is your e-mail address valid?
>
> Jared
>
> "Bart Schelkens" <BS********@hot mail.com> wrote in message
> news:%2******** ********@TK2MSF TNGP09.phx.gbl. ..
> > Hi,
> >
> > I have 2 more questions :
> >
> > 1. Can I fill a datagrid by using a DataReader or does it have to

be

a > > DataSet or a DataView?
> >
> > 2. In my datagrid I need to display two images and one of does images has
> > te
> > be a link to a new page. How would you do that ?
> >
> > Thanks.
> >
> >
>
>

[Bart Schelkens]

thx Nick,

I must have looked over it.

"Nick" <Ni**@NTWorks.n o.spam.fsnet.co .uk> wrote in message
news:%2******** **********@TK2M SFTNGP12.phx.gb l...

Part 5 - Template Columns.

Then in the code for the ItemDataBound event you add the HTML for the image. If you want the image to be a link as well, then add the <A> tags. Eg:

Sub AddImage(ByVal sender As Object, ByVal e As DataGridItemEve ntArgs)
If e.Item.ItemType <> ListItemType.He ader And e.Item.ItemType <>
ListItemType.Fo oter Then
e.Item.Cells(4) .Text() = "<img src='../images/picture.gif'></img>"
End If
End Sub

Don't forget you need to add a template column to the datagrid, and set the OnItemDataBound ="AddImage" property for the datagrid.
(For the above code, the template column would need to be the 4th column)

<Columns>
<asp:BoundColum n......></asp:BoundColumn >
<asp:BoundColum n......></asp:BoundColumn >
<asp:BoundColum n......></asp:BoundColumn >
<asp:TemplateCo lumn HeaderText="No. ">
<ItemTemplate >
</ItemTemplate>
</asp:TemplateCol umn>
</Columns>
Nick
"Bart Schelkens" <BS********@hot mail.com> wrote in message
news:eN******** ********@TK2MSF TNGP09.phx.gbl. ..

Thx for the info
but i can't find the section where they explain how to display images in the

grid.
Nor can i find the section where they tell me how to display an image that serves as a link for a new page.

"Nick" <Ni**@NTWorks.n o.spam.fsnet.co .uk> wrote in message
news:%2******** ********@tk2msf tngp13.phx.gbl. ..

This is a very good article with extra datagrid info:

http://aspnet.4guysfromrolla.com/articles/040502-1.aspx

"Bart Schelkens" <BS********@hot mail.com> wrote in message
news:Om******** *****@TK2MSFTNG P12.phx.gbl...
> Jared,
>
> thx for the answer.
> My email is a valid address BS********@hotm ail.com
> So there's no problem in sending me a reply there.
>
> Thx.
> Bart
>
> "Jared" <VB***********@ email.com> wrote in message
> news:10******** *****@corp.supe rnews.com...
> >
> > 1:) You can use a datareader to fill a datalist/datagrid.
> >
> > Dim Conn As New System.Data.Sql Client.SqlConne ction
> > Conn.Connection String = "Server=YourSer ver;
> > Database=Northw ind;Trusted_Con nection=True;"
> >
> > Conn.Open()
> >
> > Dim cmd As New SqlClient.SqlCo mmand("SELECT * FROM Employees",

Conn)

> > Me.DataGrid2.Da taSource = cmd.ExecuteRead er
> > Me.DataGrid2.Da taBind()
> >
> > Conn.Close()
> >
> > 2:)
> > If no one else answers your question, before I get home from work

I will

> > throw together an example for you. Is your e-mail address valid?
> >
> > Jared
> >
> > "Bart Schelkens" <BS********@hot mail.com> wrote in message
> > news:%2******** ********@TK2MSF TNGP09.phx.gbl. ..
> > > Hi,
> > >
> > > I have 2 more questions :
> > >
> > > 1. Can I fill a datagrid by using a DataReader or does it have

to be

a

> > > DataSet or a DataView?
> > >
> > > 2. In my datagrid I need to display two images and one of does

images

> has
> > > te
> > > be a link to a new page. How would you do that ?
> > >
> > > Thanks.
> > >
> > >
> >
> >
>
>

[Bart Schelkens]

Nick

in the example I see that the image will always be the same.
I'm trying to find a way (but i'm not very successful) to make the name of
the file variable, because that name is stored in the datasource of my
datagrid.

Thx for any help

"Nick" <Ni**@NTWorks.n o.spam.fsnet.co .uk> wrote in message
news:%2******** **********@TK2M SFTNGP12.phx.gb l...

Part 5 - Template Columns.

Then in the code for the ItemDataBound event you add the HTML for the image. If you want the image to be a link as well, then add the <A> tags. Eg:

Sub AddImage(ByVal sender As Object, ByVal e As DataGridItemEve ntArgs)
If e.Item.ItemType <> ListItemType.He ader And e.Item.ItemType <>
ListItemType.Fo oter Then
e.Item.Cells(4) .Text() = "<img src='../images/picture.gif'></img>"
End If
End Sub

Don't forget you need to add a template column to the datagrid, and set the OnItemDataBound ="AddImage" property for the datagrid.
(For the above code, the template column would need to be the 4th column)

<Columns>
<asp:BoundColum n......></asp:BoundColumn >
<asp:BoundColum n......></asp:BoundColumn >
<asp:BoundColum n......></asp:BoundColumn >
<asp:TemplateCo lumn HeaderText="No. ">
<ItemTemplate >
</ItemTemplate>
</asp:TemplateCol umn>
</Columns>
Nick
"Bart Schelkens" <BS********@hot mail.com> wrote in message
news:eN******** ********@TK2MSF TNGP09.phx.gbl. ..

Thx for the info
but i can't find the section where they explain how to display images in the

grid.
Nor can i find the section where they tell me how to display an image that serves as a link for a new page.

"Nick" <Ni**@NTWorks.n o.spam.fsnet.co .uk> wrote in message
news:%2******** ********@tk2msf tngp13.phx.gbl. ..

This is a very good article with extra datagrid info:

http://aspnet.4guysfromrolla.com/articles/040502-1.aspx

"Bart Schelkens" <BS********@hot mail.com> wrote in message
news:Om******** *****@TK2MSFTNG P12.phx.gbl...
> Jared,
>
> thx for the answer.
> My email is a valid address BS********@hotm ail.com
> So there's no problem in sending me a reply there.
>
> Thx.
> Bart
>
> "Jared" <VB***********@ email.com> wrote in message
> news:10******** *****@corp.supe rnews.com...
> >
> > 1:) You can use a datareader to fill a datalist/datagrid.
> >
> > Dim Conn As New System.Data.Sql Client.SqlConne ction
> > Conn.Connection String = "Server=YourSer ver;
> > Database=Northw ind;Trusted_Con nection=True;"
> >
> > Conn.Open()
> >
> > Dim cmd As New SqlClient.SqlCo mmand("SELECT * FROM Employees",

Conn)

> > Me.DataGrid2.Da taSource = cmd.ExecuteRead er
> > Me.DataGrid2.Da taBind()
> >
> > Conn.Close()
> >
> > 2:)
> > If no one else answers your question, before I get home from work

I will

> > throw together an example for you. Is your e-mail address valid?
> >
> > Jared
> >
> > "Bart Schelkens" <BS********@hot mail.com> wrote in message
> > news:%2******** ********@TK2MSF TNGP09.phx.gbl. ..
> > > Hi,
> > >
> > > I have 2 more questions :
> > >
> > > 1. Can I fill a datagrid by using a DataReader or does it have

to be

a

> > > DataSet or a DataView?
> > >
> > > 2. In my datagrid I need to display two images and one of does

images

> has
> > > te
> > > be a link to a new page. How would you do that ?
> > >
> > > Thanks.
> > >
> > >
> >
> >
>
>