How to update data using same texboxes?

Question

0.00/5 (No votes)

See more:

Hi everyone,

I am newly started C# and also oracle. I am developing a phone book at c#. I am Using Oracle DB. I have completed insert, delete, search. However, I cant update the information. Please help me. That is my first question. Sorry for my ignorance.
I list the records on a gridtable. Then I double click the left side of any record on grid table. Then the update panel which is filled the information of the current record is opened. There is no problem until here. However my update button does not work.
Here is my Update Button Code.

C#

OracleConnection con = new OracleConnection("Data Source=O10G;User Id=plsql_staj;Password=*****;");
           con.Open();
           string query = "UPDATE TEL_REHBERI SET AD ='" + txtGnclAd.Text.ToUpper() + "' , SOYAD ='" + txtGnclSoyad.Text.ToUpper() + "' , YAS = '" + txtGnclYas.Text.ToUpper() + "' , CEP_NO = '" + txtGnclCep.Text.ToUpper() + "' , EV_NO = '" + txtGnclEv.Text.ToUpper() + "', DOGUMYERI = '" + txtGnclDogumYeri.Text.ToUpper() + "' WHERE AD ='"++ "' AND SOYAD = '" + txtGnclSoyad.Text.ToUpper() + "' AND YAS ='" + txtGnclYas.Text.ToUpper() + "' AND CEP_NO = '" + txtGnclCep.Text.ToUpper() + "' AND EV_NO ='" + txtGnclCep.Text.ToUpper() + "' AND DOGUMYERI = '" + txtGnclDogumYeri.Text.ToUpper() + "' ";
           DataSet ds = new DataSet();// Dataset
           OracleDataAdapter da = new OracleDataAdapter(query, con); // DataAdapter olustur
           OracleCommand cmd = new OracleCommand(query, con);
           bool result = Convert.ToBoolean(cmd.ExecuteNonQuery());
           da.Fill(ds); // DataAdapteri Kullanarak Dataset içindeki Verilere erişti
           con.Close();

In my form I am using the same textboxes. I will Add two ss and hope this will help.
1st ss:
http://www.imagetoo.com/images/ss1aua.png
2nd ss:
http://www.imagetoo.com/images/ss2vuv.png
I need Help. Thanx.

Posted 24-Jul-12 22:05pm

FoxRoot

Updated 24-Jul-12 22:36pm

sachin10d

v5

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

AshishChaudha · Answer 1 · 2012-07-24T22:34:00

Dear turan,

Is there any identity field in your table, update your record on basis of an identity field not with Textfield. and Try to use parameterized query, so No SQL injection will distroy your data.

SQL

string query = "UPDATE TEL_REHBERI SET AD ='" + txtGnclAd.Text.ToUpper() + "' , SOYAD ='" + txtGnclSoyad.Text.ToUpper() + "' , YAS = '" + txtGnclYas.Text.ToUpper() + "' , CEP_NO = '" + txtGnclCep.Text.ToUpper() + "' , EV_NO = '" + txtGnclEv.Text.ToUpper() + "', DOGUMYERI = '" + txtGnclDogumYeri.Text.ToUpper() + "' WHERE <code>id="+reheberi_ID+" </code>";

Thanks
Ashish

sachin10d · Answer 2 · 2012-07-24T22:51:00

Try this

C#

OracleConnection con = new OracleConnection("Data Source=O10G;User Id=plsql_staj;Password=*****;");
con.Open();
string query = string.Format("UPDATE TEL_REHBERI SET AD ='{0}', SOYAD ='{1}', YAS = '{2}', CEP_NO = '{3}' , EV_NO = '{4}', DOGUMYERI = '{5}' WHERE AD ='{0}' AND SOYAD = '{1}' AND YAS ='{2}' AND CEP_NO = '{3}' AND EV_NO ='{4}' AND DOGUMYERI = '{5}'",txtGnclAd.Text.ToUpper() , txtGnclSoyad.Text.ToUpper(), txtGnclYas.Text.ToUpper() ,txtGnclCep.Text.ToUpper() ,txtGnclEv.Text.ToUpper() , txtGnclDogumYeri.Text.ToUpper());

DataSet ds = new DataSet();// Dataset
OracleDataAdapter da = new OracleDataAdapter(query, con); // DataAdapter olustur
OracleCommand cmd = new OracleCommand(query, con);
bool result = Convert.ToBoolean(cmd.ExecuteNonQuery());
da.Fill(ds); // DataAdapteri Kullanarak Dataset içindeki Verilere erişti
con.Close();

FoxRoot · Answer 3 · 2012-07-24T23:29:00

Solution 5

Is there anybody to solve this? Please

Posted 24-Jul-12 23:29pm

FoxRoot

Comments

Mohamed Mitwalli 25-Jul-12 6:03am

Could you stop doing that !!! if you have comment , you can comment on any solution or on your Question but don't Add a solution .

FoxRoot 25-Jul-12 7:01am

As I mentioned in my post, I am new here.I havent seen that solution / comment are seperate objects. I am sorry for this. Could you stop doing dictatorship.

How to update data using same texboxes?

3 solutions

Solution 1

Solution 3

Solution 5

Add your solution here

Preview 0