using System;
using System.Collections.Generic;
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");
con.Open();
SqlDataAdapter sqlAdapter = new SqlDataAdapter(sql, con);
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
sqlAdapter.Fill(ds);
for (int m = 0; m < ds.Tables[0].Rows.Count; m++)
{
ds.Table[0].Rows[m]["username"]; //这句有问题请大家看一下
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
finally
{
con.Close();
}
}
}
}
using System.Collections.Generic;
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");
con.Open();
SqlDataAdapter sqlAdapter = new SqlDataAdapter(sql, con);
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
sqlAdapter.Fill(ds);
for (int m = 0; m < ds.Tables[0].Rows.Count; m++)
{
ds.Table[0].Rows[m]["username"]; //这句有问题请大家看一下
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
finally
{
con.Close();
}
}
}
}
问问题,就把问题说的清楚一点。
{
ds.Table[0].Rows[m]["username"]; //这句有问题请大家看一下
}
======================>for (int m = 0; m < ds.Tables[0].Rows.Count; m++)
{
ds.Tables[0].Rows[m]["username"]; //这句有问题请大家看一下
}
你应该少指定了sqlAdapter 的SelectCommand的属性的缘故
这条语句不完整,建议改为:
Console.WriteLine(ds.Tables[0].Rows[m]["username"].ToString());
测试测试,打印输出的是什么内容
String sql = "select * from member";
DataSet ds = new DataSet();
SqlConnection con = null;
con = new SqlConnection("server=.;database=QX;uid=sa;pwd=sa");
SqlDataAdapter sqlAdapter = new SqlDataAdapter(sql, con);
sqlAdapter.Fill(ds);
for (int m = 0; m < ds.Tables[0].Rows.Count; m++)
{
Console.WriteLine(ds.Tables[0].Rows[m]["username"].ToString());
}
con.Close();
1,确保数据库表里有username 字段
2,messageBox.show( ds.Table[0].Rows[m]["username"].toString()); 看看内容
3,ds.Table[0].Rows[m]["username"] 看是否为dbnull
改成
ds.Tables[0].Rows[m]["username"];
Table 改为Tables
这句话你想要干什么!!如果想要在前台显示东西建议写个变量接收!!
ds.Table[0].Rows[m]["username"].Tostring();