BulletedList control
-
<asp:SqlDataSource ID ="myid" ConnectionString = "server = .\sqlexpress; integrated security = True; database = northwind;" SelectCommand = "select LastName from employees " runat = "server" /> <asp:BulletedList runat="server" DataSourceID = "myid"/> and its output * System.Data.DataRowView * System.Data.DataRowView * System.Data.DataRowView * System.Data.DataRowView * System.Data.DataRowView * System.Data.DataRowView * System.Data.DataRowView * System.Data.DataRowView * System.Data.DataRowView * System.Data.DataRowView * System.Data.DataRowView * System.Data.DataRowView i want it to be LastName not its default ToString();
-
<asp:SqlDataSource ID ="myid" ConnectionString = "server = .\sqlexpress; integrated security = True; database = northwind;" SelectCommand = "select LastName from employees " runat = "server" /> <asp:BulletedList runat="server" DataSourceID = "myid"/> and its output * System.Data.DataRowView * System.Data.DataRowView * System.Data.DataRowView * System.Data.DataRowView * System.Data.DataRowView * System.Data.DataRowView * System.Data.DataRowView * System.Data.DataRowView * System.Data.DataRowView * System.Data.DataRowView * System.Data.DataRowView * System.Data.DataRowView i want it to be LastName not its default ToString();
You are missing DataTextField binding. Specify the control's DataSourceID property. Specify at the very least the required DataTextField. The value of each record in this field will then be displayed as the text of each item in the list. So, you need to do:
-
<asp:SqlDataSource ID ="myid" ConnectionString = "server = .\sqlexpress; integrated security = True; database = northwind;" SelectCommand = "select LastName from employees " runat = "server" /> <asp:BulletedList runat="server" DataSourceID = "myid"/> and its output * System.Data.DataRowView * System.Data.DataRowView * System.Data.DataRowView * System.Data.DataRowView * System.Data.DataRowView * System.Data.DataRowView * System.Data.DataRowView * System.Data.DataRowView * System.Data.DataRowView * System.Data.DataRowView * System.Data.DataRowView * System.Data.DataRowView i want it to be LastName not its default ToString();
-
Also set DataTextField of your BulletedList, because without it,How BulletedList list come knowthat what to show.Use following code
Let me know if still face problem.
Cheers!! Brij
The same answer has been posted by Sandeep.
Cheers ! Abhijit Codeproject MVP
-
The same answer has been posted by Sandeep.
Cheers ! Abhijit Codeproject MVP
-
Hmm... that may be and sometime it's happens too. But that does not mean that you vote the post "1" without any reason (If you voted). :thumbsdown:
Cheers ! Abhijit Codeproject MVP