types and untyped dataset and access the right columns

[nabil m]

hi i have a couple of questions:
1) what is the difference between type and untyped dataset - i would like t
ouse the typed dataset to take adv of intellisense- but the dataset i have
created seems untyped -
herei s my code -
//create myConn to the db and my Select query and execite
SqlConnection myConn = new SqlConnection(" ");
SqlCommand mySelectCommand = new SqlCommand("SEL ECT ContactPassword
ContactUserID FROM TABLE WHERE (ContactUserID = @emailAddress)" );
mySelectCommand .Connection = myConn;

// let it know about that paramter
mySelectCommand .Parameters.Add (new SqlParameter("@ emailAddress",
SqlDbType.VarCh ar, 50));

//create a sql data adapter
SqlDataAdapter myDataAdapter = new SqlDataAdapter( );
myDataAdapter.S electCommand = mySelectCommand ;

//assign the param to the sql params
myDataAdapter.S electCommand.Pa rameters["@emailAddr ess"].Value =
this.TextBoxEma iladdr.Text.Tri m();
myConn.Open();

// create a dataset
DataSet myDataSet = new DataSet();
myDataAdapter.F ill(myDataSet);
myConn.Close()

2) how do i access a column field called : contactPassword in my Table

this.lblPasswor d.Text =
myDataSet.Table s["TABLE_Contact_ Info"].Rows[0]["contactPasswor d"].ToString();

IT IS NOT working please help thx in advance

[SevDer]

For the difference about typed datasets
Please read it @ http://www.sevder.com/default.aspx?show=HowTO.NET
About #2. Give more details like the error message or don't you get
anything at all. (You may loose your dataset in a postback)

--

SevDer
http://www.sevder.com
nabil m wrote:

hi i have a couple of questions:
1) what is the difference between type and untyped dataset - i would like t
ouse the typed dataset to take adv of intellisense- but the dataset i have
created seems untyped -
herei s my code -
//create myConn to the db and my Select query and execite
SqlConnectio n myConn = new SqlConnection(" ");
SqlCommand mySelectCommand = new SqlCommand("SEL ECT ContactPassword
ContactUserI D FROM TABLE WHERE (ContactUserID = @emailAddress)" );
mySelectComman d.Connection = myConn;

// let it know about that paramter
mySelectComman d.Parameters.Ad d(new SqlParameter("@ emailAddress",
SqlDbType.VarC har, 50));

//create a sql data adapter
SqlDataAdapt er myDataAdapter = new SqlDataAdapter( );
myDataAdapter. SelectCommand = mySelectCommand ;

//assign the param to the sql params
myDataAdapter. SelectCommand.P arameters["@emailAddr ess"].Value =
this.TextBoxEm ailaddr.Text.Tr im();
myConn.Open( );

// create a dataset
DataSet myDataSet = new DataSet();
myDataAdapter. Fill(myDataSet) ;
myConn.Close ()

2) how do i access a column field called : contactPassword in my Table

this.lblPasswo rd.Text =
myDataSet.Tabl es["TABLE_Contact_ Info"].Rows[0]["contactPasswor d"].ToString();

IT IS NOT working please help thx in advance

--

SevDer
http://www.sevder.com