datalist的问题，大家帮帮我！！！

1、select * from可以选出全部字段
2、datagrid允许自动创建列（拖建时默认的属性，不要修改）
3、绑定

这个和动态创建控件有关系的！！！<br>
当前状态：
<asp:Label id="Label2" CssClass=TextEx runat=server Text='<%# DataBinder.Eval(Container.DataItem, "RunStatus") %>'>
</asp:Label>
<br>意思就是要把这句话写成后代码，前提是我不知道有哪些字段包括名称类型和大小请大家帮我一把。

其实不难
你用select 这样的语句选出来的字段名称是什么就是什么
假如  select UserName from users
说明字段就是UserName
然后把datalist得datasource 设置一下  再邦定一下子
最后再 html里面写
'<%# DataBinder.Eval(Container.DataItem, "UserName") %>'
你在上面有个错误  你没有理解Container是什么，假如你用 datalist的话
它就是指 Datalist      ,上面你用了个Label当然什么也不会产生了
不要太急  首先要学习一下 datalist这个控件，你要知道<%#... %>这句话写在哪儿才会出现效果不是随便写在哪儿  都行的

请进入 www.wrox.com看看实在不会
把你的 E-Mail留下

shenyisyn(魔法师)：我说的是如果RunStatus我知道，那么直接用html写成静态的是可以的，再举个例子，假如我有个A表存放字段的名称m1、类型m2、大小m3，并且有字段的中文名称m4
然后依据这个表的内容我创建了一个B表，我怎么才能够根据这个A表提供的数据，将B表和datalist绑定生成下面的情况m4字段1 : 文本控件（B表字段1中的对应字段值）
m4字段2 : 文本控件（B表字段2中的对应字段值）
m4字段3 : 文本控件（B表字段3中的对应字段值）m4字段1 : 文本控件（B表字段1中的对应字段值）
m4字段2 : 文本控件（B表字段2中的对应字段值）
m4字段3 : 文本控件（B表字段3中的对应字段值）不知道我描述清楚没有，请指点

给你一份我写的datalist分页的代码把
aspx:
<%@ Page Language="vb" AutoEventWireup="false" Codebehind="WebForm2.aspx.vb" Inherits="ls1.WebForm2"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<title>文件下载</title>
<meta content="Microsoft Visual Studio .NET 7.1" name="GENERATOR">
<meta content="Visual Basic .NET 7.1" name="CODE_LANGUAGE">
<meta content="JavaScript" name="vs_defaultClientScript">
<meta content="http://schemas.microsoft.com/intellisense/ie5" name="vs_targetSchema">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<LINK href="css/type.css" type="text/css" rel="stylesheet">
<script language="javascript">

</script>
</HEAD>
<body leftMargin="0" topMargin="0" marginwidth="0" marginheight="0" MS_POSITIONING="GridLayout">
<form id="Form1" method="post" runat="server">
<table cellSpacing="0" cellPadding="0" width="778" bgColor="#708090" border="0">
<tr>
<td vAlign="top" width="15" height="540">
<table cellSpacing="0" cellPadding="0" width="100%" border="0">
<tr>
<td width="15" height="540"> </td>
</tr>
</table>
</td>
<td vAlign="top" width="748">
<table width="100%" border="0" cellPadding="0" cellSpacing="0" bgcolor="#ffffff">
<tr>
<td vAlign="top" colSpan="2" height="30">
<table cellSpacing="0" cellPadding="0" width="100%" border="0">
<tr>
<td vAlign="middle" align="center" width="750" bgColor="#ffffff" height="30"> </td>
</tr>
</table>
</td>
</tr>
<tr>
<td vAlign="top" colSpan="2" height="20">
<table cellSpacing="0" cellPadding="0" width="100%" border="0">
<tr>
<td vAlign="middle" width="748" bgColor="#efefef" height="20" class="xian">
<asp:label id="Lab_lx" runat="server" Font-Size="12px"></asp:label>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td vAlign="top" width="559" height="440">
<table cellSpacing="0" cellPadding="0" width="100%" bgColor="#ffffff" border="0">
<tr>
<td width="559" height="28" align="left" vAlign="middle">    当前位置：
<asp:label id="Lab_dh" runat="server" Font-Size="12px"></asp:label></td>
</tr>
<tr>
<td height="398" vAlign="top">
<table cellSpacing="0" cellPadding="0" width="100%" border="0">
<tr>
<td width="14" height="398"> </td>
<td width="531" vAlign="top">
<table cellSpacing="0" cellPadding="0" width="100%" border="0">
<tr>
<td class="TdBorderRB" vAlign="middle" align="left" width="474" bgColor="#efefef" height="20">◇最新更新◇</td>
<td class="TdBorderRB" vAlign="middle" align="right" width="57" bgColor="#efefef"> <A href="index_more.aspx"><font size="3"></font></A></td>
</tr>
<tr>
<td colSpan="2" height="12"></td>
</tr>
<tr>
<td height="366" colSpan="2" vAlign="top" align="center">
<asp:DataList id="My_List" runat="server" Width="530px">
<ItemTemplate>
<TABLE id="Table1" cellSpacing="0" cellPadding="0" width="530px">
<TR>
<TD colspan="4" height="22" width="354" class="TdBorder1" align="left" valign="middle">
     <a href="wjxz.aspx" onclick="return pop(this,href)">
