关于SQL EXPRESS
小弟使用SQL EXPRESS创建了桌面应用程序,程序数据库连接没有问题,SELECT语句返回值也没问题,就是UPDATE不成功,也不报错。症状就是软件打开时更新有效,软件退出后数据就还原了,跟没更新时一样。。求救~
连接语句
SqlConnectionStringBuilder connectstringbuilder = new SqlConnectionStringBuilder();
connectstringbuilder.DataSource = @"(local)\sqlexpress";
//指定数据库服务
connectstringbuilder.AttachDBFilename = @"|DataDirectory|\FMS Database.mdf";
//数据库文件,采用相对地址的方式来指定。注意格式
connectstringbuilder.IntegratedSecurity = true;
connectstringbuilder.UserInstance = true;
sqlConnection = new SqlConnection(connectstringbuilder.ConnectionString);
try
{
sqlConnection.Open();
}
catch
{
sqlConnection = null;
}
return sqlConnection;
UPDATE子程序
private bool ExecuteByProc(string strProcName)
{
flag = false;
try
{
sqlCommand = new SqlCommand(strProcName, CreateConnection());
sqlCommand.CommandType = CommandType.StoredProcedure;
flag = sqlCommand.ExecuteNonQuery() == 0 ? false : true;
}
catch
{
flag = false;
}
this.CloseConnection();
return flag;
}
C#语句
db = new OperateDataBase();
db.UpdateData("SP_PASSWORDCHANGE;1", sp);
UPDATE存储过程
ALTER PROCEDURE SP_PASSWORDCHANGE;1 @USERID AS VARCHAR(20)
,@PASSWORD AS VARCHAR(20)
/*
修改密码
*/
AS UPDATE USER_PASSWORD SET PASSWORD = @PASSWORD WHERE USERID = @USERID
/* SET NOCOUNT ON */
RETURN