SQL表中新增数

最新推荐文章于 2022-05-08 09:35:23 发布

yayun0516

最新推荐文章于 2022-05-08 09:35:23 发布

阅读量931

点赞数

分类专栏：数据库 asp.net 文章标签： asp.net SQL

本文链接：https://blog.csdn.net/yayun0516/article/details/41040869

版权

asp.net 同时被 2 个专栏收录

117 篇文章 7 订阅

订阅专栏

数据库

11 篇文章 0 订阅

订阅专栏

.aspx代码如下：

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="数据增删查改.aspx.cs" Inherits="数据增删查改" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
    姓名：<asp:TextBox ID="txt_name" runat="server"></asp:TextBox><br />
    语文：<asp:TextBox ID="txt_chinese" runat="server"></asp:TextBox><br />
    数学：<asp:TextBox ID="txt_math" runat="server"></asp:TextBox><br />
    物理：<asp:TextBox ID="txt_physics" runat="server"></asp:TextBox><br />
    化学：<asp:TextBox ID="txt_chemstry" runat="server"></asp:TextBox><br />
    英语：<asp:TextBox ID="txt_english" runat="server"></asp:TextBox><br />
        <asp:Button ID="btn_add" runat="server" Text="新增" οnclick="btn_add_Click" />
        <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 
            DataSourceID="SqlDataSource1">
            <Columns>
                <asp:BoundField DataField="姓名" HeaderText="姓名" SortExpression="姓名" />
                <asp:BoundField DataField="语文" HeaderText="语文" SortExpression="语文" />
                <asp:BoundField DataField="数学" HeaderText="数学" SortExpression="数学" />
                <asp:BoundField DataField="物理" HeaderText="物理" SortExpression="物理" />
                <asp:BoundField DataField="化学" HeaderText="化学" SortExpression="化学" />
                <asp:BoundField DataField="英语" HeaderText="英语" SortExpression="英语" />
            </Columns>
        </asp:GridView>
    
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
            ConnectionString="<%$ ConnectionStrings:userinfoConnectionString %>" 
            SelectCommand="SELECT * FROM [成绩]"></asp:SqlDataSource>
    
    </div>
    </form>
</body>
</html>

.aspx.cs代码如下：

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;

public partial class 数据增删查改 : System.Web.UI.Page
{
  string con = "server=localhost\\SQL2005 ;uid=sa;pwd=1111qq;database=userinfo";
    SqlConnection conn;
    SqlCommand cmd;
    //SqlDataReader datar;
    string str_sql;

    protected void Page_Load(object sender, EventArgs e)
    {

    }

    protected void btn_add_Click(object sender, EventArgs e)
    {
        try
        {
            conn = new SqlConnection(con);
            conn.Open();

            str_sql = makestr();
            cmd = new SqlCommand(str_sql, conn);
            int i=cmd.ExecuteNonQuery();
            if (i > 0) { Response.Write("<script>alert('添加成功!')</script>"); GridView1.DataBind(); }
           
        }
        catch (Exception ex)
        {
            Response.Write(ex.ToString());

        }

        finally
        {
            conn.Close();
        }
       
       //数据绑定，可以马上显示在表中

    }
    protected string makestr() {
        string _result = "";
        string _name, _chinese, _math, _physics, _chemstry, _english;
        _name = txt_name.Text;
        _chinese = txt_chinese.Text;
        _math = txt_math.Text;
        _physics = txt_physics.Text;
        _chemstry = txt_chemstry.Text;
        _english = txt_english.Text;
        //下面SQL语句极易出错，注意里面所用的的（）和，都必须是英文格式下的，不然会报错！！！！！！！！！！！！！！
        _result = "Insert into 成绩(姓名,语文,数学,物理,化学,英语)values('" + _name + "','" + _chinese + "','" + _math + "','" + _physics + "','" + _chemstry + "','" + _english + "')";

        return _result;
    }
    
}

易错点：SQL语句的“（）”、“，”等所有字符必须是英文格式下的，否则会报错，此处应注意！！！

<span style="font-family:Arial, Helvetica, sans-serif;"><span style="white-space: normal;">
</span></span>

yayun0516

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
SQL表中新增数

.aspx代码如下：姓名：语文：数学：物理：化学：英语： <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataSourceID="S
复制链接

扫一扫