Today morning I bought the new Mac OS X version 10.6, named Snow Leopard, at Canadian $ 40.00 with taxes. The installation is really simple. You just pop the disk in, select a couple of options and then about 40 minutes later, you are good and running the new OS.
Here are a few pictures and screen shots (click on the image for viewing in original size).
F Scott Fitzgerald’ short story, is a lot different than what we saw in the movie. Definitely a worth read.
I just bought AppleCare Protection Plan for my MacBook Pro (retails for USD 349.00) for just USD 166.00 from eBay. There are lots of sellers selling the plan at these cheap prices and they just email you the code you need for the the protection which works internationally. No fancy boxes costing an extra USD 183.
This time around he gets to meet the Justice League as well.
We knew this day was coming.
One day in your life,
You’ll remember the love you found here.
You’ll remember me somehow,
Though you don’t need me now.
I will stay in your heart,
And when things fall apart,
You’ll remember one day…
There are many ways to export data from SQL Server to Excel but I think the one way to do it by real simple coding is to export the data as an XML file and then opening it in Excel.
First we fill the data in a DataSet and then export that data to an XML file. Although the file is an XML one, I give it an extension of ‘.xls’ so that Excel opens it by default and then it can be saved it as the Excel format in some other sheet.
Dim con as SqlConnection
con = New SqlConnection(“Data Source=SERVER; Initial Catalog=dbTest;uid=sa;pwd=123”)
Dim cmd As SqlCommand = New SqlCommand
cmd.CommandText = “spExportData”
cmd.CommandType = CommandType.StoredProcedure
cmd.Connection = con
Dim ds As New DataSet
Dim da As New SqlDataAdapter
da.SelectCommand = cmd
Dim savefileName As String = Application.StartupPath & “\ExportedFile.xls”
If in a table, some columns occasionally contain null values, then while trying to retrieve the values, the following error is shown:
Conversion from type ‘DBNull’ to type ‘String’ is not valid.
To solve this problem, we can check if the Datareader has a null value for the column, and if yes, then just getting the TextBox to show an empty string.
If DBNull.Value.Equals(dataReader1(“Column_Name”)) Then
TextBox.Text = “”
TextBox.Text = dataReader1(“Column_Name”)
Chris Connell writes about what separates software engineering form computer science. Quoting:
Formal software engineering processes, such as cleanroom engineering, are gradually finding rigorous, provable methods for software development. They are raising the bright line to subsume previously squishy software engineering topics.