又总结了几个数据库操作

//添加

    public bool InsertNewsInfo(string userid, string ntitle, string nlaiyuan, string nissuer, string nwebsite, string ncontent)

    {

        MyConnection = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"].ToString());

        MyCommand = new SqlCommand("t8_sysInsertIntoNewsinfo", MyConnection);

        MyCommand.CommandType = CommandType.StoredProcedure;

        SqlParameter puserid = new SqlParameter("@userid", SqlDbType.VarChar, 255);

        puserid.Value = userid;

        MyCommand.Parameters.Add(puserid);

        SqlParameter pntitle = new SqlParameter("@ntitle", SqlDbType.VarChar, 255);

        pntitle.Value = ntitle;

        MyCommand.Parameters.Add(pntitle);

        SqlParameter pnlaiyuan = new SqlParameter("@nlaiyuan", SqlDbType.VarChar, 255);

        pnlaiyuan.Value = nlaiyuan;

        MyCommand.Parameters.Add(pnlaiyuan);

        SqlParameter pnissuer = new SqlParameter("@nissuer", SqlDbType.VarChar, 50);

        pnissuer.Value = nissuer;

        MyCommand.Parameters.Add(pnissuer);

        SqlParameter pnwebsite = new SqlParameter("@nwebsite", SqlDbType.VarChar, 255);

        pnwebsite.Value = nwebsite;

        MyCommand.Parameters.Add(pnwebsite);

        SqlParameter pncontent = new SqlParameter("@ncontent", SqlDbType.VarChar,8000);

        pncontent.Value = ncontent;

        MyCommand.Parameters.Add(pncontent);

        MyConnection.Open();

        int result;

        result = MyCommand.ExecuteNonQuery();

        MyConnection.Close();

        if (result > 0)

        {

            return true;

        }

        else

        {

            return false;

        }

    }