Click here to Skip to main content
15,919,749 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more: , +
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:
C#
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)
           {

               _connection.Open();

               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);
               }
               else
               {
                   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);
               _addcommand.ExecuteNonQuery();
               txt_barcode.Text = "";

               _connection.Close();
           };
Posted

1 solution

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

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900