how to append two fields in one column

Question

0.00/5 (No votes)

See more:

Hello sir/madam
I am trying to append some data in a column and using the given code...

C#

string query1 = "update arms_records set renewal_dates= 'hii' & renewal_dates where thana='Hkksik' and licence_number='6652'";

 string query2 = "update arms_records set renewal_dates='" + dateTimePickerRenewDate.Value.ToString() + "' & renewal_dates where thana='" + comboBoxthana.SelectedText +"' and licence_number='" + textBoxLicence_number.Text + "'";

while I use query1 it works and data is appended and saved.
but i want to use query 2. but nothing is saved in database.
Thank you ...

Posted 2-Jan-14 23:54pm

Member 10358986

Add a Solution

Comments

Sibasisjena 3-Jan-14 6:52am

Please check the comboBoxthana.SelectedText and textBoxLicence_number.Text values are not null before use these. Else check record is there in db for the corresponding values.

If the record is not there, how it will be saved.

Member 10358986 4-Jan-14 0:36am

Thank you very much
there was a small mistake in my syntax...
it should be combobxthana.Text instead of comboboxthana.SelectedText

2 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)

Ram Gunti · Answer 1 · 2014-01-03T01:01:00

Solution 1

SQL

tring query2 = "update arms_records set renewal_dates=" + dateTimePickerRenewDate.Value.ToString() + " & renewal_dates where thana=" + comboBoxthana.SelectedText +"and licence_number=" +textBoxLicence_number.Text ;

Posted 3-Jan-14 1:01am

Ram Gunti

Comments

CHill60 3-Jan-14 11:56am

This doesn't work when I try it

CHill60 · Answer 2 · 2014-01-03T05:56:00

Don't use string concatenation when creating your query string. It leaves you open to sql injection attacks, creates extra work for you and makes your query unwieldy and difficult to debug.

Use Parameters instead - http://www.dotnetperls.com/sqlparameter[^]

Then do as Sibasis05 has suggested - debug your code and check that comboBoxthana.SelectedText and textBoxLicence_number.Text actually contain some data. Also check that the data actually matches to a record in your table - watch out for spelling mistakes and capitalisation