Hi All I am developing a website in C# using VS 2005, Is it possible to get 1) Visitor IP 2) Visitor Country 3) Visitor Browser Details 4) Visitor Logged Time as email to my gmail account Kind Regards RK

Dear Tim Thank you very much it worked :) Kind regards James

Hi Tim

select count(*) from CustomerDetails where charindex('@',EmailAddress) > 0

Here its showing total record count, i wish to get the count of emails with @gmail.com @yahoo.com, but i cannot hard code this cause the list is so big that it has to run a loop by itself Kind regards James

Hi tim Thank your for your reply yes am using SQL2000

Dear All I have a Table Named CustomerDetails where i have millions of records the table structure is as follows **RecordId CustomerName CompanyName EmailAddress Phone** Is it possible to get the EmailAddress count of specific domains like how many emails with @gmail.com, @yahoo.com, @rocketmail.com, @att.net, @verizon.net I have tried a lot of ways but i have failed in all tries , If possible drop me a line of code so it will be a great help for me Kind regards James

Dear all I am developing a website for a client in ASP.NET, Client wants to protect his webpages from copied. He asked me the following 1) Stop right click 2) Stop Context menu 3) Stop user saving and viewing source using "Save Page As" and "Page Source" in firefox. "Save As" and "view source" in internet explorer. 4) Stop taking print screen and saving it as image In this i have accomplised the tasks 1 & 2 using javascript. is there any way to do the 3 & 4 tasks. If not possible please drop me the exact reason so i can make the client understand. Thanks in advance Regards sc

Hi there Can someone guide me how to do Dos printing, with paper eject and margin set. I am having a C# application with SQL 2000 i have data loaded into developer express grid. when the user selects print. it must go for dos based printing. Right now i am writing it to a text file then tried printing i am facing alignment problem like if a line has 130 letters everything goes to a mess. here is what i have to print ----------------------------------------------- Company Name Address Line1 Address Line2 ----------------------------------------------- Bill No :- 12345 Bill Date:- DD/MM/YYYY ----------------------------------------------- Customer Name :- John Travolta ----------------------------------------------- ----------------------------------------------- Waiting for a reply Thanks

Yes if i give File.WriteAll, i tried but it was not working, cause its taking last file name and writing it on places of XXX-XX.

Hi all, Am replacing a particular string with another string of a text file dynamically. but while doing this am putting them to a richtextbox also. the contents of this text file contains lot of HTML tags. right now am facing alignment problems. here is the code i have for replacing can some one help me with better solutions than mine <------------------CODE---------------------> public void ConvertFile(string Pathstring) { bool change = false; StreamReader re = File.OpenText(Pathstring); string test = ""; string input = null; string fileName = Pathstring; while ((input = re.ReadLine()) != null) { if (input.Contains("XXX-XX")) { change = true; } if (change == true) { if (input.Contains(".jpg")) { if (test.Contains("XXX-XX")) { test = test.Replace("XXX-XX", GetFilename((input))); } } } test += input+"\r\n"; } re.Close(); richTextBox1.Text = test; } <------------------END OF CODE--------------------->

It wont work since the.jpg has to be taken dynamically, its writing same file name for all XXX-XX

Dear All, Am having Nearly 470 Text files. I want to do a text replacement in all these files. There are 60-80 replacements in each page. here is sample contents of one of the file [](javascript:popUp\('../images/Backpack/158-62.jpg'\)) [](javascript:popUp\('../images/Backpack/194-62.jpg'\))

