private void SaveMact(string ComboxSelectedValue) { if (MessageBox.Show("You are about to save current operation. Do you want to proceed?", "Save Data", MessageBoxButton.YesNo, MessageBoxImage.Question) != MessageBoxResult.Yes) return; try { using (SqlConnection conn = new SqlConnection(GlobalClass.DataConnectionString)) using (SqlCommand cmdsave = new SqlCommand()) { conn.Open(); cmdsave.Connection = conn; foreach (Menuitem mi in oMenuitemlist) { if (mi.RowChanged > 0 ) { cmdsave.CommandText = "UPDATE MENUITEM SET MCAT = @MCAT WHERE MCODE = @MCODE OR PARENT = @MCODE OR MGROUP=@MCODE; cmdsave.Parameters.AddWithValue(@MCAT, mi.Mcat); cmdsave.Parameters.AddWithValue(@MCODE, mi.Mcode); cmdsave.ExecuteNonQuery(); } }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)