ASP.NET DataGrid Issue

[braber]

Hello all, I am using the dataGrid control to display inventory form a database. The very last field in the database has just an HTML text string somehting like "", when the dataGrid hits this field everything works great. I am trying to fine tune it a little, so when an image of the product does not exist, who do I get an alternate image to show in the dataGrid? Heeler

[Jon G]

Does your datagrid have a Image Server control to hold the image? If so, you can do somethign like this:

If System.IO.File.Exists("PATHTOIMAGE") = False Then
CType(MyDataGrid.Items(ROW).FindControl("IMAGEHOLDERCONTROLNAME"), System.Web.UI.webControls.Image).ImageUrl = "PATHTOBLANKIMAGE"
Else
CType(MyDataGrid.Items(ROW).FindControl("IMAGEHOLDERCONTROLNAME"), System.Web.UI.webControls.Image).ImageUrl = "PATHTOIMAGE"
End If

MyDataGrid = Your data grid name PATHTOIMAGE = the path to the image taken from the DB ROW = the current row you are working with on the datagrid IMAGEHOLDERCONTROLNAME = the name of the control to hold the image inside the dg PATHTOBLANKIMAGE = the path to the blank image to use Jon G www.Gizmocoder.com

[braber]

No, there isnt a server control to house the image, my grid gets bound automatically by the data sources default view. So basically I do not build the datagrid programatically... So when I want to display other forms of the data I just edit the SQL string... Heeler

[Jon G]

Then the only way I can see you making this possible is by making a specific image reserved for blank entries, and then setting the path in the SQL server DB to that blank image when needed. Jon G www.Gizmocoder.com

[braber]

That would be ideal, any ideas on how to do that? Really I have a stored proceedure that creates the HTML string for the picture based on the item # of the product and adds that string to the database field for all records. Thanks Heeler

[Valeria Bogdevich]

Maybe this could help you: Code-behind: ... C#: public bool IsImageAvailable(String photo) { String path = "name_of_file_here"; return File.Exists(Server.MapPath(path)); }

[braber]

That looks like it might work, i'll give it a shot.... thanks Heeler

[braber]

Thanks WiB, I used your C# method and modified the way the database inserts that field. Thank you for your help... The ASP side wouldn't work because of the way the Grid was bound. But I used part of your code so thank you very much. Actually thanks to everyone that replied... :) Heeler