RESOLVED!! Assigning dataset values to a text box

**ARPRINCE** · Feb 11th, 2004, 10:44 AM

The script below gives me back a record (i.e. FNAME, LNAME, STUDENTID) that I will bind to a datagrid. After binding, I get value of each cell in the webform datagrid and place it on a webform textbox. Is there a better way to do this so that I skip the datagrid binding and assign the values to a text box directly? Do I have other option other than using a dataReader just like a recordset in VB6?

Thanks

Code:

            Dim connectionString As String = "server='SQLSERVER1'; user id='RAUser1'; password='letmein'; database='RA'"
            Dim dbConnection As System.Data.IDbConnection = New System.Data.SqlClient.SqlConnection(connectionString)

            Dim queryString As String = "SELECT [RAUser].* FROM [RAUser] WHERE (([RAUser].[LoginName] = @LoginName) AND ([" & _
    "RAUser].[LoginPass] = @LoginPass))"
            Dim dbCommand As System.Data.IDbCommand = New System.Data.SqlClient.SqlCommand
            dbCommand.CommandText = queryString
            dbCommand.Connection = dbConnection

            Dim dbParam_loginName As System.Data.IDataParameter = New System.Data.SqlClient.SqlParameter
            dbParam_loginName.ParameterName = "@LoginName"
            dbParam_loginName.Value = loginName
            dbParam_loginName.DbType = System.Data.DbType.String
            dbCommand.Parameters.Add(dbParam_loginName)
            Dim dbParam_loginPass As System.Data.IDataParameter = New System.Data.SqlClient.SqlParameter
            dbParam_loginPass.ParameterName = "@LoginPass"
            dbParam_loginPass.Value = loginPass
            dbParam_loginPass.DbType = System.Data.DbType.String
            dbCommand.Parameters.Add(dbParam_loginPass)

            dbConnection.Open()
            Dim dataReader As System.Data.IDataReader = dbCommand.ExecuteReader(System.Data.CommandBehavior.CloseConnection)
	    Return dataReader

**ARPRINCE** · Feb 11th, 2004, 03:43 PM

I tried using the SqlConnection data provider class but I may be missing something. Here's what I did:

(1) Created a new PROJECT using VS.
(2) Created a new web form (WebForm1.aspx).
(3) Under the WebForm1.aspx.vb page_load, I typed :

Code:

Dim con As New sqlconnection("my connectionstring")

The sqlconnection is underlined. Am I missing a reference?

**ARPRINCE** · Feb 11th, 2004, 04:40 PM

Ok. I used this one instead. I needed to add SqlClient so that I will get a correct syntax (with out underlines).

VB Code:

Dim dataCON As New SqlClient.SqlConnection("server='XXXXXX'; user id='XXXXXX'; password='XXXXXX'; database='XXXXXX'")
        dataCON.Open()
        Dim dataCMD As New SqlClient.SqlCommand("Select * from rauser", dataCON)
        Dim dataREADER As SqlClient.SqlDataReader = dataCMD.ExecuteReader()

I got the value of each cell of the dataset by using:

VB Code:

dataREADER.GetValue(FieldIndex)

Anyone knows how I can get rid of the "SqlClient" so that I don't need to type it in on every program line?

Thanks

**Memnoch1207** · Feb 11th, 2004, 05:23 PM

You should have an "Imports System.Data" statement at the top of your pages, change it to "Imports System.Data.SqlClient" and you won't have to use SqlClient in your code.

**ARPRINCE** · Feb 12th, 2004, 09:02 AM

Originally posted by Memnoch1207
You should have an "Imports System.Data" statement at the top of your pages, change it to "Imports System.Data.SqlClient" and you won't have to use SqlClient in your code.

Would this be on the MyPage.aspx.vb ? At the top of this page I only see (using Visual Studio):

VB Code:

Public Class Login
    Inherits System.Web.UI.Page

My HTML code shows only this one:

Code:

<%@ Page Language="vb" AutoEventWireup="false" Codebehind="Login.aspx.vb" Inherits="RA.Login"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
	<HEAD>
		<title>Login</title>
		<meta content="Microsoft Visual Studio .NET 7.1" name="GENERATOR">
		<meta content="Visual Basic .NET 7.1" name="CODE_LANGUAGE">
		<meta content="JavaScript" name="vs_defaultClientScript">
		<meta content="http://schemas.microsoft.com/intellisense/ie5" name="vs_targetSchema">
	</HEAD>
.......

I see this when I check my references:

**ARPRINCE** · Feb 16th, 2004, 12:30 PM

VB Code:

Imports System.Data.SqlClient
 
Public Class Login
    Inherits System.Web.UI.Page

I place the syntax under the general declaration portion of my vb code.

Thanks.

Thread: RESOLVED!! Assigning dataset values to a text box

Thread Tools

Display

RESOLVED!! Assigning dataset values to a text box

Posting Permissions