private void Edit_Delete_Item(string vid) { try { SharedServices ss = new SharedServices(); var editlist = ss.GetMappinOrderItems(vid); using (Edit_Item eis = new Edit_Item(editlist, vid, user)) { eis.ShowDialog(); }; } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void ButtonAdv3_Click(object sender, EventArgs e) { using (Search_Products sp = new Search_Products(user)) { sp.ShowDialog(); if (sp.ShowDialog == true) { var pids = sp.ProductItemID_List; for (int i = 0; i < pids.Count; i++) { con.InsertInformation("INSERT INTO [mbo].[PSVendorItemMapping] ([ProductVendorId],[ProductItemId],[Name]) VALUES ('" + Vendorid + "','" + pids[i] + "',(select top 1 Name from [dbo].[ProductVendor] where ProductVendorId='" + Vendorid + "'))"); } SharedServices srv = new SharedServices(); dataGridView1.DataSource = null; dataGridView1.DataSource = srv.GetMappinOrderItems(Vendorid); } } }