To select a particular rows from datatable

The reference for IN given by Wes Aday is good. But, since it was asked in the question to fetch rows from a DataTable, the Select method of DataTable can be used as follows:

DataRow[] rows = DataTable1.Select(
                    "SID IN (101,102,109)", "", 
System.Data.DataViewRowState.CurrentRows);

The filter expressions which can be used in the Select method are explained here
http://msdn.microsoft.com/en-us/library/system.data.datacolumn.expression.aspx[^]
If the rows returned are required to be sorted, then second parameter of the Select method can be used as explained here
http://msdn.microsoft.com/en-us/library/b5c0xc84.aspx[^]
The System.Data.DataViewRowState.CurrentRows enumeration value is used as the third parameter in the above Select method to avoid returning the rows deleted in the DataTable using Row.Delete method.

Hi ,
try this

protected void Page_Load(object sender, EventArgs e)
    {
        SqlConnection con = new SqlConnection(@"Data Source=.;Initial Catalog=test;Integrated Security=True");
        string statment = "select item_code, Item_name, brand, size, section, price, Material, Qty, tax, tt  from Items ";
        SqlDataAdapter da = new SqlDataAdapter(statment, con);       
        DataSet ds = new DataSet();
        da.Fill(ds);
        DataRow[] foundRows = ds.Tables[0].Select("item_code = 1", " item_code DESC", DataViewRowState.CurrentRows);
        //this is for create datatable with same schema like the orginal one .
        string statment2 = "select item_code, Item_name, brand, size, section, price, Material, Qty, tax, tt  from Items where  item_code = 0";
        SqlDataAdapter da2 = new SqlDataAdapter(statment2, con);
        DataTable dt = new DataTable();
 
        da2.Fill(dt);
        DataRow dr = dt.NewRow();   
        foreach (DataRow row in foundRows)
        {            
            dr[0] = row[0];
            dr[1] = row[1];
            dr[2] = row[2];
            dr[3] = row[3];
            dr[4] = row[4];
            dr[5] = row[5];
            dt.Rows.Add(dr);
        }
        con.Close();
        cmd.Dispose();
        GridView1.DataSource = dt; 
        GridView1.DataBind();
    }

Best Regards
M.Mitwalli

DataRow[] rows= dt.Select("Columnname IN (PID's)");

dt=DataTable Object name

I'm not sure what exactly you mean. I have an idea that may help you though.
You can try:

select * from [name of your table] where sid=101 or sid=102 or sid=109;

If you have a DataTable object you can access the data with the following statement:

string theData = [name of your object].Rows[Y].ItemArray[X].ToString();

Y is the row index (first row is 0) and x the column index.

Hi,
Do it like this...

Select * from [TableName] where SID IN(101,102,109);

string sql = "SELECT SID, SNAME from Your Table";
            DataRow dtrownew;
            int i=0;
            SqlConnection sqlcon = new SqlConnection("Data Source=server;Initial Catalog=database;uid=user;pwd=password");
            sqlcon.Open();
            SqlDataAdapter adapter = new SqlDataAdapter(sql, sqlcon);
            DataSet dataSet = new DataSet("DS");
            adapter.Fill(dataSet, "TBL");
            //create new table with the original structure
            DataTable dttable = dataSet.Tables["TBL"].Clone();
            //loop though each row
            foreach (DataRow dtrow in dataSet.Tables["TBL"].Select("SID IN (101,102,109)"))
            {
                dtrownew = dttable.NewRow();
                //copy each field value to the new table
                while (i < dtrow.ItemArray.Length)
                {
                    dtrownew[i] = dtrow[i];
                    i++;
                }
                dttable.Rows.Add(dtrownew);
                i = 0;
            }
            gvCustomers.DataSource = dttable;
            gvCustomers.DataBind();