Insert Database Into Dataset

[toma]

i must get my database(with tables,keys,relations,views,procedures,functions,with data) to dataset.

connetcion with database exists only the first time(installation of application of c#)

from dataset do xml.

user works only with dataset from xml(without connection to really database).

how can i do this.

i get names of tables from information_scema and in loop do “select* from name_table”.

how can i get procedures,functions,keys,relation?

in sql server metod connection.getShema exists. is something in mysql?

if i get all tables with data,how do i add procedures,functions,keys ( what commands?)

[Richard J Lacroix]

This may help:

Show Information_Schema

Then again, it may not, your post is a little difficult to understand…

😉

[Author]

Posts