点击datalist的按钮事件时如何读取数据 [英] how to read data when click on button event of datalist

问题描述

我们的设计： -

Our design:-

<asp:DataList ID="DataList2" runat="server" Width="44%" BackColor="#FFFFCC"

              style="text-align: left" onitemcommand="DataList2_ItemCommand"  >
       <ItemTemplate>
         <table width="100%" border="1">
         <tr>
         <td width="100px">
          <asp:HiddenField runat="server" ID="hduser" Value='<%# Eval("username") %>' />
         <asp:Image ID="Image1" runat="server" ImageUrl = '<%# Eval("FilePath")%>'  BorderStyle="Ridge"  Width = "100px" Height = "100px"/>
         </td>
         <td>
         <span style="color:Red;font:14pt arial"><%# Eval("Name")%></span>
         <pre><span style="font:10pt Cambria"><%# Eval("city")%></pre>
         <%--<asp:Button ID="btnAddFriend" runat="server" Text="Add Friend"   CommandName="save"  />--%>
          <asp:LinkButton ID="LinkButton1" runat="server" CommandName="saverequest" CommandArgument='<%# Eval("username") %>' OnClick="populateSubCats">   </asp:LinkButton>
         </td>
         </tr>
         </table>
       </ItemTemplate>
   </asp:DataList>

$ b我使用的$ b代码： -

protected void DataList2_ItemCommand（object source，DataListCommandEventArgs e）

{

string username = string.Empty ;

DataTable dtuser1 =（DataTable）Session [User];

string user = dtuser1.Rows [0] [1] .ToString（）;





username =（（HiddenField）（e.Item.FindControl（username）））。值;

String strConnString = System.Configuration.ConfigurationManager.ConnectionStrings [ConnectionString]。ConnectionString;

SqlConnection con = new SqlConnection（strConnString）;

string strQuery =UPDATE [ FriendTable] SET [Is_Approved] = 1 WHERE Touser ='+ user +'和Fromuser ='+ username +';

SqlCommand cmd = new SqlCommand（strQuery）;



cmd.CommandType = CommandType.Text;

cmd.Connection = con;

try

{

con.Open（）;

cmd.ExecuteNonQuery（）;

}

catch （例外情况）

{

Response.Write（ex.Message）;

}

终于

{

con.Close（）;

con.Dispose（）;

}





}

请尽快回复我

code that i ma using:-
protected void DataList2_ItemCommand(object source, DataListCommandEventArgs e)
{
string username = string.Empty;
DataTable dtuser1 = (DataTable)Session["User"];
string user = dtuser1.Rows[0][1].ToString();


username = ((HiddenField)(e.Item.FindControl("username"))).Value;
String strConnString = System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
SqlConnection con = new SqlConnection(strConnString);
string strQuery = "UPDATE [FriendTable] SET [Is_Approved] = 1 WHERE Touser ='" + user + "' and Fromuser ='" + username + "'";
SqlCommand cmd = new SqlCommand(strQuery);

cmd.CommandType = CommandType.Text;
cmd.Connection = con;
try
{
con.Open();
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
finally
{
con.Close();
con.Dispose();
}


}
pls reply me soon

推荐答案

这篇关于点击datalist的按钮事件时如何读取数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！