Hello Dave.Hope you doing great my hero. I have one final question. Your help is really great. I would like to put a a dolar sign before the values on each of the colomn bar. That is the amount of the target(in dolar) on top of each column bar. Chart1.ChartAreas(0).AxisY.LabelStyle.Format = "C" wil give the Y axis points to have Dolar sign. How do i do it for each of the coloumn in the Graph both taget and achieved one? Thanks once again dave. Cheers

Thanks a million you are my hero Dave.Anything will be given for you man. Thanks. :) One last question : dr["time"] is coming as Y axis and the others like dr["progress"] are on X axis. How do i reverse it ?so the Dr{time} is X axis. Here is the Code:-- Dim dt As New DataTable With dt .Columns.Add(New DataColumn("Hour", System.Type.GetType("System.String"))) .Columns.Add(New DataColumn("Acheived", System.Type.GetType("System.String"))) .Columns.Add(New DataColumn("Hourly_target", System.Type.GetType("System.String"))) .Columns.Add(New DataColumn("Hourly_targetPer", System.Type.GetType("System.String"))) .PrimaryKey = New DataColumn() {dt.Columns("Hour")} End With Chart1.Series.Add("Hourly_target") Chart1.Series(0).ChartType = System.Web.UI.DataVisualization.Charting.SeriesChartType.Bar Chart1.Series(0).IsValueShownAsLabel = True Chart1.Series(0).LabelFormat = "#" ' here you want just target money right ? Chart1.Series.Add("Acheived") Chart1.Series(1).ChartType = System.Web.UI.DataVisualization.Charting.SeriesChartType.Bar Chart1.Series(1).IsValueShownAsLabel = False ' i have changed this Chart1.Series(0).LabelFormat = "#" Chart1.Series(0).XValueMember = "Hour" Chart1.Series(1).YValueMembers = "Hourly_target" Chart1.Series(0).Points.Clear() Chart1.Series(1).Points.Clear() For Each myDataRow As DataRow In dt.Rows Chart1.Series(0).Points.AddXY(myDataRow("Hour"), myDataRow("Hourly_target")) Chart1.Series(1).Points.AddXY(myDataRow("Hour"), myDataRow("Acheived")) Chart1.Series(1).Points(Chart1.Series(1).Points.Count - 1).Label = myDataRow("hourly_targetPer").ToString + "%" Next However i get x axis -- Hourly_target and Y axis is Hour. Is there anything i am missing ,It should be the reverse . sorry i meant to ask changing the color of the barchart not the backcolor. Thanks Dave -- Modified Thursday, October 7, 2010 1:36 PM

Thanks so much its much appreciated.That is really great. I have a few questions if you dont mind.Lets say for 8:00am target is $1000 and achieved is $500 which is (50%) and 9:00am target is %2000 and Achieved is $4000 which is 200% On the first one the progress barchart whould be half target barchart. on the second one the progrees barchart should exceed the length of the target barchart twice. But this is not the case as the value 0.5 (50%) is to small in values on the scale points on Y axis though it means £500 which is half the value of the target. If i choose percentage it is a bit tricky to represnt them on graph? Where i am getting it wrong? Can you also please let me know how could i choose the backcolor of my barchart? Many thanks.Your help is great and much appreciated.

Thanks so much. Sorry if you dont mind , I have another query.On my X axis for each scale points i have two bar graph. One is the target for the day and the other one is a progreess bar which indicates as we approach to that target. Lets say (x axis is Hours of the day) for instance at 8:00am i have a target of $1000 and this is shown with one Bargraph. and i have another one which is an online realtime data that counts as persentage to this value.So at exactly 8:00am it will be zero percent and after few minutes it will climb up this point until the hour finishes. and at 9:00 there will be another datapoints on x axis may be £2000 and another progreess bar that shows the progress etcc.. $1000 is 100% target for 8:00am and another bargraph toshow what is achieved say $500 so it will be at 50% £2000 is 100% target for 9:00am and another bargraph to toshow what is achieved say $4000 so it will be at 200% How can i represent one bargraph $1000 and another one saying 50% for one datapoint in X axis? Is it clear? -- Modified Wednesday, October 6, 2010 12:37 PM

Thanks for your email.Its much appreciated.That is great point,what i wouldnt want to show is the scale points as they are Revenue points which users are not allowed to see. The backcolor is white at the moment setting the forcolor to white wont show scale y axis. Chart1.ChartAreas["ChartArea1"].AxisY.LabelStyle.ForeColor="#FFFFFF" Did i get it right?

