怎样获取一张表里所有字段
哪位高手进来指点下啊.
C#中怎样获取一张表里所有字段
[解决办法]
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();
[解决办法]
问题讲明白了吗??
[解决办法]
select * from table
[解决办法]
select * from table
[解决办法]
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 = '表名 ')
[解决办法]
SELECT TableColumns.Name ColumnName
FROM SYSOBJECTS Tables, SYSCOLUMNS TableColumns
WHERE Tables.ID = TableColumns.ID
AND Tables.Name = '表名 '
[解决办法]
select name from syscolumns where id=object_id( 'table ')
[解决办法]
up
大家的都是SQL语句
楼主是想问C#这样连接数据库吧!
[解决办法]
推荐 popeye627(一曲肝肠断，天涯何处觅知音？) 的
select name from syscolumns where id=object_id( 'table ')
