打印本文 打印本文 关闭窗口 关闭窗口
(ASP.NET)修改和删除DataGrid行——数据库访问
作者:武汉SEO闵涛  文章来源:敏韬网  点击数5235  更新时间:2009/4/23 10:47:11  文章录入:mintao  责任编辑:mintao

(ASP.NET)修改和删除DataGrid行——数据库访问

 

       本程序涉及到数据库的添加,修改和删除操作。

 

       懒得写了,把界面贴出来,照着界面画就可以了。本例数据库:SqlServer2000附带的pubs数据库,看一下连接字符串就很清楚了。如果要在本机器上运行,把uid和pwd改成你自己SQL登陆用户名和密码。

 

       创建一个WEB页面,命名为:Add.aspx。

       界面设计如图:

 

       Add.aspx代码:

<%@ Page language="c#" Codebehind="Add.aspx.cs" AutoEventWireup="false" Inherits="TeachShow.Charpter7.AccessDataBase.Add" %>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >

<HTML>

       <HEAD>

              <title>Add</title>

              <LINK href="../../Style.css" type="text/css" rel="stylesheet">

              <meta content="Microsoft Visual Studio .NET 7.1" name="GENERATOR">

              <meta content="C#" name="CODE_LANGUAGE">

              <meta content="JavaScript" name="vs_defaultClientScript">

              <meta content="http://schemas.microsoft.com/intellisense/ie5" name="vs_targetSchema">

       </HEAD>

       <body MS_POSITIONING="GridLayout">

              <form id="Form1" method="post" runat="server">

                     <div align="center">

                            <center>

                                   <table class="smallBlack" height="318" cellSpacing="0" cellPadding="0" width="429" border="0">

                                          <tr>

                                                 <td class="title" vAlign="top" width="429" colSpan="2" height="31">添加一个新的发行者</td>

                                          </tr>

                                          <tr>

                                                 <td vAlign="top" width="79" height="23">发行者ID:</td>

                                                 <td vAlign="top" width="350" height="23"><asp:textbox id="TextBox1" runat="server" Height="18px" CssClass="smallRed"></asp:textbox><FONT face="宋体">(以99打头,共4位数字)</FONT></td>

                                          </tr>

                                          <tr>

                                                 <td vAlign="top" width="79" height="23"><FONT face="宋体">姓名:</FONT></td>

                                                 <td vAlign="top" width="350" height="23"><asp:textbox id="TextBox2" runat="server" Height="18px" CssClass="smallRed"></asp:textbox></td>

                                          </tr>

                                          <tr>

                                                 <td vAlign="top" width="79" height="23"><FONT face="宋体">城市:</FONT></td>

                         &nbs

[1] [2] [3] [4] [5] [6] [7] [8]  下一页

打印本文 打印本文 关闭窗口 关闭窗口