学步园

@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;

    }