显示错误的连接属性未初始化..... [英] showing error connection property is not initialized........

问题描述

当我执行时，此代码显示错误"executenonquery-connection属性未初始化"

有人可以帮我吗?

when i am executing, this code is showing error "executenonquery-connection property is not initialized"

can anyone help me?

 public void connect()
      {
          SqlConnection con = new SqlConnection(@"Data Source=CSZ-PCS43132\SQLEXPRESS;Initial Catalog=Test;Integrated Security=True");
          con.Open();
      }

public string viewdetails(HRViewpagedetailsMDL  objEditListingPage)
        {
            connect();
            SqlCommand cmd = new SqlCommand();
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.CommandText = "SP_USERPROFILE_INSERT";
            cmd.Parameters.AddWithValue("@firstname",objEditListingPage.firstName);
            cmd.Parameters.AddWithValue("@lastname", objEditListingPage .lastname);
            cmd.Parameters.AddWithValue("@email", objEditListingPage .email);
            cmd.Parameters.AddWithValue("@newrecruit",objEditListingPage .newrecruit);
            cmd.Parameters.AddWithValue("@siteid", objEditListingPage.site.siteid);
            cmd.Parameters.AddWithValue("@comments", objEditListingPage.comments);
            cmd.Parameters.AddWithValue("@manageothers", objEditListingPage.manageothers);
            cmd.Parameters.AddWithValue("@topfunctionid", objEditListingPage.topfunction.topfunctionid);
            cmd.Parameters.AddWithValue("@subfunctionid", objEditListingPage.subfunction.subfunctionid);
            cmd.Parameters.AddWithValue("@lmsroleid", objEditListingPage.lmsrole.lmsroleid);
            cmd.Parameters.AddWithValue("@channelid", objEditListingPage.channel.channelid);
            cmd.Parameters.AddWithValue("@employmentstatusid", objEditListingPage.employmentstatus.employmentstatusid);
            cmd.Parameters.AddWithValue("@statusid", objEditListingPage.status.statusid);
            cmd.Parameters.AddWithValue("@active", objEditListingPage.active);
            cmd.Parameters.AddWithValue("@audiencefunctionallmsid", objEditListingPage.audiencefunctionallms);
            cmd.Parameters.AddWithValue("@audiencelmsspecial", objEditListingPage.audiencespeciallms);
            cmd.Parameters.AddWithValue("@existingthecompany", objEditListingPage.existingthecompany);
            cmd.Parameters.AddWithValue("@localjobtitle", objEditListingPage.localjobtitle);
            cmd.Parameters.AddWithValue("@locallanguagejobtitle", objEditListingPage.locallanguagejobtitle);
            cmd.Parameters.AddWithValue("@kmlevel", objEditListingPage.kmlevel);
            return cmd.ExecuteNonQuery().ToString();
           
}

推荐答案

尝试一下

SqlConnection con;
public void connect()
{
 con = new SqlConnection(@"Data Source=CSZ-PCS43132\SQLEXPRESS;Initial Catalog=Test;Integrated Security=True");

}
 
public string viewdetails(HRViewpagedetailsMDL objEditListingPage)
{
connect();
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "SP_USERPROFILE_INSERT";
cmd.Parameters.AddWithValue("@firstname",objEditListingPage.firstName);
cmd.Parameters.AddWithValue("@lastname", objEditListingPage .lastname);
cmd.Parameters.AddWithValue("@email", objEditListingPage .email);
cmd.Parameters.AddWithValue("@newrecruit",objEditListingPage .newrecruit);
cmd.Parameters.AddWithValue("@siteid", objEditListingPage.site.siteid);
cmd.Parameters.AddWithValue("@comments", objEditListingPage.comments);
cmd.Parameters.AddWithValue("@manageothers", objEditListingPage.manageothers);
cmd.Parameters.AddWithValue("@topfunctionid", objEditListingPage.topfunction.topfunctionid);
cmd.Parameters.AddWithValue("@subfunctionid", objEditListingPage.subfunction.subfunctionid);
cmd.Parameters.AddWithValue("@lmsroleid", objEditListingPage.lmsrole.lmsroleid);
cmd.Parameters.AddWithValue("@channelid", objEditListingPage.channel.channelid);
cmd.Parameters.AddWithValue("@employmentstatusid", objEditListingPage.employmentstatus.employmentstatusid);
cmd.Parameters.AddWithValue("@statusid", objEditListingPage.status.statusid);
cmd.Parameters.AddWithValue("@active", objEditListingPage.active);
cmd.Parameters.AddWithValue("@audiencefunctionallmsid", objEditListingPage.audiencefunctionallms);
cmd.Parameters.AddWithValue("@audiencelmsspecial", objEditListingPage.audiencespeciallms);
cmd.Parameters.AddWithValue("@existingthecompany", objEditListingPage.existingthecompany);
cmd.Parameters.AddWithValue("@localjobtitle", objEditListingPage.localjobtitle);
cmd.Parameters.AddWithValue("@locallanguagejobtitle", objEditListingPage.locallanguagejobtitle);
cmd.Parameters.AddWithValue("@kmlevel", objEditListingPage.kmlevel);
con.Open();
string result= cmd.ExecuteNonQuery().ToString();
con.Close();
return result;
} 

尝试一下

