Click here to Skip to main content
15,896,606 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Our design:-
XML
<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>


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
Posted
Comments
anuradha.sardesai 27-May-14 7:28am    
PLease clarify, what is the question, what exactly is the problem? Will this help - http://csharp-guide.blogspot.in/2012/04/capture-button-click-events-in-datalist.html
http://msdn.microsoft.com/en-us/library/vstudio/df6hth3s(v=vs.100).aspx

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900