• 临时数据表DataTable selected方法的使用


    using System;
    using System.Collections;
    using System.Configuration;
    using System.Data;
    using System.Linq;
    using System.Web;
    using System.Web.Security;
    using System.Web.UI;
    using System.Web.UI.HtmlControls;
    using System.Web.UI.WebControls;
    using System.Web.UI.WebControls.WebParts;
    using System.Xml.Linq;

    public partial class dataTable : System.Web.UI.Page
    {
        protected DataTable dtYxzt;
        protected DataRow row;
        protected DataRow[] rows;
        private bool IsExist(int id1, int id2)
        {      
            rows = dtYxzt.Select("id1=" + id1 + " and id2=" + id2);
            if (rows.Length > 0)
                return true ;
            else
                return false;
        }
        protected void Page_Load(object sender, EventArgs e)
        {
            Int16 id1, id2;
            dtYxzt = new DataTable("yxzt");
            dtYxzt.Columns.Add("id1", typeof(Int16));
            dtYxzt.Columns.Add("id2", typeof(Int16));
            dtYxzt.Columns.Add("sglx", typeof(string));
            dtYxzt.Columns.Add("cb", typeof(string));
            dtYxzt.Columns.Add("wsg", typeof(Int32));
            dtYxzt.Columns.Add("zzsg", typeof(Int32));
            dtYxzt.Columns.Add("sgwc", typeof(Int32));

            row = dtYxzt.NewRow();
            row["id1"] = 1;
            row["id2"] = 1;
            row["sglx"] = "新井射孔";
            row["cb"] = "采油二厂";
            row["wsg"] = 66;
            row["zzsg"] = 66;
            row["sgwc"] = 66;
            dtYxzt.Rows.Add(row);
            row = dtYxzt.NewRow();
            row["id1"] = 1;
            row["id2"] = 2;
            row["sglx"] = "新井射孔2";
            row["cb"] = "采油二厂2";
            row["wsg"] = 66;
            row["zzsg"] = 66;
            row["sgwc"] = 66;
            dtYxzt.Rows.Add(row);
            row = dtYxzt.NewRow();
            row["id1"] = 1;
            row["id2"] = 3;
            row["sglx"] = "新井射孔3";
            row["cb"] = "采油二厂3";
            row["wsg"] = 66;
            row["zzsg"] = 66;
            row["sgwc"] = 66;
            dtYxzt.Rows.Add(row);
            dtYxzt.AcceptChanges();      


            id1 = 1;
            id2 = 1;
            rows = dtYxzt.Select("id1=" + id1 + " and id2=" + id2);
            Response.Write("<br>(1,1)first:" + rows[0]["wsg"].ToString() + "<br>");
            id1 = 1;
            id2 = 4;
            if (!IsExist(id1, id2))
            {
                row = dtYxzt.NewRow();
                row["id1"] = 1;
                row["id2"] = 4;
                row["sglx"] = "新井射孔4";
                row["cb"] = "采油二厂4";
                row["wsg"] = 66;
                row["zzsg"] = 66;
                row["sgwc"] = 66;
                dtYxzt.Rows.Add(row);
               
            }
            else
            {
                rows = dtYxzt.Select("id1=" + id1 + " and id2=" + id2);
                rows[0]["wsg"] = 77;
            }      
            dtYxzt.AcceptChanges();
            rows = dtYxzt.Select("id1=" + id1 + " and id2=" + id2);
            Response.Write("<br>new(1,4)" + rows[0]["wsg"].ToString() + "<br>");

            id1 = 1;
            id2 = 1;      
            if (!IsExist(id1, id2))
            {
                row = dtYxzt.NewRow();
                row["id1"] = 1;
                row["id2"] = 4;
                row["sglx"] = "新井射孔4";
                row["cb"] = "采油二厂4";
                row["wsg"] = 66;
                row["zzsg"] = 66;
                row["sgwc"] = 66;
                dtYxzt.Rows.Add(row);

            }
            else
            {
                rows = dtYxzt.Select("id1=" + id1 + " and id2=" + id2);
                rows[0]["wsg"] = 77;
            }
            dtYxzt.AcceptChanges();
            rows = dtYxzt.Select("id1=" + id1 + " and id2=" + id2);
            Response.Write("<br>更新(1,1)" + rows[0]["wsg"].ToString() + "<br>");
            this.GridView1.DataSource = dtYxzt;
            this.DataBind();
        }


    }

  • 相关阅读:
    uinty实现玩家尾随鼠标位置平滑旋转角度
    matlab hornerDemo
    【App 开发框架
    mobiscroll手机端插件 好用(时间、日历、颜色)
    朴素的UNIX之-调度器细节
    String与StringBuffer的差别
    用jquery ajax做的select菜单,选中的效果
    Codeforces Round #253 (Div. 2)A. Anton and Letters
    unix环境高级编程——文件i/o
    CSDN的技术问题
  • 原文地址:https://www.cnblogs.com/macavalier/p/1305557.html
Copyright © 2020-2023  润新知