问题急-搜索墙

问题急

1楼 zhangjingcheng 2007-07-03 11:54:25

string connec = "user id=sa;password=123;initial catalog=SQLStarnew;Server=KEYJOB;Connect TimeOut=120; ";
SqlConnection conn = new SqlConnection(connec);
conn.Open();
string Sqlstr = "select * from StarName ";
SqlCommand ddrs = new SqlCommand(Sqlstr, conn);
SqlDataReader rs = ddrs.ExecuteReader();
if (rs.Read())
{
string recorda = rs.GetValue(0).ToString().Trim();
string recordb = rs.GetValue(1).ToString().Trim();
string recordc = rs.GetValue(2).ToString().Trim();
string recordd = rs.GetValue(3).ToString().Trim();

BDLable.Text = " <a href=?id= " + recorda + "> " + recorda + " </a> " + "&nbsp&nbsp&nbsp " + "&nbsp&nbsp&nbsp " + recordb + "&nbsp&nbsp&nbsp " + "&nbsp&nbsp&nbsp " + recordc + "&nbsp&nbsp&nbsp " + "&nbsp&nbsp&nbsp " + recordd;
}
else
{
Response.Write( " <script> alert( '没有数据1 ');history.go(-1); </script> ");
}

怎么才可有把我要查询的数据显示在table控件里面上面是显示在lable里面的

2楼 zhangjingcheng 2007-07-03 12:02:46

怎么就没人呢？
自己顶了啊
送分

3楼 NetFlag 2007-07-03 12:06:55

显示在table控件里面?
那你绑定到DataGrid控件上

4楼 hongcha99 2007-07-03 12:07:30

我只会绑定tabel你问的还真不清楚。绑定，给我点分阿

5楼 amandag 2007-07-03 12:12:20

怎么才可有把我要查询的数据显示在table控件里面上面是显示在lable里面的
=================================================
应该把查询的结果放在数据绑定控件里,比如 DataList,DataGrid,Repeater等

6楼 chenny333 2007-07-03 12:47:27

ls正解

7楼 zhangjingcheng 2007-07-03 13:06:06

怎么绑定啊
给个例子哦谢谢！
<asp:TextBox ID= "TextBox1 " runat= "server "> </asp:TextBox>
<asp:Button ID= "Button1 " runat= "server " OnClick= "Button1_Click " Text= "Button " />

protected void Button1_Click(object sender, EventArgs e)
{
string connec = "user id=sa;password=123;initial catalog=SQLStarnew;Server=KEYJOB;Connect TimeOut=120; ";
SqlConnection conn = new SqlConnection(connec);
conn.Open();
string Sqlstr = "select * from StarName Where ausername= ' "+TextBox1.Text+ " ' ";
SqlCommand ddrs = new SqlCommand(Sqlstr, conn);
SqlDataReader rs = ddrs.ExecuteReader();
}这个查询怎么绑定Gridview控件呢？

8楼 zhangjingcheng 2007-07-03 13:06:37

不会用谢谢各位先

9楼 zhangjingcheng 2007-07-03 13:11:40

<asp:TextBox ID= "TextBox1 " runat= "server "> </asp:TextBox>
<asp:Button ID= "Button1 " runat= "server " OnClick= "Button1_Click " Text= "Button " />
<asp:GridView ID= "GridView1 " runat= "server " AutoGenerateColumns= "False " DataKeyNames= "ID "
DataSourceID= "SqlDataSource1 ">
<Columns>
<asp:BoundField DataField= "StarName " HeaderText= "StarName " SortExpression= "StarName " />
<asp:BoundField DataField= "ID " HeaderText= "ID " InsertVisible= "False " ReadOnly= "True "
SortExpression= "ID " />
<asp:BoundField DataField= "ausername " HeaderText= "ausername " SortExpression= "ausername " />
<asp:BoundField DataField= "bPassword " HeaderText= "bPassword " SortExpression= "bPassword " />
</Columns>
</asp:GridView>
<asp:SqlDataSource ID= "SqlDataSource1 " runat= "server " ConnectionString= " <%$ ConnectionStrings:SQLstarnewConnectionString %> "
SelectCommand= "SELECT [StarName], [ID], [ausername], [bPassword] FROM [StarName] ">
</asp:SqlDataSource>
看看这个怎么改

来源：http://topic.csdn.net/u/20070703/11/d2d00982-2ed7-405f-896d-c61b8d1a9ad7.html

热门关注
标题	回复	点击
Web.config文件里 <providerOption name="CompilerVersion" value="v3.5"/> 不允许有子节	9	569
100分请教一问题,各位达人帮忙(帮顶给分)	99	474
js技巧收集(200多个) 看看看看！！！	63	438
准备离职了，我不知道怎么跟经理谈。大家给点意见吧？谢谢大家。	62	435
无法在此路径使用此配置节。当站点管理员使用继承的配置文件中的 <location allowOverride="false"> 锁定对此节的访问时会出现这种情况	2	415
【散分】Javascript 新年快乐(2)，喜迎2010	100	408
请问大家"这是预编译工具生成的标记文件，不应被删除"的问题怎么解决?	0	395
链接服务器 "(null)" 的 OLE DB 访问接口 "Microsoft.Jet.OLEDB.4.0" 报错	3	383
ASP.NET热点问题解答14个	61	365
安装VS2005 出错错误 1335，安装所需的 CAB 文件 XXX 已损坏？	4	362

相关主题	关闭
libxml移植问题！！！急！！！！！线程创建与等待问题，急！！！急：linux中安全问题。谢谢！关于一个C++编译器安装的问题，急！~~ Gwt问题急！apue2源码编译问题！！！关于内核加入模块的问题，，急，解决gwt性能问题关于GWT的中文问题 RedHat8.0安全问题，大家帮我！！！急！！！！！！！！！

关于本站 pp酷网站导航友情链接

声明:本站部分数据来源于网络，仅供参考，如有版权问题，请联系我们，我们将及时删除!转载本站请注明来源