SQL Server, SQL Server Express, and SqlDataSource Control

Re: Select in SqlDataSource

Jian Kang - MSFT — Wed, 08 Jul 2009 11:54:48 GMT

Hi Frank,

FrankEnem:

Pls I want to return the individual fields of the table AcctMaster with the SELECT statement.

How then can I use a parameter to return the value of individuasl colums.

Could you please clarify it or provide more detail? You may refer to the tutorial below:

Using Parameterized Queries with the SqlDataSource
http://www.asp.net/learn/data-access/tutorial-48-vb.aspx

FrankEnem:

OleDbDataReader rdrSql = (OleDbDataReader)SqlDataSource2.Select(DataSourceSelectArguments.Empty);

When I put down the above code, line one gave me an error message. pls do explain this and how I can use the DataReader

Please set the SqlDataSource.DataSourceMode property set to “DataReader”, and retrieve the data as follows:

SqlDataReader dr = (SqlDataReader)SqlDataSource1.Select(DataSourceSelectArguments.Empty);

Please refer to the following document for more detail:

SqlDataSource.Select Method
http://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.sqldatasource.select.aspx

Re: Select in SqlDataSource

Mikesdotnetting — Mon, 06 Jul 2009 12:24:11 GMT

FrankEnem:
When I put down the above code, line one gave me an error message.

What is the error message?

Re: Select in SqlDataSource

FrankEnem — Mon, 06 Jul 2009 10:02:23 GMT

Hi, How then can I use a parameter to return the value of individuasl colums. You mention Dataset and Datareader well and fine, if I use a datareader, how will the code be? ---This is the smaple code for SqlDataSource1 DataView dvSql = (DataView)SqlDataSource1.Select(DataSourceSelectArguments.Empty); foreach (DataRowView drvSql in dvSql) { Label3.Text = drvSql["FirstName"].ToString(); } OleDbDataReader rdrSql = (OleDbDataReader)SqlDataSource2.Select(DataSourceSelectArguments.Empty); while (rdrSql.Read()) { Label4.Text = rdrSql["LastName"].ToString(); } rdrSql.Close(); ------- When I put down the above code, line one gave me an error message. pls do explain this and how I can use the DataReader

Re: Select in SqlDataSource

Mikesdotnetting — Sat, 04 Jul 2009 21:27:28 GMT

Hmmm. Not quite sure why you have not use a parameter for the AccountID value, but then added a parameter that you have not provided a value for or used in your SQL. Also, I don't know why you are using a DataTable, when a DataReader will do.

As far as referencing the values using their tablename.fieldname is concerned, that won't work. Read this: http://www.mikesdotnetting.com/Article.aspx?ArticleID=45

Select in SqlDataSource

FrankEnem — Sat, 04 Jul 2009 16:23:11 GMT

Hi, I have created a datasource sqldatasource1. I have issued a select statement in a view to updating a record.

--------------------Partial code

SqlDataSource1.SelectCommand = "SELECT * FROM ACCTMASTER WHERE ACCOUNTID =" + Me.AccountID.Text

SqlDataSource1.SelectParameters.Clear()

SqlDataSource1.SelectParameters.Add("PAYERID", Me.PayerID.Text)

Dim dv As DataView = DirectCast(SqlDataSource1.[Select](DataSourceSelectArguments.Empty), DataView)

Dim tab As DataTable = dv.Table

(tab.Rows.Count > 0) Then

---- and so on

-------------------end of partial code

Pls I want to return the individual fields of the table AcctMaster with the SELECT statement.

for instance,

Dim V_AccountId as String = AcctMaster.AccountId