code Tweets

Redirect webpage to another webpage/ website

2009-08-04T04:39:00.000-07:00

meta HTTP-EQUIV="REFRESH" content="0; url=http://www.DesTinationURL.com"

SQL Query returning duplicate records in a database

2009-07-06T02:38:00.000-07:00

Use GroupBy, Having clause

SELECT Emp_Name, Emp_ID FROM Emp_Db GROUP BY Emp_Name, Emp_ID HAVING COUNT (*) > 1

C# Read text from .doc to c# application

2009-06-29T03:57:00.000-07:00

Read text from word file (.doc)

Add referance to MicroSoft Word 11.0 object library

Word.ApplicationClass wordApp = new Word.ApplicationClass();
string filePath = "c:\\tempfile.doc";
object file = filePath;
object nullobj = System.Reflection.Missing.Value;
object nosave = Word.WdSaveOptions.wdDoNotSaveChanges;
Word.Document doc = wordApp.Documents.Open(ref file, ref nullobj, ref nullobj, ref nullobj, ref nullobj, ref nullobj, ref nullobj, ref nullobj, ref nullobj, ref nullobj, ref nullobj, ref nullobj, ref nullobj, ref nullobj, ref nullobj, ref nullobj);
string m_Content = doc.Content.Text;
doc.Close(ref nosave, ref nullobj, ref nullobj);
wordApp.Quit(ref nosave, ref nullobj, ref nullobj);

richTextBox.Text = m_Content;

Compare tables with same data

2009-06-27T04:09:00.000-07:00

SQL Query Compare data in two tables having same data

(SELECT * FROM @Table1 EXCEPT SELECT * FROM @Table2) UNION (SELECT * FROM @Table2 EXCEPT SELECT * FROM @Table1)

Will return unque records, if the query returned no records, the data in both table are same.

c# .net - Delete files from local drive

2009-06-25T00:23:00.000-07:00

try
{
Microsoft.VisualBasic.FileIO.FileSystem.DeleteFile("new2");
}
catch
{
// file does not exist
}

C# .net – write text into a file

2009-06-24T06:17:00.000-07:00

// create stream writer
StreamWriter writer = new StreamWriter("new");
try
{
writer1 = new StreamWriter("C:\\Program Files\\pdf995\\res\\PDF995.ini");
}
catch
{
file does not exist write to another file
}

c# Word automation - simplest way to create word doc in windows application

2009-06-23T06:22:00.000-07:00

WordAuto word = new WordAuto();
ArrayList array = new ArrayList();

array.Insert(0,Name.Text);
array.Insert(1,Age.Text);
array.Insert(2,Designation.Text);

word.CreateFile(array);

Read word document proprties

2009-06-22T06:26:00.000-07:00

string filePath = "c:\\docprop.doc";
object file = filePath;
object nullobj = System.Reflection.Missing.Value;
Word.Document oDoc = oWord.Documents.Open(ref file, ref nullobj, ref nullobj, ref nullobj, ref nullobj, ref nullobj, ref nullobj, ref nullobj, ref nullobj, ref nullobj, ref nullobj, ref nullobj, ref nullobj, ref nullobj, ref nullobj, ref nullobj);

oDocBuiltInProps = oDoc.BuiltInDocumentProperties;

Optical Character Recongnition

2009-06-22T06:05:00.000-07:00

Excellent article on OCR (optical character recongnition application using artificial neural networks)

http://www.codeproject.com/KB/recipes/UnicodeOCR.aspx

C# Send mail - Windows application

2009-06-22T00:30:00.000-07:00

Outlook.Application oApp = new Outlook.Application();

//Create the new message by using the simplest approach.
Outlook.MailItem oMsg= Outlook.MailItem)oApp.CreateItem(Outlook.OlItemType.olMailItem);

//Add a recipient
Outlook.Recipient oRecip;
oRecip = (Outlook.Recipient)oMsg.Recipients.Add("xyz@xyz.com");

//Set the basic properties.
oMsg.Subject = "Payment received";
oMsg.Body = "Dear Sir, We have received payment for your order";

//Send the message.
oMsg.Save();
oMsg.Send();

//Explicitly release objects.
oRecip = null;
//oAttach = null;
oMsg = null;
oApp = null;

Converting a normal IP Address to IP Long/decimal Format

2009-06-19T05:35:00.001-07:00

