我是一个新手,我试图从数据库中的某个表中检索列名称、大小(最大长度)和数据类型,当我执行以下代码时,希望它显示所有列类型和名称(我没有找到如何引用 Size ,我使用了 ColumnSize 但据说 DataColumn 不包含此方法的定义)
但执行时,它只显示:IsColumnSetSystem.Boolean
这是代码:
private void button1_Click(object sender, EventArgs e)
{
string EF = textBox1.Text;
try{
//SqlDataAdapter adapter = SetupDataAdapter("SELECT * FROM id_declarant");
SqlCommand comm = new SqlCommand();
string connectionString = @"Data Source=.\SQLEXPRESS;Initial Catalog=declaration;Integrated Security=True";
comm.Connection=new SqlConnection(connectionString);
String sql = @"SELECT *
FROM id_declarant,declarant
WHERE (declarant.Nom_pren_RS='" + EF + "') and (id_declarant.mat_fisc=declarant.mat_fisc) ";
comm.CommandText = sql;
comm.Connection.Open();
SqlDataReader reader = comm.ExecuteReader();
DataTable schemaTable = reader.GetSchemaTable();
foreach (DataRow row in schemaTable.Rows)
{
foreach (DataColumn column in schemaTable.Columns)
{
System.IO.File.WriteAllText(@"C:\Users\Manuela\Documents\GL4\WriteLines.txt", column.ColumnName + column.DataType );
}
}
也许我对这一点有点偏离,但要获取列的名称、大小和数据类型,您可以尝试以下操作:
DataTable schemaTable = reader.GetSchemaTable();
foreach (DataRow row in schemaTable.Rows)
{
var name = row["ColumnName"];
var size = row["ColumnSize"];
var dataType = row["DataTypeName"];
//append these to a string or StringBuilder for writing out later...
}
但也许这不是你所追求的?
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)