how to fetch a row from sql server 2008,in C# ASP.NET

dreamyeyes.ankur

Rate me:

0.00/5 (No votes)

7 Oct 2012CPOL

28K

Hi,I am designing a webPage..Kindly read below points for my requirements.....I have a button,on the click event of button,I want a row to be fetched from SQL server 2008.......Colums in my SQL table is Source, destination, date, time, summary I want to fetch summary based on...

Alternatives

Members may post updates or alternatives to this current article in order to show different approaches or add new features.

1. how to fetch a row from sql server 2008,in C# ASP.NET

7 Oct 2012Peeyush Pachaori

Check out this video- its for sql server 2005 but it makes no difference for you.http://www.youtube.com/watch?v=8FE3hqn9z1E[^]On the button click you need to send get/post request. I will advise you to use ajax. Just google around how based on which kind of GUI architecture you are using.

SQL-Server

SQL-Server-2008

ASP.NET

2. how to fetch a row from sql server 2008,in C# ASP.NET

7 Oct 2012Sandeep Mewara

Well, by using a Connection String[^] you can connect to database. Further info regarding the data communication can be read here: MSDN: Accessing data with ADO.NET[^]Beginners guide to accessing SQL Server through C#[^]

SQL-Server

SQL-Server-2008

ASP.NET

3. how to fetch a row from sql server 2008,in C# ASP.NET

7 Oct 2012Pr!y@

User Name Space - using System.Data.SqlClient;Make connection to Data Base : Use SQLConnection Class. SqlConnection con = new SqlConnection("server=Harshit-PC; database=YourDataBaseName; uid=YourSQLuid; pwd=YourSQLPassword");Wants Records On Button Click Then :Your Need Two...

SQL-Server

SQL-Server-2008

ASP.NET