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();
}
}
}