怎样遍历一个ILIST集合 并将其所有的数据插入到表中
怎样遍历一个ILIST集合 并将其所有的数据插入到 表中
[最优解释]
IList<tiankongti> timu = new List<tiankongti>();
SqlConnection conn = DBHelper.Getconn();
conn.Open();
foreach (tiankongti tq in timu )
{
strinq strSQL="insert into table1() values('"+ tk.id+"','+tk.Timu+"')";
SqlCommand com = new SqlCommand(sql, conn);
com.ExecuteNonQuery();
}
conn.Close();

[其他解释]
LIST<Sring> lis=new LIST<String>();
foreach (String var in lis)
{
var就是里面每项的值
}
[其他解释]
第一种 ILIST<String> list=new LIST<String>();
foreach (String var in list)
{
var就是里面每项的值
}
第二种 ILIST<Object> list=new LIST<Object>();
foreach (Object obj in list)
{
obj//对象的值
}

推介下自己的网站 谢谢
[其他解释]
List<T> lst=new List<T>();
foreach(T t in lst)
{
}
[其他解释]
大家把代码写完整一点
[其他解释]

引用:

List<T> lst=new List<T>();
foreach(T t in lst)
{
}

up
[其他解释]
高山流水厉害!
[其他解释]
谁能在高山流水的基础上 运用加参数的方式啊?
[其他解释]
IList<tiankongti> timu = new List<tiankongti>();
SqlConnection conn = DBHelper.Getconn();
conn.Open();
foreach (tiankongti tq in timu )
{
strinq strSQL=string.Format("insert into table1('列1','列2','列3') values('{0}','{1}','{2}')",timu[i].属性,timu[i].属性1,timu[i].属性2);
SqlCommand com = new SqlCommand(sql, conn);
com.ExecuteNonQuery();
}
conn.Close();

[其他解释]
strinq strSQL=string.Format("insert into table1('列1','列2','列3') values('{0}','{1}','{2}')",timu[i].属性,timu[i].属性1,timu[i].属性2);
好像我少写了一个半括号改为：
strinq strSQL=string.Format("insert into table1('列1','列2','列3') values('{0}','{1}','{2}')",timu[i].属性,timu[i].属性1,timu[i].属性2));

[其他解释]
示例：
string sql = "select * from l_data_chukou";
string a = this.cboBegan.Text;
ck = new List<ChuKou4>();

ck = ChuKouManager4.GetChuKou(a);
j = 0;
for (int i = 0; i < ck.Count; i++)
{
string strSQL = string.Format("insert into F_8Wei1_List([ChanYe],[HangYe],[ChanPin],[ShangPinmc],[HaiGuanbm],[ZhiBiao],[CaiZhengnd],[ZhiLengnd],[JiDu],[YueFen],[F_Field11],[QiYelx],[QiYexz],[QiYemc],[QiYedm],[ZhouBie],[GuoBie],[ZhongZhuang],[ShengShi],[ShuLiang],[ShuLiangdw],[JinE],[JiaGe],[HaiGuan],[YunShufs],[MaoYifs],[QiYedz],[DianHua],[ChuanZhen],[LianXir],[YouBian],[DianZiyg],[SanJian]) values ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}','{14}','{15}','{16}','{17}','{18}','{19}','{20}','{21}','{22}','{23}','{24}','{25}','{26}','{27}','{28}','{29}','{30}','{31}','{32}')",ck[i].L_chanye,ck[i].L_hy_code,ck[i].L_chanpin,ck[i].L_pro_names,ck[i].L_hg_code,ck[i].L_xm,ck[i].L_cn,ck[i].L_ln,ck[i].L_jd,ck[i].L_yf,ck[i].L_pinpai,ck[i].L_com_st,ck[i].L_com_st_1,ck[i].L_com,ck[i].L_com_code,ck[i].L_zhoubie,ck[i].L_con,ck[i].L_zhongzhuan_con,ck[i].L_diqu,ck[i].L_sl,ck[i].L_dw,ck[i].L_jine,ck[i].L_danjia ,ck[i].L_haiguan,ck[i].L_yunshu_st ,ck[i].L_maoyi_st,ck[i].L_qy_adress,ck[i].L_tel,ck[i].L_fax ,ck[i].L_names,ck[i].L_post,ck[i].L_email ,ck[i].L_sanjian);
try
{
SqlCommand com = new SqlCommand(strSQL, DBHelper981.connection);
DBHelper981.connection.Open();
int result = com.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
DBHelper981.connection.Close();
}
j = j + 1;
}
MessageBox.Show("导入成功！导入条数为：" + Convert.ToString(j) + "条");