Click here to Skip to main content
15,909,651 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
when i am executing, this code is showing error "executenonquery-connection property is not initialized"

can anyone help me?

C#
 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();
           
}
Posted
Updated 14-Feb-12 18:12pm
v2
Comments
Al Moje 15-Feb-12 0:16am    
Added pre tag…

Try This
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.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;
} 
 
Share this answer
 
v2
Comments
amaljosep 15-Feb-12 0:35am    
still the same error......
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. :)
 
Share this answer
 
use cmd.Connection=con; in solution 1.
 
Share this answer
 
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "SP_USERPROFILE_INSERT";
//add this line after the above lines
cmd.connection=con;


hope it works...!!
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900