 |
|
.NET Programming |
.NET Framework
Postback Property
Regular Expression
Multi-Threading
Error in ASP.NET
Errors In SQL
NESTED STORED PROCEDURES
Session Management
What is XML
Read Data From XML
ASP NET Web
Authentication
for sql connection sample code:
@ Page Language="vb" Debug="true"
@ import Namespace="System.Data"
@ import Namespace="System.Data.SqlClient"
Sub Page_Load(sender As Object, e As EventArgs)
'declarations
Dim conLath As SqlConnection
Dim cmdLath As SqlCommand
Dim rdrLath As SqlDataReader
conLath = New SqlConnection( _
"server=seasquall.ncl.ac.uk;uid=forweb;pwd=forweb; " & _
"database=latham")
conLath.Open
cmdLath = New SqlCommand ( _
"select idno,yr,txt from latham", _
conLath)
rdrLath = cmdLath.ExecuteReader
gridLath.DataSource = rdrLath
gridLath.DataBind
rdrLath.Close
cmdLath.Dispose
conLath.Close
End Sub
for my personal use only........ ( thank you)