现吧你的sql脚本导到.sql文件里面 然后编辑.bat文件 在c#里面用调用bat @echo offIF "%1"=="" GOTO usage@echo. @echo. Building Duwamish 7 Database... @echo.@echo. @echo. Creating Tables... @echo. osql -E -d %1 -n -i d7_tables.sql @echo. @echo. Creating Stored Procedures... @echo. osql -E -d %1 -n -i d7_sprocs.sqlosql -E -d %1 -n -b -Q"GRANT EXEC ON [dbo].[GetAddressByCustomerId] TO [%1]" osql -E -d %1 -n -b -Q"GRANT EXEC ON [dbo].[GetCategories] TO [%1]" osql -E -d %1 -n -b -Q"GRANT EXEC ON [dbo].[GetCustomerById] TO [%1]" osql -E -d %1 -n -b -Q"GRANT EXEC ON [dbo].[GetCustomerByEmail] TO [%1]" osql -E -d %1 -n -b -Q"GRANT EXEC ON [dbo].[GetBooksByAuthor] TO [%1]" osql -E -d %1 -n -b -Q"GRANT EXEC ON [dbo].[GetBooksByCategoryId] TO [%1]" osql -E -d %1 -n -b -Q"GRANT EXEC ON [dbo].[GetBookById] TO [%1]" osql -E -d %1 -n -b -Q"GRANT EXEC ON [dbo].[GetBooksByISBN] TO [%1]" osql -E -d %1 -n -b -Q"GRANT EXEC ON [dbo].[GetBooksBySubject] TO [%1]" osql -E -d %1 -n -b -Q"GRANT EXEC ON [dbo].[GetBooksByTitle] TO [%1]" osql -E -d %1 -n -b -Q"GRANT EXEC ON [dbo].[InsertAddress] TO [%1]" osql -E -d %1 -n -b -Q"GRANT EXEC ON [dbo].[UpdateCustomerAddress] TO [%1]" osql -E -d %1 -n -b -Q"GRANT EXEC ON [dbo].[InsertCustomer] TO [%1]" osql -E -d %1 -n -b -Q"GRANT EXEC ON [dbo].[InsertOrderDetail] TO [%1]" osql -E -d %1 -n -b -Q"GRANT EXEC ON [dbo].[InsertOrderDetailsByList] TO [%1]" osql -E -d %1 -n -b -Q"GRANT EXEC ON [dbo].[InsertSale] TO [%1]" osql -E -d %1 -n -b -Q"GRANT EXEC ON [dbo].[UpdateCustomer] TO [%1]" osql -E -d %1 -n -b -Q"GRANT EXEC ON [dbo].[PopFirstWord] TO [%1]" osql -E -d %1 -n -b -Q"GRANT EXEC ON [dbo].[GetDailyPickBooksByCategoryId] TO [%1]" @echo. @echo. Loading Data... @echo. bcp %1..ItemType in ItemType.bcp -E -T -w bcp %1..ItemCategory in ItemCategory.bcp -E -T -w bcp %1..Categories in Categories.bcp -E -T -w bcp %1..Items in Items.bcp -E -T -w bcp %1..DailyPick in DailyPick.bcp -E -T -w bcp %1..Books in Books.bcp -E -T -w bcp %1..Authors in Authors.bcp -E -T -w bcp %1..BookAuthor in BookAuthor.bcp -E -T -w bcp %1..Publishers in Publishers.bcp -E -T -w bcp %1..Customers in Customers.bcp -E -T -w bcp %1..Addresses in Addresses.bcp -E -T -w@echo. @echo. Completed! @echo. GOTO :EOF:usage echo. echo. Usage: Setup [D7 : Duwamish 7 Database Name] echo. : Database must already exist. echo. Desc: Create Tables, echo. : Stored Procedures, echo. : Loads Duwamish Data echo.
CREATE PROCEDURE usp_sql @path char(100)--,@reback int output AS exec('master.dbo.xp_cmdshell '+ '''' +' osql -U sa -P -i '+@path+'''' ) /*if @@error=0 set @reback=1 if @@error<>0 set @reback=0*/ GO 其中@path 为sql脚本路径
新键一窗体,加入一memo,考入sql代码,加入3输入框,分别对应服务名,用户,密码,加入按钮,在事件里写入代码,通过3输入框信息,连接数据库,执行memo中的代码,改窗体名为“初始化模块”,打包改工程
望各位贴出代码?
或发信箱:[email protected]
memo是什么啊?
======================
我也想知道,大力,帮忙啦...
然后编辑.bat文件
在c#里面用调用bat
@echo offIF "%1"=="" GOTO usage@echo.
@echo. Building Duwamish 7 Database...
@echo.@echo.
@echo. Creating Tables...
@echo.
osql -E -d %1 -n -i d7_tables.sql
@echo.
@echo. Creating Stored Procedures...
@echo.
osql -E -d %1 -n -i d7_sprocs.sqlosql -E -d %1 -n -b -Q"GRANT EXEC ON [dbo].[GetAddressByCustomerId] TO [%1]"
osql -E -d %1 -n -b -Q"GRANT EXEC ON [dbo].[GetCategories] TO [%1]"
osql -E -d %1 -n -b -Q"GRANT EXEC ON [dbo].[GetCustomerById] TO [%1]"
osql -E -d %1 -n -b -Q"GRANT EXEC ON [dbo].[GetCustomerByEmail] TO [%1]"
osql -E -d %1 -n -b -Q"GRANT EXEC ON [dbo].[GetBooksByAuthor] TO [%1]"
osql -E -d %1 -n -b -Q"GRANT EXEC ON [dbo].[GetBooksByCategoryId] TO [%1]"
osql -E -d %1 -n -b -Q"GRANT EXEC ON [dbo].[GetBookById] TO [%1]"
osql -E -d %1 -n -b -Q"GRANT EXEC ON [dbo].[GetBooksByISBN] TO [%1]"
osql -E -d %1 -n -b -Q"GRANT EXEC ON [dbo].[GetBooksBySubject] TO [%1]"
osql -E -d %1 -n -b -Q"GRANT EXEC ON [dbo].[GetBooksByTitle] TO [%1]"
osql -E -d %1 -n -b -Q"GRANT EXEC ON [dbo].[InsertAddress] TO [%1]"
osql -E -d %1 -n -b -Q"GRANT EXEC ON [dbo].[UpdateCustomerAddress] TO [%1]"
osql -E -d %1 -n -b -Q"GRANT EXEC ON [dbo].[InsertCustomer] TO [%1]"
osql -E -d %1 -n -b -Q"GRANT EXEC ON [dbo].[InsertOrderDetail] TO [%1]"
osql -E -d %1 -n -b -Q"GRANT EXEC ON [dbo].[InsertOrderDetailsByList] TO [%1]"
osql -E -d %1 -n -b -Q"GRANT EXEC ON [dbo].[InsertSale] TO [%1]"
osql -E -d %1 -n -b -Q"GRANT EXEC ON [dbo].[UpdateCustomer] TO [%1]"
osql -E -d %1 -n -b -Q"GRANT EXEC ON [dbo].[PopFirstWord] TO [%1]"
osql -E -d %1 -n -b -Q"GRANT EXEC ON [dbo].[GetDailyPickBooksByCategoryId] TO [%1]"
@echo.
@echo. Loading Data...
@echo.
bcp %1..ItemType in ItemType.bcp -E -T -w
bcp %1..ItemCategory in ItemCategory.bcp -E -T -w
bcp %1..Categories in Categories.bcp -E -T -w
bcp %1..Items in Items.bcp -E -T -w
bcp %1..DailyPick in DailyPick.bcp -E -T -w
bcp %1..Books in Books.bcp -E -T -w
bcp %1..Authors in Authors.bcp -E -T -w
bcp %1..BookAuthor in BookAuthor.bcp -E -T -w
bcp %1..Publishers in Publishers.bcp -E -T -w
bcp %1..Customers in Customers.bcp -E -T -w
bcp %1..Addresses in Addresses.bcp -E -T -w@echo.
@echo. Completed!
@echo.
GOTO :EOF:usage
echo.
echo. Usage: Setup [D7 : Duwamish 7 Database Name]
echo. : Database must already exist.
echo. Desc: Create Tables,
echo. : Stored Procedures,
echo. : Loads Duwamish Data
echo.
@path char(100)--,@reback int output
AS
exec('master.dbo.xp_cmdshell '+ '''' +' osql -U sa -P -i '+@path+'''' )
/*if @@error=0
set @reback=1
if @@error<>0
set @reback=0*/
GO
其中@path 为sql脚本路径