数据库数据全体自加一的问题
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Diagnostics;
using System.Data;
using System.Data.Common;
using System.Data.SQLite;
namespace test
{
class Program
{
static void Main(string[] args)
{
System.Data.SQLite.SQLiteConnection.CreateFile("datasource");
System.Data.SQLite.SQLiteConnection conn = new System.Data.SQLite.SQLiteConnection();
string datasource = "D:/Data.db";
System.Data.SQLite.SQLiteConnectionStringBuilder connstr = new System.Data.SQLite.SQLiteConnectionStringBuilder();
connstr.DataSource = datasource;
conn.ConnectionString = connstr.ToString();
conn.Open();
System.Data.SQLite.SQLiteCommand cmd = new System.Data.SQLite.SQLiteCommand();
cmd.Connection = conn;
Stopwatch watch = new Stopwatch();
watch.Start();
string sql= "SELECT * FROM test ";
cmd.CommandText = sql;
cmd.ExecuteNonQuery();
System.Data.SQLite.SQLiteDataReader reader = cmd.ExecuteReader();
watch.Stop();
Console.WriteLine(watch.Elapsed);
Console.ReadLine();
}
}
}
select from怎样遍历所有数据后自加一
[解决办法]
应该用这条sql语句
update 表名 set 年龄=年龄+1
直接cmd.ExecuteNonQuery();就可以把数据表中所有记录的“年龄”字段加上1
