December 2007 Entries
The description is used as the meta description as well as shown in the related posts. It is recommended that you write a description, but not mandatory
Dr. John Tunicliffe wrote a nice class for creating excel 2007 spreadsheets and was nice enough to post his work on the codeplex web site.
http://www.codeplex.com/ExcelPackage
I was looking to use the ExcelPackage to create a spreadsheet on a website with out having to save the spreadsheet on the server first. Well to do this we are going to have to modify the ExcelPackage class to have an constructor which accepts a stream. After you download the ExcelPackage class from codeplex add the following code to ExcelPackage.cs contructors region.
#region ExcelPackage Constructors
/// <summary>
/// Creates a new instance...
The dot net framework 3.0 added the system.speech namespace. One of the new classes they added is the SpeechRecognizer. The speech recognizer class has a SpeechRecognized event which you can use to make your application accept dictation.
For this example you need to create a .net 3.0 or .net 3.5 windows forms app. Place a multi-line textbox on the form.
Imports System.Speech
Imports System.Speech.Recognition
Public Class Form1
Dim recognizer As New SpeechRecognizer
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
AddHandler recognizer.SpeechRecognized, AddressOf SpeechRecognized
End Sub
Private Sub SpeechRecognized(ByVal sender As Object, ByVal e As...
When you are running a VB express 2008 on a 64 bit operating system there are times you need to compile the app as a 32bit. One example is if you need to open an access database. There is not a 64 bit version of jet. To force your app to use the 32 bit version you need to compile the app for the x86 version of the framework.
Unfortunately there is no built in way to change the target cpu in VB express 2008. Your best bet is get a copy of Visual studio but if this is not...
Change the DataType of a Column
Sometimes when you fill a DataTable the .Net framework does not get the data type right. Unfortunately once you fill a data table you can not change the data type. You can use the data adapters FillScheme method to setup the data table this will allow you to be to change the data type. Then you can fill the datatable with the data of the right type. .
VB Example
Dim conn As New SqlClient.SqlConnection("Server = .\sqlexpress; Database = NorthWind; " & _
"Integrated Security = sspi;")
Dim dt As New DataTable
Dim da As New SqlClient.SqlDataAdapter("Select * from [Order Details]",...