1句SQL语句返回多个字段值到指定变量

Question

declare @var1 as varchar(100),@var2 as varchar(100)
 select @var1=uuphon , @var2=uudesc 
 from sec_usr
 where uuid=44
 print @var1
 print @var2
这样在SQL里面是可以实现的，但请问假如在程序里面该如何具体写呢
我这样写的，不行啊，请教高手。
 SqlConnection cn = new SqlConnection(DbConnection);                    SqlCommand cd = cn.CreateCommand();                    cn.Open();                    string dj = "";                    string ljtr = "";                    cd.CommandText = "select @dj=dj,@ljtr=ljtr from Produc where scx='" + "生产01线" + "'";
                    cd.ExecuteNonQuery();
                    MessageBox.Show(dj);
                    MessageBox.Show(ljtr);
                    cn.Close();

Answer 1

DataSet/DataTable
DataAdapter
DataAdapter.Fill(dataset/datatable)

Answer 2

cd.CommandText = "select dj,ljtr from Produc where scx='" + "生产01线" + "'"; 
 sqldatareader reader= cd.ExecuteReader(); 
if(reader.read())
{
      MessageBox.Show(reader["dj"].tostring()); 
      MessageBox.Show(reader["ljtr"].tostring()); 
}
reader.close();
cn.Close(); 

Answer 3

//
                   SqlDataReader  reader;
                   string str = "select dj,ljtr from Produc where scx='" + "生产01线" + "'";
                   SqlConnection con = new SqlConnection(DbConnection);
                            con.Open();
                            SqlCommand cmd = new SqlCommand(str, con);
                            reader = cmd.ExecuteReader();
                            while (reader.Read())
                            {                                MessageBox.Show(reader["ljtr"].ToString());
                                MessageBox.Show(reader["dj"].ToString());
                               
                            }
                            reader.Close();
                            con.Close();                            
                      
                    //