1.先请求数据从服务器,get/post都可以
2.拿到数据后,将数据传成DataTable
- public static int CombinationSQLString(DataTable tables, string tablename)
{
string sqlparam = "";
SQLiteHelper sql = new SQLiteHelper();
for (int i = 0; i < tables.Rows.Count; i++)
{
for (int j = 0; j < tables.Columns.Count; j++)
{
if (j == 0)
sqlparam = "'"+tables.Rows[i][j].ToString();
else
sqlparam = sqlparam + "','" + tables.Rows[i][j].ToString();
}
sqlparam = "insert into " + tablename + " values (" + sqlparam + "')";
sql.ExecuteNonQuery(sqlparam);
}
return sql.ExecuteNonQuery(sqlparam)>0?1:0;
}
4.讲sql传到SQLHelper中运行就好 ,我是直接insert进去就好。