Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > General Computer Discussion > Software > 2008 - SqlDataSource1.SelectCommand

Thread Tools 2008 - SqlDataSource1.SelectCommand

yumil yumil is offline
Junior Member
Join Date: Nov 2008
Posts: 2
Hi I'm using 3.5 and behind vb. And the problem is on behind in VB.

code is:

Protected Sub dataTextBox_TextChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles makinanoTextBox.TextChanged
SqlDataSource1.SelectParameters.Add("@nMakinaID", makinanoTextBox.Text)
SqlDataSource1.SelectCommand = "select count(*) from [SpMakinaArizaKayit] where [arzbitti] = '0' and [nMakinaID] = @nMakinaID"

1- I get the data by select count(*).., but I couldn't display result

something like: Response.Write(SqlDataSource1.SelectCommand) .....???

and also

2- I can't check the value of count(*) null or not

if (count(*)= 0) then ..else..endif


Last edited by yumil; 11-19-2008 at 04:10 PM..
Reply With Quote

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Re: Call for Papers: The 2008 International Conference of Information Engineering ICIE 2008 Barry Kelly Java 0 01-09-2008 06:45 PM
EUROMEDIA 2008, April 9-11, 2008, FEUP-University of Porto, Portugal- 2nd Call for Papers Python 0 12-27-2007 02:32 AM
Windows 2008 and SQL 2008 shapper ASP .Net 1 12-08-2007 04:04 AM