Database Reference
In-Depth Information
cmd = new SqlCommand();
cmd.Connection = conn;
// Open connection
conn.Open();
// Create table
CreateTextTable();
// Prepare insert command
PrepareInsertTextFile();
// Load text file
ExecuteInsertTextFile(fileName);
txtLoadText.AppendText("Loaded "+fileName+" into TextTable.\n");
}
catch (SqlException ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
// Close connection
conn.Close();
}
}
private void CreateTextTable()
{
ExecuteCommand(@"if exists(select *
from INFORMATION_SCHEMA.TABLES
where TABLE_NAME = 'TextTable')
drop table TextTable ");
ExecuteCommand(@"create table TextTable
(
TextFile varchar(255),
TextData varchar(max)
)");
}
private void ExecuteCommand(string commandText)
{
cmd.CommandText = commandText;
cmd.ExecuteNonQuery();
txtLoadText.AppendText("\n");
}
private void PrepareInsertTextFile()
