[lnkForumImage]
TotalShareware - Download Free Software

Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

microsoft.public.sqlserver.programming

getting data after this.FormView1.DataBind...

trint

3/26/2007 2:04:00 PM

After the formview1.databind, I need to get a value for a textbox.
I've tried several methods to get the "price" for a textbox to display
after this code:

SqlCommand cmdSub2 = new SqlCommand(@"Select id, code, name,
description, short_description, image_file_name, unit, price FROM
products where id = '" + productIDSub1 + "'", new
SqlConnection(@"Integrated Security=SSPI;Persist Security
Info=False;Initial Catalog=a2101;Data Source=GCCNETWORK\gcc"));
cmdSub2.Connection.Open();
this.FormView1.DataSource =
cmdSub2.ExecuteReader();
this.FormView1.DataBind();

TextBox1.Text = ?????

How can I get the "price" value outsided of the formview please?
Thanks,
Trint