public long ip2long(string ip)
{
string[] parts = ip.Split('.');
string strhexip = string.Format("{0:X2}{1:X2}{2:X2}{3:X2}",
int.Parse(parts[0]), int.Parse(parts[1]),
int.Parse(parts[2]), int.Parse(parts[3]));
return Convert.ToInt64(strhexip, 16);
}

Read IP address of visitor

2009-06-19T05:32:00.001-07:00

string ip = Request.ServerVariables["REMOTE_ADDR"];

Turn off cookies for one page in your site

2009-06-19T05:05:00.001-07:00

Cookie.Discard Property which Gets or sets the discard flag set by the server

C# Clone an object

2009-06-18T21:44:00.001-07:00

public static void Main(Strings[] args)
{
Point pt1=new Point(150,160);
Point pt2=(Point)pt1.Clone(); //This will return new new object
}

Retrieve current user desktop path

2009-06-18T02:26:00.000-07:00

c# .Net

string path = Environment.GetFolderPath(Environment.SpecialFolder.DesktopDirectory);

Deploying Crystal Reports using C# .Net 2003

2007-02-23T22:44:00.000-08:00

Got rid of Crystal Reports deployment problem
This one was toughf, The crystal reports deployment problem was bugging me for last 3-4 days, finally solved the problem.

Few things to be rememberd while deploying crystal reports

1) Merge modules required are present in C:\Program files\commom files\merge moduledirectory
2)Following things to be added while deploying the application.1. Reports i.e. .rpt files2. CR Merge modules3. Dependancies
3)Merge modules to be added for VS2002 and bundeled CR are1. managed.msm2. Database_Access.msm3. Database_Access_enu.msm4. RegWiz.msmWhen RegWiz.msm is added it exposes licence key property which accepts key code
I got key codeRegistration number is 8013366187
Key Code: Your non-expiring code is AAP50-GS00008-1DW00JAProcedure for deploying with CRDeploying a Windows Application The following procedures assume that you already have a Windows application ready for deployment.To deploy a Windows application using the merge modules:

1. In VS .NET, open your Windows application and go to the View menu and select Solution Explorer. Right-click your Windows application solution and from the pop up menu, select Add then click New Project.

2. The Add New Project dialog box appears. Select Setup and Deployment Projects in the left pane and select Setup Project in the right pane. Click OK.

3. In the Solution Explorer, right-click the Windows application and select Add then click Project Output…

4. The Add Project Output Group dialog box appears. Select Primary Output to be added to your Setup project. When the Primary Output is added to the project, some detected dependencies will be added. • If you are using the bundled version of CR 9, add: managed.msm • If you are using the full version of CR 9, exclude: dotnetfxredist_x86_enu.msm and dotnetcrystalreports.msm In both cases, the dotnetfxredist_x86_enu.msm and dotnetfxredist_x86_enu.msm dependencies should be excluded if it is not already. NOTE If you are using the full version of CR 9: The dotnetcrystalreports.msm and dotnetfxredist_x86_enu.msm should be excluded because it will conflict with components in the other merge modules. Right-click on this item in the Solution Explorer and select Exclude.

5. In the Solution Explorer, right-click the WebSetup project and select Add then click Merge Module…

6. The Add Modules dialog box appears. Select the appropriate merge modules (see section above titled Crystal Reports Merge Modules) and add them to your project. Click OK.NOTE If you deploy a Windows application that uses an ADO.NET Dataset, you also need to include the two additional merge modules listed in the Runtime section above.

7. From your Setup project, select the licensing merge module to display the properties.

8. Expand the MergeModuleProperties and enter a valid license key the in License Key Properties box. The license key is the 19-digit alphanumeric string you receive when registering Crystal Reports. Please note that this is not the 10-digit registration number. This is mandatory whenever you deploy a Crystal Reports for Visual Studio .NET application. NOTE A license key will be given to you once you have registered Crystal Reports for Visual Studio .NET. You can also find the license key by opening VS .NET and going to the Help menu and selecting About…. Under the 'Installed application list' is the license key for Crystal Reports for Visual Studio .NET.

9. To build your Setup project, highlight and right-click your deployment package (setup1) in the Solution Explorer, and select Build. You are now ready to deploy your Windows application.

That's all foks.......Crystal Reports provide gr8 functionality but some times thay give vary complex problems...
You can post ur problem I will try to solve them