Give your variables meaningful names. At a glance, what does textBox1 do?
Your code is wide open to a SQL Injection attack. You need to look into using parameterised queries here.
Your insert statement does nothing. You create the command text and then close the connection - you need to execute the command using cmd.ExecuteNonQuery();
You have no exception handling. What happens if you can't connect the database, for instance?
If you had bothered to debug your code, you would have found the problem out in an instant. Learning to debug is one of the most valuable lessons you can master as a developer, and you should learn how to do it before too much longer.
"WPF has many lovers. It's a veritable porn star!" - Josh Smith
As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.
I wrote an application which send and receive data from a pinpad(device with RS-232 which use serial port) and i start testing the application, when i finised testing the application on my computer, I upload it to the server machine to do another test but when I run the application from client computers it does not recognize the pin pad, but when I run the application from my computer it works properly. My question is that is there any way I can access the pin pad remotely?
is there any way I can access the pin pad remotely?
I dont think so : I think you need to implement a tcp/ip network layer to sit between the serial port and the network and send it commands from your application.
We do this with eftpos devices - they are sent instructions from a centralised gateway via tcp/ip, and the client on the pc interfaces to the com port (via an activex control supplied by the eftpos company) .. (ok, so there's an activex control there, but it doesnt really matter that much)
There are commercial companies out there that offer pre-made toolkits to do this - just a quick search gives :-
when you start the application on your computer, it doesn't matter where the exe-file is located, the code runs on your computer with it's local hardware!
When you need to communicate with a remote serial port, you need to run on the remote computer an application, e.g. windows service, and communication with that application (e.g. Sockets)
I don't think so. A normal com port is not reachable from remote without any local program.
But you can write a simple program which sends every received byte to com port. backwards might be a bit difficultier, because you should use DataReceived event from com port on server. but what is life without any chalenge?
I was able to access the serial port remotely but when i change the serial port to usb it does not working. Is there any way i can access the pinpad using usb ports or is there a library which work like serial port in C#.
I have a dll from a card reader...
I encapsulate this dll into a ASP.NET Class Library...
and compile it into my own CardReaderWriter.DLL.
this Class library has methods..
the card reader will be connected in client computer..
Since it's on client side, i can not use ASP .NET to call and use the Class Library
Do I need to Copy this dll to client machine and register it .
How do i create an object of this on client side to access the methods ...
i even tried the object tag but gives me the error that object doesnot support this property
Note:- i have already compiled and registered the Dll on client machine to be safe but still not able to do it.
plz guide me to the right direction.
if possible plz provide sample codes and links to articles.
thanx in advance
i populate dataset with data from uif table and one of the colum is marriage status which is integer so i want to you case statement where for example if marriage_status is 1 then it has to display single on detailsview.
here is my code
int MarriageStatus = (int)dataset.Tables["uif"].Rows["marriage_stat"];
string status = Convert.ToString(MarriageStatus);
status = "married";
I`m very new to the programming so this might be easy question to all of you, i`m hoping someone can help me out.
So i`m trying to write very easy program in windows form but i have encountered the problem.
lets say that i have an event on the button1 (CLICK) which should pick up a random number and hold it in the memory unless i click it again to change it. My problem is that i cannot figure out how to use this variable which has been set up in the first place with another event button2(Click) which will use this variable and do other task with using int previously declared. Short example:
publicvoid Random_Click(object sender, EventArgs e)
Random myRandom = new Random();
int myNumber = myRandom.Next(1,10);
publicvoid Button2_Click(object sender, EventArgs e)
This will not work and i cannot find the way to get it right
Hello still nothing cannot solve this problem, so what i tried is i tried declare variable as a (public int nameOfInteger) just before the method, in the begining oif the class and everywhere else. Still confused
thats my code
publicpartialclass Form1 : Form
publicvoid button1_Click(object sender, EventArgs e)
Random myRandom = new Random
myNumber = myRandom.Next(1,10);
privatevoid button2_Click(object sender, EventArgs e)
so when i click button1 variable should be set up and when click button2 i would like to see this variable in the message box.
Are you using some IDE? It would be helpful if you could give some error reports and I think I could think of one. Now, that would be newNumber and myNumber. Are those supposed to be the same? I think so.
Your problem is working out the SCOPE of your variable.
If you declare it in the method it dies when the method completes.
if you declare it provate in the form (I ususally put them just before the form_load method) then the variable will be available until you close the form.
Luc Pattyn [Forum Guidelines][My Articles] The quality and detail of your question reflects on the effectiveness of the help you are likely to get.
Show formatted code inside PRE tags, and give clear symptoms when describing a problem.