SqlCommand tm1 = new SqlCommand("select id,tid from tb_temp");
tm1.Connection = conn1;
//SqlDataReader dr3 = tm1.ExecuteReader();
//if (dr3.Read())
// {
int i = 2;
while (i < 12)
{
SqlDataReader dr3 = tm1.ExecuteReader();
SqlCommand tm = new SqlCommand("update tb_shiti set dx1 = '" + dr3["tid"].ToString() + "' where id = '" + i + "'");
tm.Connection = conn1;
dr3.Dispose();
tm.ExecuteNonQuery();
i++;
}
tm1.Connection = conn1;
//SqlDataReader dr3 = tm1.ExecuteReader();
//if (dr3.Read())
// {
int i = 2;
while (i < 12)
{
SqlDataReader dr3 = tm1.ExecuteReader();
SqlCommand tm = new SqlCommand("update tb_shiti set dx1 = '" + dr3["tid"].ToString() + "' where id = '" + i + "'");
tm.Connection = conn1;
dr3.Dispose();
tm.ExecuteNonQuery();
i++;
}
解决方案 »
- vs2010学习咨询
- 为什么timer1_Tick无法触发?求助
- c#webbrowser获取所有发送和接收的XML数据
- 怎样记录电脑每次的开机关机时间和在线时长记录
- 代理和委托一样吗?
- C#调用C++的DLL问题--typedef struct 应该对应什么类型?结构指针应该对应什么类型?
- 程序运行时偶尔出现Run time Debugging Service 程序问题还是系统环境问题?
- 一个转换的问题!
- C#代码效率的疑问
- 无法找到 PInvoke DLL“cellcore.dll”中的入口点“GetDeviceUniqueID”是怎么回事?
- C# 数组求和
- C#新手提问,送分求解答!关于密封类问题
SqlCommand tm1 = new SqlCommand("select id,tid from tb_temp");
tm1.Connection = conn1;
SqlDataReader dr3 = tm1.ExecuteReader();
while (dr3.Read())
{
int i = 2;
while (i < 12)
{
SqlDataReader dr3 = tm1.ExecuteReader();
SqlCommand tm = new SqlCommand("update tb_shiti set dx1 = '" + dr3["tid"].ToString() + "' where id = '" + i + "'");
tm.Connection = conn1;
dr3.Dispose();
tm.ExecuteNonQuery();
i++;
}
}
dr3.Close();
SqlCommand tm1 = new SqlCommand("select id,tid from tb_temp");
tm1.Connection = conn1;
SqlDataReader dr3 = tm1.ExecuteReader();
int i = 2;
while (dr3.Read())
{
if (i < 12)//???
{
SqlCommand tm = new SqlCommand("update tb_shiti set dx1 = '" + dr3["tid"].ToString() + "' where id = '" + i + "'");
tm.Connection = conn1;
tm.ExecuteNonQuery();
i++;
}
}
dr3.Close();