using asp code with html code

maennet · July 21st, 2004, 02:57 AM

dear all
i have the wrox book (beginning asp.net 1.1 with vb.net 2003).
in capter 2 page 59 the author try to use asp.net code with html but the code of asp.net not executed and no error dispaly its just neglected.
any one could help me
with my regards

jordan

happygv · July 21st, 2004, 03:39 AM

This should be posted under a .net forum of this site. But you have posted that in a feedback forum.

Cheers!

_________________________
- Vijay G
Strive for Perfection

devanti · July 21st, 2004, 11:48 AM

Hi Jordan,

Do you use WebMatrix or do you have IIS installed with the .Net Framework? Which version of the .Net framework you using?

Download the book code and check your code against the downloaded sample, there are some erros in the books code, sometimes you learn more if you can figure out how to solve the problem and make it work on your own.

The.Student

What does my picture not work !

maennet · July 22nd, 2004, 01:14 AM

Hi devanti
I am using IIS and I download the code, but I think the web matrix is the reason of the problem. see below the complete code and if you could please tell me how to convert it to comfort IIS .

<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>

<script runat="server" runat="server" debuge="true">

    ' Insert page code here
    Sub Page_Load(Sender As Object, E as EventArgs)

       Dim objConnection As OleDbConnection
       Dim objCommand As OleDbDataAdapter
       Dim strConnect As String
       Dim strCommand As String
       Dim DataSet1 As New DataSet

       strConnect = "Provider=Microsoft.Jet.OLEDB.4.0;"
       strConnect += "Data Source=C:\asp.mdb;"
       strConnect += "Persist Security Info=False"

       strCommand = "SELECT number, name FROM asp_t1"

       objConnection = New OleDbConnection(strConnect)
       objCommand = New OleDbDataAdapter(strCommand, objConnection)
       objCommand.Fill(DataSet1, "asp_t1")
       DataGrid1.DataSource=DataSet1.Tables("asp_t1").Def aultView
       DataGrid1.DataBind()
    End Sub

</script>

<HTML>
    <HEAD>
        <title>Data Grid Control example</title>
    </HEAD>
    <body>
        <asp:DataGrid id="DataGrid1" runat="server"></asp:DataGrid>
    </body>
</HTML>

jordan

devanti · July 22nd, 2004, 05:53 AM

Hi Jordan,

Well first things First you want to change the position of your debug="true" declaration and correct the typo
place this in the <%@ Page Language="VB" %> declaration. As far as I can see thats the only problem with your code.

As for IIS, you need to ensure that the .NET Framework client and virtual directories have been installed, then all you should need to do is open IE and type in localhost/your-filename.aspx, if IIS is configured correctly then this should run, do you have the Quickstart samples installed?

I have IIS installed and WebMatrix and I prefer to use the built in WebMatrix server for testing, Webmatrix uses the locahost:8080/your-filename.aspx URi. So when you run this code are any errors displayed or do you get a datagrid showing the numbers and names from the asp_t1?

The.Student

What does my picture not work !

maennet · July 25th, 2004, 01:00 AM

hi united kingdom

when I use this code no error display and no data also dispaly I just have empty explorer .
thank you for help but its not work yet.

jordan

devanti · August 3rd, 2004, 05:30 PM

Hi Again Chap, sorry for the delay in replying...

First of all take one of the runat="server" declarations out of the script tag, next make sure that you have saved your page in an IIS virtual directory e.g. http://localhost/virtualdirectory/filename.aspx ensure that your IIS is up and running test this by typing localhost into Internet Explorers address bar. The default localhost window should appear.

If the problem still persists try reinstalling the .Net Framework, then test.

Let me know how you get on...

The.Student

What does my picture not work !

djdykes · August 17th, 2004, 10:28 AM

Quote:

quote:Originally posted by maennet
Hi devanti
I am using IIS and I download the code, but I think the web matrix is the reason of the problem. see below the complete code and if you could please tell me how to convert it to comfort IIS .

<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>

<script runat="server" runat="server" debuge="true">

    ' Insert page code here
    Sub Page_Load(Sender As Object, E as EventArgs)

     Dim objConnection As OleDbConnection
     Dim objCommand As OleDbDataAdapter
     Dim strConnect As String
     Dim strCommand As String
     Dim DataSet1 As New DataSet

     strConnect = "Provider=Microsoft.Jet.OLEDB.4.0;"
     strConnect += "Data Source=C:\asp.mdb;"
     strConnect += "Persist Security Info=False"

try

<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>
<script language="VB" runat="server" debug="true">

and for the connection string try

dim strconnect as string = "provider=Microsoft.jet.oledb.4.0;data source=" & server.mappath("asp.mdb")

make sure your database is in the same folder as you aspx page here otherwise you'll have to specify the directory structure etc.

If you have no luck check your .net framework is running properly... by trying out simpler .net pages

bmains · August 17th, 2004, 11:36 AM

Hey,

Try taking debug="true" out of the script tag and put it in the page tag.

Brian