using System;
using System.Data;
using System.Data.SqlClient;
class MainClass
{
static void Main(string[] args)
{
DataSet dset
= new DataSet
(); SqlConnection con;
SqlDataAdapter da;
try
{
con
= new SqlConnection
("DATA SOURCE =(Local);INITIAL CATALOG =BD;USER ID=;PASSWORD=;Integrated Security=SSPI;"); con.Open();
da
= new SqlDataAdapter
( "select * from tabla", con
); da.Fill( dset, "tabla" );
foreach( DataRow dr in dset.Tables[ "tabla" ].Rows )
{
System.Console.Write( "{0} ", dr[ "nombre" ] );
System.Console.Write( "{0} ", dr[ "apellido" ] );
System.Console.WriteLine( "{0} ", dr[ "lugar" ] );
}
Console.WriteLine("");
dset.Clear();
da
= new SqlDataAdapter
( "select * from tabla where nombre='pedro'", con
); da.Fill(dset,"tabla");
foreach( DataRow dr in dset.Tables[ "tabla" ].Rows )
{
System.Console.Write( "{0} ", dr[ "nombre" ] );
System.Console.Write( "{0} ", dr[ "apellido" ] );
System.Console.WriteLine( "{0} ", dr[ "lugar" ] );
}
con.Close();
}
catch( Exception e )
{
Console.Write("error: " +e);
}
finally
{
Console.Read();
}
}
}