62,046
社区成员
发帖
与我相关
我的任务
分享.NET asp网页GridView问题
我的意思是怎么能直接显示出数据来.
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataSourceID="SqlDataSource1" AllowPaging="True" BackColor="#DEBA84" BorderColor="#DEBA84" BorderStyle="None" BorderWidth="1px" CellPadding="3" CellSpacing="2" Width="95%" PageSize="12">
<Columns>
<asp:BoundField DataField="BrandID" HeaderText="品牌" SortExpression="BrandID" />
<asp:BoundField DataField="Technology" HeaderText="技术" SortExpression="Technology" />
<asp:BoundField DataField="Price" HeaderText="价格" SortExpression="Price" />
<asp:BoundField DataField="Model" HeaderText="型号" SortExpression="Model" />
<asp:BoundField DataField="Zoom" HeaderText="焦距" SortExpression="Zoom" />
<asp:BoundField DataField="Contrast" HeaderText="对比度" SortExpression="Contrast" />
<asp:BoundField DataField="Tmarket" HeaderText="上市时间" SortExpression="Tmarket" />
<asp:BoundField DataField="ProjectorType" HeaderText="配件类型" SortExpression="ProjectorType" />
<asp:BoundField DataField="Brightness" HeaderText="亮度" SortExpression="Brightness" />
<asp:BoundField DataField="Screen" HeaderText="屏幕比例" SortExpression="Screen" />
</Columns>
<FooterStyle BackColor="#F7DFB5" ForeColor="#8C4510" />
<HeaderStyle BackColor="#A55129" Font-Bold="True" ForeColor="White" />
<PagerStyle ForeColor="#8C4510" HorizontalAlign="Center" />
<RowStyle BackColor="#FFF7E7" ForeColor="#8C4510" />
<SelectedRowStyle BackColor="#738A9C" Font-Bold="True" ForeColor="White" />
<SortedAscendingCellStyle BackColor="#FFF1D4" />
<SortedAscendingHeaderStyle BackColor="#B95C30" />
<SortedDescendingCellStyle BackColor="#F1E5CE" />
<SortedDescendingHeaderStyle BackColor="#93451F" />
</asp:GridView>
...全文
请发表友善的回复…
发表回复
静控 2014-03-19
- 打赏
- 举报
请问头像控件。。在后台findcontro之后。。怎么做[/quote]
在gridview中点击右上的那个箭头，在添加新列中有选择字段类型，选imagefield
0718的记忆 2014-03-17
- 打赏
- 举报
请问头像控件。。在后台findcontro之后。。怎么做
静控 2014-03-15
- 打赏
- 举报
using System;
using System.Collections.Generic;
using System.Web;
using System.Data;
using System.Data.SqlClient;
using System.Web.UI;
using System.Web.UI.WebControls;
public partial class 实验6 : System.Web.UI.Page
{
private void bindtogridview()//这个方法就是绑定数据库中的代码
{
SqlConnection cn = new SqlConnection();
cn.ConnectionString = "data source=.;initial catalog=studentDB;integrated security=sspi";//显示数据要连接数据库
SqlDataAdapter da = new SqlDataAdapter("select * from student", cn);
DataSet ds = new DataSet();
da.Fill(ds);
GridView1.DataSource = ds;
GridView1.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
bindtogridview();
}
}
protected void ddlsex_DataBinding(object sender, EventArgs e)
{
DropDownList ddl1 = (DropDownList)sender;//创建dropdownlist
ddl1.Items.Add(new ListItem("男"));
ddl1.Items.Add(new ListItem("女"));
}
protected void ddlsex_SelectedIndexChanged(object sender, EventArgs e)
{
}
protected void ddlcity_DataBinding(object sender, EventArgs e)
{
DropDownList ddl2 = (DropDownList)sender;
ddl2.Items.Add(new ListItem("唐山"));
ddl2.Items.Add(new ListItem("新疆"));
ddl2.Items.Add(new ListItem("葫芦岛"));
ddl2.Items.Add(new ListItem("鞍山"));
ddl2.Items.Add(new ListItem("丹东"));
ddl2.Items.Add(new ListItem("铁岭"));
ddl2.Items.Add(new ListItem("天津"));
}
protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
{
GridView1.EditIndex = e.NewEditIndex;//选中的一行成为当前的数据索引行
bindtogridview();
}
protected void ddlcity_DataBinding1(object sender, EventArgs e)
{
DropDownList ddl2 = (DropDownList)sender;
ddl2.Items.Add(new ListItem("唐山"));
ddl2.Items.Add(new ListItem("新疆"));
ddl2.Items.Add(new ListItem("葫芦岛"));
ddl2.Items.Add(new ListItem("鞍山"));
ddl2.Items.Add(new ListItem("丹东"));
ddl2.Items.Add(new ListItem("铁岭"));
ddl2.Items.Add(new ListItem("天津"));
}
protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
{
GridView1.EditIndex = -1;//取消编辑
bindtogridview();
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
int index = e.RowIndex;
string id = GridView1.DataKeys[index].Value.ToString();
string name = ((TextBox)GridView1.Rows[index].Cells[1].FindControl("txtname")).Text;
string sex = ((DropDownList)GridView1.Rows[index].Cells[2].FindControl("ddlsex")).SelectedValue;
string city = ((DropDownList)GridView1.Rows[index].Cells[3].FindControl("ddlcity")).SelectedValue;
string sqlstring = "update student set name='" + name + "',sex='" + sex + "',city='" + city + "' where id=" + id;
SqlConnection cn = new SqlConnection();
cn.ConnectionString = "data source=.;initial catalog=studentDB;integrated security=sspi";
cn.Open();
SqlCommand cmd = new SqlCommand(sqlstring, cn);
cmd.ExecuteNonQuery();
GridView1.EditIndex = -1;
bindtogridview();
cn.Close();
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
int index = e.RowIndex;
string id = GridView1.DataKeys[index].Value.ToString();
//string name = ((TextBox)GridView1.Rows[index].Cells[1].FindControl("txtname")).Text;
//string sex = ((DropDownList)GridView1.Rows[index].Cells[2].FindControl("ddlsex")).SelectedValue;
//string city = ((DropDownList)GridView1.Rows[index].Cells[3].FindControl("ddlcity")).SelectedValue;
string sqlstring = "delete from student where id="+id;
SqlConnection cn = new SqlConnection();
cn.ConnectionString = "data source=.;initial catalog=studentDB;integrated security=sspi";
cn.Open();
SqlCommand cmd = new SqlCommand(sqlstring, cn);
cmd.ExecuteNonQuery();
GridView1.EditIndex = -1;
bindtogridview();
cn.Close();
}
protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
GridView1.PageIndex = e.NewPageIndex;
DataBind();
bindtogridview();
}
}
因为数据库没有了显示不了最后结果，至于分页gridview很好分页的，gridview控件的allowpaging属性的值设为true，pagesize在给一个值（就是每页显示多少记录），就能实现
using System.Collections.Generic;
using System.Web;
using System.Data;
using System.Data.SqlClient;
using System.Web.UI;
using System.Web.UI.WebControls;
public partial class 实验6 : System.Web.UI.Page
{
private void bindtogridview()//这个方法就是绑定数据库中的代码
{
SqlConnection cn = new SqlConnection();
cn.ConnectionString = "data source=.;initial catalog=studentDB;integrated security=sspi";//显示数据要连接数据库
SqlDataAdapter da = new SqlDataAdapter("select * from student", cn);
DataSet ds = new DataSet();
da.Fill(ds);
GridView1.DataSource = ds;
GridView1.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
bindtogridview();
}
}
protected void ddlsex_DataBinding(object sender, EventArgs e)
{
DropDownList ddl1 = (DropDownList)sender;//创建dropdownlist
ddl1.Items.Add(new ListItem("男"));
ddl1.Items.Add(new ListItem("女"));
}
protected void ddlsex_SelectedIndexChanged(object sender, EventArgs e)
{
}
protected void ddlcity_DataBinding(object sender, EventArgs e)
{
DropDownList ddl2 = (DropDownList)sender;
ddl2.Items.Add(new ListItem("唐山"));
ddl2.Items.Add(new ListItem("新疆"));
ddl2.Items.Add(new ListItem("葫芦岛"));
ddl2.Items.Add(new ListItem("鞍山"));
ddl2.Items.Add(new ListItem("丹东"));
ddl2.Items.Add(new ListItem("铁岭"));
ddl2.Items.Add(new ListItem("天津"));
}
protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
{
GridView1.EditIndex = e.NewEditIndex;//选中的一行成为当前的数据索引行
bindtogridview();
}
protected void ddlcity_DataBinding1(object sender, EventArgs e)
{
DropDownList ddl2 = (DropDownList)sender;
ddl2.Items.Add(new ListItem("唐山"));
ddl2.Items.Add(new ListItem("新疆"));
ddl2.Items.Add(new ListItem("葫芦岛"));
ddl2.Items.Add(new ListItem("鞍山"));
ddl2.Items.Add(new ListItem("丹东"));
ddl2.Items.Add(new ListItem("铁岭"));
ddl2.Items.Add(new ListItem("天津"));
}
protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
{
GridView1.EditIndex = -1;//取消编辑
bindtogridview();
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
int index = e.RowIndex;
string id = GridView1.DataKeys[index].Value.ToString();
string name = ((TextBox)GridView1.Rows[index].Cells[1].FindControl("txtname")).Text;
string sex = ((DropDownList)GridView1.Rows[index].Cells[2].FindControl("ddlsex")).SelectedValue;
string city = ((DropDownList)GridView1.Rows[index].Cells[3].FindControl("ddlcity")).SelectedValue;
string sqlstring = "update student set name='" + name + "',sex='" + sex + "',city='" + city + "' where id=" + id;
SqlConnection cn = new SqlConnection();
cn.ConnectionString = "data source=.;initial catalog=studentDB;integrated security=sspi";
cn.Open();
SqlCommand cmd = new SqlCommand(sqlstring, cn);
cmd.ExecuteNonQuery();
GridView1.EditIndex = -1;
bindtogridview();
cn.Close();
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
int index = e.RowIndex;
string id = GridView1.DataKeys[index].Value.ToString();
//string name = ((TextBox)GridView1.Rows[index].Cells[1].FindControl("txtname")).Text;
//string sex = ((DropDownList)GridView1.Rows[index].Cells[2].FindControl("ddlsex")).SelectedValue;
//string city = ((DropDownList)GridView1.Rows[index].Cells[3].FindControl("ddlcity")).SelectedValue;
string sqlstring = "delete from student where id="+id;
SqlConnection cn = new SqlConnection();
cn.ConnectionString = "data source=.;initial catalog=studentDB;integrated security=sspi";
cn.Open();
SqlCommand cmd = new SqlCommand(sqlstring, cn);
cmd.ExecuteNonQuery();
GridView1.EditIndex = -1;
bindtogridview();
cn.Close();
}
protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
GridView1.PageIndex = e.NewPageIndex;
DataBind();
bindtogridview();
}
}
因为数据库没有了显示不了最后结果，至于分页gridview很好分页的，gridview控件的allowpaging属性的值设为true，pagesize在给一个值（就是每页显示多少记录），就能实现
走出一条新道路 2014-03-15
- 打赏
- 举报
不说原理都不行，你的数据源在哪儿？你让着GridView去显示什么东西啊？
1asas 2014-03-15
- 打赏
- 举报
怎么能直接显示出数据，如果有人在弄一下分页更好.
我是菜鸟，别说原理直接挂代码.
