Search the Community

this is a very simple task, it insert name, address and age to the database error when the sql data base from server is use. but when data base from folder app_data is used its working. using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Data.SqlClient; using System.Configuration; namespace WebApplication5 { public partial class WebForm1 : System.Web.UI.Page { SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString); protected void Page_Load(object sender, EventArgs e) { con.Open(); } protected void Button1_Click(object sender, EventArgs e) { SqlCommand cmd = new SqlCommand("insert into listotable values('"+TextBox1.Text+"','" +TextBox2.Text+"', '"+TextBox3.Text+"')",con); cmd.ExecuteNonQuery(); con.Close(); TextBox3.Text=""; TextBox2.Text=""; TextBox1.Text=""; } } }