Question

VB连接SQL数据库做试题录入系统怎么实现批量录入试题?相关代码!

VB连接SQL数据库数据库做试题录入系统,在VB界面做了个菜单,分别实现试题的批量录入和批量导出,应该怎么编写代码啊?在VB菜单的CLICK事件编写代码啊,实现向SQL数据库试题表的录入和导出功能........

Answer 1

很简单，在你的硬盘上保存有sql每个字段数据的文件，每个记录一行，字段间用“,”隔开，然后在vb中连接数据库，再执行BULK INSERT，如下，'data_file' 就是这个文件：

BULK INSERT [ [ 'database_name'.][ 'owner' ].]{ 'table_name' FROM 'data_file' }
[WITH
(
[ BATCHSIZE [ = batch_size ] ]
[ [ , ] CHECK_CONSTRAINTS ]
[ [ , ] CODEPAGE [ = 'ACP' | 'OEM' | 'RAW' | 'code_page' ] ]
[ [ , ] DATAFILETYPE [ =
{ 'char' | 'native'| 'widechar' | 'widenative' } ] ]
[ [ , ] FIELDTERMINATOR [ = 'field_terminator' ] ]
[ [ , ] FIRSTROW [ = first_row ] ]
[ [ , ] FIRE_TRIGGERS ]
[ [ , ] FORMATFILE = 'format_file_path' ]
[ [ , ] KEEPIDENTITY ]
[ [ , ] KEEPNULLS ]
[ [ , ] KILOBYTES_PER_BATCH [ = kilobytes_per_batch ] ]
[ [ , ] LASTROW [ = last_row ] ]
[ [ , ] MAXERRORS [ = max_errors ] ]
[ [ , ] ORDER ( { column [ ASC | DESC ] } [ ,...n ] ) ]
[ [ , ] ROWS_PER_BATCH [ = rows_per_batch ] ]
[ [ , ] ROWTERMINATOR [ = 'row_terminator' ] ]
[ [ , ] TABLOCK ]
)
]

Answer 2

真是厉害！我虽然也是学VB的 但我都不大明白你说的什么!哎！我一定要好好学！成为高手！呵呵！