取数据库中字段具体类型的方法－－借个地方存一下

[yanlixin4csdn]

在具体开发中遇到想取数据库中字段类型的问题，ado.net中的datacolumn的datatype只能取出对应的.net类型，最后在ado.net技术内幕中找到答案
string columnName;
string columnDateType;
System.Text.StringBuilder sb = new System.Text.StringBuilder();
string mySelectQuery = "SELECT * FROM ylx";

SqlCommand myCommand = new SqlCommand(mySelectQuery,sqlConnection1);
sqlConnection1.Open();
SqlDataReader myReader;
myReader = myCommand.ExecuteReader();
DataTable tb = myReader.GetSchemaTable();

dataGrid1.DataSource= tb;
// Always call Read before accessing data.
foreach (DataRow dr in tb.Rows)
{
columnName = dr["ColumnName"].ToString();
columnDateType=((SqlDbType)dr["ProviderType"]).ToString();

}

// always call Close when done reading.
myReader.Close();
// Close the connection when done with it.
sqlConnection1.Close();

[hbzxf]

你的1分我要顶了，呵呵，刚遇到这样一个难题