C#题目编程，急急急！！！

1.
public static SqlDataReader MyReader(string strSQL)
{
SqlConnection connection = new SqlConnection(connectionString);
SqlCommand cmd = new SqlCommand(strSQL, connection);
try
{
connection.Open();
SqlDataReader myReader = cmd.ExecuteReader();
return myReader;
}
catch (System.Data.SqlClient.SqlException e)
{
throw new Exception(e.Message);
}
finally
{
cmd.Dispose();
connection.Close();
}

}

这是一个reader的方法。
如果我想从数据库中读出网站配置信息，然后显示在aspx文件的文本框内。该怎么写？
我现在是这么写的：
string sqlcmd = "select * from system_config";
SqlDataReader reader = myData.MyReader(sqlcmd);
if (reader.Read())
{
sitename.Value = reader["sitename"].ToString();
en_sitename.Value = reader["en_sitename"].ToString();
company_name.Value = reader["company_name"].ToString();
en_company_name.Value = reader["en_company_name"].ToString();
company_tel.Value = reader["company_tel"].ToString();
company_fax.Value = reader["company_fax"].ToString();
}

运行后在if (reader.Read()) 这行代码提示阅读器已经关闭。我知道那个reader方法在执行完sql语句后，就关闭连接了。我下面再取的时候就出错了。我在想我这种模式应该怎么实现？
如果我把方法中finally
{
cmd.Dispose();
connection.Close();
}
去掉的话，就需要自己在程序中手工关闭连接。但是我在想是否有更好的实现模式？想了很久了没有解决。

2.给你个只实现IEnumerable 的例子...

C# code
class sample : IEnumerable
{
private List i;

public sample()
{
i = new List ();
i.AddRange(new int[] { 1, 2, 3, 4, 5 });
}

public IEnumerator GetEnumerator()
{
return i.GetEnumerator();
}

System.Collections.IEnumerator System.Collections.IEnumerable.GetEnumerator()
{
return i.GetEnumerator();
}
}
3.
using System;
using System.Drawing;
using System.Drawing.Text;
class haidao{
static void Main(){
Bitmap bmp=new Bitmap(800,800);
Graphics g=Graphics.FromImage(bmp);
FontFamily fontfml=new FontFamily(GenericFontFamilies.Serif);
Font font=new Font(fontfml,20);
SolidBrush brush=new SolidBrush(Color.Red);
g.DrawString("我的绘画图",font,brush,50,10);
Random rnd=new Random();
Point[] haidao=new Point[4];
haidao[0]=new Point(rnd.Next(600)+100,rnd.Next(600)+100);
haidao[1]=new Point(rnd.Next(600)+100,rnd.Next(600)+100);
haidao[2]=new Point(rnd.Next(600)+100,rnd.Next(600)+100);
haidao[3]=new Point(rnd.Next(600)+100,rnd.Next(600)+100);
Pen curvepen=new Pen(Color.Red);
curvepen.Width=3;
g.DrawRectangle(curvepen,haidao); //空心矩形
SolidBrush myBrush=new SolidBrush(Color.Blue);
g.FillEllipse(myBrush, new Rectangle(0,0,100,200));//画实心椭圆
bmp.Save("haidao.jpg",System.Drawing.Imaging.ImageFormat.Jpeg);
}
}

3
Graphics g = e.Graphics;
Rectangle rect = e.ClipRectangle;
int wd = rect.Width / 2;
int x = wd / 2;
int ht = rect.Height / 2;
int y = ht / 2;
rect = new Rectangle(x, y, wd, ht);
Rectangle innerRect;
int wd2 = rect.Width *3/ 4;
int ht2 = rect.Height *3/ 4;
int y2 = (rect.Top + rect.Bottom) / 2 - ht2 / 2;
int x2 = (rect.Left + rect.Right) / 2 - wd2 / 2;
innerRect = new Rectangle(x2, y2, wd2, ht2);

Pen myPen = new Pen(Color.Red, 1);
g.DrawRectangle(myPen, rect);
Brush myBrush = new SolidBrush(Color.Blue);
g.FillEllipse(myBrush, innerRect);

int radius = (rect.Width < rect.Height ? rect.Width : rect.Height) / 8;
Pen bluePen = new Pen(Color.Blue, 1);
g.DrawEllipse(bluePen, rect.Left - radius, rect.Top - radius,2 * radius, 2 * radius);
g.DrawEllipse(bluePen, rect.Right - radius, rect.Top - radius, 2 * radius, 2 * radius);
g.DrawEllipse(bluePen, rect.Right -radius,rect.Bottom - radius, 2 * radius, 2 * radius);
g.DrawEllipse(bluePen, rect.Left - radius,rect.Bottom - radius, 2 * radius, 2 * radius);

Font font=new Font("宋体",18,GraphicsUnit.Pixel);
Brush wordBrush =new SolidBrush(Color.Red);
;
StringFormat stringFormat=new StringFormat() ;
stringFormat.Alignment = StringAlignment.Center;
stringFormat.LineAlignment = StringAlignment.Center;
g.DrawString("我的绘图画", font, wordBrush, innerRect, stringFormat);
2.
class GenericAssmble : IEnumerable
{
private T[] container;
private int mCount;
private int mSize;
public GenericAssmble():this(10)
{

}
public GenericAssmble(int size)
{
container = new T[size];
mCount = 0;
this.mSize = size;
}
public int Lenght
{
get
{
return mCount;
}
}
public IEnumerator GetEnumerator()
{

for (int i = 0; i < mCount; i++)
yield return container[i];
}

IEnumerator IEnumerable.GetEnumerator()
{
foreach (T temp in container)
yield return temp;
}
public T this[int index]
{
get
{
if (index >= 0 && index < mCount)
return container[index];
else
throw new IndexOutOfRangeException("下标越界");
}
set{
if(index>=0&&index container[index]=value;
else
throw new IndexOutOfRangeException("下标越界");
}
}
public bool Add(T temp)
{
if (mCount < mSize)
{
container[mCount++] = temp;
return true;
}
else
{
return false;
}
}
public bool Delete()
{
if (mCount <= 0)
return false;
mCount--;
return true;
}
public bool InsertIn(int index, T temp)
{
if (index < 0 || index > mCount||mCount>=mSize)
return false;
for (int i = mCount - 1; i >= index; i--)
container[i + 1] = container[i];
container[index] = temp;
mCount++;
return true;
}
public bool RemoveAt(int index)
{
if (index < 0 || index >= mCount)
return false;
for (int i = index; i container[i] = container[i + 1];
mCount--;
return true;
}
public int Size
{
get
{
return mSize;
}
}
1
string connString = @"server =.;
integrated security =true;
database =northwind";

string qry = @"select * from employees
where lastName=@lastname";
SqlConnection conn= new SqlConnection(connString);

SqlCommand cmd = new SqlCommand(qry, conn);
SqlParameter lastname = new SqlParameter("@lastname", "tan");
cmd.Parameters.Add(lastname);
conn.Open();
SqlDataReader read = cmd.ExecuteReader();

using System;
using System.Collections;
using System.Collections.Specialized;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;

namespace HuiPublicing.SQLServerDAL //可以修改成实际项目的命名空间名称
{
///