OleDbParameter 在Access中的用法

来源：互联网发布：java经典编程100例编辑：程序博客网时间：2024/06/10 17:24

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