using System;
using System.Data.SqlClient; //引用命名空间
using System.Data;
namespace DataAdapter
{
class Program
{
static void Main(string[] args)
{
//连接数据库
string constr = "Server=. ;user=sa;pwd=sa;database=MySql";
SqlConnection mycon = new SqlConnection(constr);
try
{
mycon.Open();
string sql = "selecr * from mytable01";
SqlDataAdapter myda = new SqlDataAdapter(sql, mycon);
DataSet myds = new DataSet();
myda.Fill(myds,"mytable01");
Console.WriteLine("填充成功");
OutValues(myds);
Console.Read();
}
catch(Exception ex)
{
Console.WriteLine(ex.Message.ToString());
}
finally
{
mycon.Close();
}
}
public static void OutValues(DataSet ds)
{
foreach (DataTable dt in ds.Tables)
{
Console.WriteLine("表名"+dt.TableName);
foreach (DataRow row in dt.Rows)
{
foreach (DataColumn col in dt.Columns)
{
Console.Write(row[col] + "\t");
}
Console.WriteLine();
}
}
}
}
}
作者:Czhenya
链接:https://czhenya.blog.csdn.net/article/details/77777590
来源:CSDN
著作权归作者所有。商业转载请联系作者获得授权,非商业转载请注明出处。