static void Main(string[] args)
{
//建立SqlHelper对象（包含用户名、密码）
//SqlHelper sqlHelper = new SqlHelper("127.0.0.1", "TestDB", "sa", "12345678");
//建立SqlHelper对象（不包含用户名、密码）
SqlHelper sqlHelper = new SqlHelper("127.0.0.1", "TestDB");
//通过表名获取数据表
DataTable stuTable = sqlHelper.GetTable("student", 50);
PrintTable(stuTable);
//通过sql语句获取数据表
DataTable stuTable2 = sqlHelper.GetTable("select * from student where sex=N'男'");
PrintTable(stuTable2);
//按流的方式单向读取数据（使用SqlDataReader）
SqlDataReader sqlDataReader = sqlHelper.GetDataStream("select * from student where sex=N'男'");
while (sqlDataReader.Read())
{
//获取指定字段的值
string id = sqlDataReader["sid"].ToString();
string name = sqlDataReader["name"].ToString();
string sex = sqlDataReader["sex"].ToString();
string score = sqlDataReader["score"].ToString();
Console.WriteLine(id + "\t" + name + "\t" + sex + "\t" + score);
}
sqlHelper.CloseConnection();
//执行一条SQL语句
sqlHelper.ExecuteSqlCommand("insert into student(sid,name,sex,score) values(102,'hong',N'女',78.5)");
DataTable stuTable3 = sqlHelper.GetTable("student", 50);
PrintTable(stuTable3);
//添加数据到指定DataSet中（添加到一张表）
DataSet dataSet = new DataSet();
sqlHelper.AddDataToDataSet(dataSet, "select * from student", "student");
PrintTable(dataSet.Tables["student"]);
//添加数据到指定DataSet中（添加到多张表）
//DataSet dataSet = new DataSet();
//sqlHelper.AddDataToDataSet(dataSet, new List<string> { "select * from student", "select * from teacher" }, new List<string> { "student", "teacher" });
//PrintTable(dataSet.Tables["student"]);
//PrintTable(dataSet.Tables["teacher"]);
//修改student表的分数，批量提交对数据表进行的修改
DataTable tempTable = sqlHelper.GetTable("select * from student");
foreach (DataRow row in tempTable.Rows)
{
row["score"] = double.Parse(row["score"].ToString()) - 1;
}
sqlHelper.UpdateTable(tempTable, "select * from student");
//修改student表的分数，批量提交对数据表进行的修改
//DataSet dataSet = new DataSet();
//sqlHelper.AddDataToDataSet(dataSet, "select * from student", "student");
//foreach (DataRow row in dataSet.Tables["student"].Rows)
// row["score"] = int.Parse(row["score"].ToString()) + 1;
//sqlHelper.UpdateTable(dataSet, "student", "select * from student");
}
