在ASP.NET中,进行数据库的查询,添加,删除,修改操作
在网页中使用GridView进行数据库表单的显示,以及基本的数据库操作,SqlCommand和SqlDataAdapter
查询功能,插入数据功能:(在Textbox中输入内容,点击按钮执行查询插入功能)
webForm源码
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm1.aspx.cs" Inherits="ADOTest.WebForm1" %>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
<title></title>
<style type="text/css">
#Password {
width: 100px;
}
#Password_confirm {
width: 100px;
}
</style>
</head>
<body>
<form style="text-align:center" id="form1" runat="server">
<div style="text-align:center; font-size: large; color: #000000;">
<div style="text-align:center" >
用户名查询
<asp:TextBox ID="TextBoxSelect" runat="server"></asp:TextBox>
<asp:Button ID="Btn_select" runat="server" OnClick="Btn_select_Click" Text="查询" />
</div>
<hr />
<asp:GridView ID="GridView2" runat="server" AutoGenerateDeleteButton="True" AutoGenerateEditButton="True" OnRowCancelingEdit="GridView2_RowCancelingEdit" OnRowDeleting="GridView2_RowDeleting" OnRowEditing="GridView2_RowEditing" OnRowUpdating="GridView2_RowUpdating" CellPadding="8" CellSpacing="4" ForeColor="#333333" HorizontalAlign</