新闻系统后台录入代码!请大家帮忙看看!谢谢!

我想实现新闻系统后台的上传录入功能,请大家帮忙看看代码有那些错误?谢谢!  private void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
if(!Page.IsPostBack)
{
dg_click();
getArticle();
getContent();
}
}
private void getArticle()  //把新闻内容记录到数据库
{
SqlConnection   SqlConnection1 = new SqlConnection(ConfigurationSettings.AppSettings["dsn"]);//取连接字符串,并建立连接
SqlCommand     SqlCommand1=new SqlCommand("sp_selArticleById",SqlConnection1); //创建一个命令对象
SqlCommand1.CommandType=CommandType.StoredProcedure;//把存储类型赋给对象
SqlCommand1.Parameters.Add(new SqlParameter("@articleid",SqlDbType.BigInt));
SqlCommand1.Parameters["@articleid"].Value = Request["articleid"];
try
{
SqlConnection1.Open();
SqlDataReader1=SqlCommand1.ExecuteReader();
}
catch (SqlException e1)
{
Label1.Text ="操作失败："+e1.Message;
}
void dg_Click(object sender, System.EventArgs e)
{

SqlConnection conn=new SqlConnection(@"Server="+local+";DataBase="+LGY+";uid="+name+";pwd="+pass+"");
SqlDataAdapter da=new SqlDataAdapter("SELECT * from new",conn);
DataSet ds=new DataSet();  
da.Fill(ds,"UN"); 
ListBox1.DataSource=ds;
ListBox1.DataTextField="UN";
ListBox1.DataValueField="UP";
ListBox1.DataBind();
ListBox1.Visible=true;


 }

private void getContent()    //由数据库读取新闻内容
{
SqlConnection1 = new SqlConnection(ConfigurationSettings.AppSettings["dsn"]);//取连接字符串,建立连接
SqlDataAdapter1 = new SqlDataAdapter();
SqlDataAdapter1.SelectCommand=new SqlCommand("sp_selReByArticleId",SqlConnection1);
SqlDataAdapter1.SelectCommand.CommandType=CommandType.StoredProcedure ;
SqlDataAdapter1.SelectCommand.Parameters.Add("@articleid",SqlDbType.BigInt);
SqlDataAdapter1.SelectCommand.Parameters["@articleid"].Value=Request["articleid"];
DataSet1=new DataSet();
try
{
SqlDataAdapter1.Fill(DataSet1,"Article");
}
catch (SqlException e1)
{
Label1.Text ="操作数据库错误："+e1.Message;
}
DataList1.DataSource=DataSet1;
DataList1.DataBind();
}
private void Button1_Click(object sender, System.EventArgs e)
{
if(body.Value.Length>800)
{
Label2.Text="新闻内容太长了！";
}
else 
{
//addRe();
getContent();
getArticle();
}
}