tag:blogger.com,1999:blog-82899627576883203512024-12-18T20:33:26.717-08:00Discussion group for OOP Concepts, Software (Design, Architecture, Analysis, etc..), C#.NET, VB.NET, ASP.NET, MSSQL Server, FireBird and much more..Rakesh Singhhttp://www.blogger.com/profile/13723479156035658674noreply@blogger.comBlogger39125tag:blogger.com,1999:blog-8289962757688320351.post-29304590736418408932012-10-09T23:06:00.002-07:002012-10-09T23:08:58.172-07:00

Sometime there are requirements where we are required to open CSV file in excel. if it a manual process then there is now issue. MS Excel provide features using which you can open CSV by default. Excel also provides facility to open non csv files(Delimited Text Files). To use this feature go to Note: I using MS EXCEL 2010 Data Ribbon - > Select - > "From Text" Option Select text file you want

Rakesh Singhhttp://www.blogger.com/profile/13723479156035658674noreply@blogger.comtag:blogger.com,1999:blog-8289962757688320351.post-10631981943326853792012-08-03T22:19:00.003-07:002012-08-03T22:19:43.500-07:00

Sometime it is required to Generate PDF on the fly using c#. There are lots of Printer Drivers using which you do you task. I was in a situation where i have to generate PDF Invoice using EXCEL VSTO. I used PDFCreator to do my job. I will show you how to print an active Excel Sheet using PDFCreator with C#.NET First of all Install PDFCreator When i was writing this Post it, the latest version

Rakesh Singhhttp://www.blogger.com/profile/13723479156035658674noreply@blogger.comtag:blogger.com,1999:blog-8289962757688320351.post-5101558115319589992012-07-20T01:47:00.002-07:002012-07-20T01:49:45.937-07:00

Have you been in a situation were you are asked to call a Web Service where you just have a .wsdl generated from Web Service? Once i was in a situation where i had to call a service with complex data type as input as well as output. As a .NET developer we know that we can just make Web Reference to the Server URL and we can have all the underlying definition of target web service. But what

Rakesh Singhhttp://www.blogger.com/profile/13723479156035658674noreply@blogger.comtag:blogger.com,1999:blog-8289962757688320351.post-80721925816831241132012-07-06T00:25:00.002-07:002012-07-06T00:28:05.078-07:00

When it comes to selecting DataSource for control data binding now there are lots of options. You can select from SQLDataSource LINQDataSource and Entity DataSource. Each one has their own advantage and disadvantage. when i was googleing for the same a came across with a nice article, that i am sharing here. This article looks at the implications for developers in making a choice between using

Rakesh Singhhttp://www.blogger.com/profile/13723479156035658674noreply@blogger.comtag:blogger.com,1999:blog-8289962757688320351.post-78023478439031152182012-07-05T23:44:00.003-07:002012-07-05T23:45:49.150-07:00

SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE FUNCTION [dbo].[fnSplit] (     @sInputList VARCHAR(8000)  -- List of delimited items      , @sDelimiter VARCHAR(8000) = ',' -- delimiter that separates items     )     RETURNS @List TABLE (Offset int, item VARCHAR(8000))     BEGIN    

Rakesh Singhhttp://www.blogger.com/profile/13723479156035658674noreply@blogger.comtag:blogger.com,1999:blog-8289962757688320351.post-25184384484220231862012-07-05T06:09:00.001-07:002012-07-05T06:09:23.253-07:00

The view of this article is to show use of dataAdapter to update Database. string file = Application.StartupPath + @"\excel.xlsx";            DataSet ds = ImportExcelXLS(file, true);            //SqlConnection conn = new SqlConnection("Data Source=server;Initial Catalog=TestDB;User Id=sa

Rakesh Singhhttp://www.blogger.com/profile/13723479156035658674noreply@blogger.comtag:blogger.com,1999:blog-8289962757688320351.post-52085366863414604092012-07-05T06:05:00.001-07:002012-07-05T06:05:30.392-07:00

Add Reference to Microsoft Access 14.0 Object Add Reference based on Version of Access you are Using  I am using Access 2010  string file = Application.StartupPath + @"\excel.xlsx"; DataSet ds = ImportExcelXLS(file, true); ds.WriteXml(Application.StartupPath + @"\test.xml", XmlWriteMode.WriteSchema); access.Application _accessData; _accessData = new

Rakesh Singhhttp://www.blogger.com/profile/13723479156035658674noreply@blogger.comtag:blogger.com,1999:blog-8289962757688320351.post-49342360932070019582012-07-05T06:01:00.002-07:002012-07-05T06:17:35.245-07:00

