Seeking gridview binding problem

miosoul

If your audioId segment is the Key key, you can write a SQL statement to complete it.
strSQL = "select A. field, A. field,...,count(B.audioId) as commcount from A inner join B on A.audioId = b.audioId where A.UserId = "+ uid +" Group by A .Field,A,Field,...,"

白饭米粉

Your count(B.*)

This,, an error, so 0 is not displayed, that is, only the "true" value is displayed

miosoul

count(B.*) changed to count(B.audioId)

白饭米粉

count(B.*) changed to count(B.audioId)


I tried it yesterday afternoon, and it doesn’t show up. My ID is also the primary key.

白饭米粉

miosoul

           strSQL = "select A. field, A. field,..., isnull((count(B.audioId) as commcount),0) from A inner join B on A.audioId = b.audioId where A.UserId = " + uid + "Group by A. Field,A,Field,...,"



Is this writing OK,

I tried it with the query analyzer, and there was an error in AS. It can run normally without AS

白饭米粉

isnull(count(B.audioId) ,0)as aa,,

This doesn’t show up, depressed

白饭米粉

Haha, get it done,, tired,,

Thank you

miosoul's guidance

The method I use is:


strSQL = "select A. field, A. field,..., isnull(count(B.audioId), 0)as aa from A FULL OUTER join B on A.audioId = b.audioId where A.UserId = "+ uid + "Group by A. Field,A,Field,...,"