<%# DataBinder.Eval(Container.DataItem,"T_Str_Scmc","{0:d}")%>
</a>
</TD>
<TD width="88" class="TdBorder1" align="center" valign="middle">更新时间</TD>
<TD width="88" class="TdBorder3" align="center" valign="middle">
<%# DataBinder.Eval(Container.DataItem,"T_Dat_Scsj","{0:d}")%>
</TD>
</TR>
<TR>
<TD height="22" class="TdBorder2" align="center" valign="middle" width="90">软件类型</TD>
<TD class="TdBorder2" align="center" valign="middle" width="88">
<%# DataBinder.Eval(Container.DataItem,"T_Str_Lxmc","{0:d}")%>
</TD>
<TD class="TdBorder2" align="center" valign="middle" width="88">软件子类型</TD>
<TD class="TdBorder2" align="center" valign="middle" width="88">
<%# DataBinder.Eval(Container.DataItem,"T_Str_Zlxmc","{0:d}")%>
</TD>
<TD class="TdBorder2" align="center" valign="middle" width="88">软件大小</TD>
<TD class="TdBorder4" align="center" valign="middle" width="88">
<%# DataBinder.Eval(Container.DataItem,"T_Str_Scdx","{0:d}")%>
</TD>
</TR>
</TABLE>
<table cellSpacing="0" cellPadding="0" width="100%" border="0">
<tr>
<td height="17px"><hr color="#708090" class="hrborder">
</td>
</tr>
</table>
</ItemTemplate>
</asp:DataList>
<asp:label id="Lab_jls" runat="server" Font-Size="12px"></asp:label>┊
<asp:linkbutton id="FirstPage" runat="server">首页</asp:linkbutton>┊
<asp:linkbutton id="PreviousPage" runat="server">上一页</asp:linkbutton>┊
<asp:linkbutton id="NextPage" runat="server">下一页</asp:linkbutton>┊
<asp:linkbutton id="LastPage" runat="server">尾页</asp:linkbutton>┊
<asp:label id="Lab_ys" runat="server" Font-Size="12px"></asp:label>┊
<asp:label id="Label1" runat="server" Font-Size="12px">转到</asp:label>
<asp:DropDownList id="Drop_ye" runat="server" AutoPostBack="True"></asp:DropDownList>
<asp:label id="Label2" runat="server" Font-Size="12px">页</asp:label>
</td>
</tr>
</table>
</td>
<td width="14"> </td>
</tr>
</table>
</td>
</tr>
<tr>
<td height="14"></td>
</tr>
</table>
</td>

<td vAlign="top" width="189">
<table cellSpacing="0" cellPadding="0" width="100%" bgColor="#efefef" border="0">
<tr>
<td vAlign="top" width="189" height="220">
<table cellSpacing="0" cellPadding="0" width="100%" border="0">
<tr>
<td vAlign="middle" align="center" width="190" bgColor="#778899" height="20"><font color="#ffffff" size="2">
本周下载 TOP 20</font>
</td>
</tr>
<tr>
<td vAlign="top" align="center" bgColor="#efefef" height="200"><asp:datagrid id="Grid_week" runat="server" AutoGenerateColumns="False" Width="190px" ShowHeader="False"
BorderWidth="0px">
<AlternatingItemStyle Font-Size="12px" Height="20px"></AlternatingItemStyle>
<ItemStyle Font-Size="12px" HorizontalAlign="Left" Height="20px" BorderWidth="0px"></ItemStyle>
<Columns>
<asp:TemplateColumn>
<ItemTemplate>
  · <a href="wjxz.aspx" onclick="return pop(this,href)"><%# DataBinder.Eval(Container.DataItem,"T_Str_Scmc","{0:d}")%>
