Display Data from database via textbox

Question

1.00/5 (1 vote)

See more:

C#

ASP.NET

How do i display data from database via textbox and how to edit that value

Posted 13-Apr-14 7:35am

Bajpangosh

Add a Solution

Comments

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 13-Apr-14 13:45pm

By coding. Did you try?

Nirav Prabtani 13-Apr-14 14:06pm

:) :) :) :P I don't think he tried...

Sergey Alexandrovich Kryukov 13-Apr-14 16:09pm

First of all, when you say "TextBox", the question is: which one? Full type name, please. There are different types named "TextBox". Which one?
—SA

4 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)

Manas Bhardwaj · Answer 1 · 2014-04-13T07:50:00

Solution 1

Open Visual Studio (you can use NotePad as well, but it's just easy) and start writing code. That's it.

Ok, that's not what you expect. But this is what you get when you don't even care to explain what you exactly want to do and what have you have tried so far.

My guess is you are looking for cooked code here but I am sorry to disappoint you that is not going to happen.

Please go back and show us what you have done and then come back if you face issues.

People would be more than happy to help you here.

Posted 13-Apr-14 7:50am

Manas Bhardwaj

Comments

Bajpangosh 13-Apr-14 14:15pm

SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["VeinConnectionString"].ConnectionString);
protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)
{
bindata();
}

}

public void bindata()
{
SqlCommand cmd;
SqlDataReader dr;
cmd = new SqlCommand("select * from shops where Id=" + Request.QueryString["Id"].ToString());
cmd.Connection = con;
cmd.ExecuteNonQuery();
dr = cmd.ExecuteReader();
while (dr.Read())
{
Shops.Text = dr["Shops"].ToString();
Reviews.Text = dr["Reviews"].ToString();

Website.Text = dr["Website"].ToString();
Fbpage.Text = dr["Fbpage"].ToString();
Phone.Text = dr["Phone"].ToString();
Email.Text = dr["Email"].ToString();
Place.Text = dr["Place"].ToString();
Latitude.Text = dr["Latitude"].ToString();

Longitude.Text = dr["Longitude"].ToString();

}

}

Bajpangosh 13-Apr-14 14:16pm

here is my cs code but how to display these fetched datas on aspx page..?

Maciej Los · Answer 2 · 2014-04-13T08:17:00

Solution 2

Have a look here: ASP.NET - Binding to Databases[^]
Building Secure ASP.NET Applications: Authentication, Authorization, and Secure Communication[^]
How To: Protect From SQL Injection in ASP.NET[^]

Posted 13-Apr-14 8:17am

Maciej Los

Updated 13-Apr-14 8:19am

v2

Comments

Manas Bhardwaj 13-Apr-14 16:21pm

+5!

Maciej Los 13-Apr-14 16:43pm

Thank you ;)

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) · Answer 3 · 2014-04-13T08:23:00

Solution 3

Quote:
here is my cs code but how to display these fetched datas on aspx page..?

You are already showing on aspx controls, I believe.

C#

Shops.Text =  dr["Shops"].ToString();
Reviews.Text = dr["Reviews"].ToString();

Website.Text = dr["Website"].ToString();
Fbpage.Text = dr["Fbpage"].ToString();
Phone.Text = dr["Phone"].ToString();
Email.Text = dr["Email"].ToString();
Place.Text = dr["Place"].ToString();
Latitude.Text = dr["Latitude"].ToString();

Longitude.Text = dr["Longitude"].ToString();

Here these are aspx controls and you are already assigning the values from database.

Posted 13-Apr-14 8:23am

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ)

Updated 13-Apr-14 8:24am

v2

Comments

Bajpangosh 13-Apr-14 14:27pm

but help me to display these fetched datas on text box.

just drag the textbox and change the id. is it works or teach me the right way :(

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 13-Apr-14 14:41pm

Yeah you can drag one TextBox from Toolbar, else you can write directly...

One TextBox code would look like...

<asp:TextBox ID="txtSomeName" runat="server"></asp:TextBox>

Then from code, you can assign some value like...

txtSomeName.Text = dr["Shops"].ToString();

Bajpangosh 13-Apr-14 14:46pm

run time it's shows an error :(

An exception of type 'System.NullReferenceException' occurred in App_Web_bly0ny4p.dll but was not handled in user code

it's pop-out from

cmd = new SqlCommand("select * from shops where Id=" + Request.QueryString["Id"].ToString());

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 13-Apr-14 14:55pm

That means there is no query string. It is null. So, NullReferenceException is coming.

Always check for null like...

if(Request.QueryString["Id"] != null && !string.IsNullOrEmpty(Request.QueryString["Id"].ToString()))
{
cmd = new SqlCommand("select * from shops where Id=" + Request.QueryString["Id"].ToString());
}

Bajpangosh 13-Apr-14 22:10pm

thx for helping me bro. maybe it's works but am a newbie in visual studio :(

when i put this code on cs

it's shows an compile error

//Error 19 Use of unassigned local variable 'cmd'

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 13-Apr-14 23:27pm

That is because you need to put all the codes inside the if clause. When query string exists, it would do all operations. So...

if(Request.QueryString["Id"] != null && !string.IsNullOrEmpty(Request.QueryString["Id"].ToString()))
{
cmd = new SqlCommand("select * from shops where Id=" + Request.QueryString["Id"].ToString());
cmd.Connection = con;
cmd.ExecuteNonQuery();
dr = cmd.ExecuteReader();
while (dr.Read())
{
Shops.Text = dr["Shops"].ToString();
Reviews.Text = dr["Reviews"].ToString();

Website.Text = dr["Website"].ToString();
Fbpage.Text = dr["Fbpage"].ToString();
Phone.Text = dr["Phone"].ToString();
Email.Text = dr["Email"].ToString();
Place.Text = dr["Place"].ToString();
Latitude.Text = dr["Latitude"].ToString();

Longitude.Text = dr["Longitude"].ToString();
}
}

Manas Bhardwaj 13-Apr-14 16:21pm

Good +5!

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 14-Apr-14 0:15am

Thanks. :)

Sergey Alexandrovich Kryukov · Answer 4 · 2014-04-13T10:12:00

Solution 4

Use ADO.NET:
http://en.wikipedia.org/wiki/Ado.net[^],
http://msdn2.microsoft.com/en-us/library/aa286484.aspx[^].

This short and clear CodeProject article can help you to get started in no time: Using ADO.NET for beginners[^].

—SA

Posted 13-Apr-14 10:12am

Sergey Alexandrovich Kryukov