As you can see I am a beginner. I want to code a website that you add articles or some stories etc. But I don't know how to retrieve these texts from my database. Now. I have a mainpage and "Articles" section. I want to see the articles that I add into my
database called "articles" on this page in order of date. But I don't know how to do that.(Simply it will look like a blog page) WHat should I use? A laber or a textbox or Gridview? Or can you give me an example code to retrieve the articles. I am giving the
information abouıt the database:
DB name: Articlesdb
Table name:Articlest
=columns in the table 0 : ID, Title, Article, Author, Date
You may look at the example located at : http://sdrv.ms/WRKWF0 also please feel free to explore the other demos.
( TextToSQL would be a good example if you are working with SQL server )
Mac14
Member
46 Points
71 Posts
How to retrieve data from the database?
Nov 25, 2012 08:28 AM|LINK
Hello everyone!
As you can see I am a beginner. I want to code a website that you add articles or some stories etc. But I don't know how to retrieve these texts from my database. Now. I have a mainpage and "Articles" section. I want to see the articles that I add into my database called "articles" on this page in order of date. But I don't know how to do that.(Simply it will look like a blog page) WHat should I use? A laber or a textbox or Gridview? Or can you give me an example code to retrieve the articles. I am giving the information abouıt the database:
DB name: Articlesdb
Table name:Articlest
=columns in the table 0 : ID, Title, Article, Author, Date
Thank you!
Basquiat
Contributor
2379 Points
628 Posts
Re: How to retrieve data from the database?
Nov 25, 2012 08:34 AM|LINK
To get started with getting info into a database and retrieving + displaying the info...
Check this Walkthrough http://msdn.microsoft.com/en-us/library/bb532429(v=vs.100).aspx
nikunjnandan...
Participant
872 Points
223 Posts
Re: How to retrieve data from the database?
Nov 26, 2012 01:24 PM|LINK
Hii
See this link
also search on google you can get lots of example.
Nikunj Nandaniya
My Blog
aarsh
Participant
1543 Points
427 Posts
Re: How to retrieve data from the database?
Nov 26, 2012 02:25 PM|LINK
You may look at the example located at : http://sdrv.ms/WRKWF0 also please feel free to explore the other demos. ( TextToSQL would be a good example if you are working with SQL server )
If you are experienceing issues with connection string http://www.connectionstrings.com/ or please post your queries.
Mac14
Member
46 Points
71 Posts
Re: How to retrieve data from the database?
Nov 26, 2012 05:56 PM|LINK
Thank you guys for all your help! :)
I will check the examples and see what's gonna happen :)
Have great day!