asp.net core_asp.net中向mssqlserver中添加单条数据

index.cs文件

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)
    {
        if (!Page.IsPostBack)
        {
            this.bindGridview();//调用自定义方法绑定控件数据
        }
    }
    public void bindGridview()
    {
        SqlConnection con = new SqlConnection(ConfigurationSettings.AppSettings["strCon"]);
        con.Open();//打开数据库连接
        SqlDataAdapter ada = new SqlDataAdapter("Select * From tb_Send05", con);//创建数据适配器
        DataSet ds = new DataSet();//创建数据集
        ada.Fill(ds);//填充数据集
        GridView1.DataSource = ds;//绑定数据
        GridView1.DataBind();
        con.Close();
    }
    protected void ImgBtnSend_Click(object sender, ImageClickEventArgs e)
    {
        try
        {
            SqlConnection con = new SqlConnection(ConfigurationSettings.AppSettings["strCon"]);
            con.Open();
            string InsertSql = "Insert Into tb_send05 values("" + TextBox1.Text + "","" + TextBox2.Text + "","" + TextBox3.Text + "")";
            SqlCommand com = new SqlCommand(InsertSql, con);//创建执行SQL命令的SqlCommand对象
            com.ExecuteNonQuery();//执行添加操作
            SqlDataAdapter ada = new SqlDataAdapter("Select * From tb_Send05", con);//创建适配器
            DataSet ds = new DataSet();
            ada.Fill(ds);
            GridView1.DataSource = ds;
            GridView1.DataBind();
            con.Close();
            Response.Write("<script language=javascript>alert("添加成功！")</script>");
        }
        catch
        {
            Response.Write("<script language=javascript>alert("添加失败！")</script>");
        }
    }
    protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        this.GridView1.PageIndex = e.NewPageIndex;
        this.bindGridview();
    }
}

本文来源：http://www.bbyears.com/shujuku/37283.html