< pre lang ="c#"> SqlConnection con;
公共无效的connect()
{
con =新的SqlConnection(@数据源= CSZ-PCS43132 \ SQLEXPRESS;初始目录=测试；集成安全性=真");

}

公共字符串viewdetails(HRViewpagedetailsMDL objEditListingPage)
{
connect();
SqlCommand cmd =新的SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText ="SP_USERPROFILE_INSERT";
cmd.Connection = con;
cmd.Parameters.AddWithValue("@ firstname"，objEditListingPage.firstName);
cmd.Parameters.AddWithValue("@ lastname"，objEditListingPage .lastname);
cmd.Parameters.AddWithValue("@ email"，objEditListingPage .email);
cmd.Parameters.AddWithValue("@ newrecruit"，objEditListingPage .newrecruit);
cmd.Parameters.AddWithValue("@ siteid"，objEditListingPage.site.siteid);
cmd.Parameters.AddWithValue("@ comments"，objEditListingPage.comments);
cmd.Parameters.AddWithValue("@ manageothers"，objEditListingPage.manageothers);
cmd.Parameters.AddWithValue("@ topfunctionid"，objEditListingPage.topfunction.topfunctionid);
cmd.Parameters.AddWithValue("@ subfunctionid"，objEditListingPage.subfunction.subfunctionid);
cmd.Parameters.AddWithValue("@ lmsroleid"，objEditListingPage.lmsrole.lmsroleid);
cmd.Parameters.AddWithValue("@ channelid"，objEditListingPage.channel.channelid);
cmd.Parameters.AddWithValue("@ employmentstatusid"，objEditListingPage.employmentstatus.employmentstatusid);
cmd.Parameters.AddWithValue("@ statusid"，objEditListingPage.status.statusid);
cmd.Parameters.AddWithValue("@ active"，objEditListingPage.active);
cmd.Parameters.AddWithValue("@ audiencefunctionallmsid"，objEditListingPage.audiencefunctionallms);
cmd.Parameters.AddWithValue("@ audiencelmsspecial"，objEditListingPage.audiencespeciallms);
cmd.Parameters.AddWithValue("@ existingthecompany"，objEditListingPage.existingthecompany);
cmd.Parameters.AddWithValue("@ localjobtitle"，objEditListingPage.localjobtitle);
cmd.Parameters.AddWithValue("@ locallanguagejobtitle"，objEditListingPage.locallanguagejobtitle);
cmd.Parameters.AddWithValue("@ kmlevel"，objEditListingPage.kmlevel);
con.Open();
字符串result = cmd.ExecuteNonQuery().ToString();
con.Close();
返回结果；
}</pre>


如果您愿意，请接受答案.祝一切顺利. :)

Try This

<pre lang="c#">SqlConnection con;
public void connect()
{
con = new SqlConnection(@"Data Source=CSZ-PCS43132\SQLEXPRESS;Initial Catalog=Test;Integrated Security=True");

}

public string viewdetails(HRViewpagedetailsMDL objEditListingPage)
{
connect();
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "SP_USERPROFILE_INSERT";
cmd.Connection=con;
cmd.Parameters.AddWithValue("@firstname",objEditListingPage.firstName);
cmd.Parameters.AddWithValue("@lastname", objEditListingPage .lastname);
cmd.Parameters.AddWithValue("@email", objEditListingPage .email);
cmd.Parameters.AddWithValue("@newrecruit",objEditListingPage .newrecruit);
cmd.Parameters.AddWithValue("@siteid", objEditListingPage.site.siteid);
cmd.Parameters.AddWithValue("@comments", objEditListingPage.comments);
cmd.Parameters.AddWithValue("@manageothers", objEditListingPage.manageothers);
cmd.Parameters.AddWithValue("@topfunctionid", objEditListingPage.topfunction.topfunctionid);
cmd.Parameters.AddWithValue("@subfunctionid", objEditListingPage.subfunction.subfunctionid);
cmd.Parameters.AddWithValue("@lmsroleid", objEditListingPage.lmsrole.lmsroleid);
cmd.Parameters.AddWithValue("@channelid", objEditListingPage.channel.channelid);
cmd.Parameters.AddWithValue("@employmentstatusid", objEditListingPage.employmentstatus.employmentstatusid);
cmd.Parameters.AddWithValue("@statusid", objEditListingPage.status.statusid);
cmd.Parameters.AddWithValue("@active", objEditListingPage.active);
cmd.Parameters.AddWithValue("@audiencefunctionallmsid", objEditListingPage.audiencefunctionallms);
cmd.Parameters.AddWithValue("@audiencelmsspecial", objEditListingPage.audiencespeciallms);
cmd.Parameters.AddWithValue("@existingthecompany", objEditListingPage.existingthecompany);
cmd.Parameters.AddWithValue("@localjobtitle", objEditListingPage.localjobtitle);
cmd.Parameters.AddWithValue("@locallanguagejobtitle", objEditListingPage.locallanguagejobtitle);
cmd.Parameters.AddWithValue("@kmlevel", objEditListingPage.kmlevel);
con.Open();
string result= cmd.ExecuteNonQuery().ToString();
con.Close();
return result;
} </pre>


Accept the answer if you like it.. All the best. :)

使用cmd.Connection = con;在解决方案1中.

use cmd.Connection=con; in solution 1.

这篇关于显示错误的连接属性未初始化.....的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！