namespace HowTo.Samples.ADONET
{using System;
using System.Data;
using System.Data.SqlClient;public class gettingdata
{
public static void Main()
{
gettingdata mygettingdata = new gettingdata();
mygettingdata.Run();
} public void Run()
{ SqlConnection myConnection = new SqlConnection("server=(local)\\NetSDK;Trusted_Connection=yes;database=northwind");
SqlDataAdapter mySqlDataAdapter = new SqlDataAdapter("select * from customers", myConnection); try
{
DataSet myDataSet = new DataSet(); mySqlDataAdapter.Fill(myDataSet,"Customers"); foreach (DataRow myDataRow in myDataSet.Tables["Customers"].Rows)
{
Console.WriteLine(myDataRow["CustomerId"].ToString());
}
}
catch(Exception e)
{
Console.WriteLine(e.ToString());
}
}
}}
{using System;
using System.Data;
using System.Data.SqlClient;public class gettingdata
{
public static void Main()
{
gettingdata mygettingdata = new gettingdata();
mygettingdata.Run();
} public void Run()
{ SqlConnection myConnection = new SqlConnection("server=(local)\\NetSDK;Trusted_Connection=yes;database=northwind");
SqlDataAdapter mySqlDataAdapter = new SqlDataAdapter("select * from customers", myConnection); try
{
DataSet myDataSet = new DataSet(); mySqlDataAdapter.Fill(myDataSet,"Customers"); foreach (DataRow myDataRow in myDataSet.Tables["Customers"].Rows)
{
Console.WriteLine(myDataRow["CustomerId"].ToString());
}
}
catch(Exception e)
{
Console.WriteLine(e.ToString());
}
}
}}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货