Hi all, Is there any way to hide the Y axis scale points on my Barchart? I wouldn't want to show datapoints for the Y axis.As i dont want to be seen by users. Chart1.ChartAreas("ChartArea1").AxisY ?????? Is there any Property which ci could use to hide this scale points on Y axis? Thanks for your time. -- Modified Wednesday, October 6, 2010 11:05 AM

Sorry Henry ,I have tried to come up with it still got some error. Can you please give me a hint of one Connection string similar to the one below.    <sqlServer>ServerName</sqlServer>    <sqlDatabase></sqlDatabase>    <sqlUser>sa</sqlUser>    <sqlPassword>^1^g1xgwZxejDBJqb8FWQXYeQ==</sqlPassword>    <sqlTrusted>False</sqlTrusted>    <fileaccessDomain>c3</fileaccessDomain>    <fileaccessUserName>Daniel</fileaccessUserName>    <fileaccessUserPassword>^1^Rg+/IaL/Xa1KfZLSuaLN0Q==</fileaccessUserPassword>    <ServerRoot>\\test\test\</ServerRoot>    <VirtualRoot>BangRoot\</VirtualRoot>    <FileFTPSite>BangMedia</FileFTPSite>    <Folder>Operator Pictures</Folder>

Thanks very much Henry.Its Much appreciated.I have tried to get around it.However it doesnt have something related to the one i am using the XMl data to get a connection to a database. Any Help in relation to the one i am using Please?

Hi all, when i run my application on a local PC to connect to SQL which is installed Locally i use the following config file. <configuration>    <sqlServer>CelData</sqlServer>    <sqlDatabase>mydatabase</sqlDatabase>    <sqlUser>test</sqlUser>    <sqlPassword>test</sqlPassword>    <sqlTrusted>False</sqlTrusted> </configuration> However ,now i would like to connect to a database on remote PC (with different IP address).When i Run the application locally i would like to connect to the other server that is hosting the database. How would i change the above script so that the database is going to be the one on the remote server? Please advice. Thank you in advance.

Hi Guys , Is there any script that i can run on the database server so that i can retreive all the Computers(IP addresses) that tried connect to the database? Please advice. Many thanks, Regards, kibrom

How can i restore a database from a *.dat file?

All i have is a Database.dat file ? is it the one i have to pick up.

I am not good in Sql ? Can you please get me a little bit of hint?

Hi All, I accedentailly deleted a Sql Table .Can you give me an Idea how to recover it? Thanks

Hi all, I have the following sda.fill(ds); string xmlDs = ds.GetXml(); WebRequest req = null; WebResponse rsp = null; try { string fileName = xmlDs; string uri = "http://www.website.com/Pages/CongratulationsListener.aspx"; req = WebRequest.Create(uri); //req.Proxy = WebProxy.GetDefaultProxy(); // Enable if using proxy req.Method = "POST"; // Post method req.ContentType = "text/xml"; // content type // Wrap the request stream with a text-based writer StreamWriter writer = new StreamWriter(req.GetRequestStream()); // Write the XML text into the stream writer.WriteLine(fileName); writer.Close(); // Send the data to the webserver // SendRequest(uri); rsp = req.GetResponse(); rsp.Close(); } catch (WebException webEx) { } catch (Exception ex) { } finally { if (req != null) req.GetRequestStream().Close(); if (rsp != null) rsp.GetResponseStream().Close(); } My listner page (CongratulationsListener.aspx) doesnt seem to get any Xml data? Can any one advice please? Thank you in advance.

Hi Guys, I have the following out put from Sql data adapter(sda) WebRequest req = null; WebResponse rsp = null; Dataset ds=new dataset(); Sda.fill(ds) string xmlDs= ds.Getxml(); string fileName = xmlDs; string uri = "http://www.webpage/default.appx"; req = WebRequest.Create(uri); //req.Proxy = WebProxy.GetDefaultProxy(); // Enable if using proxy req.Method = "POST"; // Post method req.ContentType = "text/xml"; I would like to Encript the Xml data before sending it accross.How would i go about it? Thank you in advance.

Sorry Guys.Appologies

Hi Christain, Thank you for your response. Can you at least learn to be polite? Any ways I have the Answer : System.Net.NetworkCredential SMTPUserInfo = new System.Net.NetworkCredential(sSMTPUser, sSMTPPass); SmtpClient emailClient = new SmtpClient("smtp.gmail.com",587); The 587 works with some mail Client but not with others like Gmail, etc...

Hi all, if someone forgets there password for login to a website, i would like to send them an email with there username and password by quering the database. Can any one advice me on the C# code that is used for sending email to a user? Thank you in advance.

Hi All , I would like to to have my two variables date1 and date2 to return the following format in Asp.net. Date1=20090625124000 and date2=20090625133900 Date1 and date2 have a diffrence on one hour in between. How can i build date1 and date2 Thank you in advance.