SqlConnection conn = new SqlConnection("server=10.10.2.251;uid=sa;pwd=sa123;database=test"); SqlDataAdapter da = new SqlDataAdapter("select id as '用戶名',pw as '密碼' from userid where ",conn); DataSet ds = new DataSet(); conn.Open(); da.Fill(ds); conn.Close(); dataGridView1.DataSource = ds.Tables[0];\
SqlDataAdapter da = new SqlDataAdapter("select id as '用戶名',pw as '密碼' from userid where ",conn);
DataSet ds = new DataSet();
conn.Open();
da.Fill(ds);
conn.Close();
dataGridView1.DataSource = ds.Tables[0];\
我一般用REPEATE
<table style="width: 100%; margin-top:15px;" cellpadding="0" cellspacing="0">
<asp:Repeater ID="Repeater1" runat="server">
<HeaderTemplate>
<tr>
<td bgcolor="#F5F5F5" style="padding:5px 0; text-align:left;" width="20%">
用户名
</td>
<td bgcolor="#F5F5F5" style="padding:5px 0; text-align:left" width="65%">
视图
</td>
<td bgcolor="#F5F5F5" style="padding:5px 0; text-align:left;" width="15%">
登录次数
</td>
</tr>
<tr>
<td bgcolor="#F5F5F5" style="padding:5px 0; text-align:left;" width="20%">
</td>
<td bgcolor="#F5F5F5" style="padding:5px 0; text-align:left" width="65%">
<img height="26" src="../images/kedu.jpg" >
</td>
<td bgcolor="#F5F5F5" style="padding:5px 0; text-align:left;" width="15%">
</td>
</tr>
</HeaderTemplate>
<ItemTemplate>
<tr>
<td style="border-bottom:#E7E7E7 dashed 1px; padding:5px 0; text-align:left" width="20%">
<%# Eval("UserName")%>
</td>
<td style="border-bottom:#E7E7E7 dashed 1px; padding:5px 0; text-align:left;" width="65%">
<img height="10" src="../hx_images/vote.jpg" width='<%# Convert.ToInt32( Eval("a"))*4 %>'>
</td>
<td style="border-bottom:#E7E7E7 dashed 1px; padding:5px 0; text-align:left;" width="15%">
<%# Eval("a") %>
</td>
</tr> </ItemTemplate>
</asp:Repeater>
</table>cs
Repeater1.DataSource = LoginRecordHandle.GetZaixianTj(Wheres);
Repeater1.DataBind();就要这样绑定一下就行了
里面的TABLE你想变什么样式就变什么