Datagrid image help
-
Hi I have built a datagrid which should populate a set of images whose urls are stored in my database, and set each of the images in my datagrid to there corresponding addresses I have a simple databind method which binds a dataset from a select query into my datagrid But i am not sure how to access the image address return values, so that I can populate the values thru my datagrid. here is my code this far any help much appreciated Cheers Boyindie
'Builds .net mysql connection and passes connection string into method Dim connection As New MySqlConnection(connectionString) 'Open connection to DB connection.Open() 'Create mySql command string for passing query or SPROC(Stored Procedure) Dim cmdString As New MySqlCommand 'Set Command to equal mySql connection, so can pass SQL query cmdString.Connection = connection 'Set command string to equal SPROC cmdString.CommandText = "sp_image" 'ONLY PLACE THIS IF SPROC, sets the command to a SPROC cmdString.CommandType = CommandType.StoredProcedure 'Create dataAdaptor for passing data between .net and mySQL Dim dataAdaptor As New MySqlDataAdapter 'Sets command object to datAdaptor dataAdaptor.SelectCommand = c