我想在本地做个生成随机数的程序,每生成一个随机数 就向数据库中写一个(这样效率很低) 我在本地写ACCESS 超慢 在 本地写SQL 速读还可以 远程就不行了
想实现写本地ACCESS时块一些,有好办法吗 忘赐教
public string ss(string s)
{
string strConnection = "Provider=Microsoft.Jet.OleDb.4.0;";
strConnection += @"Data Source=C:\mdb.mdb"; string Sql = "insert into number (n)values('" + s + "')";
OleDbConnection objConnection = new OleDbConnection(strConnection);
OleDbCommand cmd = new OleDbCommand(Sql, objConnection);
objConnection.Open();
cmd.ExecuteNonQuery();
cmd.Dispose();
objConnection.Close();
objConnection.Dispose(); return s;
} private void button1_Click(object sender, EventArgs e)
{
string number = null;
for (int i = 1; i <= 5000; ++i)
{
//number += i.ToString()+ "\r\n";
pBar1.PerformStep();
number += ss(Guid.NewGuid().ToString("N").Substring(0, 15)) + "\r\n";
}
textBox1.Text = number;
}
想实现写本地ACCESS时块一些,有好办法吗 忘赐教
public string ss(string s)
{
string strConnection = "Provider=Microsoft.Jet.OleDb.4.0;";
strConnection += @"Data Source=C:\mdb.mdb"; string Sql = "insert into number (n)values('" + s + "')";
OleDbConnection objConnection = new OleDbConnection(strConnection);
OleDbCommand cmd = new OleDbCommand(Sql, objConnection);
objConnection.Open();
cmd.ExecuteNonQuery();
cmd.Dispose();
objConnection.Close();
objConnection.Dispose(); return s;
} private void button1_Click(object sender, EventArgs e)
{
string number = null;
for (int i = 1; i <= 5000; ++i)
{
//number += i.ToString()+ "\r\n";
pBar1.PerformStep();
number += ss(Guid.NewGuid().ToString("N").Substring(0, 15)) + "\r\n";
}
textBox1.Text = number;
}
先放在内存里,到了一定量统一写入数据库.coowoo(性潮和尚 今天你被双规了吗?) 说得也对,connection不用每次都关闭.结束时关闭它就可以
连接数据库的过程比较慢的,加上你是nk次循环。