How To Access The Data From Database Table In C# Window Form ? I Have Done Coding But Unable To Get The Data. I Have Given The Code Below.

Question

4.00/5 (1 vote)

See more:

C#

MySqlConnection connection;
                string userid = string.Empty;
                string password = string.Empty;
                string connectionString = string.Empty;
                string query = string.Empty; //"INSERT INTO tableinfo (name, age) VALUES('John Smith', '33')";
                userid = UserIDCtrl.Text;
                password = PasswordCtrl.Text;

                //Check empty userid && Password
                CheckForUserIdPasswordEmpty(userid, password);
                 
                
                connectionString = "SERVER=localhost;" + "DATABASE=AshwiniDB;" + "UID=root;" + "PASSWORD=root;"+"PORT=3306;";

                connection = new MySqlConnection(connectionString);

                connection.Open();

                query = "SELECT * FROM logintable WHERE  USERID ='" + userid + "' AND  PASSWORD ='" + password + "'";
                
                

                MySqlCommand cmd = new MySqlCommand(query, connection );

                cmd.ExecuteNonQuery();

                MySqlDataReader dataReader = cmd.ExecuteReader();

                if (dataReader.Read())
                {
                    MessageBox.Show("Login Successful");
                }
                else { MessageBox.Show("Please Enter valid USERID and PASSWORD"); }


                connection.Close();


            }
            catch (Exception x)
            {
                MessageBox.Show(x.Message,"Error",MessageBoxButtons.OK,MessageBoxIcon.Error);
            }

Posted 18-Aug-14 18:38pm

Ashwini. C

Updated 18-Aug-14 18:46pm

Dilan Shaminda

v2

Add a Solution

Comments

Ashi0891 19-Aug-14 0:49am

try removing the statement "cmd.ExecuteNonQuery();"

SRS(The Coder) 19-Aug-14 1:22am

Are you getting any error ?

Sanchayeeta 19-Aug-14 1:29am

I have run this code. I didn't get any error, Even I am getting data also.
I would suggest you to debug it properly. When query string formed, If possible check manually in DB is it returning any value or not.

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)

DamithSL · Answer 1 · 2014-08-18T18:49:00

Solution 1

you can do as below

C#

if(dataReader.Read())
{
    string res = dataReader.GetString(0);
    //...
}

Refer Mysql Documentation for more details
MySqlCommand[^]

Posted 18-Aug-14 18:49pm

DamithSL

Updated 18-Aug-14 18:50pm

v2

NowYouSeeMe · Answer 2 · 2014-08-18T18:56:00

i suppose you are looking for authentication function..

C#

SqlConnection connection = new SqlConnection("YOUR CONNECTION STRING HERE"); 
    string sql = "SELECT * FROM TableName WHERE UserID = @username AND Password = @password"; 
    SqlCommand cmd = new SqlCommand(sql,connection); 
    cmd.Parameters.AddWithValue("@username", user); 
    cmd.Parameters.AddWithValue("@password", pass); 
    connection.Open(); 
  
    DataTable dt = new DataTable(); 
    SqlDataAdapter ad = new SqlDataAdapter(cmd); 
    ad.Fill(dt); 
    if (dt.Rows.Count > 0) { //check if the query returns any data 
        //Valid Username and Password 
        Response.Redirect("Default.aspx"); 
    } 
    else 
    { 
        Response.Write("INVALID Username and Password, Try Again!"); 
    } 
    connection.Close();