data population and listview

Question

1.00/5 (1 vote)

See more:

I have a homepage with list view(list of all the documents).The list is actually a list of hyperlinks i.e when I click on the items in the list it displays a document(the content of doc is getting populated from database).

How do I do this?

Any suggestions or advice?

Posted 6-Aug-12 8:10am

Member 8544853

Add a Solution

Comments

[no name] 6-Aug-12 14:14pm

How do you do what? All you have written is the list of the stuff that you already have done. What is the problem that you have? Where is the code that demonstrates the problem that you are having?

Member 8544853 6-Aug-12 14:48pm

I don't have the code right now.We are about to complete the database design and I want to know how to do this because we previously have the the link to doc(which is static and the doc is sitting in content database of sharepoint) and all we doing it right now is taking the content of the doc and putting in sql server database. so I have lot of list views which when clicked should render a doc populating it from database everytime.I want to know, do we keep the hyperlink in database? or how do we do it?

Kenneth Haugland 6-Aug-12 14:15pm

Whats stopping you from trying to do this? I dont get that....

Sergey Alexandrovich Kryukov 6-Aug-12 14:16pm

It depends on what do you want. Why ADO.NET? It could be even a static list with constant links, updated from time to time. If you need to introduce database, you should have enough reasons for that. If you need to populate the list view in response do different requests of have any other complex scenario, it's a different story. But then, this is a most usual task for ADO.NET + ASP.NET (tag it then), so what's the problem?
--SA

Member 8544853 6-Aug-12 15:26pm

Just like this site we are using for posting and reply, but this is static text.
I want this text to be loaded from database when I click on the link.

Sandeep Mewara 6-Aug-12 14:34pm

Suggestion for what? DB connection or listview ?

Member 8544853 6-Aug-12 16:20pm

can we keep the hyperlinks in database?
My Scenario:
There is content in a row in db and when user clicks the link the a HTML DOC is rendered by populating the content from the database and there are multiple docs related to this rendered doc.
so can we keep the related docs links along with the content in that row of content.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sergey Alexandrovich Kryukov · Answer 1 · 2012-08-06T08:30:00

Solution 1

Perhaps you might use some beginner's articles on ADO.NET, ASP.NET and how they can work together. Please see:
Using ADO.NET for beginners[^],
Data Binding in WebControls[^],
Complete ListView in ASP.NET 3.5[^],
…

You will find a lot more in CodeProject and elsewhere: http://www.codeproject.com/search.aspx?q=ADO.NET+ASP.NET&doctypeid=1[^].

—SA

Posted 6-Aug-12 8:30am

Sergey Alexandrovich Kryukov

Comments

Member 8544853 6-Aug-12 14:58pm

I don't have the code right now.We are about to complete the database design and I want to know how to do this because we previously have the the link to doc(which is static and the doc is sitting in content database of sharepoint) and all we doing it right now is taking the content of the doc and putting in sql server database. so I have lot of list views which when clicked should render a doc populating it from database everytime.I want to know, do we keep the hyperlink in database? or how do we do it?

Sergey Alexandrovich Kryukov 6-Aug-12 15:27pm

It depends on other operations. Of course, you always can keep them in the database, if this is in line with all of your programming chores. While working at database design, read about ADO.NET + ASP.NET, ASP.NET control binding.
--SA