Ask a Question related to ASP.NET Data Grid Control, Design and Development.
-
John K #1
Lost as can be
I am completely lost. I used a WebMatrix wizard and tried to make it a
DataList. I get no errors but it doesn't work either. I really need help.
Don't laugh too hard. I have been having a terrible time trying to figure
this out. I just want to get this to bind and display properly in a tabular
format. If it looks like I don't know very well what I'm doing then you'd be
right. I've been up and down a lot of documentaion but I have just served to
confuse myself more. I'm way on the wrong side of 50. This is something I do
for my family which is very large and spread all over the country. I have a
page doing this in ASP and it works fine but ASP.NET has thrown me pretty
good. If I could get on the right track once I hope I can figure it out from
there. Make necessary corrections and post the results if it isn't too much
trouble.
<%@ Page Language="VB" debug="true" %>
<%@ import Namespace="System.Data" %>
<%@ import Namespace="System.Data.OleDB" %>
<script runat="server">
Sub Page_Load
Dim dstNewFmnfo As System.Data.DataSet
Dim connectionString As String =
"Provider=Microsoft.Jet.OLEDB.4.0; Ole DB Services=-4; Data
Source=G:/websites/krausyr/fpdb/newfami"& _
"nfo.mdb"
Dim dbConnection As System.Data.IDbConnection = New
System.Data.OleDb.OleDbConnection(connectionString )
Dim queryString As String = "SELECT [Results].[SpouseName],
[Results].[CellPhone], [Results].[MaritalStatus], "& _
"[Results].[Child_Of], [Results].[ZIP], [Results].[City],
[Results].[MiddleName],"& _
" [Results].[HomePhone], [Results].[State], [Results].[LastName],
[Results].[Work"& _
"Phone], [Results].[DateofBirth], [Results].[StreetAddress],
[Results].[Key], [Re"& _
"sults].[FirstName], [Results].[EmailAddress], [Results].[ChildrenNames]
FROM [Re"& _
"sults]"
Dim dbCommand As System.Data.IDbCommand = New
System.Data.OleDb.OleDbCommand
dbCommand.CommandText = queryString
dbCommand.Connection = dbConnection
Dim dataAdapter As System.Data.IDbDataAdapter = New
System.Data.OleDb.OleDbDataAdapter
dataAdapter.SelectCommand = dbCommand
Dim dataSet As System.Data.DataSet = New System.Data.DataSet
dataAdapter.Fill(dstNewFmnfo)
dlstNewFmnfo.DataSource = dstNewFmnfo
dlstNewFmnfo.DataBind()
End Sub
</script>
<html>
<head>
<title>Datalist.aspx</title>
</head>
<body>
<form Runat="server">
<asp:DataList ID="dlstNewFmnfo" Runat="Server">
<HeaderTemplate>
<h2>Fam Mbr First Name:</h2>
</HeaderTemplate>
<ItemTemplate>
<table>
<tr>
<td align="right">First Name:</td>
<td><%# Container.DataItem( "FirstName" )%></td>
</tr>
</ItemTemplate>
</asp:DataList>
</form>
</body>
</html>
Thanks for your help, John K.
John K Guest
-
help I'm lost
Hi everyone I am working on a website and to get me going I used a template, which I am editing using Dreamweaver 8 and associated programs... -
Lost CD
Hi everyone, I purchased the book Macromedia Dreamweaver MX 2004 with asp, coldfusion, and php. Unfortunately, whilst working in the library, I... -
lost of 8MB of RAM on my
Hi, I recently bought a new laptop from toshiba, and it should have 512MB of RAM but in the sytem properties it tells me that I have 496 MB of... -
I've lost it!
Not long ago in the Adobe Exchange, someone posted either a style or an action that produced a "swiss cheese" effect. If I'm not mistaken, it was... -
lost in ASP & WSH!please help!
I am using the VBScript and WSH to get the existing printer network. The code: <script language="VBScript" type="text/VBScript"> Dim existing... -
Alvin Bruney [MVP] #2 Re: Lost as can be
John,
post a specific problem so we can help you. Nobody likes to troubleshoot a
wild goose.
--
Regards,
Alvin Bruney [ASP.NET MVP]
Got tidbits? Get it here...
[url]http://tinyurl.com/27cok[/url]
"John K" <john.kraus@prodigy.net> wrote in message
news:ekCfW1YGEHA.1240@TK2MSFTNGP10.phx.gbl...tabular> I am completely lost. I used a WebMatrix wizard and tried to make it a
> DataList. I get no errors but it doesn't work either. I really need help.
> Don't laugh too hard. I have been having a terrible time trying to figure
> this out. I just want to get this to bind and display properly in abe> format. If it looks like I don't know very well what I'm doing then you'dto> right. I've been up and down a lot of documentaion but I have just serveddo> confuse myself more. I'm way on the wrong side of 50. This is something Ia> for my family which is very large and spread all over the country. I havefrom> page doing this in ASP and it works fine but ASP.NET has thrown me pretty
> good. If I could get on the right track once I hope I can figure it outmuch> there. Make necessary corrections and post the results if it isn't too[Results].[ChildrenNames]> trouble.
>
> <%@ Page Language="VB" debug="true" %>
> <%@ import Namespace="System.Data" %>
> <%@ import Namespace="System.Data.OleDB" %>
> <script runat="server">
>
> Sub Page_Load
> Dim dstNewFmnfo As System.Data.DataSet
> Dim connectionString As String =
> "Provider=Microsoft.Jet.OLEDB.4.0; Ole DB Services=-4; Data
> Source=G:/websites/krausyr/fpdb/newfami"& _
> "nfo.mdb"
> Dim dbConnection As System.Data.IDbConnection = New
> System.Data.OleDb.OleDbConnection(connectionString )
>
> Dim queryString As String = "SELECT [Results].[SpouseName],
> [Results].[CellPhone], [Results].[MaritalStatus], "& _
> "[Results].[Child_Of], [Results].[ZIP], [Results].[City],
> [Results].[MiddleName],"& _
> " [Results].[HomePhone], [Results].[State], [Results].[LastName],
> [Results].[Work"& _
> "Phone], [Results].[DateofBirth], [Results].[StreetAddress],
> [Results].[Key], [Re"& _
> "sults].[FirstName], [Results].[EmailAddress],> FROM [Re"& _
> "sults]"
> Dim dbCommand As System.Data.IDbCommand = New
> System.Data.OleDb.OleDbCommand
> dbCommand.CommandText = queryString
> dbCommand.Connection = dbConnection
>
> Dim dataAdapter As System.Data.IDbDataAdapter = New
> System.Data.OleDb.OleDbDataAdapter
> dataAdapter.SelectCommand = dbCommand
> Dim dataSet As System.Data.DataSet = New System.Data.DataSet
> dataAdapter.Fill(dstNewFmnfo)
>
> dlstNewFmnfo.DataSource = dstNewFmnfo
> dlstNewFmnfo.DataBind()
>
>
> End Sub
>
> </script>
> <html>
> <head>
> <title>Datalist.aspx</title>
>
>
> </head>
> <body>
> <form Runat="server">
> <asp:DataList ID="dlstNewFmnfo" Runat="Server">
>
> <HeaderTemplate>
> <h2>Fam Mbr First Name:</h2>
> </HeaderTemplate>
>
> <ItemTemplate>
> <table>
> <tr>
> <td align="right">First Name:</td>
> <td><%# Container.DataItem( "FirstName" )%></td>
> </tr>
> </ItemTemplate>
>
> </asp:DataList>
>
> </form>
> </body>
> </html>
>
>
> Thanks for your help, John K.
>
>
Alvin Bruney [MVP] Guest
-
John K #3 Re: Lost as can be
I started over from scratch because I found a link on the MS ASP.NET site
that gave a complete example of a DataList using OleDB with Access. Just
what I wanted to do. It represented the main structure and from there I was
OK. I just wanted to make all the records appear in tabular form so users
could scroll down and see each of the fields in each record. There are too
many fields to use comfortably in that way with a DataGrid because you have
to scroll horizontally and vertically (a pain in the butt). There are about
150 records (family members) and some people like to scroll through them to
refresh their memory about what kid belongs to whom etc. It takes six to
eight seconds for this page to load but it isn't called that often. It's a
little longer with dial up but still not too bad. Most people use the
'Search' cause people typically look for a unique person. I have fields for
spouse, parents, children, as well as addresses phone(s) and the like. We
also have a lot of genealogy info dating back to the 1600s that one of my
brothers has been compiling for years. That is in a different section of the
site. We also have a section with a LOT of photos and members can upload
photos.
For my next trick I think I will make it so the records each display a
picture of the person. We started planning a big family reunion last year
for this summer and I'll be taking a photo of everyone with a digital
camera. I don't know if Access can store pictures in JPG or if I will need
to reference to a web folder that contains the images.
I"ve had this site up and running for almost four years and decided to bite
the bullet and change over to ASP.NET (from ASP). It's a lot of work and is
challenging if you aren't a programmer. I originally had it all running on
Server 2000 but my server was getting a bit long in the tooth so I built a
new one last fall with Standard Server 2003. It works great!!
Thanks Alvin. I'm sure I'll need help in the near future again.
Later, John Kraus
John K Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
