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