Understanding Parameters FileName: Defines path to Excel File hasHeaders: Defines whether each column in Excel files has header included public static DataSet ImportExcelXLS(string FileName, bool hasHeaders)         {             string HDR = hasHeaders ? "Yes" : "No";       &

Rakesh Singhhttp://www.blogger.com/profile/13723479156035658674noreply@blogger.comtag:blogger.com,1999:blog-8289962757688320351.post-26779219824821013962012-07-03T00:41:00.000-07:002012-07-03T00:44:27.339-07:00

Have you ever used ASP.NET AJAX and Timer Control and ModalPopup Ctonrol on a page? If yes, Then how you Managed to Display Modalpopup when Timer Control Tick event occurs? Many of you have faced such situation even i have faced the same. But i used a very simple solution to handle the same. What is did it is, Stopped the timer control when i view the ModalDialog and then restart the timer when

Rakesh Singhhttp://www.blogger.com/profile/13723479156035658674noreply@blogger.comtag:blogger.com,1999:blog-8289962757688320351.post-9218309005705749972012-07-03T00:11:00.001-07:002012-07-03T00:15:55.639-07:00

Many people have faced a situation where they have to show documents like .PDF,.Doc ,.Docx and other like images too. For showing Images there are lots JQuery Plugins available which can accomplish these task and are really good. But how to show real document to the user, in stead of showing them the option to download you can provide facility to your users where they can view documents

Rakesh Singhhttp://www.blogger.com/profile/13723479156035658674noreply@blogger.com1tag:blogger.com,1999:blog-8289962757688320351.post-80106723736359065662012-03-26T05:19:00.004-07:002012-03-26T06:28:14.509-07:00

Hello,I was asked to implement ASP.NET built in User Management using MySQL. Though It was a new work for me, Because I do have that much knowledge in ASP.NET compared to Winform.But, Google was with me. So i started exploring the same, and found lots of articles on how to implement.I would like to explore the same here.I assume you have already installed MYSQL Server. :)Steps 1:Install MYSQL

Rakesh Singhhttp://www.blogger.com/profile/13723479156035658674noreply@blogger.comtag:blogger.com,1999:blog-8289962757688320351.post-13471914054956393662012-03-26T05:08:00.002-07:002012-03-26T05:14:29.935-07:00

Hello Everyone,Having years of experience on .NET Technologies. I have never looked at anything related to open source. But was always impressed with DNN, being an open source CMS i never had a chance to explore it.For last few months. I was introduce to OpenERP. A Python and PostgreSQL based open source ERP solution. I was impressed with it too and started exploring its functionality. I started

Rakesh Singhhttp://www.blogger.com/profile/13723479156035658674noreply@blogger.comtag:blogger.com,1999:blog-8289962757688320351.post-67465041797201687642012-03-01T22:34:00.002-08:002012-03-01T22:37:47.583-08:00

Hello,I am back again with new spirit. Since two i didn't a single word, But could not stay without this.So i am back.during these two years i came across many technologies like silverlight, WCF , WPF and OpenERP.So, from now you will find some interesting stuffs on this.If you want to ask and have any articles related to this, you are welcome.you can also visit http://www.itlabsindia.in/

Rakesh Singhhttp://www.blogger.com/profile/13723479156035658674noreply@blogger.comtag:blogger.com,1999:blog-8289962757688320351.post-36907898884867289452010-04-21T22:46:00.000-07:002012-03-26T05:39:35.400-07:00

Hello Friends, after a very long i am writing this blog. As i was bussy with changing my current employer. Ever if you had ever visited my profile would have found that i was working with 4Colordesign.com. But, now i have left it and have joined Silver Touch Technologies Ltd. with a new designation "Programmer". This is not important. Today we are here to introduc ourself with C# 4.0. Yes,

Rakesh Singhhttp://www.blogger.com/profile/13723479156035658674noreply@blogger.comtag:blogger.com,1999:blog-8289962757688320351.post-29499905278090072792009-09-09T06:46:00.000-07:002009-09-09T06:58:23.041-07:00

Backup and Restore operation on any database is a common operation. Some times it becomes very tedious when not handled properly.There are some points that needs to be kept in mind while restoring a database. Here i am providing the code for restoring SQL Server Database from C# Code.While restoring Database use should keep in mind that, only one user is using the Database, what i mean to say is

Rakesh Singhhttp://www.blogger.com/profile/13723479156035658674noreply@blogger.comtag:blogger.com,1999:blog-8289962757688320351.post-48941413301830225132009-07-09T01:48:00.000-07:002009-07-09T02:00:24.641-07:00

Hello,many times in interviews, A quesion is being asked that "How to swap two values with out using thrid variable".We know how to swap using thrid vaiable i.e.a=10;b=20;c=0;c=a;a=b;b=c;Now, if you want to swap two string variables without using third variable usestring A= "string A";string B= "string B";A+=b;B = A.substring(0,A.Length-B.Length);A = A.substring(B.Length);in order to swap two

Rakesh Singhhttp://www.blogger.com/profile/13723479156035658674noreply@blogger.comtag:blogger.com,1999:blog-8289962757688320351.post-71031431433340224552009-06-26T00:15:00.000-07:002009-06-26T05:52:47.418-07:00

