How can I display MySQL database table user info in c sharp

[Aviator4Life]

Hi all

I am a new c sharp programmer and I was looking at this code:

private void button1_Click(object sender, EventArgs e)
{
string input = textBox3.Text;
connectdatabase();
string wow = "SELECT `CustomerName` FROM `CustomerInfo`";
MySqlCommand wowcmd = new MySqlCommand(wow, connection);
MySqlDataReader Reader;
Reader = wowcmd.ExecuteReader();
while (Reader.Read())
{
if (input == Convert.ToString(Reader))
{
textBox5.Text = Convert.ToString(Reader);
}
}


}
Post Reply

And I was wondering if anyone could rewrite the code so that it display the MySQL table data for a specific user I already have a string called username and that stores the username entered on the login form. I want the code to use the username string to search for the name and display that users info.

My table contents are: username
First name
Last name
Position
Employee Id
Airline

If you do this it would be greatly appreciated

[PsychoCoder]

Sorry but this isnt a code writing repository, so we're not going to rewrite your code

[Aviator4Life]

Can you at least tell me what too do

[Grim]

There is an example in MySQL Conenctor .Net, just look at it.

[PsychoCoder]

The only thing you need to do is to change your query. So change this

string wow = "SELECT `CustomerName` FROM `CustomerInfo`";

to this

string wow = "SELECT `CustomerName` FROM `CustomerInfo` where <Your Column> = <YourVariable>";

What you've done there is tell it to return everything for a certain user. Hope that helps.

Happy Coding!

[ariful alam]

select `first_name` + ' ' + `last_name` from `<table_name>` where username = <your variable name>

[Aviator4Life]

Thank you all for the help greatly appreciated guess I'm sticking with this for cause daniweb takes weeks to reply

[PsychoCoder]

Glad we could help you with this.