And just using MAX doesn't work? SELECT A.BILL, A.BILLER, MAX(A.VERSION_NO) AS VERSION_NO, A.CODE, A.NAME,A.SEGMENT_CODE, A.COMMENT,B.BILL AS BILL, B.BILLER AS DW_BILLER, B.MCN AS DW_MCN, B.SO AS DW_SO, B.BG AS DW_BG, B.CODE AS DW_CODE, B.NAME AS DW_NAME,B.SEGMENT_CODE AS DW_SEGMENT_CODE FROM WEB_REF A, WEB_CUST B WHERE A.BILL=B.BILL AND A.BILLER=B.BILLER ORDER BY A.BILL My advice is free, and you may get what you paid for.

Try Google . Esnips.com cheers, Abhijit My Latest Article : IIS 7.0 and Deploying Asp.Net WebSites on IIS 7.0

GetPrivateProfileString[^] and WritePrivateProfileString[^] You should use the registry instead.

Hi, Did you solve the issue? If not How many versions of .net do you have? **$**herin Iranimose

No problem Bob Ashfield Consultants Ltd

aaraaayen wrote: , if the user is typing the same wrong invalid password consecutively for 5 times, the user id is not getting locked in the database. how are you locking the user in database ? aaraaayen wrote: This means for the same wrong set of userid and password, the post back is not working. I dont thing post back is depends on wrong user name and password. Check your logic in details Best Regards ----------------- Abhijit Jana Check Out My Latest Article Java.NET : Integration of Java and .NET[^] "Success is Journey it's not a destination"

why would it ? I mean, it's still one attempt,right ? I guess this means some component is doing this, it's not your own code ? Christian Graus Please read this if you don't understand the answer I've given you "also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

hi aaraaayen You should be Posting this in a ASP Forum. OK lets look at your Problem aaraaayen: Wrote However, if the user is typing the same wrong invalid password consecutively for 5 times, the user id is not getting locked in the database Ok, try to Debug your Application, place a Break point from the moment you submit the user input and try to Enter incorrect credentials 5 times as you said and see where it goes wrong because we cannot tell whats wrong until we see your code. but as i said, try to debug and see where it fails and ask a Question based on the failing line and then it will be simple to help you thanks Vuyiswa Maseko, Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding VB.NET/SQL7/2000/2005 http://vuyiswamb.007ihost.com http://Ecadre.007ihost.com vuyiswam@tshwane.gov.za

A quick search on MSDN reveals these KB articles: PRB: Multiple "System Files Are Out of Date" Errors[^] PRB: Setup Cannot Continue...System Files Are Out of Date[^] You receive multiple "System files are out of date" error messages when you install a Visual Basic 6.0 application[^] This last article would probably be your best bet. A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007, 2008

I think you're mistaken in what you want the masked text box to do. int.TryParse is how you work out if a string is an int, and convert it. Christian Graus Please read this if you don't understand the answer I've given you "also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

The username and password can be whatever you want; there are defined on the SQLServer end. Create a user account, define the password, and grant access to the database.

This question was asked and answered before. You have a DNS configuration issue on your network. Only your LAN Admin can fix this problem so that all the machines on the network can resolve the name of the server to it's IP address. This is your ONLY possible solution! You can NOT use the MAC address in the connection string. The MAC address isn't usable by your code at all. It's a physical layer address used to transmit packets between network cards on the same physical subnet. The MAC is completely meaningless to your application. A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007, 2008

See this http://www.codeproject.com/KB/vb/Manage_Dialup_Automatic.aspx[^] Rajesh B --> A Poor Workman Blames His Tools <--

It's simply amazing what you can find with a little application of Google. "vb6 send email[^]" A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007, 2008

aaraaayen wrote: and if press Save it should show Save dialog box and give filename and save it, or if we Give open it should open the excel sheet. Then save the data to a temporary .xls file in the %TEMP% folder and launch this .xls file so Excel launches and opens the file itself. A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007

Try this... Dim FILE_NAME As String = "C:\test.txt" Dim tmpLine As String = "" If System.IO.File.Exists(FILE_NAME) = True Then Dim objReader As New System.IO.StreamReader(FILE_NAME) Do While objReader.Peek() <> -1 tmpLine = objReader.ReadLine() If Mid(tmpLine, 1, 1) = "1" Then ' Your code for command 1 ElseIf Mid(tmpLine, 1, 1) = "2" Then ' Your code for command 2 Else ' Your code for anything else End If Loop Else MsgBox("File Does Not Exist") End If

hey u can do one thing in excel select the column in which u r showing the date, then click on for example A column so that the entire A column gets selected then right click and select format cell then click the tab number then select date then set the format as per ur wish it will set the property for that column permanently. hope it helps Prakash Mishra(Banglore,India)

Same for winforms

Hi, Thanks lot for your reply. Can you suggest any other ideas to overcome this problem. Waiting for your reply. Regards,