又总结了几个数据库操作

 一、存储过程

１.名称：t8_sysGetNewsInfo

CREATE proc t8_sysGetNewsInfo

@nlinkid varchar(255) as select * from t8_news where nlinkid=@nlinkid   GO ２.名称：t8_sysInsertIntoNewsinfo REATE PROCEDURE t8_sysInsertIntoNewsinfo @userid varchar(255) , @nlaiyuan char(255) , @nwebsite varchar(255) , @nissuer varchar(50) , @ntitle varchar(255) , @ncontent varchar(8000)  AS  INSERT INTO t8_news(  [userid],[nlaiyuan],[nwebsite],[nissuer],[ntitle],[ncontent])  VALUES(  @userid,@nlaiyuan,@nwebsite,@nissuer,@ntitle,@ncontent) GO 二、程序调用

//添加

    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;

        }

    }

//读取

    public SqlDataReader GetNewsInfo(string nlinkid)

    {

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

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

        MyCommand.CommandType = CommandType.StoredProcedure;

 

        SqlParameter pnlinkid = new SqlParameter("@nlinkid", SqlDbType.VarChar, 255);

        pnlinkid.Value = nlinkid;

        MyCommand.Parameters.Add(pnlinkid);

 

        MyConnection.Open();

        SqlDataReader dr = MyCommand.ExecuteReader(CommandBehavior.CloseConnection);

        return dr;

    }