c# Dynamic Query into DataTable?

Question

I want to make a function wich sends a query to a remote mysql server and puts the data into a DataTable object dynamically, my problem now is to get the values out of the reader and fill that object entirely. If I get 1 row out of the reader its not the whole data, if I get 10 its a out of range error. I dont want to make this bound to a specific table.

    ...
    oCon = new MySqlConnection(...)
    ...        

    private DataTable query(MySqlCommand command, DataTable pattern)
    {
        DataTable table = pattern;
        oCon.Open();
        MySqlDataReader reader = command.ExecuteReader();
        while (reader.Read())
        {
            for (int i = 0; i < table.Columns.Count; i++)
            {
                table.Rows.Add(What here?);
            }
        }
        reader.Close();
        oCon.Close();
        return table;
    }

Mez · Accepted Answer · 2014-04-20 21:34:25Z

1

You need to use the GetName function.

MySqlDataReader resultSet = cmd.ExecuteReader();
dt.Columns.Clear();
for (int i = 0; i < resultSet.FieldCount; i++)
{
    dt.Columns.Add(resultSet.GetName(i));
}
dt.Load(resultSet);

answered Apr 20, 2014 at 21:34

Mez

4,7364 gold badges32 silver badges58 bronze badges

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

Collectives™ on Stack Overflow

c# Dynamic Query into DataTable?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related