Embedding VB.NET code blocks in aspx page

Question

4.00/5 (1 vote)

See more:

I am trying to embed code blocks in aspx page.
as

<%@ Page Language="VB" AutoEventWireup="false" CodeFile="abcd.aspx.vb" Inherits="abcd" %>
<%@Import Namespace="System.Data"%>
<%@Import Namespace="System.Data.SqlClient" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<script runat="server"> 
    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        Dim connects As New SqlClient.SqlConnection(ConfigurationManager.ConnectionStrings("dbCon").ConnectionString)
        Dim sd1 As New SqlDataAdapter("STORED_PROCEDURE", connects)
        Dim ds1 As New DataTable
        sd1.Fill(ds1)
        Dim dd As String = ds1.Rows(0).Item("Type")
    End Sub
</script>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">

Now I want to fetch the above fields returned by Procedure Inside a html table .
My question is how can I get the values and what must be the syntax to place the values in table rows.

Posted 8-Aug-12 19:34pm

Karwa_Vivek

Updated 8-Aug-12 19:35pm

v2

Add a Solution

2 solutions

Solution 2

The proper way to do this is from code behind: In the design view, just double click on a blank place in your aspx and Visual Studio will create the code behind function Page_load() for you. Then, move your code there.

Doing that from within a code block is only used in other specific situations, and for backward compatibility with ASP (not NET). You should avoid that.

Best regards,

Roger Tranchez

Posted 8-Sep-12 5:00am

Roger Tranchez

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

_Amy · Accepted Answer · 2012-08-08T19:51:00

Take a StringBuilder take a html syntax inside that. Append each row and columns with the values returned buy the procedure. Try this:

VB

Dim s As New StringBuilder
'dt is your datatable returned by stored procedure
s.Append("<table border=1><tr>")
For Each drow As Data.DataRow In dt.Rows
    s.Append("<td>")
    s.Append(drow(0).ToString())
    s.Append("</td>")
    s.Append("<td>")
    s.Append(drow(1).ToString())
    s.Append("</td>")
    s.Append("<td>")
    s.Append(drow(2).ToString())
    s.Append("</td>")
Next
s.Append("</tr></table>")
Response.Write(s)

--Amit