C#

zead wrote:

i want to create a gadget like that in igoogle in my windows form application

I are Troll

cmd.ExecuteReader();

SqlDataReader reader = cmd.ExecuteReader();
reader.Read();

create Proc [dbo].[sp_Deneme]
	as 
		Begin 
				select * from Rehber
		End 

cmd = new SqlCommand("sp_Deneme", conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
conn.Open();
reader = cmd.ExecuteReader();
while (reader.Read())
{
    label1.Text = reader.GetInt32(0).ToString();
    label2.Text = reader.GetString(1);
    label3.Text = reader.GetString(2);
}

Luc Pattyn wrote:

No comment on SELECT * ?

Luc Pattyn wrote:

GetString(1) ?

Luc Pattyn wrote:

if the fields get reordered

dr = this.con.ExecuteReader
(
    @"
    SELECT *
    FROM JunkName
    WHERE Id=@Param0
    "
,
    ID
) ;

if ( dr.Read() )
{
    result = new Junk.Types.Record()
    {
        ID              = (System.Guid)              dr [ "ID" ]
    ,
        LastName        = (string)                   dr [ "LastName" ]
    ,
        FirstName       = (string)                   dr [ "FirstName" ]
    ,
        Gender          = (Junk.Types.Gender) (byte) dr [ "Gender" ]
    ,
        FavouriteColour = Colour.Parse ( (string)    dr [ "Colour" ] )
    ,
        Created         = (System.DateTimeOffset)    dr [ "Created" ]
    } ;
}

PIEBALDconsult wrote:

reordered. Who'd do a silly thing like that?

PIEBALDconsult wrote:

IDataReader fields can be accessed by name too.

Luc Pattyn wrote:

I did expect

PIEBALDconsult wrote:

maybe you expected