Dataset , DataTable ,DataColumn,DataRow

1

DataSet dataSet = frmMDI.MySql.query("select id from data");
proTable = dataSet.Tables[0];

DataTable dtTemp = new DataTable("Product");
dtTemp = proTable.Clone(); //Clone the source table to create a temporary table.

for (i = startRec; i < endRec; i++)
{
    dtTemp.ImportRow(proTable.Rows[i]);
}

2

        private void LoadPage()
        {
            int i;
            int startRec;
            int endRec;
            DataSet dsetTemp;
            DataTable Product = new DataTable("Product");
            DataTable dtableTemp;
            DataColumn dcol;
            DataRow drow;
            DataRow pro_Row;
            DataRow pic_Row;
            dcol = new DataColumn("pid");
            dcol.DataType = System.Type.GetType("System.String");
            Product.Columns.Add(dcol);

            dcol = new DataColumn("oe");
            dcol.DataType = System.Type.GetType("System.String");
            Product.Columns.Add(dcol);

            dcol = new DataColumn("mynum");
            dcol.DataType = System.Type.GetType("System.String");
            Product.Columns.Add(dcol);

            dcol = new DataColumn("oth");
            dcol.DataType = System.Type.GetType("System.String");
            Product.Columns.Add(dcol);

            dcol = new DataColumn("pic_s");
            dcol.DataType = System.Type.GetType("System.Byte[]");
            Product.Columns.Add(dcol);

            dcol = new DataColumn("pic_b");
            dcol.DataType = System.Type.GetType("System.Byte[]");
            Product.Columns.Add(dcol);


            if (proPage == proPageCount)
            {
                endRec = proMaxRec;
            }
            else
            {
                endRec = proPageSize * proPage;
            }
            startRec = proPageSize * (proPage - 1); ;
            if (startRec < 0) startRec = 0;

            //Copy rows from the source table to fill the temporary table.
            for (i = startRec; i < endRec; i++)
            {
                pro_Row = proTable.Rows[i];
                drow = Product.NewRow();
                drow["pid"] = pro_Row[0];
                drow["oe"] = pro_Row[1];
                drow["mynum"] = pro_Row[2];
                dsetTemp = frmMDI.MySql.query("select * from pro_data_pic where pid=" + drow["pid"].ToString());
                dtableTemp = dsetTemp.Tables[0];
                if (dtableTemp.Rows.Count > 0)
                {
                    pic_Row = dtableTemp.Rows[0];
                    drow["pic_s"] = pic_Row[1];
                    drow["pic_b"] = pic_Row[2];
                }
                Product.Rows.Add(drow);
            }
            gridControl1.DataSource = Product;
        }

3

proTable.PrimaryKey = new DataColumn[] { proTable.Columns[0] };
Int16 test = Convert.ToInt16(ProView.GetRowCellValue(e.RowHandle,"pid"));
DataRow row = proTable.Rows.Find(test);  
或
proTable.Select("pid=123");