Search results for query: *

im sorry to trouble you all again but i need some pointers i am having a issue with my code taking a long time to update my database table, i load the excel document into a datagridview and then format it using code as below. its making my database jump to nea4 50 mb . and spreadsheet im...

struggling to conbine a excel read into a write to data table both work seperatly in demo form but wont work together effectively the excel document reads fine and populates the table and datagridview and the columns in datagrid matches the spreadsheet fields exactly and the table im trying to...

after my sql update at bottom i really wanted to refresh the datagridview prob i got is there could up to 30 records that change with that update. Requestcount = Nothing Requestcount = Convert.ToInt32(InputBox("Please confirm how many cases you want?", "Records", "0")) If...

Dim ActUser As String Dim Hitme As String Dim sql As String Dim intResponse As Integer Dim sqlupdate As String Dim con1 As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data source ='" & dbPath1 & "'; Jet OLEDB:database password=123")...

hi im really struggling to get a one button import routine running i import a xls into a data grid this bit works great, i then want it to insert into a database table "mdb" on the fly. i found some code online but this errors. what im looking for a way to drop all data from the grid into a...