</a>
</ItemTemplate>
</asp:TemplateColumn>
</Columns>
</asp:datagrid></td>
</tr>
</table>
</td>
</tr>
<tr>
<td vAlign="top" height="220">
<table cellSpacing="0" cellPadding="0" width="100%" bgColor="#efefef" border="0">
<tr>
<td vAlign="middle" align="center" width="189" bgColor="#778899" height="20"><font color="#ffffff" size="2">总下载
TOP 20</font></td>
</tr>
<tr>
<td vAlign="top" align="center" bgColor="#efefef" height="200">
<asp:datagrid id="Grid_count" runat="server" AutoGenerateColumns="False" Width="190px" ShowHeader="False"
BorderWidth="0px">
<AlternatingItemStyle Font-Size="12px" Height="20px"></AlternatingItemStyle>
<ItemStyle Font-Size="12px" Height="20px"></ItemStyle>
<Columns>
<asp:TemplateColumn>
<ItemTemplate>
  · <a href="wjxz.aspx" onclick="return pop(this,href)">
<%# DataBinder.Eval(Container.DataItem,"T_Str_Scmc","{0:d}")%>
</a>
</ItemTemplate>
</asp:TemplateColumn>
</Columns>
</asp:datagrid></td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
<tr bgColor="#ffffff">
<td class="xian" vAlign="top" colSpan="2" height="20"> </td>
</tr>
<tr bgColor="#ffffff">
<td vAlign="top" colSpan="2" height="30"> </td>
</tr>
</table>
</td>
<td width="1"> </td>
<td vAlign="top" width="14">
<table cellSpacing="0" cellPadding="0" width="100%" border="0">
<tr>
<td width="14" height="540"> </td>
</tr>
</table>
</td>
</tr>
</table>
</form>
</body>
</HTML>vb:
Imports System.Data
Imports System.Data.SqlClient
Public Class WebForm2
    Inherits System.Web.UI.Page#Region " Web 窗体设计器生成的代码 "    '该调用是 Web 窗体设计器所必需的。
    <System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent()    End Sub
    Protected WithEvents Lab_lx As System.Web.UI.WebControls.Label
    Protected WithEvents Lab_dh As System.Web.UI.WebControls.Label
    Protected WithEvents My_List As System.Web.UI.WebControls.DataList
    Protected WithEvents Grid_week As System.Web.UI.WebControls.DataGrid
    Protected WithEvents Grid_count As System.Web.UI.WebControls.DataGrid
    Protected WithEvents Lab_jls As System.Web.UI.WebControls.Label
    Protected WithEvents FirstPage As System.Web.UI.WebControls.LinkButton
    Protected WithEvents PreviousPage As System.Web.UI.WebControls.LinkButton
    Protected WithEvents NextPage As System.Web.UI.WebControls.LinkButton
    Protected WithEvents LastPage As System.Web.UI.WebControls.LinkButton
    Protected WithEvents Lab_ys As System.Web.UI.WebControls.Label
    Protected WithEvents Label1 As System.Web.UI.WebControls.Label
    Protected WithEvents Drop_ye As System.Web.UI.WebControls.DropDownList
    Protected WithEvents Label2 As System.Web.UI.WebControls.Label    '注意: 以下占位符声明是 Web 窗体设计器所必需的。
    '不要删除或移动它。
    Private designerPlaceholderDeclaration As System.Object    Private Sub Page_Init(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Init
        'CODEGEN: 此方法调用是 Web 窗体设计器所必需的
        '不要使用代码编辑器修改它。
        InitializeComponent()
    End Sub#End Region
    Dim nowdsn As String = ConfigurationSettings.AppSettings("dsn")
    Dim MyConnection As SqlConnection = New SqlConnection(nowdsn)
    Const pagesize = 9    Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        '在此处放置初始化页的用户代码        If Not IsPostBack Then
            Dim Str_sql As String = "Select count(*) as id From Tbl_Scgl"
            Dim My_js As SqlCommand = New SqlCommand(Str_sql, MyConnection)
            My_js.Connection = MyConnection
            My_js.Connection.Open()            Dim js As SqlDataReader = My_js.ExecuteReader
            Dim n As Integer = 0
            Dim pagecount As Integer
            If js.Read Then
                n = js.Item("id")
            End If
            My_js.Connection.Close()
            Lab_jls.Text = "共" & n & "条记录"
            viewstate("intcount") = n
            '计算共有几页
            If viewstate("intcount") Mod pagesize = 0 Then
                pagecount = viewstate("intcount") \ pagesize
            Else
                pagecount = viewstate("intcount") \ pagesize + 1
            End If
            '绑定跳转页数据
            Dim i As Integer
            For i = 1 To pagecount
                Dim My_List = New ListItem
                My_List.Text = i
                My_List.Value = i - 1
                Drop_ye.Items.Add(My_List)
            Next
            Lab_ys.Text = "第1/" & pagecount & "页"
            viewstate("pagecount") = pagecount
            viewstate("pageindex") = 0
            list_bind()        End If
    End Sub    Function list_bind()        MyConnection.Open()
        Dim startindex = viewstate("pageindex") * pagesize
        Dim Str_sql As String
        Dim My_js As SqlDataAdapter
        Dim ds As DataSet = New DataSet
        Str_sql = "Select * From Tbl_Scgl Order by T_Dat_Scsj desc"
        My_js = New SqlDataAdapter(Str_sql, MyConnection)
        My_js.Fill(ds, startindex, pagesize, "Zxgx")
        My_List.DataSource = ds.Tables("Zxgx").DefaultView
        My_List.DataBind()
        MyConnection.Close()    End Function

Private Sub NavigationButtonClicked(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles FirstPage.Click, PreviousPage.Click, NextPage.Click, LastPage.Click
        Dim direction As String = CType(sender, LinkButton).Text
        Select Case direction.ToUpper()
            Case "首页"
                viewstate("pageindex") = 0
                FirstPage.Enabled = False
                PreviousPage.Enabled = False
                NextPage.Enabled = True
                LastPage.Enabled = True
            Case "上一页"
                viewstate("pageindex") = Math.Max(0, viewstate("pageindex") - 1)
                NextPage.Enabled = True
                LastPage.Enabled = True
                If viewstate("pageindex") = 0 Then
                    FirstPage.Enabled = False
                    PreviousPage.Enabled = False
                End If
            Case "下一页"
                viewstate("pageindex") = Math.Min(viewstate("pagecount") - 1, viewstate("pageindex") + 1)
                FirstPage.Enabled = True
                PreviousPage.Enabled = True
                If viewstate("pageindex") = viewstate("pagecount") - 1 Then
                    NextPage.Enabled = False
                    LastPage.Enabled = False
                End If
            Case "尾页"
                viewstate("pageindex") = viewstate("pagecount") - 1
                FirstPage.Enabled = True
                PreviousPage.Enabled = True
                NextPage.Enabled = False
                LastPage.Enabled = False
            Case Else
        End Select
        list_bind()
        Lab_ys.Text = "第" & viewstate("pageindex") + 1 & "/" & viewstate("pagecount") & "页"
        Drop_ye.SelectedIndex = viewstate("pageindex")    End Sub    Private Sub Drop_ye_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Drop_ye.SelectedIndexChanged
        viewstate("pageindex") = Drop_ye.SelectedItem.Value
        If viewstate("pageindex") = 0 Then
            FirstPage.Enabled = False
            PreviousPage.Enabled = False
            NextPage.Enabled = True
            LastPage.Enabled = True
        End If
        If viewstate("pageindex") = viewstate("pagecount") - 1 Then
            FirstPage.Enabled = True
            PreviousPage.Enabled = True
            NextPage.Enabled = False
            LastPage.Enabled = False
        End If
        If viewstate("pageindex") > 0 And viewstate("pageindex") < viewstate("pagecount") - 1 Then
            FirstPage.Enabled = True
            PreviousPage.Enabled = True
            NextPage.Enabled = True
            LastPage.Enabled = True
        End If
        '分页选择后数据绑定
        list_bind()
        Lab_ys.Text = "第" & viewstate("pageindex") + 1 & "/" & viewstate("pagecount") & "页"
        Drop_ye.SelectedIndex = viewstate("pageindex")
    End SubEnd Class

to lwgj(大麦町) :
<TD class="TdBorder2" align="center" valign="middle" width="88">软件子类型</TD>
<TD class="TdBorder2" align="center" valign="middle" width="88">
<%# DataBinder.Eval(Container.DataItem,"T_Str_Zlxmc","{0:d}")%></TD>你写的这段代码是静态的，我需要他变成动态的用后代码实现，因为我要取的字段如"T_Str_Zlxmc"是从其他表中取出来的怎么解决？？？

See here:
http://chs.gotdotnet.com/quickstart/aspplus/

这个问题没有人回答？那么我换个问题：答对马上给分请问我要上传多个文件，象163或者sina里的附件上传的方式用c#怎么实现？

<br/>
当前状态：
<asp:Label id="Label2" CssClass=TextEx runat=server Text='<%# DataBinder.Eval(Container.DataItem, "RunStatus") %>'>
</asp:Label>
<br/>意思就是要把这句话写成后代码，前提是我不知道有哪些字段包括名称类型和大小请大家帮我一把。
这个是不能写成后代码的，他只能静态绑定，所以你需要实现的功能是不能达到，不知道你明白没有。上传文件：
<%@ Page Language="vb" AutoEventWireup="false" Codebehind="MultiUpload.aspx.vb"
Inherits="aspxWeb.MultiUpload" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
<HTML>
  <HEAD>
    <title>多文件上传</title>
    <script language="JavaScript">
    function addFile()
    {
     var str = '<INPUT type="file" size="50" NAME="File">'
     document.getElementById('MyFile').insertAdjacentHTML("beforeEnd",str)
    }
    </script>
  </HEAD>
  <body>
    <form id="form1" method="post" runat="server" enctype="multipart/form-data">
      <center>
        <asp:Label Runat="server" ID="MyTitle"></asp:Label>
        <P id="MyFile"><INPUT type="file" size="50" NAME="File"></P>
        <P>
          <input type="button" value="增加(Add)" onclick="addFile()">
          <asp:Button Runat="server" Text="上传" ID="Upload"></asp:Button>
          <input onclick="this.form.reset()" type="button" value="重置(ReSet)">
        </P>
      </center>
      <P align="center">
        <asp:Label id="strStatus" runat="server" Font-Names="宋体" Font-Bold="True"
         Font-Size="9pt" Width="500px" BorderStyle="None" BorderColor="White"></asp:Label>
      </P>
    </form>
  </body>
</HTML>后代码：MultiUpload.aspx.vbPublic Class MultiUpload
    Inherits System.Web.UI.Page
  Protected WithEvents Upload As System.Web.UI.WebControls.Button
  Protected WithEvents MyTitle As System.Web.UI.WebControls.Label
  Protected WithEvents strStatus As System.Web.UI.WebControls.Label
#Region " Web Form Designer Generated Code "
  'This call is required by the Web Form Designer.
  <System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent()
  End Sub
  Private Sub Page_Init(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Init
    'CODEGEN: This method call is required by the Web Form Designer
    'Do not modify it using the code editor.
    InitializeComponent()
  End Sub
#End Region
  Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
    MyTitle.Text = "<h3>多文件上传</h3>"
    Upload.Text = "开始上传"
    If (Me.IsPostBack) Then Me.SaveImages()
  End Sub
  Private Function SaveImages() As System.Boolean
    '遍历File表单元素
    Dim files As System.Web.HttpFileCollection = System.Web.HttpContext.Current.Request.Files
    '状态信息
    Dim strMsg As New System.Text.StringBuilder("上传的文件分别是：<hr color=red>")
    Dim iFile As System.Int32
    Try
      For iFile = 0 To files.Count - 1
        '检查文件扩展名字
        Dim postedFile As System.Web.HttpPostedFile = files(iFile)
        Dim fileName, fileExtension As System.String
        fileName = System.IO.Path.GetFileName(postedFile.FileName)
        If Not (fileName = String.Empty) Then
          fileExtension = System.IO.Path.GetExtension(fileName)
          strMsg.Append("上传的文件类型：" + postedFile.ContentType.ToString() + "<br>")
          strMsg.Append("客户端文件地址：" + postedFile.FileName + "<br>")
          strMsg.Append("上传文件的文件名：" + fileName + "<br>")
          strMsg.Append("上传文件的扩展名：" + fileExtension + "<br><hr>")
          '可根据扩展名字的不同保存到不同的文件夹
          postedFile.SaveAs(System.Web.HttpContext.Current.Request.MapPath("images/") + fileName)
        End If
      Next
      strStatus.Text = strMsg.ToString()
      Return True
    Catch Ex As System.Exception
      strStatus.Text = Ex.Message
      Return False
    End Try
  End Function
End Class

调试易

datalist的问题，大家帮帮我！！！

解决方案 »