c#下获取数据库行列信息。
添加应用:
system
system.configuration
system.data
system.deployment
system.drawing
system.windows.forms
system.xml
using system;
using system.data;
using system.collections.generic;
using system.data.sqlclient;
using system.componentmodel;
class dataset_1
{
static void main()
{
sqlconnection thisconnect = new sqlconnection("data source=(local);initial catalog=xianlu;integrated security=true");
//thisconnect.open();
sqldataadapter thisadapter = new sqldataadapter(
"select * from dbo.xianlu",
thisconnect
);
dataset thisdataset = new dataset();
thisadapter.fill(thisdataset, "myxianlu");
int i = 0;
//foreach (datacolumn clo in thisdataset.tables["myxianlu"].columns)
//{
// console.writeline(therow["id"] + "/t" + therow["xl_podu"]);
// console.writeline(clo[i]);
//i++;
//console.readline();
//}
for (i = 0; i < thisdataset.tables["myxianlu"].columns.count; i++)
{
// if (thisdataset.tables["myxianlu"].columns[i] == null)
// break;
console.writeline(thisdataset.tables["myxianlu"].columns[i].tostring());
console.readline();
}
thisconnect.close();
console.writeline("program finished");
console.readline();
}
}