如何将数据插入到asp.net网站的SQL Server？

编程入门行业动态更新时间:2024-10-27 12:37:27

本文介绍了如何将数据插入到asp网站的SQL Server？的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！问题描述

我想从我的网站中插入数据到SQL Server建立在VS 2008.For，我使用按钮点击事件。我试图显示在YouTube上code，但在code不起作用。它会显示错误在我的网站。

I tried to insert data into sql server from my website build in vs 2008.For that I used button click event .I tried code shown in youtube but the code doesn't work .It shows error in my website.

在code。在.aspx.cs文件

The code in .aspx.cs file is

public partial class _Default : System.Web.UI.Page { SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString); protected void Page_Load(object sender, EventArgs e) { conn.Open(); } protected void btnInsert_Click(object sender, EventArgs e) { SqlCommand cmd = new SqlCommand("insert into Insert values('"+txtCity.Text+"','"+txtFName.Text+"','"+txtLName.Text+"')",conn); cmd.ExecuteNonQuery(); conn.Close(); Label1.Visible =true; Label1.Text = "Your data inserted successfully"; txtCity.Text = ""; txtFName.Text = ""; txtLName.Text = ""; }

} `

推荐答案

好了，让我们来解决这个问题code最多只是一点点。你越来越有：

Okay, let's fix this code up just a little. You're getting there:

var cnnString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; var cmd = "insert into Insert values(@City,@FName,@LName)"; using (SqlConnection cnn = new SqlConnection(cnnString)) { using (SqlCommand cmd = new SqlCommand(cmd, cnn)) { cmd.Parameters.AddWithValue("@City",txtCity.Text); cmd.Parameters.AddWithValue("@FName",txtFName.Text); cmd.Parameters.AddWithValue("@LName",txtLName.Text); cnn.Open(); cmd.ExecuteNonQuery(); } }

有两件事情需要注意修改code。