你可以做
public static DataTable SchemaReader(string tableName)
{
string sql = "MySP";//replace this with your store procedure name
conn.open();
sqlCommand cmd = new sqlCommand(sql, conn);
cmd.CommandType = CommandType.StoredProcedure;
sqlDataReader reader = cmd.ExecuteReader();
DataTable schema = reader.GetSchemaTable();
reader.Close();
conn.Close();
return schema;
}
希望这个帮助
602392714
清零编程群