Question

c#取dataset值

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;
namespace ConsoleApplication1
{
class Program2
{
static void Main(string[] args)
{
String sql = "select * from member";
DataSet ds = new DataSet();
SqlConnection con=null;
try
{
con = new SqlConnection("server=.;database=QX;uid=sa;pwd=sa");
SqlDataAdapter sqlAdapter = new SqlDataAdapter(sql, con);
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
con.Open();
sqlAdapter.Fill(ds);
for(int m = 0; m <ds.Tables[0].Columns.Count;m++ )
{
ds.Tables[0]["username"]; ????为什么不能取值啊?
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
finally
{
con.Close();
}
}
}
}

Answer 1

for(int m = 0; m <ds.Tables[0].Columns.Count;m++ )
改成
for(int m = 0; m <ds.Tables[0].Rows.Count;m++ )

ds.Tables[0]["username"];
改成
ds.Tables[0].Rows[m]["username"]
这句话的意思就是取第m行username字段的值

Answer 2

for(int m = 0; m <ds.Tables[0].Columns.Count;m++ )
是对每一列循环
for(int m = 0; m <ds.Tables[0].Rows.Count;m++ )
对每一行循环

Answer 3

纯粹的语法错误:
ds.Table[0]["username"]没有这样写的~~如下:
ds.Table[0].Rows[m]["username"];

Answer 4

LZ说的对