C#语言和sql的部分应用

最新推荐文章于 2024-09-27 21:41:13 发布

yyxzzWT

最新推荐文章于 2024-09-27 21:41:13 发布

阅读量222

点赞数

分类专栏： C# 文章标签： sql

本文链接：https://blog.csdn.net/weixin_55801010/article/details/114496069

版权

C# 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

文章目录

- 1.选课部分的代码

1.选课部分的代码

代码如下：

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 Default3 : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {
        string ~serial_no = GridView1.DataKeys[e.RowIndex].Value.ToString();
        string ~student_id = ((TextBox)(GridView1.Rows[e.RowIndex].Cells[1].Controls[0])).Text.ToString();
        string ~course_id = ((TextBox)(GridView1.Rows[e.RowIndex].Cells[2].Controls[0])).Text.ToString();
        string ~course_name = ((TextBox)(GridView1.Rows[e.RowIndex].Cells[3].Controls[0])).Text.ToString();
        string sqlStr = "update ~course_select set student_id='" + student_id + "',course_id=" + course_id + " , course_name ='" + course_name + "', select_time = Getdate() where serial_no= " + serial_no;

        String str = "Server=【~命令提示符IP：config10.0.121.34】,1433;User Id=sa;Pwd=123;DataBase=【学生】";
        SqlConnection conn = new SqlConnection(str);
        conn.Open();
        SqlCommand cmd = new SqlCommand(sqlStr, conn);
        SqlDataSource1.UpdateCommand = sqlStr;
        int num = cmd.ExecuteNonQuery();
        cmd.Dispose();
        conn.Close();
        GridView1.EditIndex = -1;
        GridView1.DataBind();
    }
}