Comments by Member 10717094 (Top 15 by date)

this is just my hobby and i am really very sorry if i got in your way. no offense sir Wes, anyway thanks for your time. And thanks also to every other people who really helps newbie in c#. Salute you guys :)

I am just asking question well if you do not have some tips or some helpful answer then shut up.

i am just new csharp at least some pointers or tips to do it :)

i have a datagridview unbound.
1 button add new
6 textbox search,description,dosage,qty,selling price,amount
search is a filter for the pop up form displaying choices of items to choose and passing
it to the line then input qty and first line will be complete and when button addnew is clicked first line will be moved to the dgv then all textbox will be cleared to start a new line. that's where my problem comes. when try searching again the event on the description is not activating. is there any alternative approach for inserting multiple lines before saving to database. i am new to c# and glad if you will contribute to my learning. thanks

i chose enter event coz the previous control is a search textbox that's why calling of form would be activated with no keypress in the next textbox control, i tried textchanged but it just triggers when there is changes on the textbox enter event is most ideal but my problem is it cant be refreshed to be used to the next line. is there any other approach for putting multiple lines in one transaction as per item sales.

Thanks Peter

can you give me an alternate query?

sqlCon.Open();
SqlCommand cmd = new SqlCommand("Update ItemInfo set Item_Name=@Item_Name, Dosage=@Dosage, Generic_Name=@Generic_Name, Supplier_Name=@Supplier_Name where (Item_Name=@Item_Name)", sqlCon);
cmd.Parameters.AddWithValue("@Item_Name", txtItemDescription.Text);
cmd.Parameters.AddWithValue("@Dosage", txtDosage.Text);
cmd.Parameters.AddWithValue("@Generic_Name", txtGeneric.Text);
cmd.Parameters.AddWithValue("@Supplier_Name", comboSupplier.Text);
cmd.ExecuteNonQuery();
sqlCon.Close();
MessageBox.Show("Successfully Updated", "Completed !", MessageBoxButtons.OK);

message successfully updated. when the data on Item_Name is the one to update, no changes to database. other fields were perfectly updating except the one i put in the condition on sql query