I am supporting a project which is in market, developed by our company. All of a sudden our client appeared and asked for multi-language support for the software. i was very much confused on how to deliver that. But later i found that with the Help of VS.NET it is very much easy to deliver any application with multiple language support.So, i decided to write this article on my blog about how to

Rakesh Singhhttp://www.blogger.com/profile/13723479156035658674noreply@blogger.comtag:blogger.com,1999:blog-8289962757688320351.post-28306029845842285982009-06-16T01:55:00.000-07:002009-06-16T01:56:29.023-07:00

int[] Arr = { 1, 2, 1, 24, 25, 1, 5, 5, 8, 7, 96, 3, 8, 4, 12, 45, 8, 6, 9, 5 };ArrayList Array = new ArrayList(Arr);Hashtable ht = new Hashtable(); foreach (int item in Array) ht[item] = null; ArrayList AList = new ArrayList(ht.Keys);

Rakesh Singhhttp://www.blogger.com/profile/13723479156035658674noreply@blogger.comtag:blogger.com,1999:blog-8289962757688320351.post-25006826256716339942009-04-10T03:17:00.000-07:002009-06-16T01:55:26.143-07:00

Here is a simple password generator.there is nothing special in this code, i have just used the Random class in C# to generate random number and some range of character from Character Array, below code illustrate is more easily.public string GetRandomPassword(int numChars , int seed) { string[] chars = { "a", "b", "c", "d", "e", "f", "g", "h", "i", "j", "k", "l", "m", "n", "o",

Rakesh Singhhttp://www.blogger.com/profile/13723479156035658674noreply@blogger.comtag:blogger.com,1999:blog-8289962757688320351.post-17933725333859645392009-04-08T23:39:00.000-07:002009-04-08T23:50:18.189-07:00

There are situations where some time it is viable to go for late binding.though it is a tedious to perform and also needs carefull overall programming.I was working on a project where clients were continious asking for new changes and want in Auto updates and at that time found late binding better for the situation.Though early binding is considered as better option than late binding, but late

Rakesh Singhhttp://www.blogger.com/profile/13723479156035658674noreply@blogger.comtag:blogger.com,1999:blog-8289962757688320351.post-60670395801589711872009-04-03T02:49:00.000-07:002009-04-10T03:23:14.601-07:00

Here is a very simple method for uploading and downloading files from FTP server.you need to have FTP Host Name and UserName and Password for Authentication credentialsMake a reference to System.NetDownLoad://Filepath is the path to your local machine where you want to download the file//Filename is the name of the file which you want to download from FTP Serverprivate void Download(string

Rakesh Singhhttp://www.blogger.com/profile/13723479156035658674noreply@blogger.comtag:blogger.com,1999:blog-8289962757688320351.post-88431703980359952832009-01-28T01:00:00.000-08:002009-01-28T01:07:57.956-08:00

Very recently i have been shifted to ASP.NET programming. In the beginning i was facing a lots of problem. but now, I find myself bit comfortable with this. i am providing a simple code for downloading any file from Web Server located in any directory on the Web Application folder.make a reference to System.IO, and check that your web application has rights for Read/Write/Modify/Execute

Rakesh Singhhttp://www.blogger.com/profile/13723479156035658674noreply@blogger.comtag:blogger.com,1999:blog-8289962757688320351.post-24715268200008683312008-11-28T22:07:00.000-08:002008-12-02T02:05:20.390-08:00

I am using Firebird since last 2 years from 1.5 version. The latest version that i am presently using in Firebird 2.1.0 Super Server. Before this I had never used any open source Database, though there are lots of Databases available likeSQLitePostgresMySQLetc..Being a file based RDBMS, i have seen very good performance in Firebird.though we are using firebird in our company there are lots of

Rakesh Singhhttp://www.blogger.com/profile/13723479156035658674noreply@blogger.comtag:blogger.com,1999:blog-8289962757688320351.post-73582649392866310202008-09-12T05:08:00.000-07:002008-09-12T05:12:07.632-07:00

Add a reference to Microsoft Word Object XX.0 Library and also same for Excel. i have user Object Library 12.0using MSWord Microsoft.Office.Interop.Word;using MSExcel = Microsoft.Office.Interop.Excel;public bool CreateWordDocument(string FilePath) { bool bsuccess = false; try { object missing = System.Reflection.Missing.Value;

Rakesh Singhhttp://www.blogger.com/profile/13723479156035658674noreply@blogger.comtag:blogger.com,1999:blog-8289962757688320351.post-65217092180814376682008-08-13T02:32:00.001-07:002008-09-12T05:04:47.066-07:00

Q. Which is the Base class for all the classes in .NET?A. System.ObjectQ. What is the differece between .ToString() and Convert.ToString()?A. .ToString() can not handle null, while Convert.ToString() handles null and does not raise a null value exception.Q. What is the difference between bool and Boolean?A. No difference they both refers to the same, and also same is with string/String, int/int32

Rakesh Singhhttp://www.blogger.com/profile/13723479156035658674noreply@blogger.com