[RESOLVED] Manually saving DataGrid

[Roofuss]

Hi

Is it possible to manually save data from my dataGridView to my SQL server database table?

if it is possible can some please tell me how to do it because i don't like using the data sets and reader VB has because it doesn't give me full control over the procedure.

please see the code below it all works fine its just the last two line im struggling with, which is where i am trying to save the data from the two columns in my DataGridView

            Try
                mySqlCommand.CommandText = "INSERT INTO quin (Type, DateRaised, Status, " _
                & "Company, Address, Postcode, Support, TasksCompleted, HoursAllocated, HoursUsed, OverLim, HourlyRate, " _
                & "ExtendedCost, MonthlySupport, Vat, Total, qutask, qucost) " _
                & " VALUES " _
                & "(@Type, @DateRaised, @Status, " _
                & "@Company, @Address, @Postcode, @Support, @TasksCompleted, @HoursAllocated, @HoursUsed, " _
                & "@OverLim, @HourlyRate, @ExtendedCost, @MonthlySupport, @Vat, @Total, @Qutask, @Qucost)"
                mySqlCommand.Parameters.AddWithValue("@Type", cbType.Text.Trim)
                mySqlCommand.Parameters.AddWithValue("@DateRaised", tbDateRaised.Text.Trim)
                mySqlCommand.Parameters.AddWithValue("@Status", cbStatus.Text.Trim)
                mySqlCommand.Parameters.AddWithValue("@Company", cbCompany.Text.Trim)
                mySqlCommand.Parameters.AddWithValue("@Address", tbAddress.Text.Trim)
                mySqlCommand.Parameters.AddWithValue("@PostCode", tbPostCode.Text.Trim)
                mySqlCommand.Parameters.AddWithValue("@Support", tbSupport.Text.Trim)
                mySqlCommand.Parameters.AddWithValue("@TasksCompleted", lvTasksComp.Text.Trim)
                mySqlCommand.Parameters.AddWithValue("@HoursAllocated", tbHoursAlo.Text.Trim)
                mySqlCommand.Parameters.AddWithValue("@HoursUsed", tbHoursUsed.Text.Trim)
                mySqlCommand.Parameters.AddWithValue("@OverLim", tbOverLim.Text.Trim)
                mySqlCommand.Parameters.AddWithValue("@HourlyRate", tbHourRate.Text.Trim)
                mySqlCommand.Parameters.AddWithValue("@ExtendedCost", tbExtended.Text.Trim)
                mySqlCommand.Parameters.AddWithValue("@MonthlySupport", tbMonthCharge.Text.Trim)
                mySqlCommand.Parameters.AddWithValue("@Vat", cbVat.Text.Trim)
                mySqlCommand.Parameters.AddWithValue("@Total", tbTotal.Text.Trim)
                mySqlCommand.Parameters.AddWithValue("@Qutask", ??)
                mySqlCommand.Parameters.AddWithValue("@Qucost", ??)

Thanks in Advance