“如何在运行时创建表并将该表存储在数据库中" [英] "how to create table at runtime and stored this table in database"

问题描述

将提供任何类型的帮助

推荐答案

通过使用给定的代码，您可以轻松地在数据库中创建新表并在该表上填充记录.您可以在Page_Load或任何Button click事件中使用此代码.



试试

如果不是(conn.State = ConnectionState.Open)然后

conn.Open()

如果结束


Dim sql As String ="CREATE TABLE mySchoolRecord" +"
(StudentId INTEGER CONSTRAINT PkeyMyId PRIMARY KEY，"
+名称CHAR(50)，地址CHAR(255)，联系INTEGER)"

cmd =新的OdbcCommand(sql，conn)

cmd.ExecuteNonQuery()



sql ="INSERT INTO mySchoolRecord(StudentId，Name，

地址，联系方式)"+"值(1，"Manish先生"，"

+``Sector-12，Noida''，2447658)"

cmd =新的OdbcCommand(sql，conn)

cmd.ExecuteNonQuery()



sql ="INSERT INTO mySchoolRecord(StudentId，Name，

地址，联系方式)"+"值(2，``阿南德先生''，"+"``马友尔

维哈尔，
新德里"，2457896)"

cmd =新的OdbcCommand(sql，conn)

cmd.ExecuteNonQuery()



sql ="INSERT INTO mySchoolRecord(StudentId，Name，

地址，联系方式)"+"值(3，蒙娜小姐"，"+"

''25，
教堂路，孟买"，2784521)"

cmd =新的OdbcCommand(sql，conn)

cmd.ExecuteNonQuery()



如果conn.State = ConnectionState.Open然后

conn.Close()

如果结束


作为OdbcException异常捕获


MessageBox.Show(ex.Message.ToString)


结束
试试

By using given code you can easily create new table in a Database and fill records on that table. You can use this code on the Page_Load or in any Button click event.



Try

If Not (conn.State = ConnectionState.Open) Then

conn.Open()

End If


Dim sql As String = "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. Anand'', " + " ''Mayur

Vihar,
New Delhi'', 2457896) "

cmd = New OdbcCommand(sql, conn)

cmd.ExecuteNonQuery()



sql = "INSERT INTO mySchoolRecord (StudentId, Name,

Address,Contact) " + "VALUES (3, ''Miss Mona'', " + "

''25,
Church Road,Mumbai'', 2784521) "

cmd = New OdbcCommand(sql, conn)

cmd.ExecuteNonQuery()



If conn.State = ConnectionState.Open Then

conn.Close()

End If


Catch ex As OdbcException


MessageBox.Show(ex.Message.ToString)


End
Try

这篇关于“如何在运行时创建表并将该表存储在数据库中"的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！