retrieving data in datalist from code behind

I am using datalist control and i want to change data of datalist control on click event .i am using session for giving the condition of retrieveing data from sql server in datalist but i want if session change it's value then data of datalist should change it's value according to the condition .what should i do?

please help me

Re: retrieving data in datalist from code behind

it will show you how to work and bind the data to datalist in asp.net

http://csharpektroncmssql.blogspot.com/2012/03/datalist-control-in-aspnet.html

Re: retrieving data in datalist from code behind

bhaskar.mule ,

<asp:DataList ID="DataList2" runat="server" Width="778px" CellPadding="4" ForeColor="#333333">
                            <AlternatingItemTemplate>
                                &nbsp;<br />
                            </AlternatingItemTemplate>
                            <ItemTemplate>
                                &nbsp;<asp:Label ID="Label4" runat="server" Text='<%# Eval("sname") %>'></asp:Label>-&gt;
                                <asp:Label ID="Label3" runat="server"  Text='<%# Eval("message") %>' ></asp:Label>
                            </ItemTemplate>
                            <FooterStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
                            <AlternatingItemStyle BackColor="White" />
                            <ItemStyle BackColor="#E3EAEB" />
                            <SelectedItemStyle BackColor="#C5BBAF" Font-Bold="True" ForeColor="#333333" />
                            <HeaderStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
                        </asp:DataList>

 con.Open();
        Session["frind1"] = ((LinkButton)DataList1.Items[DataList1.SelectedIndex].FindControl("LinkButton1")).Text;
        com = new SqlCommand(" select message,sname from msg where uid=@uid and fid=@fid", con);
        com.Parameters.AddWithValue("@uid",Session["uid"]);
        com.Parameters.AddWithValue("@fid", Session["frind1"]);
        dr = com.ExecuteReader();
        DataList2.DataSource = dr;
      
        DataList2.DataBind();
        
        dr.Close();
this is my code:-

in this i want to bind labels in code behind

Re: retrieving data in datalist from code behind

Where you change the value of session you can set again your value of session in datasource of datalist.

Sample:

Session["MySession"] = dataTable;
dataList.DataSource = Session["MySession"];
dataList.DataBind();

I hope this help.

Re: retrieving data in datalist from code behind

I am using two datalist frist retrieve the list of friend when user select any friend and coversation between current user and his selected friend will start.i am retrieveing data on the basis of of user id and friend id if user id and friend id match to the present user and his selected friend retrieve all data of matched condition when user change or friend change then where condition should change

of retrieveing data in datalist .meanse when user change his friend then messeage of conversation should be change in datalist control

this is my problem cna you give me any idea

Re: retrieving data in datalist from code behind

you can post your code?

Does is need to use two datalist? Doesn't is better use two dropdown with events to SelectedIndexChange?

Re: retrieving data in datalist from code behind

<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="messege.aspx.cs" Inherits="Default3" Title="Untitled Page" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
    <table style="width: 600px; height: 600px; background-color: #ccffff;">
        <tr>
            <td style="width: 100px; height: 596px;">
                <asp:MultiView ID="MultiView1" runat="server">
                    <asp:View ID="View1" runat="server">
                        <asp:DataList ID="DataList1" runat="server" DataSourceID="SqlDataSource1" OnSelectedIndexChanged="DataList1_SelectedIndexChanged" BackColor="White" BorderColor="#CC9966" BorderStyle="None" BorderWidth="1px" CellPadding="4" GridLines="Both" Width="782px" SelectedIndex="0">
                            <ItemTemplate>
                                <asp:LinkButton ID="LinkButton1" runat="server" OnClick="LinkButton1_Click" CommandName="select" Text='<%# Eval("friendname") %>'></asp:LinkButton>
                            </ItemTemplate>
                            <FooterStyle BackColor="#FFFFCC" ForeColor="#330099" />
                            <ItemStyle BackColor="White" ForeColor="#330099" />
                            <SelectedItemStyle BackColor="#FFCC66" Font-Bold="True" ForeColor="#663399" />
                            <HeaderStyle BackColor="#990000" Font-Bold="True" ForeColor="#FFFFCC" />
                        </asp:DataList><asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:PictureAlbumConnectionString %>"
                            SelectCommand="SELECT [friendname] FROM [friend] WHERE ([uid] = @uid)">
                            <SelectParameters>
                                <asp:SessionParameter Name="uid" SessionField="uid" Type="String" />
                            </SelectParameters>
                        </asp:SqlDataSource>
                    </asp:View>
                    <asp:View ID="View2" runat="server">
                        <asp:DataList ID="DataList2" runat="server" Width="778px" CellPadding="4" ForeColor="#333333">
                            <AlternatingItemTemplate>
                                &nbsp;<br />
                            </AlternatingItemTemplate>
                            <ItemTemplate>
                                &nbsp;<asp:Label ID="Label4" runat="server" Text='<%# Eval("sname") %>'></asp:Label>-&gt;
                                <asp:Label ID="Label3" runat="server"  Text='<%# Eval("message") %>' ></asp:Label>
                            </ItemTemplate>
                            <FooterStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
                            <AlternatingItemStyle BackColor="White" />
                            <ItemStyle BackColor="#E3EAEB" />
                            <SelectedItemStyle BackColor="#C5BBAF" Font-Bold="True" ForeColor="#333333" />
                            <HeaderStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
                        </asp:DataList><asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:PictureAlbumConnectionString %>"
                            SelectCommand="SELECT [message], [sname] FROM [msg] WHERE (([uid] = @uid) AND ([fid] = @fid))">
                            <SelectParameters>
                                <asp:SessionParameter Name="uid" SessionField="uid" Type="Int32" />
                                <asp:SessionParameter Name="fid" SessionField="frnd2" Type="String" />
                            </SelectParameters>
                        </asp:SqlDataSource>
                        <asp:TextBox ID="TextBox1" runat="server" Height="32px" Width="267px"></asp:TextBox><br />
                        &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
                        &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
                        &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
                        &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="Send" /></asp:View>
                </asp:MultiView>
            </td>
        </tr>
    </table>

