OleDbParameter 在Access中的用法

public static int Update(string title, string addTime, string content, int typeID, int id,string rollimg)
    {
        OleDbConnection con = DBcon.createcon();
        con.Open();
        string cmdText = "Update News Set NewsTitle=?, AddTime=?, Content=?, TypeID=?, RollImg=?  Where ID=?";
        OleDbCommand cmd = new OleDbCommand(cmdText, con);
        cmd.Parameters.Add("?", OleDbType.LongVarWChar, 60).Value = title;
        cmd.Parameters.Add("?", OleDbType.LongVarWChar, 60).Value = addTime;
        cmd.Parameters.Add("?", OleDbType.LongVarChar).Value = content;
        cmd.Parameters.Add("?", OleDbType.Integer, 4).Value = typeID;
        cmd.Parameters.Add("?", OleDbType.LongVarChar).Value = rollimg;
        cmd.Parameters.Add("?", OleDbType.Integer).Value = id;
        int result = cmd.ExecuteNonQuery();
        con.Close();
        return result;
      
    }

 public static int Add(string title, string addtime, string content, int typeID,string rollImg)
    {
        OleDbConnection con = DBcon.createcon();
        con.Open();
        string cmdText = "Insert into  News(NewsTitle,AddTime,Content,RollImg,TypeID) Values (?,?,?,?,?)";
        OleDbCommand cmd = new OleDbCommand(cmdText, con);
        cmd.Parameters.Add("?", OleDbType.LongVarWChar, 60).Value = title;
        cmd.Parameters.Add("?", OleDbType.LongVarWChar, 60).Value = addtime;
        cmd.Parameters.Add("?", OleDbType.LongVarChar).Value = content;
        cmd.Parameters.Add("?", OleDbType.LongVarChar).Value = rollImg;
        cmd.Parameters.Add("?", OleDbType.Integer, 4).Value = typeID;
        int result = cmd.ExecuteNonQuery();
        con.Close();
        return result;
    }

public DataSet GetDataSetFromAdapter(
    DataSet dataSet, string connectionString, string queryString)
{
    using (OleDbConnection connection =
               new OleDbConnection(connectionString))
    {
        OleDbDataAdapter adapter =
            new OleDbDataAdapter(queryString, connection);

        // Set the parameters.
        adapter.SelectCommand.Parameters.Add(
            "@CategoryName", OleDbType.VarChar, 80).Value = "toasters";
        adapter.SelectCommand.Parameters.Add(
            "@SerialNum", OleDbType.Integer).Value = 239;

        // Open the connection and fill the DataSet.
        try
        {
            connection.Open();
            adapter.Fill(dataSet);
        }
        catch (Exception ex)
        {
            Console.WriteLine(ex.Message);
        }
        // The connection is automatically closed when the
        // code exits the using block.
    }
    return dataSet;
}

  • 2
    点赞
  • 3
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值