public int InsertNewLine(DsBusWeb.LinesRow dr)
{
ExecuteNonQuery(string.Format("INSERT INTO Lines(LineName, Culture) VALUES({0}, {1})",
OleDbStrHelper.getParamStr(dr.LineName),
OleDbStrHelper.getParamStr(dr.Culture)));
return(Convert.ToInt32(ExecuteScalar("SELECT MAX(LineID) FROM Lines")));
}
public void UpdateLine(DsBusWeb.LinesRow dr)
{
ExecuteNonQuery(string.Format("UPDATE Lines SET LineName={0} WHERE LineID={1}",
OleDbStrHelper.getParamStr(dr.LineName),
OleDbStrHelper.getParamStr(dr.LineID)));
}
