ASP.NET

SET ANSI_WARNINGS OFF<br />
Declare @ono varchar(50)<br />
DECLARE My_Cursor CURSOR FOR<br />
SELECT distinct ProductID<br />
FROM Products<br />
<br />
drop table tmp<br />
create table tmp(ono varchar(50),allname varchar(50))<br />
<br />
OPEN My_Cursor<br />
<br />
FETCH NEXT FROM My_Cursor into @ono<br />
WHILE @@FETCH_STATUS = 0<br />
BEGIN<br />
DECLARE @MyList varchar(100)<br />
set @MyList = null<br />
SELECT  @MyList = COALESCE(@MyList + ', ', '') + <br />
   CAST(CategoryID AS varchar(5))<br />
FROM Products where ProductID = @ono<br />
insert into tmp(ono,allname) values(@ono,@MyList)<br />
    FETCH NEXT FROM My_Cursor into @ono<br />
END<br />
<br />
CLOSE My_Cursor<br />
DEALLOCATE My_Cursor<br />
<br />
select * from tmp<br />
<br />

Piyush Vardhan Singh wrote:

or this (format([StartDateTime],"hh mm ss") As StartTime) we get time in Ms Access but it not return AM/PM.

Piyush Vardhan Singh wrote:

(format([StartDateTime],"hh mm ss") As StartTime

foreach(DataRow dr in ds.Tables[0].Rows)<br />
               {<br />
                   TreeNode tn = new TreeNode();<br />
                   tn.Text = dr["name"].ToString();<br />
                   dataTRV.Nodes.Add(tn);<br />
                   TreeNode ctn = new TreeNode();<br />
                   ctn.Text =  dr["id"].ToString();<br />
                   tn.ChildNodes.Add(ctn);<br />
                   TreeNode ctn1 = new TreeNode();<br />
                   ctn1.Text =  dr["sal"].ToString();<br />
                   ctn.ChildNodes.Add(ctn1);<br />
               }

Imran Khan Pathan wrote:

Hi "Sherin" please delete your post or modify.