c#使用sqlite数据库开发问题
c#开发mobile程序,使用sqlite数据库,insert语句在查询分析器里可以正常插入数据,在程序中执行后没有报错,但数据库中没有插入数据,下面是代码:
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into yh_data(");
strSql.Append("v_date,i_lcb,i_type,m_money,m_price,d_jyl,v_jyz,i_isfull,v_beizhu)");
strSql.Append(" values (");
strSql.Append("@v_date,@i_lcb,@i_type,@m_money,@m_price,@d_jyl,@v_jyz,@i_isfull,@v_beizhu)");
SQLiteParameter[] parameters = {
SQLiteHelper.MakeSQLiteParameter("@v_date", DbType.String,30,date.Trim()),
SQLiteHelper.MakeSQLiteParameter("@i_lcb", DbType.Int32,128,int.Parse(lcb.Trim())),
SQLiteHelper.MakeSQLiteParameter("@i_type", DbType.Int32,128,type),
SQLiteHelper.MakeSQLiteParameter("@m_money", DbType.Decimal,128,decimal.Parse(money)),
SQLiteHelper.MakeSQLiteParameter("@m_price", DbType.Decimal,128,decimal.Parse(price)),
SQLiteHelper.MakeSQLiteParameter("@d_jyl", DbType.Decimal,128,decimal.Parse(jyl)),
SQLiteHelper.MakeSQLiteParameter("@v_jyz", DbType.String,128,jyz.Trim()),
SQLiteHelper.MakeSQLiteParameter("@i_isfull", DbType.Int32,128,full),
SQLiteHelper.MakeSQLiteParameter("@v_beizhu", DbType.String,128,beizhu.Trim())
};
SQLiteHelper.ExecuteSql(strSql.ToString(), parameters);
executeSql:
public static int ExecuteSql(string SQLString, string content)
{
using (SQLiteConnection connection = new SQLiteConnection(connectionString))
{
SQLiteCommand cmd = new SQLiteCommand(SQLString, connection);
SQLiteParameter myParameter = new SQLiteParameter("@content", DbType.String);
myParameter.Value = content;
cmd.Parameters.Add(myParameter);
try
{
connection.Open();
int rows = cmd.ExecuteNonQuery();
return rows;
}
catch (System.Data.SQLite.SQLiteException E)
{
throw new Exception(E.Message);
}
finally
{
cmd.Dispose();
connection.Close();
}
}
}
求高人指点