Advertisement

06.18.2008 at 05:27AM PDT, ID: 23494871
[x]
Attachment Details

Simple VB.net passing data from .vb file to .aspx file

Asked by drocco21 in Visual Studio, Microsoft Visual Basic.Net

Tags:

I am looking to select data from a database in the .vb file so I can do an if/then statement. I then want that information to display on the .aspx page, in a gridview, or however it would be easiest. I am new to VB.net and just now getting a handle on it.

Below is the code for both the .vb file and the .aspx file. I think I have the connection string setup correctly but im not sure how to do the if/then in the .vb file. additionally I am stumped on how to get this to talk to the .aspx page and display the data.

Thanks for your helpStart Free Trial 
1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:

---.vb file---
Imports System.Data.SqlClient
Partial Class _Default
    Inherits System.Web.UI.Page
    
    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        Dim now = Date.Now
        Dim Conn As New SqlConnection("Initial Catalog=court_dms;Data Source=DINO;Integrated Security=no; User ID=norton;PWD=goldcat13")
        Dim SQL As String
        SQL = "SELECT * FROM court_gbs"
        Dim Comm As New SqlCommand(SQL, Conn)
        If court_gbs.judge = hoover Then
            Response.Write("test value")
        End If
        Conn.Close()
    End Sub
End Class
 
 
 
---.aspx file---
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="_Default" %>
 
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
 
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title>Untitled Page</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
    
    </div>
    <asp:GridView ID="GridView1" runat="server">
    </asp:GridView>
    </form>
</body>
</html>
[+][-]06.18.2008 at 05:29AM PDT, ID: 21812089

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]06.18.2008 at 05:38AM PDT, ID: 21812147

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: Visual Studio, Microsoft Visual Basic.Net
Tags: Visual Basic
Sign Up Now!
Solution Provided By: Chaosian
Participating Experts: 1
Solution Grade: A
 
 
[+][-]06.18.2008 at 06:40AM PDT, ID: 21812715

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]06.18.2008 at 06:46AM PDT, ID: 21812781

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]06.18.2008 at 07:31AM PDT, ID: 21813291

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.18.2008 at 07:35AM PDT, ID: 21813336

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628