how to retrieve value stored in dataset?

[krunal kakadia]

hi all,

i have image path name in database and i am fetching it this way.

con.Open();
string img= "select imgPath from Tbl_Image where imgId='1'";
SqlCommand cmd = new SqlCommand(img,con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
con.Close();

i got path name in ds.

now my question is how to assign that path to my image.

//imgCurrent.ImageUrl

Thanks you,
krunalkakadia

[Frinavale]

Your DataSet contains a set of DataTables that contain the data that you requested from the database. In your case it looks like the result of your query is 1 table with 1 record/row in it.

You need to use the DataSet.Tables Property to retrieve the table. Then you need to retrieve the item you are interested in from the row/column in the table.

-Frinny

[dip_developer]

imgCurrent.ImageUrl=ds.Tables(0).Rows(0).Item("img Path")