Link to home
Start Free TrialLog in
Avatar of jana
janaFlag for United States of America

asked on

How save rows from a datatable to sql table in VB.net

We are working in a solution, in VB.net, to save large contents of data in a datatable directly to SQL tables with using For/Next and SQL statements.

Is there an instruction or command that can save the rows contents in a datatabe directly to the SQL tables without SQL statements?

We think this is possible and are searching for a solution.

Please advice,
Avatar of jana
jana
Flag of United States of America image

ASKER

We are testing in VB.net bit also we were advice in using DevExpress for this function.
ASKER CERTIFIED SOLUTION
Avatar of Éric Moreau
Éric Moreau
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of jana

ASKER

please explain on "don't want to write the data layer"
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of jana

ASKER

Understood.  Is the tool part of VB or like DevExpress, a paid add-on?
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of jana

ASKER

Ok will do.

One last question.  This means that with Entity Framework, whatever is on the datatabe or framework, will be saved to the SQL tables without use incorporation of SQL statements in our VB coding?
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of jana

ASKER

Is that a Yes to our question,  that in using "Entity Framework", whatever is on the datatabe or framework, will be saved to the SQL tables without writing SQL statements in our coding?
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of jana

ASKER

Thank you very much!!
Avatar of jana

ASKER

Thanx!