how to display data from mysql in textboxes

Question

0.00/5 (No votes)

See more:

MySqlDataReader myReader = null;
MySqlCommand myCommand = new MySqlCommand("select * from users where user_name='" + Session["user"] + "'", con);

myReader = myCommand.ExecuteReader();

while (myReader.Read())
{
TextBox4.Text = (myReader["user_name"].ToString());
}

HTML

i want to display data from db into textboxes but this code dont work help me please

Posted 14-Aug-14 22:51pm

ben.josey

Updated 27-Nov-20 13:44pm

v2

Add a Solution

Comments

Ashi0891 15-Aug-14 5:21am

ofcourse it doesn't. You are getting *(all coumns) from database and showing it in one textbox, and you think it will work?
secondly.. you dnt get value from reader this way. please check my solution.

3 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Kim Togo · Accepted Answer · 2014-08-15T01:23:00

Just make it really simple. If you only want 1 column to be display. Do not use "SELECT *", but select only does columns that you need.

C#

MySqlCommand myCommand = new MySqlCommand("SELECT lastlogin FROM users WHERE user_name=@userName", con);
myCommand.Parameters.AddWithValue("userName", Session["user"].ToString());

object result = myCommand.ExecuteScalar();

if (result == null)
{
  TextBox4.Text = "User not found";
}
else
{
  TextBox4.Text = result.ToString();
}

Ashi0891 · Accepted Answer · 2014-08-14T23:21:00

for SQL:

SqlCommand cmd = new SqlCommand(select <column_1>,<column_2> from <table_name> where <any_condition>, conn);
                conn.Open();
                SqlDataReader dr = cmd.ExecuteReader();
                while (dr.Read())
                {
                    Label4.Text = dr[0].ToString(); // [0] for <column_1>
                    Label5.Text = dr[1].ToString(); // [1] for <column_2>
                }

in your case:

MySqlCommand myCommand = new MySqlCommand("select <column_name> from users where user_name='" + Session["user"] + "'", con);
con.open();
Mysqldatareader myReader = myCommand.ExecuteReader();
while (myReader.Read())
{
TextBox4.Text = myReader[0].ToString();
}
conn.close();

enjoy! :)

ben.josey · Accepted Answer · 2014-08-14T23:57:00

MySqlConnection con = new MySqlConnection();

MySqlCommand com = new MySqlCommand();

MySqlDataReader dr;

con = new MySqlConnection(ConfigurationManager.ConnectionStrings["netConnectionString"].ToString());
con.Open();
com = new MySqlCommand("select password from users where user_name='" + Session["user"] + "'", con);
dr = com.ExecuteReader();
if (dr.Read())
{
Label6.Text = dr[0].ToString();
TextBox4.Text = dr[0].ToString();
}

how to display data from mysql in textboxes

3 solutions

Solution 3

Solution 1

Solution 2

Add your solution here

Preview 0

how to display data from mysql in textboxes

3 solutions

Solution 3

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us