我的思路是利用timer1,每3秒从数据库里读一条数据,然后更新SMS_SEND_STATE 的状态,但dataGridView1一开始就花了10几秒钟才能显示数据,然后更新数据后,dataGridView1的值没有变,而进数据库查看却发现值已经改变了;关于这个问题,百度出来的,都是要设置DataGridView的AutoSizeColumnsMode等,但也不行,也有说分页显示,但我每次只取一条记录,没必要分页吧,请给位高手给我意见,具体代码如下:
private void Form1_Load(object sender, EventArgs e)
{
ConnectionString = "Data Source=hhk;user=erp;password=hhk7845475;";//写连接串
conn=new OracleConnection(ConnectionString);//创建一个新连接
conn.Open();
}private void timer1_Tick(object sender, EventArgs e)
{
string sql = "SELECT * FROM SMS_INFO WHERE (SMS_SEND_STATE = '待发') AND (ROWNUM < 2) "; //OracleCommand cmd = conn.CreateCommand();
//cmd.CommandText = sql;
//OracleDataReader odr = cmd.ExecuteReader();//创建一个OracleDateReader对象 adapter = new OracleDataAdapter(sql, conn);
OracleCommandBuilder sqlBulider = new OracleCommandBuilder(adapter); ds = new DataSet("GenStgReferenz");
adapter.Fill(ds, "GenStgReferenz");
this.dataGridView1.DataSource = ds.Tables["GenStgReferenz"];
int i = this.dataGridView1.Rows.Count;
if (i > 1)
{
this.dataGridView1.Rows[0].Cells[7].Value = "已发";
this.dataGridView1.Rows[0].Cells[8].Value = System.DateTime.Now.ToString("yyyy-MM-dd hh:MM:ss");
}
else
{ label1.Text = "无数据"; }
adapter.Update(ds.Tables["GenStgReferenz"]);
}
private void Form1_Load(object sender, EventArgs e)
{
ConnectionString = "Data Source=hhk;user=erp;password=hhk7845475;";//写连接串
conn=new OracleConnection(ConnectionString);//创建一个新连接
conn.Open();
}private void timer1_Tick(object sender, EventArgs e)
{
string sql = "SELECT * FROM SMS_INFO WHERE (SMS_SEND_STATE = '待发') AND (ROWNUM < 2) "; //OracleCommand cmd = conn.CreateCommand();
//cmd.CommandText = sql;
//OracleDataReader odr = cmd.ExecuteReader();//创建一个OracleDateReader对象 adapter = new OracleDataAdapter(sql, conn);
OracleCommandBuilder sqlBulider = new OracleCommandBuilder(adapter); ds = new DataSet("GenStgReferenz");
adapter.Fill(ds, "GenStgReferenz");
this.dataGridView1.DataSource = ds.Tables["GenStgReferenz"];
int i = this.dataGridView1.Rows.Count;
if (i > 1)
{
this.dataGridView1.Rows[0].Cells[7].Value = "已发";
this.dataGridView1.Rows[0].Cells[8].Value = System.DateTime.Now.ToString("yyyy-MM-dd hh:MM:ss");
}
else
{ label1.Text = "无数据"; }
adapter.Update(ds.Tables["GenStgReferenz"]);
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货