Hi there,
I tried to fired a query to get the list of users.
When I run the query in SQL, I got two set of result.
So how can I put the result in a label in asp.net?
I tried the following code but the result is shown only one result.
protected void frmtestingpwe_Load(object sender, EventArgs e)
{
string id = "2091";
string sqlQuery;
sqlQuery = " SELECT flist.FUserID ";
sqlQuery += " FROM cm_userFriendList as flist INNER JOIN cs_NotificationSubsciption as subs ON subs.UserID = flist.FUserID";
sqlQuery += " WHERE flist.UserID = @ID AND subs.PostIsSubscribe = '1' AND flist.isDelete = 0 AND flist.Status=1";
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["MSSQLConnectionString"].ToString()))
{
try {
...
Go to the complete details ...