在vs里怎么向SQL05的表里添加一行数据呢

来源：百度知道 编辑：UC知道 时间：2024/06/28 03:53:00
using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

public partial class KnowledgeNet_KMap_knfield : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{

}
protected void TextBox2_TextChanged(object sender, EventArgs e)
{

}

protected void Button1_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection("server=FDI\\SQLEXPRESS;database=KMS;uid=sa;pwd=123");
con.Open();
string cmdtext = "insert into Kn_Taxonomy values(" + TextBox1.Text + ",'" + this.TextBox2.Text + "',&

…… ……
con.Open();
string cmdtext = .......;
SqlCommand cmd = new SqlCommand(cmdtext,con);
cmd.ExecuteNonQuery(); //少了这句，意思是执行SQL语句
con.Close();
…… ……

楼上正解...
但是,

if(cmd.ExecuteNonQuery > 0)
{
Response.Write("<script>alert("更新成功!")</script>");
}

con.close();