how to divide result from select statement ?

Get the data using DataAdapter.Fill in DataTable and use dt.Rows[0].Item[0] and dt.Rows[0].Item[1]

or

use ExecuteReader to get data in SqlDataReader and use sr.Item[0] and sr.Item[1]

or

use ExecuteScalar twice with item1 and item2 separately.

select item1,item2 from items where item1='"+textbox1.text+"'

execute this query and take result into DataSet(ds)
now
var result1 = ds.Tables[0].Rows[0]["item1"]

var result2 = ds.Tables[0].Rows[0]["item2"]

This is one way you can do the things ,

Another is

Write a stored procedure having two query like

select item1 from items where item1='"+textbox1.text+"'

select item2 from items where item1='"+textbox1.text+"'

and now execute above SP and take result into one dataset and do following things,

var Result1= ds.Tables[0].Rows[0]["item1"]

var Result2 = ds.Tables[1].Rows[0]["item2"]

I hope this will help you.

All d Best.

Use this as a guideline. You should check returned values for DBNull as well.

var item1, item2;


//you must put code for creating and defining command by yourself

try
{
   SqlDataReader reader = myCommand.ExecuteReader();

   while(reader.Reads())
   {  
      //for the example purposes I'll assume int is correct data type,
      //otherwise use  proper Get method
      item1 = reader.GetInt32(0);
      item2 = reader.GetInt32(1);

      //do something with acquired data...
   }
}
catch
{
   //exception handling or just throw it
}
finally
{
   reader.Close();
   myCommand.Dispose();
}