objConnection.Dispose();
objConnection.Close();
这两句任选其一,你先Dispose,再Close肯定出错
objConnection.Close();
这两句任选其一,你先Dispose,再Close肯定出错
解决方案 »
- 关于黑冰防火墙
- 同一个页面多个相同控件的处理问题.......
- 一次让人发疯的风页调试,竟然把SA的密码加上提示跳起来
- 为什么调用邹健存取过程的时候一翻页出现该表中已有继承了标识属性的列 'id'
- 为什么一开始添加时,xml文件会的最上面会有一空白行,全部为null,添加的代码如下,请问问题出在哪里?一上午都没解决,请各位多指教了
- 求助~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
- 如何调用服务器端可执行程序
- 关于发送EMAIL
- 为什么ASP.NET的空间,比PHP空间贵?
- (在线等候!!!!)在textbox里面录入字符的时候如何控制用户录入的字符的数量??或者在用户点击提交的时候判断是否字符数超出限制??
- ASp问题
- 做ASP。NET的都不得不看的帖子
objConnection.Dispose();
objConnection.Close();
但是他还是报“未将对象引用设置到对象的实例”
请您说仔细点可以吗?
这个接口是给Flash用的,以前我没有写过
string _Company = cut(Request["_Company"]);
string _Picture = cut(Request["Picture"]);
string _Categories = cut(Request["Categories"]);
string sql = string.Format("select count(*) from Guest where Company='{0}' and Picture='{1}'and Categories='{2}'", _Company, _Picture, _Categories);
string strConnection = ConfigurationSettings.AppSettings["ConnectionString"];
using (SqlConnection objConnection = new SqlConnection(strConnection))
{
objConnection.Open();
SqlCommand cmd = new SqlCommand(sql, objConnection);
cmd.ExecuteNonQuery();
}
Response.Write("成功");最好将错误信息一个给出来
using System.Collections;
using System.Configuration;
using System.Data;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Data.SqlClient; public partial class Interface_Guest : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
try
{
string _Company = cut(Request["_Company"]);
string _Picture = cut(Request["Picture"]);
string _Categories = cut(Request["Categories"]);
string sql = "select count(*) from Guest where Company='" + _Company + "'and Picture='" + _Picture + "'and Categories='" + _Categories + "'";
string strConnection = ConfigurationSettings.AppSettings["ConnectionString"];
SqlConnection objConnection = new SqlConnection(strConnection);
objConnection.Open();
SqlCommand cmd = new SqlCommand(sql, objConnection);
cmd.ExecuteNonQuery();
cmd.Dispose();
objConnection.Dispose();
Response.Write("成功");
}
catch (Exception ex)
{
Response.Write("失败" + ex.Message);
}
} private string cut(string content)
{
if (string.IsNullOrEmpty(content))
return string.Empty;
return content.Trim().Replace("'", "").Replace("%", "").Replace("*", "").Replace("insert", "").Replace("into", "").Replace("update", "").Replace("delete", "").Replace("select", "");
}
}
是你这个方法有问题,字符串为空的时候,你要判断下。
try
{
Company = cut(Request["_Company"]);
}catch{
Company = "";
}
.....以下几个一样.
using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Data.SqlClient; public partial class Interface_Guest : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
try
{
string _Company = cut(Request["_Company"]);
string _Picture = cut(Request["Picture"]);
string _Categories = cut(Request["Categories"]);
string sql = "select count(*) from Guest where Company='" + _Company + "'and Picture='" + _Picture + "'and Categories='" + _Categories + "'";
string strConnection = ConfigurationSettings.AppSettings["ConnectionString"];
SqlConnection objConnection = new SqlConnection(strConnection);
objConnection.Open();
SqlCommand cmd = new SqlCommand(sql, objConnection);
cmd.ExecuteNonQuery();
cmd.Dispose();
objConnection.Dispose();
Response.Write("成功");
}
catch (Exception ex)
{
Response.Write("失败" + ex.Message);
}
} private string cut(string content)
{
if (string.IsNullOrEmpty(content))
return string.Empty;
return content.Trim().Replace("'", "").Replace("%", "").Replace("*", "").Replace("insert", "").Replace("into", "").Replace("update", "").Replace("delete", "").Replace("select", "");
}
}
连接字符串有没有问题?数据库中有没有Guest这个表?