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="";
}
}
}