一
1
<div>
<div>
<%# projectName %>
<br />
<br />
<%= DateTime.Now %>
</div>
<br />
<div>
</div>
<asp:TextBox ID="bindTest" runat="server" Text="<%$ AppSettings:test %>" />
<br />
<br />
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False">
<Columns>
<asp:TemplateField>
<HeaderTemplate>
<asp:Label runat="server" Text="姓名:" />
</HeaderTemplate>
<ItemTemplate>
<%#Eval("Name") %>
<br />
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField>
<HeaderTemplate>
<asp:Label runat="server" Text="性别:"></asp:Label>
</HeaderTemplate>
<ItemTemplate>
<%#Eval("Sex") %>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField>
<HeaderTemplate>
<asp:Label runat="server" Text="年龄:"></asp:Label>
</HeaderTemplate>
<ItemTemplate>
<%#Eval("Age") %>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
</div>
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
namespace WebApplication1
{
public partial class Default : System.Web.UI.Page
{
public string projectName;
protected void Page_Load(object sender, EventArgs e)
{
ini_table();
projectName = "单值绑定";
Page.DataBind();
}
void ini_table()
{
DataTable dataTable = new DataTable();
//用于显示的Name列
dataTable.Columns.Add("Name");
dataTable.Columns.Add("Sex");
dataTable.Columns.Add("Age");
DataRow dataRow = dataTable.NewRow();
dataRow[0] = "周周";
dataRow[1] = "男";
dataRow[2] = 23;
dataTable.Rows.Add(dataRow);
dataRow = dataTable.NewRow();
dataRow[0] = "芳芳";
dataRow[1] = "女";
dataRow[2] = 22;
dataTable.Rows.Add(dataRow);
//数据源绑定
this.GridView1.DataSource = dataTable.DefaultView;
this.GridView1.DataBind();
}
}
}
2
<div>
<table>
<tr>
<td align="Top" colspan="2">
<asp:Label ID="Label1" runat="server" Text="新上架的水果:" />
</td>
</tr>
<tr>
<td>
<asp:ListBox ID="ListBox1" runat="server" />
</td>
</tr>
</table>
</div>
ArrayList arrayList = new ArrayList();
arrayList.Add("香蕉");
arrayList.Add("苹果");
arrayList.Add("橘子");
this.ListBox1.DataSource = arrayList;
this.ListBox1.DataBind()
List<string> list = new List<string>();
list.Add("香蕉");
list.Add("苹果");
list.Add("橘子");
this.ListBox1.DataSource = list;
this.ListBox1.DataBind();
Dictionary<int, string> fruit = new Dictionary<int, string>();
fruit.Add(1, "香蕉");
fruit.Add(2, "苹果");
fruit.Add(3, "橘子");
this.ListBox1.DataSource = fruit;
this.ListBox1.DataTextField = "Value";
this.DataBind();
3
<connectionStrings>
<add name="ConnectionString" connectionString="Data Source=XXXXXX;Initial Catalog=XXXXXX;Integrated Security=True"/>
</connectionStrings>
<div>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ConnectionStrings:ConnectionString %>"
ProviderName="System.Data.SqlClient" DataSourceMode="DataReader" SelectCommand="select * from Advertisements">
</asp:SqlDataSource>
<table>
<tr>
<td align="Top" colspan="2">
<asp:Label ID="Label1" runat="server" Text="广告:" />
</td>
</tr>
<tr>
<td>
<asp:ListBox ID="ListBox1" runat="server" DataSourceID="SqlDataSource1" AutoPostBack="true"
DataTextField="AlternateText" DataValueField="ID" Width="200px" Height="200px">
</asp:ListBox>
</td>
</tr>
</table>
</div>
<div>
请选择:
<asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="true">
<asp:ListItem>冰山</asp:ListItem>
<asp:ListItem>荷塘</asp:ListItem>
<asp:ListItem>落日</asp:ListItem>
</asp:DropDownList>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ConnectionStrings:ConnectionString %>"
ProviderName="System.Data.SqlClient" DataSourceMode="DataReader" SelectCommand="select * from Advertisements where AlternateText=@text">
<SelectParameters>
<asp:ControlParameter Name="text" ControlID="DropDownList1" PropertyName="SelectedValue" />
</SelectParameters>
</asp:SqlDataSource>
<br />
<asp:Label Text="导航链接:" runat="server" />
<br />
<asp:ListBox ID="ListBox1" runat="server" DataSourceID="SqlDataSource1" AutoPostBack="true"
DataTextField="NavigateUrl" DataValueField="ID" Width="200px" Height="200px">
</asp:ListBox>
</div>
<div>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ConnectionStrings:ConnectionString %>"
ProviderName="System.Data.SqlClient" DataSourceMode="DataReader" SelectCommand="select AlternateText,ID from Advertisements">
</asp:SqlDataSource>
<br />
<asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ConnectionStrings:ConnectionString %>"
ProviderName="System.Data.SqlClient" DataSourceMode="DataReader"
SelectCommand="select * from Advertisements where ID=@ID"
InsertCommand="insert into Advertisements(ID,ImageUrl,NavigateUrl,Impressions,AlternateText)
values(@ID,@ImageUrl,@NavigateUrl,@Impressions,@AlternateText); select @ID=scope_Identity()"
UpdateCommand="update Advertisements set ImageUrl=@ImageUrl,NavigateUrl=@NavigateUrl,Impressions=@Impressions,AlternateText=@AlternateText where ID=@ID"
DeleteCommand="delete Advertisements where ID=@ID" OnInserted="SqlDataSource2_Inserted">
<SelectParameters>
<asp:ControlParameter Name="ID" ControlID="DropDownList1" PropertyName="SelectedValue" Type="String" DefaultValue="1" />
</SelectParameters>
<InsertParameters>
<asp:Parameter Name="ImageUrl" Type="String" />
<asp:Parameter Name="NavigateUrl" Type="String" />
<asp:Parameter Name="Impressions" Type="String" />
<asp:Parameter Name="AlternateText" Type="String" />
<asp:Parameter Name="ID" Type="String" DefaultValue="1" />
</InsertParameters>
<UpdateParameters>
<asp:Parameter Name="ImageUrl" Type="String" />
<asp:Parameter Name="NavigateUrl" Type="String" />
<asp:Parameter Name="Impressions" Type="String" />
<asp:Parameter Name="AlternateText" Type="String" />
<asp:Parameter Name="ID" Type="String" DefaultValue="1" />
</UpdateParameters>
<DeleteParameters>
<asp:Parameter Name="ID" Type="String" DefaultValue="1" />
</DeleteParameters>
</asp:SqlDataSource>
<br />
<asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="true" DataSourceID="SqlDataSource1"
DataTextField="AlternateText" DataValueField="ID" OnSelectedIndexChanged="DropDownList1_SelectedIndexChanged">
</asp:DropDownList>
<br />
<asp:DetailsView ID="DetailsView1" runat="server" DataSourceID="SqlDataSource2" AutoGenerateRows ="false"
AutoGenerateInsertButton="true" AutoGenerateEditButton="true" AutoGenerateDeleteButton="true" DataKeyNames="ID"
GridLines="Both" OnItemDeleted="DetailsView1_ItemDeleted" OnItemUpdated="DetailsView1_ItemUpdated">
<HeaderStyle BackColor="Wheat" ForeColor="PaleGoldenrod" />
<RowStyle BackColor="White" />
<AlternatingRowStyle BackColor="Lavender" />
<EditRowStyle BackColor="LavenderBlush" />
<Fields>
<asp:BoundField DataField="ID" HeaderText="广告编号" InsertVisible="false" ReadOnly="true" />
<asp:BoundField DataField="ImageUrl" HeaderText="图片地址" />
<asp:BoundField DataField="NavigateUrl" HeaderText="链接地址" />
<asp:BoundField DataField="Impressions" HeaderText="显示频率" />
<asp:BoundField DataField="AlternateText" HeaderText="广告名称" />
</Fields>
</asp:DetailsView>
</div>
using System;
using System.Collections;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
namespace WebApplication1
{
public partial class Default : System.Web.UI.Page
{
//public string projectName;
protected void Page_Load(object sender, EventArgs e)
{
}
protected void SqlDataSource2_Inserted(object sender, SqlDataSourceStatusEventArgs e)
{
System.Data.Common.DbCommand command = e.Command;
DropDownList1.DataBind();
this.DetailsView1.DataBind();
}
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
this.DetailsView1.DataBind();
}
protected void DetailsView1_ItemDeleted(object sender, DetailsViewDeletedEventArgs e)
{
DropDownList1.DataBind();
}
protected void DetailsView1_ItemUpdated(object sender, DetailsViewUpdatedEventArgs e)
{
this.DropDownList1.DataBind();
DropDownList1.SelectedValue = e.Keys["ID"].ToString();
DetailsView1.DataBind();
}
}
}
转自
https://www.cnblogs.com/spilledlight/p/4869058.html
二
asp.net---几种数据绑定方法
1.使用Eval方法,该方法用于定义单向(只读)绑定
<asp:Lable id="lable1" runat="server" Text='<%#DataBind.Eval(Container.DataItem,"UserName")%>'/>
简化版
<asp:Lable id="lable1" runat="server" Text='<%#Eval("UserName")%>'/>
2.使用Bind方法,该方法用于定义双向(可更新)绑定
<asp:Lable id="lable1" runat="server" Text='<%#Bind("UserName")%>'/>
3.数据绑定表达式,<%#数据绑定表达式%>,数据绑定表达式可以是一个变量,也可以是一个带返回值的c#方法,例如:
<li>
<span><%#getName()%></span><!--getName()为一个后台有返回值的方法-->
</li>
<li>
<span><%#UserNake%></span><!--UserName为后台一个公有或受保护的变量-->
</li>
提示:上诉<%#%>数据绑定方法用于服务器控件,必须通过DataBind()绑定数据源
4.<%=%> 例如:
(1)前端代码:
<span><%=Content%></span>
后端代码:
public string name;
protected void Page_Load(object sender, EventArgs e)
{
Content="this is a demo!"
}
<span><%=Content%></span>等价于<span>this is a demo!</span>
提示:Content必须是公有或者受保护的变量
(2)前段代码:
<span><%=getName()%></span>
后端代码:
protected getName()
{
return "This is a demo";
}
<span><%=getName()%></span>等价于<span>this is a demo!</span>
转自
https://blog.csdn.net/qq_41226029/article/details/81065720
三
前台:
<ul>
<asp:Repeater ID="Repeater1" runat="server">
<ItemTemplate>
<li><%#Eval("字段")%></li>
</ItemTemplate>
</asp:Repeater>
</ul>
后台:
this.Repeater1.DataSource = 数据源;
this.Repeater1.DataBind();
四
ul中的li动态获取后台数据$.each()的使用方式
https://blog.csdn.net/m0_37246536/article/details/78611926
my.leftCarRealTimeInformation = function(){
$.ajax({
url: '----------后台给的数据地址------------',
type: 'post', //获取数据方式:post/get
async: false, //加载方式默认异步,true为同步
dataType:'json', //数据格式
success:function(data){
var carNewsList = "";
$.each(data,function(i,item){ //遍历ul中的li
carNewsList += "<li style='font-size:14px;color:#5d5d5d;'>"+item.columnName+"</li>";
});
$('#leftCarInformationList').html(carNewsList); //数据在<ul id="leftCarInformationList"></ul>里面显示
},
error: function(obj){
alert("return error:"+obj);
},
});
};