Error:
System.InvalidOperationException was unhandled by user code
Message="ExecuteNonQuery: Connection property has not been initialized."
Source="System.Data"
StackTrace:
at System.Data.SqlClient.SqlCommand.ValidateCommand(String method, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at _Default.btnSubmit_Click(Object sender, EventArgs e) in c:\Users\Somesh\Desktop\assigment\Default.aspx.cs:line 32
at System.Web.UI.WebControls.Button.OnClick(EventArgs e)
at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)
at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
InnerException:
Code:
using System;
using System.Configuration;
using System.Data;
using System.Linq;
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.Xml.Linq;
using System.Data.SqlClient;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["siteConnectionString1"].ConnectionString);
SqlCommand cm = new SqlCommand("insert into new_user (first,last,email,mobile,gender,country) values(@first,@last,@email,@mobile,@gender,@country)");
cm.CommandType = CommandType.Text;
cm.Parameters.AddWithValue("@first", txtFirstName.Text);
cm.Parameters.AddWithValue("@last", txtSecondName.Text);
cm.Parameters.AddWithValue("@email", txtFirstName.Text);
cm.Parameters.AddWithValue("@mobile", txtFirstName.Text);
cm.Parameters.AddWithValue("@gender", txtFirstName.Text);
cm.Parameters.AddWithValue("@country", txtFirstName.Text);
con.Open();
cm.ExecuteNonQuery();
con.Close();
}
protected void btnClear_Click(object sender, EventArgs e)
{
}
}
Config file:
add name="siteConnectionString1" connectionstring="Data Source=SOMESH-PC\SQLEXPRESS;Initial Catalog=site;Integrated Security=True" providerName="System.Data.SqlClient"