asp.net DataSet 遍历
class Program
{
static void Main(string[] args)
{
//利用ado得到数据
SqlConnection conn = new SqlConnection("server=.;database=test;user=sa;pwd=1");
conn.Open();
SqlDataAdapter da = new SqlDataAdapter("select * from news", conn);
DataSet ds = new DataSet();
da.Fill(ds,"新闻表");
conn.Close();
//遍历输出
for (int i = 0; i < ds.Tables.Count;i++ )
{
DataTable dt = ds.Tables[i];
Console.WriteLine("表名：{0}",dt.TableName);
Console.WriteLine("表字段：\t");
foreach(DataColumn col in dt.Columns)
{
Console.Write("-{0}-",col.ColumnName);
}
Console.WriteLine("");
foreach (DataRow dr in dt.Rows)
{
for (int j = 0; j < dt.Columns.Count; j++)
{
Console.Write("-{0}-", dr[j]);
}
Console.WriteLine("");
}
}
Console.ReadKey();
}
}
- 上一篇：vc++7.0 是什么
- 下一篇：VS2008 找不到解决方案