循环遍历

[欣睿]

public void InsertAppraise(Appraise appraise)
{
SqlConnection conn = DBHelp.Getcon();
conn.Open();
foreach(Appraise app in appraise)
{
string sql = string.Format("insert into Appraise(userID,sportsID,appraiseTime,appraiseContent,Support) values({0},{1},getdate(),'{3}','{4}')",app.UserID,app.SportsID,app.AppraiseContent,app.Support1);
SqlCommand cmd = new SqlCommand(sql,conn);
cmd.ExecuteNonQuery();
}
conn.Close();
}
这个的foreach语句怎么个写法？

[掌握永恒需控制现在]

引用 楼主 lsy6542 的回复:

public void InsertAppraise(Appraise appraise) { SqlConnection conn = DBHelp.Getcon(); conn.Open(); foreach(Appraise app in appraise) { string sql = string.Format("insert into Appraise(userID,sportsID,appraiseTime,appraiseContent,Support) values({0},{1},getdate(),'{3}','{4}')",app.UserID,app.SportsID,app.AppraiseContent,app.Support1); SqlCommand cmd = new SqlCommand(sql,conn); cmd.ExecuteNonQuery(); } conn.Close(); } 这个的foreach语句怎么个写法？

Appraise 是一个什么

[gclol]

我猜你是想一次数据库操作执行完所有insert语句... 要是没猜错的话，在sql server里做不到，oracle里用OracleParameter，将OracleParameter.Value设为含有参数值的数组

[掌握永恒需控制现在]

引用 楼主 lsy6542 的回复:

public void InsertAppraise(Appraise appraise) { SqlConnection conn = DBHelp.Getcon(); conn.Open(); foreach(Appraise app in appraise) { string sql = string.Format("insert into Appraise(userID,sportsID,appraiseTime,appraiseContent,Support) values({0},{1},getdate(),'{3}','{4}')",app.UserID,app.SportsID,app.AppraiseContent,app.Support1); SqlCommand cmd = new SqlCommand(sql,conn); cmd.ExecuteNonQuery(); } conn.Close(); } 这个的foreach语句怎么个写法？

appraise应该是一个Appraise集合 你可以这么定义 List<Appraise> appList=new List<Appraise>(); 然后先在这个appList里面加入 所有需要的Appraise