Your Ad Here

I deleted my Files and Pictures on my Computer, what can I do about it?

June 4th, 2009 admin 3 comments

oh_no

So you lost all your important files or pictures on your computer huh?  No problem, thanks to a tool that is called DiskDigger.  By the way it is completely free too.  The tool options menu let’s you specify what kind of files you would like to search for including: images (.JPG, .PNG, etc) documents (.doc, .pdf), and multi-media (.MPG, .MP3, etc).  DiskDigger even has a preview, so you can view the files you are tryingdisk_digger1 to recover on your computer.  Pretty cool right?   One of the important things to note here is that this tool only runs on Windows.  DiskDigger recover popular file types like I mentioned above rather effectively but more complex file types are not as likely to be found.  That being said the tool has a very user-friendly interface and oh did I mention it was free!

Till Next Time,

Rene

rene@renitech.com

Categories: Technology Tags:

Bing and Wolfram Alpha take on Google. Is Google facing real competition in the future?

June 2nd, 2009 admin 2 comments

bing
wolfram

Over the last month or so there has been a lot of talk about Microsoft’s Bing Search engine and Wolfram Research’s Wolfram Alpha Answer Engine.  The talk has been mostly about how these two “search/answer” engines will compete with Google.

What’s different about Bing?

The claim is that is seems to work better than Google for finding real product information and reviews.  Google leverages keyword searches that alter particular searches.  What I mean by this is that when you do a search on Google the results are sometimes governed by websites that have tweaked their coding to help their ranking on a particular search.  I guess you can say that Bing is a lot cleaner in its search criteria.  For now… 

It is my understanding that some of Google’s commands still work with Bing, which makes the transition from Google to Bing a lot easier.  For instance, the “search” (the quotes for a particular word) will work in Bing.  I think overell Microsoft is aware that it will take time (some years) to come close to Google’s popularity.  I think a more reasonable aim is to take on Search engines like Yahoo!, Ask Jeeves and some others.

What’s different about WolframAlpha?

This one is a bit more interesting.  WolframAlpha proclaims to be an answer engine and not a search engine at all.  Huh?  Let me explain.  Wolfram Research states that the “answer engine” is like a student asking a question and a professor giving a direct answer.  So basically, you enter a key word or phrase into the WolframAlpha engine and instead of getting back a whole lot of links to different websites (like Google and Bing), you get an answer or data based on your keyword of phrase.  For example, when I typed in Miami in the WolframAlpha engine, it gave me the history of Miami and other key statistical data.  I would encourage everyone to at least test out the new engine.  Wolfram Research also states that the engine can solve complex mathematical equations, which is interesting for some academics.

My Conclusion

Both engines are still in their Beta stages, so they are very much still infants.  That being said, I think taking on a monster like Google is no easy task.  I believe Bing is more like Google and it has the greatest potential and could be a viable alternative to Google in the future.  Wolfram I believe is too technical for the general population and the search experience is a bit cumbersome.

Till next time,

Rene

rene@renitech.com

Categories: Technology Tags:

ASP.Net Chart Control-Exporting Chart to Excel FINALLY!

June 1st, 2009 admin 4 comments

Hi Everyone, I am writing this post because I have been trying to export a chart to excel using the new charting control that Microsoft has made available for Visual Studio.  I am building a Business Intelligence Dashboard for work and one of the essential components of this application is to export these charts to excel/word/etc.  After about 2 months (off and on) of trying to get this to work, I finally got it.

Let’s Get Started

Save the Chart as an Image to the server and make sure we have an empty excel file that is already stored in the server (For this example we will use MyExcel.xls).  You write this code either on the PageLoad or ButtonClick Handler.

Save the chart as an image to the server like shown below in VB.net.

Chart1.SaveImage(Server.MapPath(~\WebCharts\Chart.Jpeg”))

Now we can build the excel file after the image has been created and stored on the server.  This is the code to do that.  Note we must import the Microsoft.Office.Interop.Excel and Microsoft.Office.Core namespaces.  Here is the code that writes a dataset (in this example the dataset is called mydata) into the “MyExcel.xls” file that is stored at the server level.  At the end we will have an html link that will call this “MyExcel.xls” from the server to the user via browser.

 
Dim sFileName As String = Server.MapPath(“~\WebCharts\Chart.Jpeg”)

Dim sFilePath As String = Server.MapPath(“myexcel.xls”)

If File.Exists(sFilePath)

Then

File.Delete(sFilePath)

End

Dim objApp As Microsoft.Office.Interop.Excel.Application = New Microsoft.Office.Interop.Excel.Application

Dim objSheet As Microsoft.Office.Interop.Excel.Worksheet = New Microsoft.Office.Interop.Excel.Worksheet

Dim objWorkBook As Microsoft.Office.Interop.Excel.Workbook

Dim col, row As Integer

Try

If myData.Tables.Count < 0 Or myData.Tables(0).Rows.Count <= 0 Then

Exit Sub

End If

Catch ex As

Exception

End

Try

objWorkBook = objApp.Workbooks.Add()
objSheet = objWorkBook.ActiveSheet

objSheet = objWorkBook.Sheets(1)

objSheet.Name =
“Graph with Report”

‘This is where we add the picture.

objSheet.Shapes.AddPicture(sFileName, Microsoft.Office.Core.MsoTriState.msoFalse, Microsoft.Office.Core.MsoTriState.msoTrue, 50, 150, 850, 500)


Dim i As Integer= 1

With

objApp.Worksheets(1).Range(“A1″, “H1″).Interior.ColorIndex = 23.Worksheets(1).Range(“A1″, “H1″).Font.Color = RGB(255, 255, 255)

.Cells(1, 1).Value =“Example History for Day(s) Selected: “ & Date1.Text & ” To: “& Date2.Text

.Cells(1, 1).EntireRow.Font.Bold =True

.Cells(3, 1).Value =“Example Sales Date”

.Cells(3, 1).EntireRow.Font.Bold =True

.Cells(3, 2).Value =“Example Amount”

.Cells(3, 2).EntireRow.Font.Bold =True

i = 2

Dim k As Integer= 1

For col = 0 To myData.Tables(0).Columns.Count – 1i = 4

For row = 0 To myData.Tables(0).Rows.Count – 1

.Cells(i, k).Value = myData.Tables(0).Rows(row).ItemArray(col)
i += 1

Next

k += 1

Next

objWorkBook.SaveAs(sFilePath, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlNoChange, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing)

End With

Catch ex As

Exception

Finally

objApp.Quit()

End

Okay now we should have a dataset and an image stored in our “MyExcel.xls” file ready to go.

Calling “My Excel.xls” From HTML

This is the easiest part and you don’t have to necessary call it from a hyperlink. You can use a button or any other control to call this file. Here is the code we will use to create the link in HTML:

a href=”MyExcel.xls””>Open Excel File from Browser /a

To make it even easier, I would just drag and drop the Hyperlink control in Visual Studio into my Project and find the excel file in Properties under Source.

I hope this helps as I have been looking for a solution for quite some time. The Chart Control forum has been very useful for other matter with regards to this new charting control. I would like to thank Alex Gorv (The forum moderator) personally for all his help with other issues I have encountered using this control.

Till next time,

Rene
Please contact me if you have any questions at: rene@ReniTECH.com

Categories: Technology Tags:
1 visitors online now
1 guests, 0 members
Max visitors today: 3 at 04:02 pm UTC
This month: 5 at 12-05-2017 07:30 pm UTC
This year: 7 at 03-22-2017 08:20 am UTC
All time: 36 at 01-03-2015 08:11 pm UTC