Binding a count total to a label

[Mnemonic]

Hey folks... im trying to take a select count query and bind it to a label... here's the query:

SELECT COUNT(ID) AS total
FROM DailySales
WHERE (saledate = @saledate)

Now... how do i tell the label to return the value of total? I can only databind to an acctual column in the properties, but not to a count result column...

Any ideas?

Thanks in advance!

 

[cjard]

thats a scalar query, you cannot bind it. Instead, just assign it to the label text every time you run it

 

[cjard]

watch this. Note that you dont dim a new one every time you run the query. If you run it a lot, dim it as a form variable once and repeatedly call it

 

[Arg81]

omg, he's gone into the movie business

(there's a secret Cjard Does Dallas hidden away on the net)

 

[Mnemonic]

Thank you so much for making a movie explaining how to do it!

Problem is, when i put in Dim x As New DBDataSetTableAdapters.QueriesTableAdapter, it says "Type 'DBDataSetTableAdapters.QueriesTableAdapter' is not defined"

Any ideas?

 

[Mnemonic]

Duh... i got it.. im an idiot...

Thanks so much guys!!!

 

[Arg81]

that wasn't the name of YOUR dataset and datatable?

 

[Mnemonic]

LOL, That was like an hour after i got in to the office after a very hung over weekend :-D I figured intellisense would just KNOW what i was talking bout

 

[cjard]

I wrote a cool thing called ArtificiIntellisense, it is actually telepathic and writes code for me at the drop of a thought. You should see the uncompilable **** it churns out when the Uma Thurman screensaver pops up.

Did you know she's 6 foot, with size 11 feet? Meroww!