Hai. I'm a beginner of C#.NET and MySQL. I would like to know how to display selected sql statement to specific column of datagridview. here is my code so far.
public void BindingMetaboliteName(frmMetCon config)
{
schemaForm = new SchemaName();
string connStr = "datasource=localhost;port=3306;username=root;password=root;";
conn = new MySqlConnection(connStr);
command = conn.CreateCommand();
string database = schemaForm.getData;
try
{
dtable = new DataTable();
bindingSource = new BindingSource();
conn.Open();
dbSumMetabolite.ResetBindings();
switch (cmbMetabolite.SelectedIndex)
{
case 0:
command.CommandText = "SELECT MetaboliteID, Metabolite_Name FROM " + database +
".Metabolites " +
"WHERE MetaboliteID IN ('met1', 'met2');";
MySqlDataReader dr = command.ExecuteReader(CommandBehavior.CloseConnection);
dtable.Load(dr);
dbSumMetabolite.AutoGenerateColumns = false;
dbSumMetabolite.DataSource = dtable;
break;
}
conn.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
The column i defined in datagridview is
Metabolite ID | Metabolites Name
and the dbSumMetabolite is my datagridview.