怎么在ASP.NET(C#)里用控件TextBox与GridView做简单查询()
admin
2023-07-14 09:14:27

相机,
gridview本身的功能都可以做到,一行代码都不用写,好好看看gridview怎么用吧
给你页面代码
种类:asp:DropDownList ID=DropDownList1
runat=server AutoPostBack=True
asp:ListItem Value=0信息速递/asp:ListItem
asp:ListItem Value=1各界评论/asp:ListItem
/asp:DropDownList
asp:GridView ID=GridView1 runat=server AllowPaging=True AutoGenerateColumns=False
BackColor=White BorderColor=#999999 BorderStyle=None BorderWidth=1px
CellPadding=3 DataKeyNames=H_ID DataSourceID=AccessDataSource1 GridLines=Vertical
ShowHeader=False Width=95% OnRowCommand=GridView1_RowCommand
FooterStyle BackColor=#CCCCCC ForeColor=Black /
Columns
asp:BoundField DataField=H_Time SortExpression=H_Time
ItemStyle Width=20% /
/asp:BoundField
asp:BoundField DataField=H_Title HeaderText=H_Title SortExpression=H_Title
ItemStyle Width=65% /
/asp:BoundField
asp:TemplateField
ItemStyle Width=15% /
ItemTemplate
asp:HyperLink ID=HyperLink1 runat=server NavigateUrl='%# edit.aspx?id= + Eval(H_ID) %'
Text=编辑/asp:HyperLink
asp:LinkButton ID=LinkButton1 runat=server CommandName=del CommandArgument='%#Eval(H_ID) %'删除/asp:LinkButton
/ItemTemplate
/asp:TemplateField
/Columns
RowStyle BackColor=#EEEEEE ForeColor=Black /
SelectedRowStyle BackColor=#008A8C Font-Bold=True ForeColor=White /
PagerStyle BackColor=#999999 ForeColor=Black HorizontalAlign=Center /
HeaderStyle BackColor=#000084 Font-Bold=True ForeColor=White /
AlternatingRowStyle BackColor=Gainsboro /
/asp:GridView
asp:AccessDataSource ID=AccessDataSource1 runat=server DataFile=~/App_Data/db1.mdb
SelectCommand=SELECT * FROM [article] WHERE ([H_type] = ?)
SelectParameters
asp:ControlParameter ControlID=DropDownList1 DefaultValue=0 Name=H_type PropertyName=SelectedValue
Type=Byte /
/SelectParameters
/asp:AccessDataSource 将如下代码拷贝到页面中的head中~:
script language=javascript
function onMouseOver(Button)
{
button.sytle.backgroundColor='red';
}
function onMouseOut(button)
{
button.sytle.backgroundColor='';
}
/script

将如下代码拷贝到body中:
input type=button id=btnTest1 runat=server onmouseover=onMouseOver(this) onmouseout=onMouseOut(this) value=click me /
asp:Button ID=btnTest2 runat=server Text=click me onmouseover=onMouseOver(this) onmouseout=onMouseOut(this) /

再运行一下,你就可以看到效果了!

告一段落~谢谢~ 我做的是弹出一个Panel,数据用的是DataList控件绑定的
界面代码
div style=height: 345px
asp:TextBox ID=TextBox1 runat=server/asp:TextBox

asp:Button ID=Button1 runat=server onclick=Button1_Click Text=Button /
asp:Panel ID=Panel1 runat=server Height=271px Visible=False
asp:DataList ID=DataList1 runat=server DataKeyField=EmployeeJobID
DataSourceID=SqlDataSource1
RepeatColumns=5
RepeatDirection=Horizontal Width=460px
ItemTemplatea style= text-decoration:none; color:Black href=Default.aspx?id=%# Eval(EmployeeJobName) %
EmployeeJobID:
asp:Label ID=EmployeeJobIDLabel runat=server
Text='%# Eval(EmployeeJobID) %' /
br /
EmployeeJobName:
asp:Label ID=EmployeeJobNameLabel runat=server
Text='%# Eval(EmployeeJobName) %' /
br /
EmployeeDepartmentID:
asp:Label ID=EmployeeDepartmentIDLabel runat=server
Text='%# Eval(EmployeeDepartmentID) %' /
br /
BasePay:
asp:Label ID=BasePayLabel runat=server Text='%# Eval(BasePay) %' /
br /
Buzhu:
asp:Label ID=BuzhuLabel runat=server Text='%# Eval(Buzhu) %' /
br /
br //a
/ItemTemplate
/asp:DataList
//新建数据源,绑定数据
asp:SqlDataSource ID=SqlDataSource1 runat=server
ConnectionString=%$ ConnectionStrings:酒店管理数据库ConnectionString %
SelectCommand=SELECT * FROM [Job]/asp:SqlDataSource
/asp:Panel
/div
后台代码
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString.Count != 0)
{
if (Request.QueryString[id].ToString() != )
{
TextBox1.Text = Request.QueryString[id].ToString();
}
}
}

protected void Button1_Click(object sender, EventArgs e)
{
Panel1.Visible = true;
}
数据要根据自己情况进行绑定,可以实现的,希望对你有用

相关内容

热门资讯

张梅汇空中瑜伽教师培训系列课 ... 本文给大家分享一套张梅汇空中瑜伽教师培训系列课 一级和二级 8节课资源课程视频,希望可以帮助有需要的...
三周吃瘦12斤,拥有易瘦好体质 本文给大家分享一套三周吃瘦12斤,拥有易瘦好体质资源课程视频,希望可以帮助有需要的同学 最...