Using the following code you can easily create a new table in a Database and fill records in that table. You can use this code on the Page_Load or in any Button click event.
try
{
if (!(conn.State == ConnectionState.Open))
{
conn.Open();
}
string sql = "CREATE TABLE mySchoolRecord" + "
(StudentId INTEGER CONSTRAINT PkeyMyId PRIMARY KEY,"
+ "Name CHAR(50), Address CHAR(255), Contact INTEGER)";
cmd = new OdbcCommand(sql, conn);
cmd.ExecuteNonQuery();
sql = "INSERT INTO mySchoolRecord (StudentId, Name,
Address,Contact) " + "VALUES (1, 'Mr. Manish', "
+ " 'Sector-12,Noida', 2447658 ) "
cmd = new OdbcCommand(sql, conn);
cmd.ExecuteNonQuery();
sql = "INSERT INTO mySchoolRecord (StudentId, Name,
Address,Contact) " + "VALUES (2, 'Mr. Ravi', "
+ " 'New Delhi', 2584076521 ) "
cmd = new OdbcCommand(sql, conn);
cmd.ExecuteNonQuery();
sql = "INSERT INTO mySchoolRecord (StudentId, Name,
Address,Contact) " + "VALUES (3, 'Mr. Peter', "
+ " 'United States', 25684124 ) "
cmd = new OdbcCommand(sql, conn);
cmd.ExecuteNonQuery();
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
}
catch (OdbcException ex)
{
MessageBox.Show(ex.Message.ToString);
}