C#链接我本地数据库,读取订单信息后打印出来,但是我只能一次打印一个字段。。。。其他的什么客户名称啊没法一起打印
static void Main(string[] args)
{
using (SqlConnection conn=new SqlConnection("Data Source=.;Initial Catalog=master;User id=sa;pwd=123321"))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = "select * from orderlist";
SqlDataAdapter adapter =new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
ds.Locale = CultureInfo.InstalledUICulture;
adapter.Fill(ds);
DataTable orders =ds.Tables[0];
foreach (DataRow row in ds.Tables[0].Rows)
{
Console.WriteLine(row["订单编号"]);
}
求好办法。。。。C#纯新手。。。。
static void Main(string[] args)
{
using (SqlConnection conn=new SqlConnection("Data Source=.;Initial Catalog=master;User id=sa;pwd=123321"))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = "select * from orderlist";
SqlDataAdapter adapter =new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
ds.Locale = CultureInfo.InstalledUICulture;
adapter.Fill(ds);
DataTable orders =ds.Tables[0];
foreach (DataRow row in ds.Tables[0].Rows)
{
Console.WriteLine(row["订单编号"]);
}
求好办法。。。。C#纯新手。。。。
