displaying i datalist

Posted by Klbaiju under ASP.NET on 10/21/2009 | Views : 1155 | Status : [Member] | Replies : 4
Hi ,
I have a table college with fields
cname nvarchar(50)
cid int
place nvarchar(50)
courses nvarchar(60)
suppose a record contains
cname cid place courses
KVNCOLLEGE 100 Bangalore computer science,mechanical,civil

means 3 courses in kvn college
i want to display this record in datalist as follows
Kvn college
courses:computer science
mechanical
civil
how to write the query

Regards
K L BAIJU




Responses

Posted by: Virendradugar on: 10/21/2009 [Member] [MVP] Silver

Up
0
Down
Hi,

Your query should be

Select Cname, Courses from college where cid = 100


Thanks,
Virenda Dugar

Klbaiju, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Santosh4u on: 10/21/2009 [Member] Bronze

Up
0
Down
hi Klbaiju
plz tell clearly in datalist how u want to show??
i am not getting the Question Correctly.

Regards
Santosh



Klbaiju, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Klbaiju on: 10/21/2009 [Member] Starter

Up
0
Down
Hi friend

in my table 3 fields

collegename,id,place,courses
in the following record , computer science,mechanical,civil are in 1 field.

KVNCOLLEGE | 100| Bangalore| computer science,mechanical,civil
i want to display in datalist like this

Name Id place courses
KVN college 100 bangalore computerscience
mechanical
civil
is it possible

Regards
Baiju

Klbaiju, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Klbaiju on: 10/21/2009 [Member] Starter

Up
0
Down
computer science
mechanical
civil

should come below courses

Klbaiju, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response