asp应用程序中的实例失败错误 [英] Instance Failure Error in asp application

问题描述

连接字符串正确时，代码中出现实例失败错误。 plzz告诉我，我可以删除此错误.Thnxx。

< connectionstrings> 
< add name =ABCconnectionstring =Data Source = DEEPAK-PC\\SQLEXPRESS; Initial Catalog = Lastimage; User ID = sa; Password = sasa> 
 providerName =System.Data.SqlClient/> 
< add name =LastimageConnectionStringconnectionstring =Data Source = DEEPAK-PC\\SQLEXPRESS; Initial Catalog = Lastimage; User ID = sa; Password = sasa> 
 providerName =System.Data.SqlClient/> 
< / add>< / add>< / connectionstrings> 

和.aspx.cs页面上的代码是

 静态  string  str = ConfigurationManager.ConnectionStrings [  ABC]。ConnectionString; 
 
 受保护  void  Page_Load（对象发​​件人，EventArgs e）
 {
 如果（！IsPostBack）
 {
 filldropdown（） ; 
} 
} 
  //   SqlConnection con = new SqlConnection（str）;  
  public   void  filldropdown（）
 {
 < span class =code-comment> //   SqlConnection con = new SqlConnection（@Data Source = DEEPAK-PC \\SQLEXPRESS; Initial Catalog = Lastimage;用户ID = sa;密码= sasa）;  
 SqlConnection con =  new  SqlConnection（str）; 
 **** con.Open（）; 
 SqlCommand cmd =  new  SqlCommand（ 选择来自Tbl_Emp的EmpID，con）; 
  //   if（con.State == ConnectionState.Closed） 
 < span class =code-comment> //   { 
  //   con.Open（）;  
  //   }  
 SqlDataReader dr = cmd.ExecuteReader（）; 
 TextBox3.Items.Clear（）; 
  if （dr.HasRows）
 {
  //  < span class =code-comment> TextBox3.DataSource = dr [EmpID]。ToString（）;  
  //   TextBox3.DataBind（）;  
 
  while （dr.Read（））
 {
 TextBox3.Items.Add（dr [  EmpID]。ToString（ ））; 
} 
} 
 con.Close（）; 
} 

它在盯着线上显示错误..plzz告诉我可以我删除它。

解决方案

在web.config文件中更改连接字符串部分，如：

<&的ConnectionStrings GT;
< add name =ABCconnectionstring =Data Source = DEEPAK-PC\\SQLEXPRESS; Initial Catalog = Lastimage; User ID = sa; Password = sasaprovidername =System.Data.SqlClient >< /添加>
< / connectionstrings>

使用此

 <   add     name   =  ABC    connectionstring   = 数据源= DEEPAK-PC\\SQLEXPRESS;初始目录= Lastimage;用户ID = sa;密码= sasa    
   
               providerName   =  System.Data.SqlClient    /  >  
 <  < span class =code-leadattribute> add     name   =  LastimageConnectionString    connectionstring   = 数据源= DEEPAK-PC\\SQLEXPRESS;初始目录= Lastimage;用户ID = sa;密码= sasa    
   
               providerName   =  System.Data.SqlClient    /  >  

试试这个...< add name =myConSqlconnectionstring =server = localhost; database = Lastimage; uid = sa; password = sasaprovidername =System.Data.SqlClient>< / add> 

I have instance failure error in code while connection string is right. plzz tell me hw can i remove this error..Thnxx.

<connectionstrings>
    <add name="ABC" connectionstring="Data Source=DEEPAK-PC\\SQLEXPRESS;Initial Catalog=Lastimage;User ID=sa;Password=sasa">
      providerName="System.Data.SqlClient" />
    <add name="LastimageConnectionString" connectionstring="Data Source=DEEPAK-PC\\SQLEXPRESS;Initial Catalog=Lastimage;User ID=sa;Password=sasa">
      providerName="System.Data.SqlClient" />
  </add></add></connectionstrings>

and code on .aspx.cs page is

static string str = ConfigurationManager.ConnectionStrings["ABC"].ConnectionString;
    
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            filldropdown();
        }
    }
    //SqlConnection con = new SqlConnection(str);
    public void filldropdown()
    {
        //SqlConnection con = new SqlConnection(@"Data Source=DEEPAK-PC\\SQLEXPRESS;Initial Catalog=Lastimage;User ID=sa;Password=sasa");
        SqlConnection con = new SqlConnection(str);
****        con.Open();
        SqlCommand cmd = new SqlCommand("Select EmpID from Tbl_Emp", con);
        //if (con.State == ConnectionState.Closed)
        //{
        //con.Open();
        //}
        SqlDataReader dr = cmd.ExecuteReader();
        TextBox3.Items.Clear();
        if (dr.HasRows)
        {
            //TextBox3.DataSource = dr["EmpID"].ToString();
            //TextBox3.DataBind();

            while (dr.Read())
            {
                TextBox3.Items.Add(dr["EmpID"].ToString());
            }
        }
        con.Close();
    }

Its showing an error in stared line..plzz tell hw can i remove it.

解决方案

Change your connection string section in web.config file like:

<connectionstrings>
    <add name="ABC" connectionstring="Data Source=DEEPAK-PC\\SQLEXPRESS;Initial Catalog=Lastimage;User ID=sa;Password=sasa" providername="System.Data.SqlClient"></add> 
</connectionstrings>

use this

<add name="ABC" connectionstring="Data Source=DEEPAK-PC\\SQLEXPRESS;Initial Catalog=Lastimage;User ID=sa;Password=sasa" 

      providerName="System.Data.SqlClient" />
    <add name="LastimageConnectionString" connectionstring="Data Source=DEEPAK-PC\\SQLEXPRESS;Initial Catalog=Lastimage;User ID=sa;Password=sasa" 

      providerName="System.Data.SqlClient" />

try this... <add name="myConSql" connectionstring="server=localhost;database=Lastimage;uid=sa;password=sasa" providername="System.Data.SqlClient"></add>

这篇关于asp应用程序中的实例失败错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！