Discussion forums for open issues and questions concerning database tools, data access components and developer tools from Devart
https://forums.devart.com/
Code: Select all
mySqlDataTable1.SelectCommand.Parameters.Add("paramName", MySqlType.Int);As I have mentioned before I have filled DataTable with data from database, but I dont know of what type specified column is. But I can get Column data Type like that DataTable.Column[].DataType , but it is not MysqlType which is needed in Parameters but Type. How can I know what MysqlType corespod to which Type.Alexey wrote:Please describe in detail what exactly you need or what is the problem.
Take a look at the code below:Code: Select all
mySqlDataTable1.SelectCommand.Parameters.Add("paramName", MySqlType.Int);
Code: Select all
select * from I need to know it at run time.Alexey wrote:If you need to know colunms' data types of any table, create a MySqlDataAdapter, configure it with select command likePress Preview button and then press Schema Tables button.Code: Select all
select * from
Code: Select all
MySqlConnection conn = new MySqlConnection("");
MySqlCommand cmd = new MySqlCommand("select * from ", conn);
conn.Open();
MySqlDataReader reader = cmd.ExecuteReader();
DataTable dt = reader.GetSchemaTable();And how am I suposed to use this column data type obtained by your sniplet in:Alexey wrote:Then use the following code:Code: Select all
MySqlConnection conn = new MySqlConnection(""); MySqlCommand cmd = new MySqlCommand("select * from ", conn); conn.Open(); MySqlDataReader reader = cmd.ExecuteReader(); DataTable dt = reader.GetSchemaTable();
Code: Select all
MySqlConnection conn = new MySqlConnection("");
MySqlCommand cmd = new MySqlCommand("select * from where =:", conn);
DataTable dt = conn.GetSchema("Columns", new string[] { "", "", "%" });
cmd.Parameters.Add("", dt.Rows[].ItemArray[dt.Columns["DataType"].Ordinal].ToString());
cmd.Parameters[""].Value = ;
MySqlDataReader reader = cmd.ExecuteReader();