• dataset 和DataTable的用法


    以下包含了这两种不同属性的用法:

    foreach (DataRow dr in dataset.Tables[0].Rows)
                {

                    if (i != 0 && lujing!="")
                    {
                        DataTable dt = new DataTable();
                        dt = new BLL.production().GetList_pro(" production_id=" + dr["Column1"]).Tables[0];
                        int n = int.Parse(dt.Rows.Count.ToString());
                        if (n == 0)
                        {
                            model.channel_id = 20;
                            model.category_id = 83;
                            model.production_id = int.Parse(dr["Column1"].ToString());
                            model.pmzc = dr["Column2"].ToString();
                            model.title1 = dr["Column3"].ToString();
                            model.author = dr["Column4"].ToString();
                            model.img_url1 = lujing + dr["Column5"].ToString();
                            model.size = dr["Column6"].ToString();
                            model.creation_year = dr["Column7"].ToString();
                            model.judge = dr["Column8"].ToString();
                            if (!string.IsNullOrEmpty(dr["Column10"].ToString()))
                            {
                                model.explain_1 = dr["Column10"].ToString();
                            }
                            model.explain_2 = dr["Column11"].ToString();
                            model.sort_id = 99;
                            if (bll.Add(model) < 1)
                            {

                            }
                        }
                        else {
                            foreach (DataRow item in dt.Rows)
                            {

                                Model.production model_1 = bll.GetModel(int.Parse(item["id"].ToString()));
                                model_1.price_1 = dr["Column9"].ToString();
                                if (bll.Update(model_1))
                                {

                                }
                            }
                           
                           
                        }
                       
                    }
                    i++;
                }

  • 相关阅读:
    sql server 镜像操作
    微信测试公众号的创见以及菜单创建
    linux安装redis步骤
    Mysql 查询表字段数量
    linux 链接mysql并覆盖数据
    linux (centos)增删改查用户命令
    CentOS修改用户密码方法
    https原理及其中所包含的对称加密、非对称加密、数字证书、数字签名
    com.mysql.cj.exceptions.InvalidConnectionAttributeException: The server time zone value 'Öйú±ê׼ʱ¼ä' is unrecognized or represents more than one time zone. 问题解决方法
    设计模式(三):模板方法模式
  • 原文地址:https://www.cnblogs.com/WZH75171992/p/4140139.html
Copyright © 2020-2023  润新知