怎样获取一张表里所有字段

[liujb526]

哪位高手进来指点下啊.
C#中怎样获取一张表里所有字段

[yumanqing]

using System.Data.SqlClient;
SqlConnection con = new SqlConnection();
con.ConnectionString = "Persist Security Info=false;Initial Catalog=ycqry2;User Id=sa;Password=;server=" + DB.LoginServer();

con.Open();

int year = System.DateTime.Now.Year;

//不同年对应的用友数据库
string UFDFcode="select * from UFDFcode where cYear="+year;
SqlCommand cmdUFDAcode = new SqlCommand(UFDFcode, con);
SqlDataReader drUFDFcode = cmdUFDAcode.ExecuteReader();

string UFDatabaseOld = "";
string UFDatabaseNew = "";
while (drUFDFcode.Read())
{
UFDatabaseOld=drUFDFcode.GetString(1);
UFDatabaseNew=drUFDFcode.GetString(2);
}
drUFDFcode.Close();

[lovehongyun]

问题讲明白了吗??

[懒牛科技]

select * from table

[nayc]

select * from table

[terry_12]

SELECT TABLE_CATALOG AS [Database], TABLE_SCHEMA AS Owner, TABLE_NAME AS TableName, COLUMN_NAME AS ColumnName, ORDINAL_POSITION AS OrdinalPosition, COLUMN_DEFAULT AS DefaultSetting, IS_NULLABLE AS IsNullable, DATA_TYPE AS DataType, CHARACTER_MAXIMUM_LENGTH AS MaxLength, DATETIME_PRECISION AS DatePrecision,COLUMNPROPERTY(object_id(TABLE_NAME), COLUMN_NAME, 'IsIdentity') as IsIdentity
FROM INFORMATION_SCHEMA.COLUMNS WHERE (TABLE_NAME = '表名')

[hbx1982]

SELECT TableColumns.Name ColumnName
FROM SYSOBJECTS Tables, SYSCOLUMNS TableColumns
WHERE Tables.ID = TableColumns.ID
AND Tables.Name = '表名'

[popeye627]

select name from syscolumns where id=object_id('table')

[woshibai112]

up
大家的都是SQL语句
楼主是想问C#这样连接数据库吧!

[Jinwmmail]

推荐 popeye627(一曲肝肠断，天涯何处觅知音？) 的

select name from syscolumns where id=object_id('table')

[liujb526]

呵呵
Jinwmmail这位大哥才是我想要的。