62,046
社区成员
发帖
与我相关
我的任务
分享初学者请教asp.net2.0中读数据库中某字段方法
asp.net 1.1中connection,command等方法的代码还将就能看懂，到了asp.net 2.0;vs 2005就搞不懂了，用VS 2005 SqlDataSource控件创建的数据源，完全搞不懂怎么用，比如我用vs2005 SqlDataSource控件创建一个数据库连接，只取两个字段“序号”“备注”，主健“序号”，用where 序号=1，然后我该怎么写代码，单独取出“备注”字段的值赋入一个变量呢？？？源码附下面，望达者指教，谢谢！！能帮我把代码写出来最好，再谢！！！
<%@ Page Language="C#" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<script runat="server">
</script>
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>无标题页</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:testconn %>"
SelectCommand="SELECT [序号], [备注] FROM [test01] WHERE ([序号] = @序号)">
<SelectParameters>
<asp:Parameter DefaultValue="1" Name="序号" Type="Int32" />
</SelectParameters>
</asp:SqlDataSource>
</div>
</form>
</body>
</html>
<%@ Page Language="C#" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<script runat="server">
</script>
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>无标题页</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:testconn %>"
SelectCommand="SELECT [序号], [备注] FROM [test01] WHERE ([序号] = @序号)">
<SelectParameters>
<asp:Parameter DefaultValue="1" Name="序号" Type="Int32" />
</SelectParameters>
</asp:SqlDataSource>
</div>
</form>
</body>
</html>
...全文
请发表友善的回复…
发表回复
