User940894612 posted
I have a page which returns a list whereby a user can select a list of his plants with an icon he's previously assigned to it. We have 4 icons and a user should be able to update the plant to assign a different icon to the plant. I'm having issues displaying
the original data and do not know how to display it correctly. we have 4 icons, star - triangle - circle - heart
If the icon assigned is the star it display the image src 'star.gif', if not 'star-fallback.gif' If the icon assigned is the triangle it displays the image src 'triangle.gif', if not 'triangle-fallback.gif' etc
So in the return data
Column 1: Plant Name Column 2: 4 icons - 3 of which are the fallback and the one selected one. I need to be able to update these icons in the gridview, but for now just need the display to work.
Here's my code to bind the data
protected void BindData(int profileId)
{
string conn = ConfigurationManager.ConnectionStrings["SQLConnection"].ConnectionString;
DataTable table = new DataTable();
using (SqlConnection sqlConn = new SqlConnection(conn))
{
if (sqlConn != null)
{
try
{
if (sqlConn.State == ConnectionState.Closed)
sqlConn.Open();
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = sqlConn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "TD_GetUserPlantIcons";
cmd.Parameters.AddWithValue("@profileId", profileId);
SqlDataReader reader = cmd.ExecuteReader();
DataTable dt = new DataTable();
dt.Columns.Add("PlantName");
dt.Columns.Add("Icon");
while (reader.Read())
{
DataRow row = dt.NewRow();
row["PlantName"] = reader["PlantName"];
row["Icon"] = reader["Icon"];
dt.Rows.Add(row);
}
GridView1.DataSource = dt;
GridView1.DataBind();
reader.Close();
}
}
catch (Exception ex)
{
}
}
}
}
The Stored Procedure is a basic select statement
SELECT Icon, PlantName
FROM UserPlantIcons
WHERE ProfileId=@ProfileId
--AND UserId = @UserId -- not needed
--AND TreeId=@TreeId
--AND PlantName=@PlantName -- not needed
AND IsSelected=1
Any help would be greatly appreciated.
Thanks Rob
