Question

vb.net怎么用app.config的ConnectionString来连接数据库?

dim Cnn as sqlconnection
dim cmd as sqlcommand
dim dataR as sqldatareader
If Page.IsValid Then
Cnn = New SqlConnection//这后边这么写？？？

Answer 1

cnn.ConnectionString ="server=.;uid=sa;pwd=;database=库名";
cnn.open();
cmd.connection=cnn;
cmd.commandText=sql;
cmd.commandType=commandType.text;
dataR.selectcommand=cmd;