ASP.NET数据绑定_第四篇_用SqlDataSource控件绑定_01
+++ 页面代码如下:
<asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True"
AutoGenerateColumns="False" DataKeyNames="username" DataSourceID="SqlDataSource1"
PageSize="3">
<Columns>
<asp:BoundField DataField="username" HeaderText="用户名" SortExpression="username" ReadOnly="true" />
<asp:BoundField DataField="userpwd" HeaderText="密码" SortExpression="userpwd" />
<asp:CommandField ShowEditButton="True"/>
<asp:CommandField ShowDeleteButton="True"/>
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="Data Source=ora9;User ID=scott;Password=tiger;Persist Security Info=True"
ProviderName="System.Data.OracleClient"
SelectCommand="SELECT USERNAME, USERPWD from USERS"
UpdateCommand="UPDATE USERS SET USERPWD =:userpwd where USERNAME = :username"
DeleteCommand="DELETE from USERS where USERNAME =:username">
<UpdateParameters>
<asp:ControlParameter ControlID="GridView1" DefaultValue="username" Name="username"
PropertyName="SelectedValue" />
<asp:ControlParameter ControlID="GridView1" DefaultValue="userpwd" Name="userpwd"
PropertyName="SelectedValue" />
</UpdateParameters>
<DeleteParameters>
<asp:ControlParameter ControlID="GridView1" Default
相关文档:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.OleDb; //导入命名空间
using System.IO;
using Excel = Microsoft.Office.Interop.Excel;
using System.Reflection;
using System.Data;
usi ......
'<%#Eval("djid").ToString()+Eval("djid1").ToString()+… %>'这种形式就行
把Eval("").ToString()当成一个普通字符串,而'<%# %>'保留就行,怎么处理都可以,所有字符串的操作都有效,还可以用静态函数来处理这些字符串。 ......
虽然这个东西很基本,但是自己有时候还是很混乱,所以今天就小小的整理了下,先给大家带来的是页面的跳转问题。
以下是四种 打开新页面的方法.
1. 直接转向新页面,原页面不保留
Response.Redirect("Webform6.aspx?id=1");
2. 直接转向新页面,原页面不保留
nServer.Transfer("Webform6.aspx?id=1",true);
3. 打开 ......
1、aspx
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="TransferMoney.aspx.cs" Inherits="BtmsWebApp.report.TransferMoney" MasterPageFile="~/ReportPage.master" %>
<%@ Register Assembly="Microsoft.ReportViewer.WebForms, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d5 ......
+++ 页面代码如下:
<asp:GridView ID="GridView1" runat="server" DataSourceID="ObjectDataSource1"
AutoGenerateColumns="true" DataKeyNames="EMPNO">
</asp:GridView>
<asp:ObjectDataSource ID="ObjectDataSource1" runat="server" SelectMethod="GetEmp" TypeName="O ......