New records in Datagrid to be inserted into SQL table. URGENT!

[Guest]

Hi
i m populating a datagrid with data from excel. is it possible to take the datatable in this dataset and create the same as a new table in SQl database. can some one gimme ideas to solve the same in different way

 

[Hermit Dave]

Well you can write a generic function in your data access layer. first run a
check to see if you have the table in your db, next iterate the dataset and
start inserting records.

* Get the Table myDT from the DataSet myDS
* You will have to juggle a bit to create the create table statement from
the DataTable
* execute the create table and then do a "select * from tablename " from sql
server
* once you get the new dataset newDS,
iterate the myDT (using i)
call newDS.Tables[0].ImportRow(myDT.Rows
once done importing the rows
newDS.Tables[0].AcceptChanges

i did start coding but it will take me a while plus i gotta leave for work
now.. will do something of this sort in the evening and post it if necessary

Chao,

Hermit Dave

Hi,
i m populating a datagrid with data from excel. is it possible to take the

datatable in this dataset and create the same as a new table in SQl
database. can some one gimme ideas to solve the same in different ways

 

[onedaywhen]

Here's one approach: connect to the Excel data source using Jet OLEDB
and execute a SELECT..INTO query using the IN keyword to specify the
SQL Server target e.g.

SELECT *
INTO [odbc;Driver={SQL
Server};Server=MyServer;Database=MyDatabase;User
ID=sa].[NewTempTable]
FROM [Sheet1$]

 

[Guest]

i tried this
testAdapter = New OleDbDataAdapter("SELECT * INTO [odbc;Driver={SQLServer};Server=MyServer;Database=InputData;uid=sa;].[NewTempTable] FROM [companyRelation22$]", strConn)
which gave the error
error : ODBC--connection to '{SQLServer}MyServer' failed.

so, when i changed it to

testAdapter = New OleDbDataAdapter("SELECT * INTO [SQLOLEDB;Driver={SQLServer};Server=MyServer;Database=InputData;uid=sa;].[NewTempTable] FROM [companyRelation22$]", strConn)

it gives the following error
error : Could not find installable ISAM

the strConn connection parameter is proper.
Can you please gimme more details on this as it is very urgent.

 

[Guest]

hi
can you please gimme the next steps to complete the task. i tried some insertcommands but of no use...