...........
MyConnection = new SqlConnection("server=server2k;database=store;User Id=sa;");
MyCommand = new SqlCommand("select top 5 Customers.FirstName,Customers.LastName,Customers.urll from Customers inner join CustMoreDetail on Customers.CustomerID=CustMoreDetail.CustomerID Order by Customers.CreateTime Desc", MyConnection);
MyConnection.Open();
webDataGrid.DataSource = MyCommand.ExecuteReader(CommandBehavior.CloseConnection);
webDataGrid.DataBind();...........注意,上句已经查询出Customers的FirstName和LastName现在我要做的效果是在DataGrid中出现这样的效果FirstName LastName就是
1.
FirstName LastName连在一起
2.
FirstName LastName间有个空格3.
FirstName LastName加链接值为url那个值
string FirstName = "a"
string LastName = "b";
e.Item.Cells[6].Text= FirstName+" "+LastName;
超连接在外面套一个就行了~
或者你在grid的DataBound中作处理
if(e.Item.ItemType!=ListItemType.Header)
{
e.Item.Cells[0].Text="<a href='Jingzheng_CustTongji1.aspx?Area_Zone="+e.Item.Cells[0].Text+"&tongji_date="+this.TextResultDate.Text+"'>"+e.Item.Cells[0].Text +"</a>";
}
<ItemTemplate>
<%#DataBinder.Eval(Container.DataItem,"FirtName"%>
<%#DataBinder.Eval(Container.DataItem,"ListName"%>
</ItemTemplet>
替换掉你以前用来显示FirstName与LastName的两列
<ItemTemplate>
<a href="<%#<%#DataBinder.Eval(Container.DataItem,"urll"%>%>" target="_blank">
<%#DataBinder.Eval(Container.DataItem,"FirtName"%>
<%#DataBinder.Eval(Container.DataItem,"ListName"%>
</a>
</ItemTemplet>
<ItemTemplate>
<asp;LinkButton Url="<%#<%#DataBinder.Eval(Container.DataItem,"urll"%>%>" Text="
<%#DataBinder.Eval(Container.DataItem,"FirtName"%>
<%#DataBinder.Eval(Container.DataItem,"ListName"%>">
</asp:LinkButton>试试
<ItemTemplate>