[](javascript:popUp\('../images/Backpack/106-62.jpg'\))[Here for value XXX-XX it must be replaced with the .JPG file name which comes below. I have Created a Desktop Application in C# to do this. its getting converted but the alignment changes happens for files. Am doing it this way 1) Am Opening Text File private const string FILE_TAG = "[FILE]"; private const string FILENAME_TAG = "[NAME]"; private const string FILE_FILTER = "Text files (*.txt)|*.txt|All files (*.*)|*.*"; private bool m_bIncludeRelativePath = false; private bool m_bRecurseSubDirs = false; private string m_sFilePath = string.Empty; private string m_sSourcePath = string.Empty; private string m_sInputTemplate = string.Empty; string sPingPath = string.Empty; public TEXT_REPLACE() { InitializeComponent(); } private string GetOpenFilePath() { string sFilePath = string.Empty; OpenFileDialog openFile = new OpenFileDialog(); openFile.Title = "Open File"; openFile.Filter = FILE_FILTER; if (openFile.ShowDialog() == DialogResult.OK) { sFilePath = openFile.FileName; sPingPath = openFile.FileName; } return sFilePath; //return sPingPath; } private string LoadFile(string sFilePath) { FileStream file = null; StreamReader sr = null;](javascript:popUp('../images/Backpack/106-62.jpg'))

yes exactly

1 George Washington April 30, 1789
2 John Adams March 4, 1797
3 Thomas Jefferson March 4, 1801
4 James Madison March 4, 1809
5 James Monroe March 4, 1817
6 John Quincy Adams March 4, 1825
7 Andrew Jackson March 4, 1829
8 Martin Van Buren March 4, 1837
9 William H. Harrison March 4, 1841
10 John Tyler April 4, 1841

yes exactly but for William H. Harrison its comming in next line, i have left space for it like 1 George Washington April 30, 1789 2 John Adams March 4, 1797 3 Thomas Jefferson March 4, 1801 4 James Madison March 4, 1809 5 James Monroe March 4, 1817 6 John Quincy Adams March 4, 1825 7 Andrew Jackson March 4, 1829 8 Martin Van Buren March 4, 1837 9 William H. Harrison March 4, 1841 10 John Tyler April 4, 1841 i have enough space like this after name, plz tell me how to do it

am sending this text file to a DOT MATRIX printer, that too to a PREPRINTED STATIONARY, is there any way i can specify X & Y positions in text file or printer

r u using windows or webapplication ?

Hi all while am writing to a text file using the way PrintTextWrite.WriteLine(PSLNO.PadRight(3) + " " + PKCODE.PadRight(14) + " " + PITEMNAME.PadRight(45) + " " + PQTY.PadLeft(40) + " " + PRT.PadRight(11) + " " + PTOT1.PadLeft(20)); when PITEMNAME length increases there is alignment problem for PQTY & PRT & PTOT1 am i doing it proper way or is there any other way to set format for text file ??? thanks in advance

But its making the print slow, right now am using this way. PrintTextWrite.WriteLine(PSLNO.PadRight(3) + " " + PKCODE.PadRight(14) + " " + PITEMNAME.PadRight(45) + " " + PQTY.PadLeft(40) + " " + PRT.PadRight(11) + " " + PTOT1.PadLeft(20)); but when size of PITEMNAME increases PQTY,PRATE,PTOT1 will go off the paper

Hi All Am developing an inventory package in C# 2005. in this customer needs printout of sales in preprinted stationary. right now am following it this way. On Clicking the grid and print button is selected am writing it to a TEXT file named SALESPRINT.TXT. AM HAVING PROBLEM FROM THIS PART, AM ABLE TO WRITE TO A TEXT FILE BUT THERE IS ALIGNMENT PROBLEMS. following is the format of the preprinted stationary. INV DATE xxxxxxxxxx INV NO xxxxxxxxxxxx PAGE NO xxxxx CUSOTMER ADDRESS1 xxxxxxxxxxxxxxxxx CUSOTMER ADDRESS2 xxxxxxxxxxxxxxxxx SL NO SHORT CODE ITEM NAME QTY RATE TOTAL xx xxxxxx xxxxxxxxxxxxxxxxxxx 10 12.25 122.5 xx xxxxxx xxxxxxxxxxxxxxxxxxx 10 12.25 122.5 xx xxxxxx xxxxxxxxxxxxxxxxxxx 10 12.25 122.5 xx xxxxxx xxxxxxxxxxxxxxxxxxx 10 12.25 122.5 xx xxxxxx xxxxxxxxxxxxxxxxxxx 10 12.25 122.5 xx xxxxxx xxxxxxxxxxxxxxxxxxx 10 12.25 122.5 xx xxxxxx xxxxxxxxxxxxxxxxxxx 10 12.25 122.5 xx xxxxxx xxxxxxxxxxxxxxxxxxx 10 12.25 122.5 xx xxxxxx xxxxxxxxxxxxxxxxxxx 10 12.25 122.5 xx xxxxxx xxxxxxxxxxxxxxxxxxx 10 12.25 122.5 xx xxxxxx xxxxxxxxxxxxxxxxxxx 10 12.25 122.5 xx xxxxxx xxxxxxxxxxxxxxxxxxx 10 12.25 122.5 _______________________________________________________________________________ TOTAL xxxxx _______________________________________________________________________________ DISCOUNT xxxxx _______________________________________________________________________________ GT xxxxx so right now am using string.PadRight & string.PadLeft to specify the positions of contents in the text file. but am finding it difficult to do it. customer is using Dot matrix printer & preprinted continuous sheets for printing this. So to do this am i doing the right thing and am i on right track ???? Please guide to finish this, if anyone knows how t

Hi Everyone I need a help, i have a number for eg :- 9.5 i want it to be 9.05 while taking to database cause if use round of it will give 9.50 but i want 9.05. am using C# 2005. Thanks In Advance