Nitesh Kejriwal

09/01/2015 by Nitesh

Download Image Files From FTP Server in C#

Friends, In my previous posts, I dealt with How To List Files From FTP Server, How To Delete File From FTP Server. In this post, we will see how can we can download an image file from FTP server using C# from within your Console or Windows Forms Application. private StreamReader DownloadFileFromFTP() { var request…

09/01/2015 by Nitesh

Solution : Oledb Exception – No value given for one or more required parameters

Friends, In this post, we will see solution to an error that occurs when using OleDbConnection classes to connect with Access database. The exception says – “No value given for one or more required parameters”. This can occur while inserting, selecting, updating or deleting data in Access database. The common problems to this error are…

06/01/2015 by Nitesh

Convert Text to Title Case As You Type in TextBox Control in Windows Forms

Friends, In this post we will see how can we convert any text written by user in a TextBox Control to Title Case as they type in. If you don’t know about TitleCase, check it on Wikipedia here. In simple words, any sentence where 1st letter of every word is capital is known as to…

05/01/2015 by Nitesh

Change Height of TextBox Control in Windows Forms

Friends, From the title, this seems to be a very simple post that every novice programmer would know but changing the height of a textbox control in a Windows Forms Application is bit tricky that thought. You must be wondering that setting the Size.Height property of the control would do this, but as soon as…

03/01/2015 by Nitesh

Export Data From GridView to Excel 2007/2010 in ASP.Net

Friends, In this post, we will see how can we export data from GridView to Excel 2007/2010 format in ASP.Net in less than 5 minutes. Without much delay, let’s get started – Add EPPlus package using Nuget. Include OfficeOpenXml and OfficeOpenXml.Table namespaces at the top. In your event handler, write the below code. You’re done….