using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Security;
using System.Reflection;
using System.Security.Permissions;
[assembly: AssemblyKeyFile("keys.snk")]
[assembly: AssemblyVersion("1.1.1.0")]
namespace FindDataTableDeme
{
[PublisherIdentityPermission(SecurityAction.InheritanceDemand,CertFile="Certificate.cer")]
public partial class Form1 : Form
{
DataSet ds = new DataSet();
private DataRow rowFound;
//System.Runtime.Serialization.ISerializable
//System.SerializableAttribute
/// <summary>
///
/// </summary>
public Form1()
{
InitializeComponent();
}
/// <summary>
/// 塗聚文 締友計算機信息技術有限公司 Geovin Du
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void Form1_Load(object sender, EventArgs e)
{
//DataTable dt = findDatatble();
//DataRow foundRow =dt.DefaultView.Find(this.textBox1.Text.Trim());
findDatatble();
}
private void findDatatble()
{
DataTable table1 = new DataTable("table one");
DataTable table2 = new DataTable("table two");
//creating columns for the tables:
table1.Columns.Add(new DataColumn("id", typeof(int)));
table1.Columns.Add(new DataColumn("someText", typeof(string)));
table2.Columns.Add(new DataColumn("id2", typeof(int)));
table2.Columns.Add(new DataColumn("someOtherText", typeof(string)));
//populating tables, one by one and add them to dataSet:
//populating table 1:
DataRow dr;
for (int i = 1; i < 13; i++)
{
dr = table1.NewRow();
dr["id"] = i;
dr["someText"] = "text with number " + i.ToString();
table1.Rows.Add(dr);
}
dr = table1.NewRow();
dr["id"] = 14;
dr["someText"] = "涂聚文";
table1.Rows.Add(dr);
//populating table 2:
for (int i = 101; i < 113; i++)
{
dr = table2.NewRow();
dr["id2"] = i;
dr["someOtherText"] = "other text with number " + i.ToString();
table2.Rows.Add(dr);
}
dr = table2.NewRow();
dr["id2"] = 114;
dr["someOtherText"] = "涂聚文";
table2.Rows.Add(dr);
//adding both tables to dataSet:
ds.Tables.AddRange(new DataTable[] { table1, table2 });
//you could add them seperately, like:
//ds.Tables.Add(table1);
//ds.Tables.Add(table2);
//Now lets loop through the dataSet and write the results out (int messageBox):
for (int i = 0; i < ds.Tables.Count; i++) //LOOP THROUGH TABLES OF DATASET
{
string text = null;
foreach (DataRow dr1 in ds.Tables[i].Rows) //LOOP TRGOUGH THE ROWS OF <strong class="highlight">DATATABLE</strong>
{
string a = dr1[0].ToString();
string b = dr1[1].ToString();
text += a + ". " + b + Environment.NewLine;
}
// MessageBox.Show("In dataSet is dataTable of index [" + i + "] with values:\n" + text);
}
ds.Tables[0].DefaultView.Sort = "id";
// Set Primary Key and Sort Order
DataColumn[] dcolPk = new DataColumn[1];
dcolPk[0] = ds.Tables[0].Columns["someText"];
ds.Tables[0].PrimaryKey = dcolPk;
dataGridView1.DataSource = ds.Tables[0].DefaultView;
}
/// <summary>
///
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button1_Click(object sender, EventArgs e)
{
try
{
int intRow;
object s = textBox1.Text.Trim();
// At least one row matches primary key
rowFound = ds.Tables[0].Rows.Find(s); //所搜索的内容,也是设定的主键
if (rowFound != null)
{
MessageBox.Show(rowFound[0].ToString()+","+rowFound[1].ToString());
}
else
{
MessageBox.Show("A row with the primary key of " + s + " could not be found");
}
DataRow[] foundRows;
foundRows = ds.Tables[0].Select("someText Like '涂%'");
if (foundRows != null)
{
MessageBox.Show(foundRows[0].ToString());
}
Finds the row specified in txtFindArg
//intRow = ds.Tables[0].DefaultView.Find(s);
Debug.WriteLine(intRow);
//if (intRow == -1)
//{
// MessageBox.Show("No PK matches " + textBox1.Text);
//}
//else
//{
// // Jump to the Row and select it
// //dataGridView1.CurrentRow.Index = intRow; //CurrentRowIndex
// dataGridView1.Rows[intRow].Selected=true;
//}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
private void s()
{
//create a datatable object which will host the two column: notebookID, notebook producer
DataTable o_aTable = new DataTable("Notebooks");
//creating a datacolumn
//definition and initilization of column
DataColumn o_aColumn = new DataColumn();
//defining column properties
//caption
o_aColumn.Caption = "Notebook Producers";
//type of column
o_aColumn.DataType = System.Type.GetType("System.String");
//access name of column
o_aColumn.ColumnName = "Producer";
//default value
o_aColumn.DefaultValue = "unknown producer";
//add column to the table
o_aTable.Columns.Add(o_aColumn);
//initialize a new instance of data column for creating a new column
o_aColumn = new DataColumn();
//defining column properties
//caption
o_aColumn.Caption = "Notebook Producer ID";
//type of column
o_aColumn.DataType = System.Type.GetType("System.Int32");
//access name of column
o_aColumn.ColumnName = "ProducerID";
//default value
o_aColumn.DefaultValue = 0000;
//add new column to the table
o_aTable.Columns.Add(o_aColumn);
//create a primary key column to use search
//definition and initial.
DataColumn[] o_aPrimaryKeyColumn = new DataColumn[1];
//assigning notebookID column of created table to this column: it will serve as primary key column
o_aPrimaryKeyColumn[0] = o_aTable.Columns["ProducerID"];
//mapping primary key column of table to the created primary key holder column
o_aTable.PrimaryKey = o_aPrimaryKeyColumn;
//adding rows-records to column
//create a datarow object which serves as a record entry
DataRow o_aRow;
//adding the records
//add 1th record for producer HP
//initialize a new row for table object
o_aRow = o_aTable.NewRow();
//assign value of 1th column ID
o_aRow["ProducerID"] = 1;
//assign value of 2th column producer
o_aRow["Producer"] = "HP";
//add 1th row to the table
o_aTable.Rows.Add(o_aRow);
//add 2nd record for producer IBM
//initialize a new row for table object
o_aRow = o_aTable.NewRow();
//assign value of 1th column ID
o_aRow["ProducerID"] = 2;
//assign value of 2th column producer
o_aRow["Producer"] = "IBM";
//add 2nd row to the table
o_aTable.Rows.Add(o_aRow);
//display the records within table
for (int i = 0; i < o_aTable.Rows.Count;i++ )
{
//display ID
Console.WriteLine("row " + i + ": notebook ID is: " + o_aTable.Rows[i]["ProducerID"].ToString());
//display producer
Console.WriteLine("row " + i + ": notebook Producer is: " + o_aTable.Rows[i]["Producer"].ToString());
}
//Handling row with specifying a particular primary column addressed by ID
//create a row object to store found row which matches criteria ID
DataRow o_dRow_findedRow;
//look for row with id 1
if ((o_dRow_findedRow = o_aTable.Rows.Find("1")) != null)
{
Console.WriteLine("Primary key column of Table (in memory) is being queried for notebookID 1...");
Console.WriteLine("A row with notebookID 1 is found.");
}
else
{
Console.WriteLine("A record with notebookID 1 is not found.");
}
}
}
}
DataTable search keyword
最新推荐文章于 2021-08-06 05:02:55 发布