Create database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hey,

I need create database (MsSql) within my application, when it run. What is
the best metod to do it.
 
Hi,

You'll probably have to use a command object and fire appropriate ddl sql
statements (depends on mysql what statements).
 
Yes, I have send ddl sal statements to server.
What is the best metod do it.

Miha Markic said:
Hi,

You'll probably have to use a command object and fire appropriate ddl sql
statements (depends on mysql what statements).

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

Leszek Urbañski said:
Hey,

I need create database (MsSql) within my application, when it run. What is
the best metod to do it.
Click to expand...
Click to expand...
 
Using a command object - either OleDbCommand or native mySql's command
object (don't know its name).

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

Leszek Urbañski said:
Yes, I have send ddl sal statements to server.
What is the best metod do it.

Miha Markic said:
Hi,

You'll probably have to use a command object and fire appropriate ddl sql
statements (depends on mysql what statements).

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

message
Hey,

I need create database (MsSql) within my application, when it run. What
is
the best metod to do it.
Click to expand...
Click to expand...
Click to expand...
 
I mean MSSql, no MySql.
I understand, I neead write all Sql script to the comand obiect, and execute
it ?
Is mayby any metod to create database from the xlm file (where is defined db
structure) or from dataset object ?

Miha Markic said:
Using a command object - either OleDbCommand or native mySql's command
object (don't know its name).

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

Leszek Urbañski said:
Yes, I have send ddl sal statements to server.
What is the best metod do it.

Miha Markic said:
Hi,

You'll probably have to use a command object and fire appropriate ddl sql
statements (depends on mysql what statements).

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

message
Hey,

I need create database (MsSql) within my application, when it run. What
is
the best metod to do it.
Click to expand...
Click to expand...
Click to expand...
 
Ouch, yes, it was written similar to MySql :-)
Then use SqlCommand object.
There is no built in way to create a database - you are stuck with issuing
sqlcommands or somehow run isql with proper script.

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com


Leszek Urbañski said:
I mean MSSql, no MySql.
I understand, I neead write all Sql script to the comand obiect, and
execute
it ?
Is mayby any metod to create database from the xlm file (where is defined
db
structure) or from dataset object ?

Miha Markic said:
Using a command object - either OleDbCommand or native mySql's command
object (don't know its name).

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

message
Yes, I have send ddl sal statements to server.
What is the best metod do it.

:

Hi,

You'll probably have to use a command object and fire appropriate ddl
sql
statements (depends on mysql what statements).

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

message
Hey,

I need create database (MsSql) within my application, when it run.
What
is
the best metod to do it.
Click to expand...
Click to expand...
Click to expand...
 
I have not heard of can use XML to create SQL table. I only know you can
extract data in table to XML. So do let me know if you know how to do it.

chanmm

Leszek Urbanski said:
I mean MSSql, no MySql.
I understand, I neead write all Sql script to the comand obiect, and
execute
it ?
Is mayby any metod to create database from the xlm file (where is defined
db
structure) or from dataset object ?

Miha Markic said:
Using a command object - either OleDbCommand or native mySql's command
object (don't know its name).

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

message
Yes, I have send ddl sal statements to server.
What is the best metod do it.

:

Hi,

You'll probably have to use a command object and fire appropriate ddl
sql
statements (depends on mysql what statements).

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

message
Hey,

I need create database (MsSql) within my application, when it run.
What
is
the best metod to do it.
Click to expand...
Click to expand...
Click to expand...
 
XML no, but from objects structure, can do it XPO modul company DevExpress.

chanmmn said:
I have not heard of can use XML to create SQL table. I only know you can
extract data in table to XML. So do let me know if you know how to do it.

chanmm

Leszek Urbanski said:
I mean MSSql, no MySql.
I understand, I neead write all Sql script to the comand obiect, and
execute
it ?
Is mayby any metod to create database from the xlm file (where is defined
db
structure) or from dataset object ?

Miha Markic said:
Using a command object - either OleDbCommand or native mySql's command
object (don't know its name).

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

message
Yes, I have send ddl sal statements to server.
What is the best metod do it.

:

Hi,

You'll probably have to use a command object and fire appropriate ddl
sql
statements (depends on mysql what statements).

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

message
Hey,

I need create database (MsSql) within my application, when it run.
What
is
the best metod to do it.
Click to expand...
Click to expand...
Click to expand...
 
Yes, XPO is a fine product.
It uses SQL DDL to create database (CREATE TABLE, etc).

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

Leszek Urbañski said:
XML no, but from objects structure, can do it XPO modul company
DevExpress.

chanmmn said:
I have not heard of can use XML to create SQL table. I only know you can
extract data in table to XML. So do let me know if you know how to do it.

chanmm

message
I mean MSSql, no MySql.
I understand, I neead write all Sql script to the comand obiect, and
execute
it ?
Is mayby any metod to create database from the xlm file (where is
defined
db
structure) or from dataset object ?

:

Using a command object - either OleDbCommand or native mySql's command
object (don't know its name).

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

message
Yes, I have send ddl sal statements to server.
What is the best metod do it.

:

Hi,

You'll probably have to use a command object and fire appropriate
ddl
sql
statements (depends on mysql what statements).

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

in
message
Hey,

I need create database (MsSql) within my application, when it
run.
What
is
the best metod to do it.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top