Simple dataset question

[Tweety99]

Hi,

i have problems with dataset ?

I have public function with connected in database.
I want return that function one row in form messagebox.

Function code like this:

*Code function

cn.Open()
cmd.CommandType = 1
cmd.CommandText = "select y from XX where zz = @zz"
cmd.Parameters.Add("@zz", zz)

Dim aa As SqlDataReader
aa = cmd.ExecuteReader(CommandBehavior.SingleRow)
Return aa.GetValue(0)

When i try get that value in form, it's only show 0. What it wrong or ....


Tweety99

[nemaroller]

I think it may be you are setting CommandType =1, which is TableDirect, which is not supported with a SQL Connection, only using an OLEDB connection.

[Tweety99]

Number 1 should be CommandType.Text.

Tweety99