UC知道c#取dataset值
来源：百度知道 编辑：UC知道 时间：2024/06/29 01:06:16
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"]; ????为什
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"]; ????为什
纯粹的语法错误:
ds.Table[0]["username"]没有这样写的~~如下:
ds.Table[0].Rows[m]["username"];
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字段的值
for(int m = 0; m <ds.Tables[0].Columns.Count;m++ )
是对每一列循环
for(int m = 0; m <ds.Tables[0].Rows.Count;m++ )
对每一行循环
LZ说的对