最新评论
Pretty_Cool 2012-01-29 18:00
2012最新发现，一个叫凯备份的软件，可以安全保护备份电脑里的数据，介绍给大家试一试。http://www.carbonite.cn
D.Resource 2011-12-12 12:28
1楼的问题解决办法：
将ZipFileDictory中的
entry = new ZipEntry(Path.Combine(ParentFolderName, Path.GetFileName(FolderToZip) + "/")); //加上 “/” 才会当成是文件夹创建
换为下面的程序就可以了。
string strPath = Path.GetFileName(FolderToZip);
if (strPath != "")
{
strPath += "/";
}
entry = new ZipEntry(Path.Combine(ParentFolderName, strPath + Path.GetFileName(file)));
PS:可以压缩中文目录和中文文件，但密码问题还没有解决，下次有空的时候再查下原因
虽然 马上就要到2012了，而回复的是08年的问题，但希望对后来的人有用
逸~杰 2010-12-22 12:11
SQLDMO 的引用
SQLDMO由Microsoft SQL Server自带的SQLDMO.dll提供，由于SQLDMO.dll是一个COM对象，所以大家在用之前必须在.NET项目中添加对它的引用，其路径是“C:\Program Files\Microsoft SQL Server\80\Tools\Binn\SQLDMO.dll”
同时SQLDMO.Application sqlApp = new SQLDMO.ApplicationClass() ;
选择你所引用的对象在属性里 改变互嵌套的类型
qianyz 2010-11-26 13:28
如果心跳测试失败，我怎样才能拿到失败的结果？期待回答
melody&bobo 2010-05-12 11:12
this.AspNetPager1.CustomInfoHTML = string.Format("当前第{0}/{1}页 共{2}条记录 每页{3}条", new object[] { this.AspNetPager1.CurrentPageIndex, this.AspNetPager1.PageCount, this.AspNetPager1.RecordCount, this.AspNetPager1.PageSize });
melody&bobo 2010-05-12 11:10
<style type="text/css">
/*拍拍网风格*/
.paginator { font: 11px Arial, Helvetica, sans-serif;padding:10px 20px 10px 0; margin: 0px;}
.paginator a {padding: 1px 6px; border: solid 1px #ddd; background: #fff; text-decoration: none;margin-right:2px}
.paginator a:visited {padding: 1px 6px; border: solid 1px #ddd; background: #fff; text-decoration: none;}
.paginator .cpb {padding: 1px 6px;font-weight: bold; font-size: 13px;border:none}
.paginator a:hover {color: #fff; background: #ffa501;border-color:#ffa501;text-decoration: none;}
/*淘宝风格*/
.paginator { font: 12px Arial, Helvetica, sans-serif;padding:10px 20px 10px 0; margin: 0px;}
.paginator a {border:solid 1px #ccc;color:#0063dc;cursor:pointer;text-decoration:none;}
.paginator a:visited {padding: 1px 6px; border: solid 1px #ddd; background: #fff; text-decoration: none;}
.paginator .cpb {border:1px solid #F50;font-weight:700;color:#F50;background-color:#ffeee5;}
.paginator a:hover {border:solid 1px #F50;color:#f60;text-decoration:none;}
.paginator a,.paginator a:visited,.paginator .cpb,.paginator a:hover
{float:left;height:16px;line-height:16px;min-width:10px;_width:10px;margin-right:5px;text-align:center;
white-space:nowrap;font-size:12px;font-family:Arial,SimSun;padding:0 3px;}
</style>
前台：<table cellpadding="0" cellspacing="0" align="center" width="99%" class="border">
<tr>
<td align="left" colspan="2">
<webdiyer:AspNetPager ID="AspNetPager1" CssClass="paginator" CurrentPageButtonClass="cpb" runat="server" AlwaysShow="True"
FirstPageText="首页" LastPageText="尾页" NextPageText="下一页" PageSize="20" PrevPageText="上一页" ShowCustomInfoSection="Left"
ShowInputBox="Never" onpagechanged="AspNetPager1_PageChanged" CustomInfoTextAlign="Left" LayoutType="Table" >
</webdiyer:AspNetPager>
</td>
</tr>
</table>
e路狂奔 2009-08-26 15:43
this.goErr(this.Request.QueryString[i].ToString());
有问题的。
应该是
this.goErr(this.Request.QueryString.Keys[i].ToString());
melody&bobo 2009-07-16 10:26
创建数据库：(Student)
创建用户表：(Users)
use Student
go
create table Users
(
id int identity(1, 1) primary key,
name nvarchar(20) not null,
password nvarchar(20) not null
)
1.带输入参数的存储过程
create procedure proc_login
@name nvarchar(20),
@password nvarchar(20)
as
begin
select *
from Users
where name = @name and password = @password
end
go
调用带输入参数的存储过程
//连接数据库的字符串
private string connectionString = ConfigurationManager.AppSetting["connectionString"];
//数据层的登录方法
public static User Login(string name, string password) {
User user = null;
using (SqlConnection conn = new SqlConnection(connectionString)) {
SqlCommand cmd = new SqlCommand("proc_login", conn);
cmd.CommandType = CommandType.StoredProcedure; //指定调用存储过程
//指定参数
cmd.Parameters.Add("@name", SqlDbType.nvarchar, 20).Value = name;
cmd.Parameters.Add("@password", SqlDbType.nvarchar, 20).Value = password;
conn.open();
using(SqlDataReader sdr = cmd.ExecuteReader()) {
if(sdr.Read()) {
user = new User((int)sdr["id"], sdr["name"].ToString(), sdr["password"].ToString());
}
}
conn.Close();
}
return user;
}
2.带输入输出参数的存储过程
create procedure proc_login
@name nvarchar(20),
@password nvarchar(20),
@message nvarchar(50) output //用于输出用户登录的信息
as
begin
//判断用户名是否存在
if exists (select * from Users where name = @name)
begin
//判断密码是否正确
select * from Users where name = @name and password = @password
//返回的行数〉0
if @@rowcount > 0
begin
set @message = '登录成功！'
end
else
begin
set @message = '密码错误！'
end
end
else
begin
set @message = '用户名不存在！'
end
//在过程中如果有错误
if @@error <> 0
begin
set @message = '登录失败！'
end
end
go
调用带输入输出参数的存储过程
//数据层的登录方法
public static User Login(string name, string password, out string message) {
User user = null;
using (SqlConnection conn = new SqlConnection(connectionString)) {
SqlCommand cmd = new SqlCommand("proc_login", conn);
cmd.CommandType = CommandType.StoredProcedure; //指定调用存储过程
//指定参数
cmd.Parameters.Add("@name", SqlDbType.nvarchar, 20).Value = name;
cmd.Parameters.Add("@password", SqlDbType.nvarchar, 20).Value = password;
SqlParameter mes = new SqlParameter("@message", SqlDbType.nvarchar, 50);
mes.Direction = ParameterDiraction.Output;
cmd.Add(mes);
conn.open();
using(SqlDataReader sdr = cmd.ExecuteReader()) {
message = mes.Value.ToString();
if(sdr.Read()) {
user = new User((int)sdr["id"], sdr["name"].ToString(), sdr["password"].ToString());
}
}
conn.Close();
}
return user;
}
3.带返回值得存储过程
create procedure proc_login
@name nvarchar(20),
@password nvarchar(20)
as
declare @message nvarchar(50) output //用于返回用户登录的信息
begin
//判断用户名是否存在
if exists (select * from Users where name = @name)
begin
//判断密码是否正确
select * from Users where name = @name and password = @password
//返回的行数〉0
if @@rowcount > 0
begin
set @message = '登录成功！'
end
else
begin
set @message = '密码错误！'
end
end
else
begin
set @message = '用户名不存在！'
end
//在过程中如果有错误
if @@error <> 0
begin
set @message = '登录失败！'
end
return @message
end
go
调用带返回值得存储过程
//数据层的登录方法
public static User Login(string name, string password, out string message) {
User user = null;
using (SqlConnection conn = new SqlConnection(connectionString)) {
SqlCommand cmd = new SqlCommand("proc_login", conn);
cmd.CommandType = CommandType.StoredProcedure; //指定调用存储过程
//指定参数
cmd.Parameters.Add("@name", SqlDbType.nvarchar, 20).Value = name;
cmd.Parameters.Add("@password", SqlDbType.nvarchar, 20).Value = password;
SqlParameter mes = new SqlParameter("@message", SqlDbType.nvarchar, 50);
mes.Direction = ParameterDiraction.ReturnValue; //注意这里指定返回值
cmd.Add(mes);
conn.open();
using(SqlDataReader sdr = cmd.ExecuteReader()) {
message = mes.Value.ToString();
if(sdr.Read()) {
user = new User((int)sdr["id"], sdr["name"].ToString(), sdr["password"].ToString());
}
}
conn.Close();
}
return user;
}
melody&bobo 2009-07-16 10:26
创建数据库：(Student)
创建用户表：(Users)
use Student
go
create table Users
(
id int identity(1, 1) primary key,
name nvarchar(20) not null,
password nvarchar(20) not null
)
1.带输入参数的存储过程
create procedure proc_login
@name nvarchar(20),
@password nvarchar(20)
as
begin
select *
from Users
where name = @name and password = @password
end
go
调用带输入参数的存储过程
//连接数据库的字符串
private string connectionString = ConfigurationManager.AppSetting["connectionString"];
//数据层的登录方法
public static User Login(string name, string password) {
User user = null;
using (SqlConnection conn = new SqlConnection(connectionString)) {
SqlCommand cmd = new SqlCommand("proc_login", conn);
cmd.CommandType = CommandType.StoredProcedure; //指定调用存储过程
//指定参数
cmd.Parameters.Add("@name", SqlDbType.nvarchar, 20).Value = name;
cmd.Parameters.Add("@password", SqlDbType.nvarchar, 20).Value = password;
conn.open();
using(SqlDataReader sdr = cmd.ExecuteReader()) {
if(sdr.Read()) {
user = new User((int)sdr["id"], sdr["name"].ToString(), sdr["password"].ToString());
}
}
conn.Close();
}
return user;
}
2.带输入输出参数的存储过程
create procedure proc_login
@name nvarchar(20),
@password nvarchar(20),
@message nvarchar(50) output //用于输出用户登录的信息
as
begin
//判断用户名是否存在
if exists (select * from Users where name = @name)
begin
//判断密码是否正确
select * from Users where name = @name and password = @password
//返回的行数〉0
if @@rowcount > 0
begin
set @message = '登录成功！'
end
else
begin
set @message = '密码错误！'
end
end
else
begin
set @message = '用户名不存在！'
end
//在过程中如果有错误
if @@error <> 0
begin
set @message = '登录失败！'
end
end
go
调用带输入输出参数的存储过程
//数据层的登录方法
public static User Login(string name, string password, out string message) {
User user = null;
using (SqlConnection conn = new SqlConnection(connectionString)) {
SqlCommand cmd = new SqlCommand("proc_login", conn);
cmd.CommandType = CommandType.StoredProcedure; //指定调用存储过程
//指定参数
cmd.Parameters.Add("@name", SqlDbType.nvarchar, 20).Value = name;
cmd.Parameters.Add("@password", SqlDbType.nvarchar, 20).Value = password;
SqlParameter mes = new SqlParameter("@message", SqlDbType.nvarchar, 50);
mes.Direction = ParameterDiraction.Output;
cmd.Add(mes);
conn.open();
using(SqlDataReader sdr = cmd.ExecuteReader()) {
message = mes.Value.ToString();
if(sdr.Read()) {
user = new User((int)sdr["id"], sdr["name"].ToString(), sdr["password"].ToString());
}
}
conn.Close();
}
return user;
}
3.带返回值得存储过程
create procedure proc_login
@name nvarchar(20),
@password nvarchar(20)
as
declare @message nvarchar(50) output //用于返回用户登录的信息
begin
//判断用户名是否存在
if exists (select * from Users where name = @name)
begin
//判断密码是否正确
select * from Users where name = @name and password = @password
//返回的行数〉0
if @@rowcount > 0
begin
set @message = '登录成功！'
end
else
begin
set @message = '密码错误！'
end
end
else
begin
set @message = '用户名不存在！'
end
//在过程中如果有错误
if @@error <> 0
begin
set @message = '登录失败！'
end
return @message
end
go
调用带返回值得存储过程
//数据层的登录方法
public static User Login(string name, string password, out string message) {
User user = null;
using (SqlConnection conn = new SqlConnection(connectionString)) {
SqlCommand cmd = new SqlCommand("proc_login", conn);
cmd.CommandType = CommandType.StoredProcedure; //指定调用存储过程
//指定参数
cmd.Parameters.Add("@name", SqlDbType.nvarchar, 20).Value = name;
cmd.Parameters.Add("@password", SqlDbType.nvarchar, 20).Value = password;
SqlParameter mes = new SqlParameter("@message", SqlDbType.nvarchar, 50);
mes.Direction = ParameterDiraction.ReturnValue; //注意这里指定返回值
cmd.Add(mes);
conn.open();
using(SqlDataReader sdr = cmd.ExecuteReader()) {
message = mes.Value.ToString();
if(sdr.Read()) {
user = new User((int)sdr["id"], sdr["name"].ToString(), sdr["password"].ToString());
}
}
conn.Close();
}
return user;
}