在asp.net中从dataSet获取一个值 [英] Get a single value from dataSet in asp.net

问题描述

我正在从tbl_message表中进行查询以获取Title和RespondBY，我要在对数据中继器进行数据绑定之前解密Title。在执行数据绑定之前，如何访问标题值。

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();  

以下代码部分可以从数据集

string title = ds.Tables[0].Rows[0]["Title"].ToString();

这篇关于在asp.net中从dataSet获取一个值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！