程序博客网 > 网络监控软件手机版下载

简单数据库的调用

来源：互联网发布：网络监控软件手机版下载编辑：程序博客网时间：2024/05/22 06:07

<%@ 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">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:CheckBox ID="chk1" runat="server" AutoPostBack ="true" Text ="学生基本信息调查表" OnCheckedChanged ="chkchanged" />
        <asp:DataGrid ID ="dgclass" runat ="server" AutoGenerateColumns ="false" >
         <Columns >
         <asp:BoundColumn DataField ="number" HeaderText ="学生学号" DataFormatString ="#{0:N0}" />
         <asp:BoundColumn DataField ="phone" HeaderText ="学生电话" Visible ="false" />
         <asp:BoundColumn DataField ="age" HeaderText ="学生年龄" DataFormatString ="{0:N0}" />

         </Columns>
        </asp:DataGrid>

    </div>
    </form>
</body>
</html>

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;

        }
    }
}

网络监控软件手机版下载

网络监控软件手机版下载

原创粉丝点击

热门问题 老师的惩罚人脸识别我在镇武司摸鱼那些年重生之率土为王我在大康的咸鱼生活盘龙之生命进化天生仙种凡人之先天五行春回大明朝姑娘不必设防，我是瞎子命带三奇的人多吗三奇贵人查法三奇贵人女命带三奇三奇贵人多久出现一次三奈三奈的功效与作用砂姜三奈图片沙姜三奈香料图片山里相公宠田妻三奈三好三好学生哪三好三好学生萝莉三好萝莉有三好三好亚矢影后有三好刘三好三好两恶三好二怯三好杏依三好康子三好沙耶香三好差生三好街网上三好街沈阳三好街三好男人是哪三好三好咀嚼片区三好科目三好难为啥只练3天三好学生主要事迹三好学生申请书三好学生申请理由大学三好学生申请书大学三好学生主要事迹三好学生申请三好学生个人总结大学申请三好学生理由200字