SqlDataAdapter adapter2 = new SqlDataAdapter("SELECT * FROM dbo.OrderLines", cn); adapter2.InsertCommand = new SqlCommand("dbo.InsertOrderLine", cn); adapter2.InsertCommand.CommandType = CommandType.StoredProcedure; adapter2.InsertCommand.Parameters.Add(new SqlParameter("@ServiceProviderID", SqlDbType.Int, 15, "ServiceProviderID")); adapter2.InsertCommand.Parameters.Add(new SqlParameter("@ProductID", SqlDbType.Int, 15, "ProductID")); adapter2.InsertCommand.Parameters.Add(new SqlParameter("@PolicyNumber", SqlDbType.NVarChar, 50, "PolicyNumber")); SqlParameter parameter2 = adapter.InsertCommand.Parameters.Add("@ID2", SqlDbType.Int, 0, "OrderLineID"); parameter2.Direction = ParameterDirection.Output; DataTable orderline = new DataTable(); adapter.Fill(orderline); // find primary key of both productComboBox.SelectedItem from Products table // and serviceProviderCombobox.SelectedItem from ServiceProviders table DataRow newRow2 = orderline.NewRow(); newRow2["ServiceProviderID"] = ?serviceProviderComboBox.SelectedItem?; newRow2["ProductID"] = ?productComboBox.SelectedItem?; newRow2["PolicyNumber"] = policyTextBox.Text; orderline.Rows.Add(newRow2); adapter.Update(orderline); id2 = int.Parse(parameter2.Value.ToString());
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)