Click here to Skip to main content
Rate this: bad
Please Sign up or sign in to vote.
hello all,
I am developing a mobile app and i have to insert some values from the txtbox to dhe database table when enter key is pressed.but the sql command inserts more then one row,until i add a new value to the txt box.i think the problem is at the connection.Close();where should i close it,or should i make any if checks??Please help!
Thanks in advance.
Here some part of code:
 string _connString = String.Format(System.Globalization.CultureInfo.InvariantCulture,
            @"Data Source = {0}\SQL_CE.sdf", Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase));
            SqlCeConnection _connection = new SqlCeConnection(_connString);
            if (e.KeyChar == (char)13)
                SqlCeCommand desc_command = new SqlCeCommand("select description from Items where barcode=@barcode;", _connection);
                desc_command.Parameters.AddWithValue("@barcode", txt_barcode.Text);
                SqlCeDataReader rdr = desc_command.ExecuteReader();
                if (rdr.Read())
                    txt_description.Text = rdr.GetString(0);
                    txt_description.Text = "-----";
                SqlCeCommand _addcommand = new SqlCeCommand("insert into Inventory values(@barcode,@amount);", _connection);
                _addcommand.Parameters.AddWithValue("@barcode", txt_barcode.Text);
                _addcommand.Parameters.AddWithValue("@amount", txt_amount.Text);
                txt_barcode.Text = "";
Posted 17-Feb-12 0:36am

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

I resolved it,Thanks anyway.I just used a while loop,while the txtbox != "" ,open the connection,the insert statement,then close the connection!!

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

  Print Answers RSS
0 CHill60 205
1 Sergey Alexandrovich Kryukov 175
2 Zoltán Zörgő 175
3 Richard MacCutchan 175
4 Richard Deeming 170
0 Sergey Alexandrovich Kryukov 9,328
1 OriginalGriff 6,806
2 Peter Leow 4,442
3 Zoltán Zörgő 3,984
4 Richard MacCutchan 2,807

Advertise | Privacy | Mobile
Web04 | 2.8.150129.1 | Last Updated 17 Feb 2012
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100