Select from mysql database with c#.net winforms - how to check response?

Question

I'm adding a record into remote mysql database and after that I want to check if it's added - So i want to try to select this particular record.

My code:

    public void Select(string filename)
    {
        string query = "SELECT * FROM banners WHERE file = '"+filename+"'";

        //open connection
        if (this.OpenConnection() == true)
        {
            //create command and assign the query and connection from the constructor
            MySqlCommand cmd = new MySqlCommand(query, connection);

            //Execute command
            cmd.ExecuteNonQuery();

            //close connection
            this.CloseConnection();
        }
    }

How to check the response from the server? Or selected records? It's c# windows forms app.

You may use datatable to be filled with the data either by SqlDataReader or SqlDataAdapter. Now just check rowcount over datatable object. — user841123
– user841123, Commented Jul 19, 2012 at 5:00

user1088520 · Accepted Answer · 2012-07-18 23:51:43Z

2

Instead of making another round-trip (with additional select) you can expand you insert statement by

SELECT LAST_INSERT_ID();

execute your insert command

command.ExecureQuery();

and get the ID of the last inserted record.

Have a look at MySQL Information Functions

answered Jul 18, 2012 at 23:51

user1088520

Sign up to request clarification or add additional context in comments.

Comments

Chandu · Accepted Answer · 2012-07-18 23:42:45Z

Try this:

public void Select(string filename)
{
        string query = "SELECT * FROM banners WHERE file = '"+filename+"'";

        //open connection
        if (this.OpenConnection() == true)
        {
                //create command and assign the query and connection from the constructor
                MySqlCommand cmd = new MySqlCommand(query, connection);

                //Get the DataReader from the comment using ExecuteReader
                            MySqlDataReader reader = cmd.ExecuteReader(); 
                while (myReader.Read())  
                { 
                    //Use GetString etc depending on the column datatypes.
                    Console.WriteLine(myReader.GetInt32(0)); 
                } 

                //close connection
                this.CloseConnection();
        }
}

Check this URL for more info: http://msdn.microsoft.com/en-us/library/haa3afyz(v=vs.100).aspx

PraveenVenu · Accepted Answer · 2012-07-19 04:57:40Z

0

You can do it when you run command.ExecuteNonQuery() for INSERT statement itself. command.ExecuteNonQuery() returns the number of rows affetced (inserted in your case). So

if(command.ExecuteNonQuery()>0)
{
 //inserted
}
else
{
 //Not inserted
}

http://dev.mysql.com/doc/refman/5.1/en/connector-net-ref-mysqlclient.html#connector-net-ref-mysqlclient-mysqlcommand-executenonquery

answered Jul 19, 2012 at 4:57

PraveenVenu

8,3674 gold badges32 silver badges39 bronze badges

Collectives™ on Stack Overflow

Select from mysql database with c#.net winforms - how to check response?

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related