C# coding of create table statement

[kevin21388]

I am doing some development for a company and they have given me all the create table statements in a .sql file. Is there any way that I can use the create table statements or the .sql file itself to add these tables to a database created using visual studio. I would use the graphical table creator, but there are a lot of tables with a lot of columns. Thanks, Kevin

[Manikgisl]

hi,
u r having the Insert Query for Create a table in a .SqlFile

Using Stream Reader this can be easily

HI.!!!
[SIZE=2]
StreamReader sr = [/SIZE][SIZE=2][COLOR=#0000ff]new[/COLOR][/SIZE][SIZE=2] StreamReader("SqlFile");
[/SIZE][SIZE=2][COLOR=#0000ff]string[/COLOR][/SIZE][SIZE=2] strQuery = sr.ReadLine();
SqlConnection sqlcon = [/SIZE][SIZE=2][COLOR=#0000ff]new[/COLOR][/SIZE][SIZE=2] SqlConnection(connectionstring);
sqlcon.Open();
SqlCommand sqlcmd = [/SIZE][SIZE=2][COLOR=#0000ff]new[/COLOR][/SIZE][SIZE=2] SqlCommand(strQuery,sqlcon);
sqlcmd.ExecuteNonQuery();



[/SIZE]if u unable to create to open the .sql File in Stream Reader[/SIZE]

U may copy the Create statement from Sql File to Notepad File[/SIZE]

and Then try

I hope this will Work

[Manikgisl]

Hi,

public void fnInserttable()
{
try
{
StreamReader sr = new StreamReader("SqlFile");
string strQuery = sr.ReadLine();
SqlConnection sqlcon = new SqlConnection(connectionstring);
sqlcon.Open();
SqlCommand sqlcmd = new SqlCommand(strQuery,sqlcon);
sqlcmd.ExecuteNonQuery();
}
catch(Exception ex)
{
MessageBox.Show(ex.Message);
}

}

pls try this I hope this will help u

bye

With Regards,
Mani

[kevin21388]

I don't understand why this would work if copy and pasting the sql code directly as the command string did not work. If I am mistaken and this does something different let me know.

[r035198x]

Which database? MS SQL, Oracle e.t.c?
What is the structure of the .sql file? Are the create table commands separated by some delimiter?
If there is a command provided by the RDBM that allows you to load an sql file and execute the sql in it then that would be the best way.