lulu79

hi, I have a Gridview like below:  What I want is: 1) User can click at **LINE** column, for example user click at **M23** and it will redirect to other page. 2) At the other page, it will display something like this: **Please insert countermeasure for M23** where …

I have datatable looks like below:  I want to create a stack chart that will produce something like this:  I don't know where to start. I have google about how to create stack column but still can't get it. So far I have a chart but …

I have a LINQ function to get 3 things :: Line, Average of Duration and Count I have a problem to sort it based on Average Of Duration column. Here is my code: Dim group2 As IEnumerable(Of DataRow) = _ From row In Ds.Tables(0).AsEnumerable() _ Group row By LINENAME = …

Hi, How can i draw a horizontal line in my chart? Currently my chart look like below:  Before this i use below code to draw it but when i try to draw with this application (Y axis in datetime), it give me error like 'make sure not dividing …

I have two datatables that generate a datagridview like below: 1) datatable name : grpDT  2) datatable name : grpTot  I want to merge both datatable so that I the datagridview will be like this:  what is the best way to do this? do …

Hi, I have 2 datagridview. 1 to show TANTOU, TOTAL SUM of DURATION and COUNT of event happened. Another 1 is to show TANTOU, AVERAGE of DURATION and COUNT of event happened. I have use LINQ function to get the result. But how can i combine it so that i …

I want to display datatable result in a label. I have something like this : PLEASE TAKE ACTION FOR LINE **LABEL** But i want the result to be like this: PLEASE TAKE ACTION FOR LINE **Z3, Z5, Z8** I try to use loop but still cant get the result that …

I want to perform an UPDATE query but i'm getting this error:  This is my Sub in vb.net: Public Sub changeStatus() Dim Sqlstr As String Dim connectionString As String = "server=xxxx;uid=xxxx;pwd=xxxx;database=xxxx" Dim strtTime As String Dim endTime As String strtTime = DateTime.Today.ToString("yyyy/MM/dd") & " " & "06:15:00" endTime …

Hi, How can i change the bar chart color after I click a button? Here is the senario. I have a bar chart to show line progress. Here is the 3 condition for the bar chart: 1) Before the bar chart reach maximum limit, the color will set to blue. …

How can I change the color of bar chart based on value in database column? For example, in table "STATUS" in my database, I have 3 type of value. What I want is: 1) If the value = 0, then color will change to blue. 2) If the value = …

Hi, Is it possible to send an email from SMTP server, for example from do_not_reply@xxxx.xxx.com, without have the server credential (username and password) inside my code? I tried one code, it works, but it send from my email account. Not from SMTP server. I also tested several code but I …

Hi, I have a bar chart to display information. I also have a vertical line indicate the limit of Y-value. For example, I set the limit to 25. So now I want the color of column bar to change to red color if the column exceed the limit. I tried …

Hi, I want to get last working day data from database(SQL database). For example, if today is Tuesday, I want to get Monday data. I can get the data directly using strtTime = Date.Now.AddDays(-1).ToString("yyyy/MM/dd") & " " & "06:15:00" But the problem is if today day is Monday. Since the …

Hi, i have a dataset with 2 columns. 1 column is in String datatype and another one is in Timespan. Now i want to generate a chart from the dataset. While i'm trying to generate the chart, it has error: *"Series data points do not support values of type System.TimeSpan …

Hi, How can i convert my column with timespan dataType (Eg: 04:04:45 ) to DateTime in HH:mm:ss format (Eg: 04:04:45)? Currently I can convert the column to datetime (Eg: 10/2/2012 4:04:45 AM) but I only want the time (Eg: 04:04:45 ). Can someone help me please...

Hi, i'm a newbie and get stuck with this problem for a few days. I have datatable with two column, line and duration. I want to sum the duration based on the line group. For example: LINE DURATION A1 00:05:20 A1 00:07:00 A1 00:02:10 A1 00:01:50 A2 00:02:01 A2 00:03:45 …