SqlCommand MSCmd = new SqlCommand(@"select name from sysobjects where xtype='u' and name!='dtproperties' ", conn);可以得到表名,但是你怎么知道字段名?再去遍历?你这是什么需求...
SqlCommand MSCmd = new SqlCommand(@"select name from sysobjects where xtype='u' and name!='dtproperties' ", conn); SqlDataReader MyReader = MSCmd.ExecuteReader(); while (MyReader.Read()) { //往各表插数据 }
什么表?数据库表?DataTable?Excel表格?Html的Table?脑壳拍烂都不知道你想说什么
SqlCommand MSCmd = new SqlCommand(@"select name from sysobjects where xtype='u' and name!='dtproperties' ", conn);可以得到表名,但是你怎么知道字段名?再去遍历?你这是什么需求...
SqlCommand MSCmd = new SqlCommand(@"select name from sysobjects where xtype='u' and name!='dtproperties' ", conn);
SqlDataReader MyReader = MSCmd.ExecuteReader();
while (MyReader.Read())
{
//往各表插数据
}