操作sqlserver数据库示例

      

//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);