I did the exercise on chapter seven for the selecting-editing-data, it worked fine.
However, I found myself in a situation where I need to apply this concept, so I used and modified the code as per my own need, surprise was that the code, once you click on a desired action says: "The SQL statement that would be executed is: xxxxxxx" amd so on, so it actually doesn't execute the code, rather it puts it on a label. What command should I use, or what should I place so it actually executes the command instead of telling me what the sql command would be...?

Thanks.

Hey,

To execute a select statement, you would do:

mySQLDataAdapter = new SQLDataAdapter("proc, query, or table name", myConnection)
mySQLDataAdapter.SelectCommand.CommandType = CommandType.<appropriate type>
mySQLDataAdapter.Fill(myDataSet, "tableName")

To execute:

mySQLDataAdapter = new SQLDataAdapter()
mySQLDataAdapter.InsertCommand = new SQLCommand("proc, table, or query", myConnection)
mySQLDataAdapter.InsertCommand.CommandTYpe = <appropriate type>

myConnection.Open()
mySQLDataAdapter.InsertCommand.ExecuteNonQuery()
myConnection.Close()

Brian