Velocity Reviews - Computer Hardware Reviews

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

Reply
Thread Tools

asp.net 2008 - SqlDataSource1.SelectCommand

 
 
yumil yumil is offline
Junior Member
Join Date: Nov 2008
Posts: 2
 
      11-19-2008
Hi I'm using asp.net 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"
..
endsub



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

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

thanks.
 

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

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 tavares@fe.up.pt Python 0 12-27-2007 02:32 AM
Windows 2008 and SQL 2008 shapper ASP .Net 1 12-08-2007 04:04 AM



Advertisments