Dream SoftwareDreamMaker.com Create

C# Read Excel File

Microsoft.Office.Interop.Excel.Application _excelApp = new Microsoft.Office.Interop.Excel.Application();
Workbook workbook = _excelApp.Workbooks.Open(openFileDialog1.FileName);
Worksheet workSheet = workbook.Worksheets["TabName"];
Range usedRange = workSheet.UsedRange;
object[,] valueArray = usedRange.get_Value(XlRangeValueDataType.xlRangeValueDefault);
TextBox.Text = valueArray[2, 2].ToString();

Posted on Wednesday, December 03, 2014 7:48 AM

Not able to change account picture and lock screen picture in Windows 8.1

Clicking on the Browse button just flickers and doesn't not display select window

1. Run > Regedit
2. Go to "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\Current Version\Explorer\Desktop\NameSpace"
3. Right Click at the "NameSpace" folder and make a new Key and name it to {B4FB3F98-C1EA-428d-A78A-D1F5659CBA93}
4. Double click at the "(Default)" string and put the Value data as "Other Users" (with no quotes)

Posted on Sunday, November 16, 2014 11:59 AM


Calculus is the mathematical study of change, in the same way that geometry is the study of shape and algebra is the study of operations and their application to solving equations.

Posted on Sunday, November 02, 2014 5:52 AM

If I had asked people what they wanted, they would have said faster horses. [Henry Ford]

Posted on Monday, October 13, 2014 12:01 PM

Microsoft Application Insights

Microsoft Application Insights lets you monitor your live application for:

  • Availability - Test your URLs every few minutes from around the world.
  • Performance - Detect and diagnose perf issues and exceptions.
  • Usage - Find out what users are doing with your app, so that you can make it better for them.

Posted on Monday, September 15, 2014 12:20 PM

Background Thread for better UI performance

System.Threading.Thread backgroundThread;

private void SomeMethod()
backgroundThread = new System.Threading.Thread(() => DoSomething(SomeParameter));
backgroundThread.IsBackground = true;

private void DoSomething(string SomeParameter)

Posted on Friday, September 12, 2014 1:18 PM

Capture USB Camera Video and Image

After trying various scenarios and having thread deadlock issues, I was able to use Aforge Controls & DirectShow to successfully capture live video and then an image.

private VideoSourcePlayer videoPlayer = new VideoSourcePlayer();
private VideoCaptureDevice videoDevice;

var videoDevices = new FilterInfoCollection(FilterCategory.VideoInputDevice);
videoDevice = new VideoCaptureDevice(videoDevices[0].MonikerString);

//0 = 640x480
//1 = 320x240
//2 = 800x600
//3 = 1024x768
//4 = 1280x1024
//5 = 1600x1200
videoDevice.VideoResolution = videoDevice.VideoCapabilities[3];

videoPlayer.NewFrame += new VideoSourcePlayer.NewFrameHandler(this.videoPlayer_NewFrame);
videoPlayer.VideoSource = videoDevice;
videoPlayer.VideoSource = null;
videoPlayer.NewFrame -= this.videoPlayer_NewFrame;

Posted on Tuesday, September 09, 2014 10:54 AM

Convert Image to PDF using iTextSharp

var img = iTextSharp.text.Image.GetInstance(image);
iTextSharp.text.Document document = new iTextSharp.text.Document();
PdfWriter.GetInstance(document, new FileStream(string.Format("{0}\{1}", ConfigurationManager.AppSettings["OrderFormImagePath"], string.Format("{0}.pdf", fileName)), FileMode.Create));

Posted on Friday, August 29, 2014 2:53 PM

Infinite Scrolling

Code to detect end pf page for infinite scrolling

<script type="text/javascript">
                    if  ($(window).scrollTop() == $(document).height() - $(window).height()){
                          // run our call for pagination

Posted on Friday, August 29, 2014 8:48 AM

Tour de Tonka 2014

I signed up for the Tour de Tonka 100 mile route.  Since I havent been on alot of long rides this should be a challenge.  Riding with Kelly Fitz (Starkey).

Posted on Thursday, July 31, 2014 11:22 AM