Sql Query

Expand Post »

Hi All

I have a select statement:

Select PERMISSION_BUTTON_ID from ALC_SECURITY_PERMISSION where ROLE_ID = 1

Now I want to store / retrieve the values of the field that I am querying without using dataset. Is this possible? If yes how can I do this?

Is it possible that I declare a variable Array and store the output.

Similar Threads

sql query problem with MS Access and C# in C#
Urgent Help with SQL Query in MySQL
C# VS 2005 - SQL Query Parameters to an ODBC DataSource in C#
sql query updating problem in Visual Basic 4 / 5 / 6
Javascript array from sql query in JSP

Tellie

Reputation Points: 7

Solved Threads: 0

Newbie Poster

Offline

11 posts
since Apr 2004

Permalink

Apr 29th, 2004

Re: Sql Query

Well, if it's only one value that your going to be returned, you can use the .ExecuteScalar, which returns an Object (the first row, first column of your query).

Tekmaven

Moderator

Reputation Points: 322

Solved Threads: 28

The C# Man, Myth, Legend

Offline

914 posts
since Feb 2002

Permalink

Nov 12th, 2008

Re: Sql Query

You can retrieve data from database without using dataset .

cnn.Open()
cmd = New SqlCommand(sql, cnn)
Dim count As Int32 = Convert.ToInt32(cmd.ExecuteScalar())
cmd.Dispose()
cnn.Close()

http://vb.net-informations.com/ado.n...sqlcommand.htm

bruce

bruce2424

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

23 posts
since Jun 2008

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in VB.NET Forum Timeline: OOLEDB Connection(vb.net & Access)

Next Thread in VB.NET Forum Timeline: linking two combo boxes

DaniWeb Message

Cancel Changes

User Name
Password