简单数据库的调用

最新推荐文章于 2021-02-03 04:59:17 发布

yhh345814509

最新推荐文章于 2021-02-03 04:59:17 发布

阅读量403

点赞数

CC 4.0 BY-SA版权

文章标签：数据库 datagrid dataset server asp xhtml

本文链接：https://blog.youkuaiyun.com/yhh345814509/article/details/6971834

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="WebApplication71._Default" %>

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;

namespace WebApplication71
{
    public partial class _Default : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            string strconnection = "server=.;database=class;integrated security=true;";
            SqlConnection objconnection = new SqlConnection(strconnection);
            string sqlstr = "SELECT * FROM student WHERE number<5 order by number";
            SqlDataAdapter objadapter = new SqlDataAdapter(sqlstr ,objconnection );

            DataSet objdataset = new DataSet();
            objadapter.Fill(objdataset );
            objconnection.Close();
            dgclass.DataSource = objdataset;
            dgclass.DataBind();

        }
        protected void chkchanged(object sender, EventArgs e)
        {
            dgclass.Columns[1].Visible = chk1.Checked;

        }
    }
}