从DataTable中取得指定数据
private int idx = 1000000;
private int fndIdx = 0;
private DataTable GetData( )
{
fndIdx = int.Parse( textBox1.Text );
DataTable dt = new DataTable( );
dt.Columns.Add( "id", typeof( int ) );
dt.Columns.Add( "name", typeof( string ) );
dt.Columns.Add( "type", typeof( string ) );
dt.PrimaryKey = new DataColumn[ ] { dt.Columns["id"], dt.Columns["name"] };
for ( int i = 0; i < idx; i++ )
{
dt.Rows.Add( i, i.ToString( ), i % 3 );
dt.Rows.Add( i, i.ToString( ) + "A", i % 3 );
}
return dt;
}
private void button1_Click( object sender, EventArgs e )
{
DataTable dt = GetData( );
DateTime tStart = DateTime.Now;
string type = dt.Select( "id = " + fndIdx + " and name = '" + fndIdx + "'" )[0]["type