I want to display data from database in GeoMap. My database table is:
Station Name Danger Levels St-01 Normal(blue) St-02 Danger(red) St-06 Warning(yellow) St-10 Danger(red) St-11 Warning(yellow)
Now in GeoMap, For Particular state(of Malaysia), I need to show the different stations and danger level(using colors defined in above table) related to each stations (from above database table). Need to understand the code as per my requirement: URL...
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())
[Code] ....
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; }
What I want to do is to replace number with a name. So if in the Month Column it receives five "1" it changes those 5 "1" to JANUARY.
Is it possible? This is because unfortunately I can only arrange my months by number and not by their name, this because of my queries and tables format, so, I thought maybe I can tell the gridview to change the month number to their relative month name.
I have a table that shows datas from a SQL DB. Some of those datas is numeric ( 1,2,3) and in another table I got the name that represents each number.
ex:
1= Goalie 2= Defence
So I did a Class_filters, in which I associate the number to the right string data.
I was wondering how can I do that in GridView? Is it possible?
I have a gridView and I would like to extract the PhotoPath (ftppath + filename (ftp://192.168.1.2/Jelly.jpg))
its in asp.net and I'm not sure how to retrieve the data ive set the gridView up for selection and I like to "upon" select store the PhotoPath in a string.
Im trying to render a gridview control to a string as part of a confirmation email to be sent to a customer. When I try to render it, I get an exception.
ex = {"Control 'OrderLineItems1_gridOrder' of type 'GridView' must be placed inside a form tag with runat=server."}
The code which is attempting to render the control is
[Code]....
The RenderControl() raises the aforementioned exception. Has anyone succeeded in doing something similar.
I am exporting data from gridview to excel file.My problem is that for all the string which contain "+", the rest of data begining from it is missing in excel file.For example: PWE-WER+78, when exported it will become PWE-WER.Below is my code.
I have a column in my gridview titled Progress. The data is currently consisting of integer values such as 1, 2, and 3. How can I change them to say "Good", "Review", and "Redo" based on their value?
when bind list of strings to listview , what value needs to supply for Datakey or what should be done so ListViewUpdateEventArgs.newValues in ItemUpdating event can be accessed without empty?
I have a gridview that is built using a objectdatasource and set to autogenerate the columns based on that source, on some other pages i have a gridview that is built within the page with template fields and so on..
in that gridview i have a field that displays the time value like so
I am trying to format the cost as 10.00 but does not seem to have any effect at all. I get the values OK, but if the value of the string is 10.90, the output I get is 10.9
i have an objectdatasource bound to the System.Web.Security.Roles getAllRoles methods, this method returns an string[] with the names of the roles, then i wanna bind a gridview with this datasource, but it shows me just a one column named length(the length of each role name), how can i instead the length of the string that represent the role name, put the role name?
i need to concatenate the gridview rows to a single string if the gridview count is more than 100 then i need to perform the concatenation as 100 comma seperated and the next has to be carried over to the next string say if the count of gridview is 1000 then i need to concatenate the string as string1= 1to 100(Ex: a,b,c....) then string2=101-200 string3= 201-300... and so on. in case if i had to use String builder for this.. tel me how to proceed with this.
I have a DropDownList when selected, brings up Detail Info in GridView1. That GridView has a LinkButton when selected brings up the final Detail Info, in GridView2. need to have the GridView2 clear out and display as when it is "EmptyDataText", when the DropDownList is changed.