Retrieve data from Database

Question

0.00/5 (No votes)

See more:

Hi, I am a beginner in asp.net c# and I want to Retrieve data from Database & Display into ASP.NET Textbox controls using SQL Stored Procedure?. plz help me...

Posted 21-Oct-11 1:08am

Rajirima

Add a Solution

2 solutions

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)

kiran dangar · Answer 1 · 2011-10-21T01:30:00

you can use ADO.net to retrieve data from database.

If you want only single value from database to display in Textbox then you can use ExecuteScalar() ...

I am assuming you are using SQL server database.. Follow this link : http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlcommand.executescalar.aspx[^]

If you want to use Stored Procedure instead of Inline query then set CommantType attribute as given below...

C#

System.Data.SqlClient.SqlCommand objCommand = new System.Data.SqlClient.SqlCommand();
                objCommand.CommandType = System.Data.CommandType.StoredProcedure;

Hope this will help...

Mantu Singh · Answer 2 · 2011-10-21T01:21:00

You need to use ADO.NET classes if you are to perform the task programatically

C# code

C#

using System.Data.SqlClient;

//in your class or method .........
SqlConnection con=new SqlConnection("write connection string here");
con.Open();

SqlCommand cmd=new SqlCommand("my_procedure",con);
SqlDataReader dr=cmd.ExecuteReader();
while(dr.Read())
{
textBox1.Text=dr[0].ToString();
}

these links may be helpful
how to display data from sql database to textbox using C#.net[^]

http://forums.cnet.com/7723-6615_102-219037.html[^]

Use this code Best of Luck.......

Retrieve data from Database

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0