private DataTable GetData(string query)
{
string conString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
MySqlCommand cmd = new MySqlCommand(query);
using (MySqlConnection con = new MySqlConnection(conString))
{
using (MySqlDataAdapter sda = new MySqlDataAdapter())
{
cmd.Connection = con;
sda.SelectCommand = cmd;
using (DataTable dt = new DataTable())
{
sda.Fill(dt);
return dt;
}
}
}
}
DataTable tempdt = new DataTable();
tempdt.Columns.Add(new DataColumn("DangerUpstream", typeof(string)));
DataTable dt = new DataTable();
dt = this.GetData("Select DangerUpstream from Table");
string Upstream = dt.Rows[i]["DangerUpstream"].ToString();
tempdt.Rows.Add(Upstream);
rptMarkers.DataSource = tempdt;
rptMarkers.DataBind();
<script type="text/javascript">
var google_markers = new Array();
var markers = [
<asp:Repeater ID="rptMarkers" runat="server">
<ItemTemplate>
{
"Upstream": '<%# Eval("DangerUpstream") %>',
}
</ItemTemplate>
<SeparatorTemplate>
,
</SeparatorTemplate>
</asp:Repeater>
];
</script>
In above C# code, I want to change the color of DataTable row "Upstream" based on If condition from code behind.
I tried below code, but its not working:
decimal res = Convert.ToDecimal(Upstream);
if (res <= 0 && res >= 2)
{
Color col = ColorTranslator.FromHtml("#0000FF");
Upstream = Color.Blue;
}
else
{
Color col = ColorTranslator.FromHtml("#FFFFFF");
Upstream = Color.Red;
}
Please reply.