try
{
dataMSSQL.Open();
trr.Begin();
foreach (DataRow dr in ds.Tables[0].Rows)
{
//循环处理每个人所有的收费项目
DataRow addRow=AddRow(dr,dataDB2,dt);
string field="";
string values="";
foreach (DataColumn col in dt.Columns)
{
field+=","+col.ColumnName; switch (col.DataType.ToString())
{
case "System.String":
if (col.ColumnName=="办理类型" && System.Text.Encoding.Default.GetBytes(addRow[col.ColumnName].ToString()).Length>10)
{
values+=",''";
}
else
{
values+=",'"+addRow[col.ColumnName]+"'";
}
break;
case "System.DateTime":
values+=",'"+addRow[col.ColumnName]+"'";
break;
case "System.Decimal":
values+=","+addRow[col.ColumnName];
break;
} }
field=field.Remove(0,1);
values=values.Remove(0,1);
sql="insert into "+TableName+" ("+field+") values("+values+")";
dataMSSQL.ExecuteNonQuery(sql);
progressBar1.Value++;
System.Windows.Forms.Application.DoEvents();
}
trr.Commit();
}
catch (System.Exception ex)
{
MessageBox.Show("错误:"+ex.Message);
trr.Rollback();
}
finally
{
dataMSSQL.Close();
MessageBox.Show("更新完成");
this.progressBar1.Value=0;
}
{
dataMSSQL.Open();
trr.Begin();
foreach (DataRow dr in ds.Tables[0].Rows)
{
//循环处理每个人所有的收费项目
DataRow addRow=AddRow(dr,dataDB2,dt);
string field="";
string values="";
foreach (DataColumn col in dt.Columns)
{
field+=","+col.ColumnName; switch (col.DataType.ToString())
{
case "System.String":
if (col.ColumnName=="办理类型" && System.Text.Encoding.Default.GetBytes(addRow[col.ColumnName].ToString()).Length>10)
{
values+=",''";
}
else
{
values+=",'"+addRow[col.ColumnName]+"'";
}
break;
case "System.DateTime":
values+=",'"+addRow[col.ColumnName]+"'";
break;
case "System.Decimal":
values+=","+addRow[col.ColumnName];
break;
} }
field=field.Remove(0,1);
values=values.Remove(0,1);
sql="insert into "+TableName+" ("+field+") values("+values+")";
dataMSSQL.ExecuteNonQuery(sql);
progressBar1.Value++;
System.Windows.Forms.Application.DoEvents();
}
trr.Commit();
}
catch (System.Exception ex)
{
MessageBox.Show("错误:"+ex.Message);
trr.Rollback();
}
finally
{
dataMSSQL.Close();
MessageBox.Show("更新完成");
this.progressBar1.Value=0;
}
string Location = "";
string str = ""; using (System.Data.DataTable dt = SqlHelper.ExecuteDataset(CN, CommandType.Text, @"select top 1 * from [Shops] where shopID=505749 ").Tables[0])
{ if (dt.Rows.Count > 0)
{
shopID =dt.Rows[0]["HtmlInfo"].ToString ();
Regex shop =new Regex(@"OpenShopMap(.*);return false;"" >地图");
Regex re2 = new Regex(@"[^\d]+");
Location = dt.Rows[0]["HtmlInfo"].ToString();
Regex re1 = new Regex(@"<h3>推荐菜(.)*<div class=""Blank"">");
if (re1.IsMatch(Location))
{
shopID = shop.Match(shopID).Value;
shopID = re2.Replace(shopID, "");
MatchCollection mc=re1.Mathes(Location);
for(int i=0;i<mc.Count;i++)
{
str="insert into Table1(XX) Values(shopID)";
qlHelper.ExecuteNonQuery(CN, CommandType.Text, sql_insert);
}
}
}
}
{
sql+="insert into talbe(....) values('"+ dr[columns0] +"','"+ dr[columns1].tostring() +"';";
}
根据字段类型做转换.拼接出来的SQL语句可以设断点查看一下....
{
sql = sql + "\n"
"insert into temp (data) values '"+i+"'"
}然后在这里执行SQL就行了。。
{
sql = sql + "\n" +
"insert into temp (data) values '"+i+"'"
}
sqlcommand cmd=new sqlcommand();
for(int i=0;i<100;i++)
{
con.open();
cmd.commandText="insert into temp (data) values '"+i+"'";
cmd.ExecuteNonQuery();
con.close();
"
}