7,765
社区成员
发帖
与我相关
我的任务
分享
'payable=应缴金额,todate=应缴日期
Public Sub Project_InsertInfo(payable As Decimal, todate As DateTime)
Dim fine As Decimal = 0D '滞纳金
For i As Integer = 1 To DateTime.Now.Date.Subtract(todate.Date).Days
fine += payable * i * 0.005D '每日滞纳金
Next
Dim conn As New OleDbConnection("Provider='Microsoft.Jet.OLEDB.4.0';Data Source='" + Application.StartupPath & "\data.mdb'")
Try
Dim comm As New OleDbCommand("insert into [表] ([应缴金额],[应缴日期],[实缴日期],[滞纳金]) values (" & payable & ",'" & todate.ToString("yyyy-MM-dd") & "','" & DateTime.Now.ToString("yyyy-MM-dd") & "'," & fine & ")", conn)
conn.Open()
comm.ExecuteNonQuery()
Catch
MessageBox.Show("本次计算结果保存失败");
Finally
conn.Close()
End Try
End Sub
public void Project_InsertInfo(int x,int y)
{
int v = x * y;
string s = "x乘以y等于" + v.ToString();
//我定义了两个变量,数字跟字符串插入数据库的时候字符串要加引号。
OleDbConnection conn = new OleDbConnection(@"Provider='Microsoft.Jet.OLEDB.4.0';Data Source='" + Application.StartupPath + @"\data.mdb'");
try
{
OleDbCommand comm = new OleDbCommand("insert into [表] ([字段1],[字段2]) values (" + v + ",'" + s + "')", conn);
conn.Open();
comm.ExecuteNonQuery();
}
catch
{
//MessageBox.Show("本次计算结果保存失败");
}
finally
{
conn.Close();
}
}