Fetching value from Database to textbox

Question

0.00/5 (No votes)

See more:

Hi

Could you pls correct me where i am going wrong.
From database i am retriving the value to textbox.

C#

SqlDataReader reader = null;
        string connectionString = ConfigurationManager.ConnectionStrings["InvoiceConnectionString"].ConnectionString;
        SqlConnection conn = new SqlConnection(connectionString);
        string sqlcommand = "SELECT DoNo from DO where DoNo = DoNo";
        SqlCommand cmd = new SqlCommand(sqlcommand, conn);
        conn.Open();
        reader = cmd.ExecuteReader();
        while (reader.Read())
        {
            dono = reader["DoNo"].ToString();
            dono = DoNotb.Text;
        
        }

i am able to see the value here

C#

{
   dono = reader["DoNo"].ToString();
   dono = DoNotb.Text;
}

finally it is becoming null

Regards
Lancy

Posted 5-Nov-11 2:38am

Lancy.net

Updated 5-Nov-11 2:48am

Sander Rossel

v3

Add a Solution

4 solutions

Solution 3

Assignment is wrong.
you have assign Textbox value to variable. do exactly reverse.

C#

DoNotb.Text = dono;

Posted 5-Nov-11 2:54am

koolprasad2003

Solution 5

Everythings fine. Just assignment is incorrect. You give the value from TextBox which is currently empty to a variable (dono). That is why, dono returning null value;

C#

while(reader.Read())
{
     dono=reader["DoNo"].ToString();
     DoNotb.Text=dono;
}

Posted 5-Nov-11 5:24am

Jyoti Choudhury

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)

AditSheth · Accepted Answer · 2011-11-05T02:49:00

Solution 1

C#

while (reader.Read())
        {
            dono = reader["DoNo"].ToString();
            DoNotb.Text = dono;
        
        }

Posted 5-Nov-11 2:49am

AditSheth

Comments

Sander Rossel 5-Nov-11 8:52am

Same answer as me. Answered at the same time so my 5 :)

Lancy.net 5-Nov-11 8:56am

Thanks i too find just now

Sander Rossel · Accepted Answer · 2011-11-05T02:52:00

I assume DoNotb is your TextBox? In that case your last line of code should be turned around:

C#

dono = reader["DoNo"].ToString();
DoNotb.Text = dono;

You are currently giving the dono variable the value of your TextBox, which is empty.
Instead you should give your TextBox.Text the value of the dono variable, as in my code.
Do notice that the Text in your TextBox is overridden in every new iteration. So you will always end up with the value of the last row in your database.