|
veejay_veejay wrote: what the hell are you talking
have you gone nuts ???
if you dont how work then go to hell, but don't waste our precious time.
Who rattled your cage?
veejay_veejay wrote: if you keep on doing these stupid things i will report you as a spam and the administrator will block you account, mind it.
Please, be my guest. Go right ahead.
No trees were harmed in the sending of this message; however, a significant number of electrons were slightly inconvenienced.
This message is made of fully recyclable Zeros and Ones
|
|
|
|
|
i am inserting values of useridtxtbx and pwdtxtbx to database on submitbtn_click.Insert statement is not showing error while debugging ..but when the program runs it is giving syntax error..Below is my code
protected void submitbtn_Click(object sender, EventArgs e)
{
OleDbConnection con= new OleDbConnection("provider=Microsoft.Jet.OLEDB.4.0;data source = C:\\Documents and Settings\\swuser\\My Documents\\Clinical_Billing.mdb;" );
con.Open();
OleDbCommand cmd = new OleDbCommand("insert into user_login(user_id,password) values('" + useridtxtbx.Text + "','" + pwdtxtbx.Text + "'", con);
cmd.ExecuteNonQuery();
con.Close();
}
|
|
|
|
|
Use parameterized queries. You should be good then.
|
|
|
|
|
myinstincts wrote: new OleDbCommand("insert into user_login(user_id,password) values('" + useridtxtbx.Text + "','" + pwdtxtbx.Text + "'", con);
As Navaneeth, suggested try to avoid code like that. It will caused SQL Injection Problem. Use Parameterized Query.
Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.
modified on Saturday, September 5, 2009 3:50 AM
|
|
|
|
|
this is the first time i am hearing of anything like parameterized query and sql injection problem...thanks for those valuable informations...i will try with those then
|
|
|
|
|
|
hi,
1.
the values parenthesis isn't closed
2.
you shouldn't store plain passwords in a database, if it gets hacked all the entries become worthless at once.
|
|
|
|
|
I can run the application just fine in my development environment. But when I created the Install package the application bombs everytime on the other machines after installation when this specific form is called.
The I moved the control I viewed as the problem to a form of it's own, and this is the form that crashes. As long as the form is not called it works great.
Sorry for a the history here is the meat:
The Form Contains 2 controls only. 1 Combobox and 1 Crystal Report Viewer.
The install Package identified all the assemblies by default plus in my debugging I added a few.
Also in debugging on this form I placed message boxes all throughout the form Marking each line for code for the forms initilization, load, resize event. Everything to the point of the form fully comming up.
I only get the first message box marker before the forms INITILIZATION() process before the application bombs.
The application bombs with the error:
Unhandled exception has occured in your application. If you click continue the application will ignore this error and attempt to continue. If you click quit, the application will close immediately.
The type initilizer for 'CrystalDecision.CrystalReports.Engine.ReportDocument Threw an exception.
Under More Info I get the following:
EventType : clr20r3 P1 : peerassistloader.exe P2 : 1.4.15.267
P3 : 4aa1d6bb P4 : crystaldecisions.crystalreports.engine
P5 : 10.5.3700.0 P6 : 4711bede P7 : 2c5 P8 : 43
P9 : system.nullreferenceexception
What information is needed for help? I can have someone remote into my system and look at it with me if they want. Skype: jollymansart.
|
|
|
|
|
Have you searched? I found this[^] when I did.
|
|
|
|
|
Me thinks you're missing the CrystalReports runtime. Get that installed and you might be all set. You can usually find it in C:\Program Files\Microsoft Visual Studio 8\SDK\v2.0\BootStrapper\Packages\CrystalReports.
|
|
|
|
|
Testing now... I have been searching for days for a resolution to this. I will feel mighty coo-coo if this is all it was. It has just the right ring to it I think it might just work.  I will let you know in 1 hour when it complete's the transfer to the other site.
|
|
|
|
|
That was it thanks a million
|
|
|
|
|
You're welcome! 
|
|
|
|
|
Help Help Help If you Live in East Bay around S.F. CA. I need a C# Master to Come work with me and Instruct and help me with a Progrom developer's dream. A strat up and I need to learn C I just can't get it out of the books. It's grahic and engineering, so if this sound like something you want to do send me an email. I like vb but it just dosen't work.
|
|
|
|
|
rodbiser wrote: I like vb but it just dosen't work.
C# can't do anything that VB can't do.
This forum is for C# programmers to ask for specific help. It's not really a place to ask for a private tutor. You should advertise in the job board.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
Christian Graus wrote: C# can't do anything that VB can't do.
It can express itself concisely; VB is verbose, though not as bad as COBOL. 
And C# developers get more chicks. 
|
|
|
|
|
When does that start  
DaveBTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)
Visual Basic is not used by normal people so we're not covering it here. (Uncyclopedia)
Why are you using VB6? Do you hate yourself? (Christian Graus)
|
|
|
|
|
Wow it's getting worse nowadays, from "Urgentz send me codez" to this. What next? "Come do my job for me"? 
|
|
|
|
|
|
I have learn C# myself and just want to talk face to face with people that know what there are doing and wanted to share my project. so! I think if some of the people on this form have to much time and?
|
|
|
|
|
Few of us here are paid tutors. We donate some of our time to answer questions online. If you wish to hire someone, there are plenty of people you can hire and resources you can purchase. I pointed you to some at Microsoft.com, which has an excellent education program (especially for novices.)
I also pointed out that you don't have to learn C# yourself. My local University has very good C# .NET classes and a continuing education program so people in the community can sign up for night and summer classes.
Now, if you want to pay me $1200 a day plus expenses, I'll fly to where you're at and teach you what I know.
|
|
|
|
|
Hello. How will I show the other data that came from the other text file after I sort and search a different text file?
For example, I searched for the name which is saved from another text file, how will i show the corresponding data which are saved from different text files for the name i searched?
For example, for searching:
Search: Lopez
Last Name First Name Age Gender
Lopez John 18 Male
for sorting:
before:
Sorting by Last Name:
Lopez John
Belasco Kelly
Santiago Kristine
Feroia Peter
after:
Belasco Kelly
Feroia Peter
Lopez John
Santiago Kristine
How will i be able to do that?
|
|
|
|
|
that is exactly why I said you could create a class MyType that holds all info, then sort the collection of MyType objects; doing so keeps the items intact.
|
|
|
|
|
I have 5 text files and inside every file there are 30 predefined data. Is it possible for me to add those data in the class MyType as one? Besides that I have a function that lets the user add more data, which is easier to add in the class MyType as one.
|
|
|
|
|
gamer1127 wrote: Is it possible for me to ...
if you can explain it properly, then you can program it.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
![Badger | [badger,badger,badger,badger...]](https://codeproject.freetls.fastly.net/script/Forums/Images/badger.gif)
![Jig | [Dance]](https://codeproject.freetls.fastly.net/script/Forums/Images/jig.gif)
