using System;
using System.Data;
using System.Data.SqlClient;
namespace ConsoleApp2
{
class Program
{
static void Main(string[] args)
{
//string conn = "server=.;database=mydatabase082;uid=sa;pwd=886566";
//SqlConnection connection = new SqlConnection(conn);
//connection.Open();
//string sql = "select studentid ,studentname,age,gender,birthday from student where gender ='fe'";
//SqlCommand command = new SqlCommand(sql, connection);
//SqlDataReader objreader = command.ExecuteReader();
//while (objreader.Read())
//{
// Console.WriteLine(objreader["studentid"].ToString()+
// "\t"+objreader["studentname"] + "\t" + objreader["age"] +
// "\t" + objreader["gender"] + "\t" + objreader["birthday"]);
//}
//objreader.Close();
//connection.Close();
//string sql = "select count(*) from student";
//Console.WriteLine( SQLHelper.ReadSingleLine(sql).ToString());
//string sql = "update student set studentname = 'mayun' where studentid =10005";
//SQLHelper.Update(sql);
string sql = "select studentname from student";
SqlDataReader sdr= SQLHelper.GetMultiLine(sql);
while (sdr.Read())
{
Console.WriteLine(sdr["studentname"]);
}
sdr.Close();
}
}
}