//DataTable 读取
DataTable dt = new TableFaqManager().GetList("ClassID asc").Tables[0];
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
DataRow dr = dt.Rows[i];
int cid = Convert.ToInt32(dr["ClassID"].ToString());
Lfenlei += "<li><a href=\"news/" + dr[0] + ".html\">" + dr[1] + "</a></li>";
}
}
//读取
SqlDataReader dr = databind.GetExecuteReader("select id,idcode,model1 from dt_bearings order by id asc", false);
int i = 0;
while (dr.Read()) //读取所有记录
{
string model = dr["model1"].ToString().Trim();
string id = dr["id"].ToString().Trim();
string idcode = dr["idcode"].ToString().Trim();
}
dr.Close();
//更新
int k = databind.GetExecuteNonQuery("update skxox set nei_jin='" + nei_jin + "',wai_jin='" + wai_jin + "' ,houdu='" + houdu + "',leixing='" + leixing + "',pp='" + zcpp + "' where id =" + id + "", false);
//插入
int k = databind.GetExecuteNonQuery("insert into xhcx_CaiJi(pp,can_x,leixing) select top 15 pp,can_x,leixing from bearings where leixing='" + leixing2 + "' and len(can_x)<7", false);
本站仅提供存储服务,所有内容均由用户发布,如发现有害或侵权内容,请
点击举报。