从数据集asp.net获取单个值 [英] Get a single value from dataSet in asp.net
本文介绍了从数据集asp.net获取单个值的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我做一个查询,以从tbl_message表中获取标题和RespondBY,我想我做的数据绑定到中继器之前解密的标题。如何访问做数据绑定前的标题值。
字符串MysqlStatement =SELECT标题,RespondBy FROM tbl_message WHERE tbl_message.MsgID = @MsgID;
使用(数据服务器的服务器=新的数据服务器())
{
了MySQLParameter [] =参数新了MySQLParameter [1];
参数[0] =新了MySQLParameter(@的MsgID,MySqlDbType.Int32);
参数[0] .value的邮件ID =;
command.Parameters.AddWithValue(@的MsgID,邮件ID);
DS = server.ExecuteQuery(CommandType.Text,MysqlStatement,参数);
}
rptList.DataSource = DS;
rptList.DataBind();
<表样式=WIDTH:498px;颜色:#F5F5F5;>
< ASP:直放站ID =rptList=服务器>
<&HeaderTemplate中GT;
< / HeaderTemplate中>
<&ItemTemplate中GT;
< TR>
< TD WIDTH =15%>
< B个受试对象; / B>
< / TD>
< TD WIDTH =60%>
< ASP:标签ID =lbl_Subj=服务器文本='<%#的eval(标题)%GT;/>
< / TD>
< / TR>
解决方案
或许,像下面的代码部分,你可以拿到冠军并尝试
rptList.DataSource = DS在此之前编码;
rptList.DataBind();
下面的代码部分可以得到的数据
串标题= ds.Tables [0] .Rows [0] [标题]的ToString()。
I am doing a query to get Title and RespondBY from the tbl_message table, I want to decrypt the Title before I do databinding to the repeater. How can I access the title value before doing databind.
string MysqlStatement = "SELECT Title, RespondBy FROM tbl_message WHERE tbl_message.MsgID = @MsgID";
using (DataServer server = new DataServer())
{
MySqlParameter[] param = new MySqlParameter[1];
param[0] = new MySqlParameter("@MsgID", MySqlDbType.Int32);
param[0].Value = MessageID;
command.Parameters.AddWithValue("@MsgID", MessageID);
ds = server.ExecuteQuery(CommandType.Text, MysqlStatement, param);
}
rptList.DataSource = ds;
rptList.DataBind();
<table style="width: 498px; color: #F5F5F5;">
<asp:Repeater ID="rptList" runat="server">
<HeaderTemplate>
</HeaderTemplate>
<ItemTemplate>
<tr>
<td width="15%">
<b>Subject</b>
</td>
<td width="60%">
<asp:Label ID="lbl_Subj" runat="server" Text='<%#Eval("Title")%>' />
</td>
</tr>
解决方案
Probably, like following code part you can get the Title and try this coding before
rptList.DataSource = ds;
rptList.DataBind();
The following code part can get the Title from dataset
string title = ds.Tables[0].Rows[0]["Title"].ToString();
这篇关于从数据集asp.net获取单个值的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文