</asp:Content>

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

public partial class Default3 : System.Web.UI.Page
{
    SqlConnection con = new SqlConnection("Data Source=ORDIN-PC;Initial Catalog=PictureAlbum;Integrated Security=True");
    SqlCommand com;
    SqlDataReader dr;
    protected void Page_Load(object sender, EventArgs e)
    {
        MultiView1.ActiveViewIndex = 0;
        DataList2.DataBind();
    }
    protected void DataList1_SelectedIndexChanged(object sender, EventArgs e)
    {
        Session["frind1"] = ((LinkButton)DataList1.Items[DataList1.SelectedIndex].FindControl("LinkButton1")).Text;
        
        
    }
    protected void LinkButton1_Click(object sender, EventArgs e)
    {
        con.Open();
        Session["frind1"] = ((LinkButton)DataList1.Items[DataList1.SelectedIndex].FindControl("LinkButton1")).Text;
        com = new SqlCommand(" select message,sname from msg where uid=@uid and fid=@fid", con);
        com.Parameters.AddWithValue("@uid",Session["uid"]);
        com.Parameters.AddWithValue("@fid", Session["frind1"]);
        dr = com.ExecuteReader();
        DataList2.DataSource = dr;
      
        DataList2.DataBind();
        
        dr.Close();
     

       
       
        string abc = ("select uid from login where username=@user");
        com = new SqlCommand(abc, con);
        com.Parameters.AddWithValue("@user", Session["frind1"].ToString());
        Session["frnd2"] = (com.ExecuteScalar());
        
        MultiView1.ActiveViewIndex = 1;
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
       
            con.Open();
            string abc = ("select name from login where uid=@uid");
            com = new SqlCommand(abc, con);
            com.Parameters.AddWithValue("@uid", Session["uid"]);
            Session["tripu"] = (com.ExecuteScalar());
            string p = ("insert into msg(uid,fid,message,sname)values(@uid,@fid,@message,@sname)");
            com = new SqlCommand(p, con);
            com.Parameters.AddWithValue("@message", TextBox1.Text);
            com.Parameters.AddWithValue("@uid", Session["uid"]);
            com.Parameters.AddWithValue("@fid", Session["frnd2"]);
            com.Parameters.AddWithValue("@sname",Session["tripu"]);
            com.ExecuteNonQuery();
            string q = ("insert into msg(fid,uid,message,sname)values(@uid,@fid,@message,@sname)");
            com = new SqlCommand(q, con);
            com.Parameters.AddWithValue("@message", TextBox1.Text);
            com.Parameters.AddWithValue("@uid", Session["uid"]);
            com.Parameters.AddWithValue("@fid", Session["frnd2"]);
            com.Parameters.AddWithValue("@sname", Session["tripu"]);
            com.ExecuteNonQuery();
            MultiView1.ActiveViewIndex = 1;
            DataList2.DataBind();
       
    }
}

Re: retrieving data in datalist from code behind

I did any changes:

ASPX:

tripu
<asp:LinkButton ID="LinkButton1" runat="server" OnClick="LinkButton1_Click" CommandName="select" Text='<%# Eval("friendname") %>'></asp:LinkButton>

<asp:LinkButton ID="LinkButton1" runat="server" OnClick="LinkButton1_Click" CommandName="select"
Text='<%# Eval("friendname") %>' CommandArgument='<%# Eval("fid") %>'></asp:LinkButton>

In CS

tripu
Session["frind1"] = ((LinkButton)DataList1.Items[DataList1.SelectedIndex].FindControl("LinkButton1")).Text;

Session["frind1"] = Convert.ToInt16(((LinkButton)DataList1.Items[DataList1.SelectedIndex].FindControl("LinkButton1")).CommandArgument);

Observations:

This event DataList1_SelectedIndexChanged is only fired when MultiView1.ActiveViewIndex = 1 in the method LinkButton1_Click
I needed to change this value Session["frind1"] in LinkButton1_Click because the value in LinkButton.Text is string, I think that should is integer, occur an error of type because this value;