Through Crystal report try this article : Choosing a printer when printing from Crystal Reports in C#[^] while their are some Printable Reports Library for Windows Forms also try this Printable Reports Library for Windows Forms[^] Best Of Regards, SOFTDEV Sad like books with torn pages, sad like unfinished stories ...

You are welcome Shay Noy

Thank you so much Mr. S.M.Kanerkar. Your solution works well. Regards Drex

I'm still wondering how to use that Crystal Report? Anyone can let me know how to show a dataset table result using a Crystal Report after clicking a button? And how can I pass 3 string parameter to the Crystal report? Thanks for reading. Drex

Thanks Mr. Dave,I have solve the problem. I make a mistaken on the DataGridView1.Column1 header name. So I change it to the original name and it works now. Thanks alot to Mr. Dave and everyone reading here. Regards :) Drex

Thanks Jon_Boy and Mr. Dave for the help. I have solve the problem here by changing what you recommend to me. It work well now. :)

You didn't specify which line the error occurs on, but I can take an educated guess: ObjAdapter.Fill(ds, "Client_Comp") Your DataSet object, ds, is Nothing, or null in C#. You have to create an instance of a DataSet object to pass to the DataAdapter. A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007, 2008

Yes,thats what I wish the combobox can auto showout all the stuff that match the user type drop down inside the combobox. Do you have any sample how should I do it? Thanks for replying.

Hi Drex, drexler_kk wrote: ' " & TerminalLocate & " ' to >> '"& TerminalLocate &"' Actually the problem was apparently as I described, but you did indeed solve it. Your variable TerminalLocate was correct, but because of the spaces between the single quotes and the double quotes, your code executed the UPDATE statement with the parameter value: " KK " instead of "KK" as you needed. In other words, in your code the update statement became: UPDATE WhatWasYourTablesNameAgain SET WhatWasThatFieldsNameAgain = 'blablabla' WHERE TerminalCode = ' KK ' instead of: UPDATE WhatWasYourTablesNameAgain SET WhatWasThatFieldsNameAgain = 'blablabla' WHERE TerminalCode = 'KK' So yes, it was because of the spaces... ;) My advice is free, and you may get what you paid for.

If I understand you correct you want to run something from a shared folder without having to log in a user. One way is to run a script from HKLM\Software\Microsoft\Windows\CurrentVersion\Run You still need to login to the shared folder though, one tool for doing that is found here[^] The best is of course to use a domain and a group policy startup script.

Hello Mycroft and all , Currently my system is directly running the Main Module to do everything here. I use this design because I allowed the user to do some counter setting when the system loads. The user can change the receipt setting such as receipt starting number,counter name,receipt allignment and the selection of database profile as what I'm trying to develop it now. But I'm still wondering am I doing the right design for this? Because I read some forum said that we shouldn't used the Main Module anymore in order to make our system totally object oriented. So,do you all have any idea about using Main Module for VB.NET langguage on doing window form application system?? Hope to hear someone opinion here about this. Thanks for reading. Regards Drex modified on Sunday, July 27, 2008 11:51 PM

Glad it was helpful. Parameterized queries helps you to avoid SQL Injection attacks. CP has a good article[^] on the subject, no doubt it's worth reading. All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia How to use google | Ask smart questions

Sorry,I still can't figure out how should do this detection for my receipt printer and barcode printer here. Anyone can give me further detail or sample for the above code? Thanks for reading. Regards Drex

IMO, you should try to select the user from table with the name and password without loading everybody into the dataset, ie Select * from pos_cashier Where LocationCode = @loc And UserName = @name And UserPassword = @password If you get a row, the password is valid, otherwise invalid.

Hello Mr. Christian Graus, I have try to change my code to the following: Public Function FurtherUser_Authenticate(ByVal UserVerifySuccess As Boolean) As Boolean Dim FrmAuthen As New FrmAuthen FrmAuthen.StartPosition = FormStartPosition.CenterScreen FrmAuthen.Show() End Function But I still found the error for my window frmSetting for the line of my function FurtherUser_Authenticate(). The error message appeared: Argument not specified for parameter 'UserVerifySuccess' of 'Public Function FurtherUser_Authenticate(UserVerifySuccess As Boolean As Boolean)'. Beside,can you give me some exaple how should I solve this problem here?

So the problem was not at all in the code that you posted, but in some other code that you didn't post... Assigning a boolean value to a string variable is such an obvious error. I wonder why I didn't see that by looking at the code that you posted? ;) Despite everything, the person most likely to be fooling you next is yourself.

To add, there is a vb.net example that gets installed with the .net connector, it is in C:\Program Files\MySQL\MySQL Connector Net 5.1.6\Samples\Table Editor\vb You can use that as a guide.

Thanks everyone for reading,I found the problem and solution for my post here. Just to share with someone who need it in the future,the following are what I found: VS .NET 2003 doesn't support MySql 5.0/5.1 .NET Connector. The only connector supported is 1.0 .NET Connector which is the most earliest version of tools build by MySql to linkup with VS.NET 2003. Thanks for everyone effort and hope this helps you all there in the future. Regards Drex

VB.Net forum Avoid Google. Use Blackle[^]

Repost http://www.codeproject.com/script/Forums/View.aspx?fid=1646&msg=2574964[^]