I need help to restore SQL Server Data using VB.NET

[dwel]

i'm using VB.NET AND SQL SERVER AND HAD PROBLEM TO RESTORE PREVIOUSLY BACKUP TEXT FILE.

[etftw]

What is the problem exactly?

If the text file contains queries each on a line of their own then you could loop through the file line by line and execute the query that is on each line.

[dwel]

exactly, i have to restore sql server data, which was backup previously in text file using VB, VB.NET programming techniques.

[etftw]

Could you provide an extract from the text file to show how the SQL is stored?

Is every query on a new line?

[dwel]

i have backup database file in text file format, which includes all tables, views etc which are included on one database. I have to restore those text file data into running same database on SQL Server using VB.NET.