Database Exception when binding datagrid

Question

public void FillGrid()
{
    string connString = "Server =localhost;Port = 3306; Database =lbmtcs; UID =serverUser; Password =";
    MySqlConnection Pathway = new MySqlConnection(connString);

    string gridView = "SELECT PIN, Status, Cert_Title_No, Owner_Name, Co_Owner, Street, Barangay FROM landrecord"
                        +"WHERE PIN = @pin, Status = @Stat AND Cert_Title_No = @Cert AND Owner_Name = @Owner AND Co_Owner = @CO AND Street = @St AND Barangay = @Bar";
    MySqlCommand grid = new MySqlCommand(gridView, Pathway);
    MySqlDataAdapter MyDA = new MySqlDataAdapter();
    MySqlCommandBuilder cmd = new MySqlCommandBuilder(MyDA);
    MyDA.SelectCommand = grid;

    DataTable table = new DataTable();
    MyDA.Fill(table);

    BindingSource bSource = new BindingSource();
    bSource.DataSource = table;
    dGrid.DataSource = bSource;

}

MySqlException was unhandled:

Fatal error encountered during command execution.

Whats wrong in the code?

I'm selecting some columns to show in my datagrid.

for starters I would change the gridView variable to be something like strSQL 2nd where are you creating the Parameters..? Pathway change that to sqlConn clean up your code a bit and use variables that make sense just FYI — MethodMan
– MethodMan, Commented Sep 17, 2012 at 16:04
Do you just want to display data or are you planning on saving and updating etc? Let me know as it changes the answer. — dash
– dash, Commented Sep 17, 2012 at 16:27
thanks dash.. followed what u posted.. this is new error.. cant seem to find the right type.. i used int in my database.. Incorrect format on DbType.. all Int creates this error — Domtican Jimenez Kipas
– Domtican Jimenez Kipas, Commented Sep 17, 2012 at 16:37
MySqlParameter parameter = new MySqlParameter() { ParameterName = "@pin", DbType = DbType.Int32, Value = Int32.Parse(txtPin.Text) }; whats wrong with this code? Error is Incorrect FOrmat — Domtican Jimenez Kipas
– Domtican Jimenez Kipas, Commented Sep 17, 2012 at 16:45

gsharp · Accepted Answer · 2012-09-17 16:04:40Z

2

Between @pin and Status should be an AND and not a ,

answered Sep 17, 2012 at 16:04

gsharp

28k26 gold badges93 silver badges137 bronze badges

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

1 Comment

Domtican Jimenez Kipas Over a year ago

changed my code to what u all said.. still same error.. this is what im trying to do. input from textbox ->data to mysql database then datagrid will show whats inside the database.

Collectives™ on Stack Overflow

Database Exception when binding datagrid

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related