连接SQL2005 Express版本的时候出现本问题,连接代码代替如下:string dbName = "server=.\\sqlexpress;uid='sa';pwd='123'";
void createDB(string database)
{
//Create database "stormdb"
string dbCmd = "create database stormdb";
runSQLCmd(dbName, dbCmd, "Create Database OK.<br>");
// Reopen to create table
string dbName1 = dbName + ";database='" + database + "'";
string tbCmd = "create table tb_login("
+ "lno int identity(1,1) primary key,"
+ "lname varchar(20) unique,"
+ "lpassword varchar(20) not null)";
runSQLCmd(dbName1, tbCmd, "Create table OK.<br>");
}
void runSQLCmd(string datebase, string cmd, string result)
{
SqlConnection sqlConn;
string sqlConnStr = datebase;
SqlCommand sqlCmd;
string sqlCmdStr = cmd;
try
{
sqlConn = new SqlConnection(sqlConnStr);
sqlConn.Open();
sqlCmd = new SqlCommand(sqlCmdStr, sqlConn);
sqlCmd.ExecuteNonQuery();
sqlConn.Close();
labError.Text += result;
}
catch (Exception ex)
{
labError.Text = ex.Message;
}
}调用createDB时容易出错,请教大家,谢谢了
void createDB(string database)
{
//Create database "stormdb"
string dbCmd = "create database stormdb";
runSQLCmd(dbName, dbCmd, "Create Database OK.<br>");
// Reopen to create table
string dbName1 = dbName + ";database='" + database + "'";
string tbCmd = "create table tb_login("
+ "lno int identity(1,1) primary key,"
+ "lname varchar(20) unique,"
+ "lpassword varchar(20) not null)";
runSQLCmd(dbName1, tbCmd, "Create table OK.<br>");
}
void runSQLCmd(string datebase, string cmd, string result)
{
SqlConnection sqlConn;
string sqlConnStr = datebase;
SqlCommand sqlCmd;
string sqlCmdStr = cmd;
try
{
sqlConn = new SqlConnection(sqlConnStr);
sqlConn.Open();
sqlCmd = new SqlCommand(sqlCmdStr, sqlConn);
sqlCmd.ExecuteNonQuery();
sqlConn.Close();
labError.Text += result;
}
catch (Exception ex)
{
labError.Text = ex.Message;
}
}调用createDB时容易出错,请教大家,谢谢了
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货