objConnection.Dispose();
objConnection.Close(); 
这两句任选其一,你先Dispose,再Close肯定出错

解决方案 »

  1.   

    你是说要这两句其中的一句对吗?
    objConnection.Dispose(); 
    objConnection.Close(); 
      

  2.   

    我试过了··
    但是他还是报“未将对象引用设置到对象的实例”
    请您说仔细点可以吗?
    这个接口是给Flash用的,以前我没有写过
      

  3.   

    cmd.Dispose();  这个不要可以吗
      

  4.   


    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("成功");最好将错误信息一个给出来
      

  5.   

    这样看看: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", "");
            } 
        }
      

  6.   

    private string cut(string content) 
    是你这个方法有问题,字符串为空的时候,你要判断下。
      

  7.   

    string _Company;
    try
    {
     Company = cut(Request["_Company"]);
    }catch{
     Company = "";
    }
    .....以下几个一样.
      

  8.   

    失败对象名 'Guest' 无效。
    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", "");
            } 
        }
      

  9.   


    连接字符串有没有问题?数据库中有没有Guest这个表?