object result =null;
DbProviderFactory factory = GetDbProviderFactory(smartDatabaseType);
using (DbConnection dbConnection = factory.CreateConnection())
{
dbConnection.ConnectionString = connectionString;
using (DbCommand dbCommand = dbConnection.CreateCommand())
{
dbCommand.CommandText = sentence;
if (parameters != null)
{
dbCommand.Parameters.AddRange(parameters);
}
dbConnection.Open();
result = dbCommand.ExecuteScalar().ToString();
}
}
//如果返回的是DBNull类型或者是空,则返回null
if (result == DBNull.Value || result.ToString().Trim().Length == 0)
{
result = null;
}
return result;
DbProviderFactory factory = GetDbProviderFactory(smartDatabaseType);
using (DbConnection dbConnection = factory.CreateConnection())
{
dbConnection.ConnectionString = connectionString;
using (DbCommand dbCommand = dbConnection.CreateCommand())
{
dbCommand.CommandText = sentence;
if (parameters != null)
{
dbCommand.Parameters.AddRange(parameters);
}
dbConnection.Open();
result = dbCommand.ExecuteScalar().ToString();
}
}
//如果返回的是DBNull类型或者是空,则返回null
if (result == DBNull.Value || result.ToString().Trim().Length == 0)
{
result = null;
}
return result;
解决方案 »
- 窗体的插入数据
- 支付宝接口问题
- 框架刷新问题
- 新手提问:textbox最大长度问题。。
- 问高哥的帖子?哈哈,长点
- ASP.NET(C#)处理页面缓存的问题
- vs.net中部署时发生的问题?请帮忙!
- |M| 为什么我的缓存没有效果 <%@ OutputCache Duration="3600" VaryByParam="Type,Keyworld,ParkType,Country,Province,City,Area"%>
- 如何继承一个webform控件并支持设计时特性
- datagrid的Datasource能否为Dataset中的不同数据表呢?(同时是2个以上)
- 实时获取数据库最新记录,JS每秒刷新一次查询??求助。。。
- DataList中如何获取ItemTemplate中控件的值
convert(varchar(300),字段)
http://msdn.microsoft.com/zh-cn/library/ms187928.aspx
数据库里没有NTEXT字段
我也不清楚是哪个字段出的问题
result = dbCommand.ExecuteScalar().ToString();
NTEXT得转换下才能EQUEL地
CREATE PROCEDURE dt_master
@username varchar(20),
@password varchar(10),
@state int output
as
select mm_id from tb_mastermanage where cast( mm_username as varchar)=@username
if(@@rowcount<1)
begin
set @state=0
end
else
select mm_id from tb_mastermanage where cast( mm_username as varchar)=@username and cast( mm_psw as varchar)=@password
if(@@rowcount<1)
begin
set @state=0end
else
set @state=1return
GO这是我的存储过程