.NETGURU
  Search:  
NamespacesDiscussions.NET v1.1Dot Net Guru's BlogIT Certification
Demo on ASPNG.com
Messages   Related Types
This message was discovered on ASPFriends.com 'aspng' list.
Responses highlighted in red are from those people who are likely to be able to contribute good, authoratitive information to this discussion. They include Microsoft employees, MVP's and others who IMHO contribute well to these kinds of discussions.

Lentil Stew
I am running Charles' database sample over at:
http://www.aspng.com/learn/dbtable.aspx

Trying to understand this subroutine:

Sub Page_Load(Src As Object, E As EventArgs)
Dim DS As DataSet
Dim MyConnection As ADOConnection
Dim MyCommand As ADODataSetCommand
dim strconn as string
dim strSQL as string

strconn="DSN=student;uid=student;pwd=magic"

strSQL="select * from Publishers where state='NY'"

MyConnection = New ADOConnection(strconn)
MyCommand = New ADODataSetCommand(strSQL,MyConnection)

DS = new DataSet()
MyCommand.FillDataSet(ds, "Publishers")

MyDataGrid.DataSource=ds.Tables("Publishers").DefaultView
MyDataGrid.DataBind()
End Sub

FIRST QUESTION:
This subroutine is not called anywhere on the page. Does this have something
to do with the ADO namespace (I'm still trying to grasp namespaces)? Is the
namespace calling this subroutine?

Actually, I'll just leave it at that one question for now. . .

Thanks in advance for all your help.

LS
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com
Reply to this message...
 
    
Scott Watermasysk (VIP)
This event is called when the page loads....

ASP.Net has multiple events you can code. Page_Load is just one of them.

-Scott

-----Original Message-----
From: Lentil Stew [mailto:Click here to reveal e-mail address]
Sent: Thursday, May 03, 2001 10:13 AM
To: aspng
Subject: [aspng] Demo on ASPNG.com

I am running Charles' database sample over at:
http://www.aspng.com/learn/dbtable.aspx

Trying to understand this subroutine:

Sub Page_Load(Src As Object, E As EventArgs)
Dim DS As DataSet
Dim MyConnection As ADOConnection
Dim MyCommand As ADODataSetCommand
dim strconn as string
dim strSQL as string

strconn="DSN=student;uid=student;pwd=magic"

strSQL="select * from Publishers where state='NY'"

MyConnection = New ADOConnection(strconn)
MyCommand = New ADODataSetCommand(strSQL,MyConnection)

DS = new DataSet()
MyCommand.FillDataSet(ds, "Publishers")

MyDataGrid.DataSource=ds.Tables("Publishers").DefaultView
MyDataGrid.DataBind()
End Sub

FIRST QUESTION:
This subroutine is not called anywhere on the page. Does this have something

to do with the ADO namespace (I'm still trying to grasp namespaces)? Is the
namespace calling this subroutine?

Actually, I'll just leave it at that one question for now. . .

Thanks in advance for all your help.

LS
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com

| [aspng] member Click here to reveal e-mail address = YOUR ID
| http://www.asplists.com/asplists/aspngcurious.asp = JOIN/QUIT
| http://www.asplists.com/search = SEARCH Archives
Reply to this message...
 
    
Lentil Stew
Cool Scott, thanks for the info
So, now (thanks to you) I am trying to find somewhere that lists all the
subroutines like that that are available for the system.ado.namespace but am
having a hard time finding them in the .Net Framework SDK. . . .can anyone
point me to a URL?

Thanks,

LS

[Original message clipped]

_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com
Reply to this message...
 
    
Suki Chima
Try running wincv.exe from the command prompt ... or locate in the .NET /bin
directory ...

----Original Message Follows----
From: "Lentil Stew" <Click here to reveal e-mail address>
Reply-To: "aspng" <Click here to reveal e-mail address>
To: "aspng" <Click here to reveal e-mail address>
Subject: [aspng] RE: Demo on ASPNG.com
Date: Thu, 03 May 2001 15:52:26 -0000

Cool Scott, thanks for the info
So, now (thanks to you) I am trying to find somewhere that lists all the
subroutines like that that are available for the system.ado.namespace but am
having a hard time finding them in the .Net Framework SDK. . . .can anyone
point me to a URL?

Thanks,

LS

[Original message clipped]

_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com

| [aspng] member Click here to reveal e-mail address = YOUR ID
| http://www.asplists.com/asplists/aspngcurious.asp = JOIN/QUIT
| http://www.asplists.com/search = SEARCH Archives

_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com
Reply to this message...
 
    
Scott Watermasysk (VIP)
At the top of your page, turn on tracing:

<%@ Page Language = "C#" Trace = "True" %>

This will show you all of the events in the order they are occurring. (Plus
a ton of other info...)

There is also a page_unload event that does not get shown.

-Scott

-----Original Message-----
From: Lentil Stew [mailto:Click here to reveal e-mail address]
Sent: Thursday, May 03, 2001 11:52 AM
To: aspng
Subject: [aspng] RE: Demo on ASPNG.com

Cool Scott, thanks for the info
So, now (thanks to you) I am trying to find somewhere that lists all the
subroutines like that that are available for the system.ado.namespace but am

having a hard time finding them in the .Net Framework SDK. . . .can anyone
point me to a URL?

Thanks,

LS

[Original message clipped]

_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com

| [aspng] member Click here to reveal e-mail address = YOUR ID
| http://www.asplists.com/asplists/aspngcurious.asp = JOIN/QUIT
| http://www.asplists.com/search = SEARCH Archives
Reply to this message...
 
 
System.Data.DataSet
System.EventArgs




ExamGuru IT Solutions - .Net Guru is owned and operated by ExamGuru, Inc., the man behind .Net Guru. If you're in the market for bespoke software or software consultancy, why not get him and his highly trained team to help? - www.examguru.net/ITCertification
Ad


Need Dot Net Interview Questions?
Ask ExamGuru, Inc. for advice and help on Passing .Net Interviews
.Net Projects
Best-of-breed application framework for .NET projects, developed by ExamGuru, Inc. and ExamGuru IT
Free .net Help
Commission ExamGuru, Inc. and his team for your next bespoke software project
FogBUGZ
The only bug tracking system carefully crafted with one goal in mind: helping teams create great software.
Awesome Tools
If you don't know about these, you're missing out... IT Certification Questions
IT Interview Questions
Free Oracle 10g Training
MCSE Boortcamp
Cisco Study Guides
Cheap Study Guides
Exact Questions
Dot Net Interview Questions
Oracle OCP
Cheap Travel
Designer Perfumes - Wholesale Prices
Free Programming Tutorials
 
ExamGuru IT Solutions - .Net Guru is owned and operated by ExamGuru, Inc., the man behind .Net Guru. If you're in the market for bespoke software or software consultancy, why not get him and his highly trained team to help? - www.examguru.net/ITCertification
 Copyright © ExamGuru, Inc. 2001-2006
Contact Us - Terms of Use - Privacy Policy - www.dot-net-guru.com - www.examguru.net - www.oraclesource.net - www.itinterviews.net - www.examguru.net/ITCertification