How to change DataType into coresponding MySqlType ??

[AceEmbler]

I have got DataTable.Column[].DataType how to change it into MySqlType.

I need it for parameters in MysqlDataTable.UpdateCommand.

[Alexey]

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);

[AceEmbler]

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);

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]

If you need to know colunms' data types of any table, create a MySqlDataAdapter, configure it with select command like

Code: Select all

select * from 

Press Preview button and then press Schema Tables button.

[AceEmbler]

If you need to know colunms' data types of any table, create a MySqlDataAdapter, configure it with select command like

Code: Select all

select * from 

Press Preview button and then press Schema Tables button.

I need to know it at run time.

[Alexey]

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();

[AceEmbler]

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();

And how am I suposed to use this column data type obtained by your sniplet in:
UpdateCommand.Parameters.Add(); //??

[Alexey]

OK, use GetSchema() method of MySqlConnection component:

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();