concatanation in datalist asp.net c#

sir this is my code...please refer and provide solution to me..
codebehind:

protected void btnSend_Click(object sender, EventArgs e)

{

try

{

//GetImages();

SqlParameter param1 = new SqlParameter("@senderid", Session["sender"]);

SqlParameter param2 = new SqlParameter("@message", Session["txtMessage"]);

SqlParameter param3 = new SqlParameter("@date", DateTime.Now);

SqlParameter param7 = new SqlParameter("@receiverid", Session["receiver"]);

String stm = "sp_ChatInsert";

SqlHelper.ExecuteNonQuery(CommonSetting.GetConnectionString(true), CommandType.StoredProcedure, stm, param1, param2, param3, param7);

getMessage();

//txtCompose.Text = null;

}

catch (Exception ex)

{

Response.Write(ex.Message);

}

public void getMessage()

{

try

{

string strSql = "sp_GetChatMessage";

//string curChatHistory = null;

SqlParameter param5 = new SqlParameter("@senderid", Session["sender"]);

SqlParameter param6 = new SqlParameter("@receiverid", Session["receiver"]);

ds = SqlHelper.ExecuteDataset(CommonSetting.GetConnectionString(true), CommandType.StoredProcedure, strSql, param5, param6);

dldisplayMessage.DataSource = ds;

//List strrr = new List();

//foreach (DataRow dr in ds.Tables[0].Rows)

//{

// strrr.Add(dr["SenderId"].ToString());

// strrr.Add(dr["Message"].ToString());

// strrr.Add(dr["Date"].ToString());

// if (Session["curr"] != null)

// {

// strrr.Add(Session["curr"].ToString());

// }

//}

//curChatHistory = curChatHistory + ds.Tables[0].Rows[0]["SenderID"].ToString() + "" + ds.Tables[0].Rows[0]["Message"].ToString() + "" + ds.Tables[0].Rows[0]["Date"].ToString() + "
";

//ViewState["curChatHistory"] = curChatHistory;

//Session["curr"]= strrr;

//List strrr1 = new List();

//strrr1 = null;

// strrr1 += strrr;

//dldisplayMessage.DataSource = Session["curr"];

// AjaxControlToolkit.HTMLEditor.Toolbar test = (AjaxControlToolkit.HTMLEditor.Toolbar)FTBMessage.Controls[0].Controls[2].Controls[0].Controls[0];

dldisplayMessage.DataBind();

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

yadagiri uppari13y ago
sir this is my code...please refer and provide solution to me..
codebehind:
protected void btnSend_Click(object sender, EventArgs e)
{
try
{
//GetImages();

SqlParameter param1 = new SqlParameter("@senderid", Session["sender"]);
SqlParameter param2 = new SqlParameter("@message", Session["txtMessage"]);
SqlParameter param3 = new SqlParameter("@date", DateTime.Now);
SqlParameter param7 = new SqlParameter("@receiverid", Session["receiver"]);
String stm = "sp_ChatInsert";
SqlHelper.ExecuteNonQuery(CommonSetting.GetConnectionString(true), CommandType.StoredProcedure, stm, param1, param2, param3, param7);
getMessage();
//txtCompose.Text = null;
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
}
public void getMessage()
{
try
{

string strSql = "sp_GetChatMessage";
//string curChatHistory = null;
SqlParameter param5 = new SqlParameter("@senderid", Session["sender"]);
SqlParameter param6 = new SqlParameter("@receiverid", Session["receiver"]);

ds = SqlHelper.ExecuteDataset(CommonSetting.GetConnectionString(true), CommandType.StoredProcedure, strSql, param5, param6);
dldisplayMessage.DataSource = ds;
//List strrr = new List();
//foreach (DataRow dr in ds.Tables[0].Rows)
//{
// strrr.Add(dr["SenderId"].ToString());
// strrr.Add(dr["Message"].ToString());
// strrr.Add(dr["Date"].ToString());
// if (Session["curr"] != null)
// {
// strrr.Add(Session["curr"].ToString());
// }
//}
//curChatHistory = curChatHistory + ds.Tables[0].Rows[0]["SenderID"].ToString() + "" + ds.Tables[0].Rows[0]["Message"].ToString() + "" + ds.Tables[0].Rows[0]["Date"].ToString() + "
";
//ViewState["curChatHistory"] = curChatHistory;

//Session["curr"]= strrr;

//List strrr1 = new List();
//strrr1 = null;
// strrr1 += strrr;

//dldisplayMessage.DataSource = Session["curr"];

// AjaxControlToolkit.HTMLEditor.Toolbar test = (AjaxControlToolkit.HTMLEditor.Toolbar)FTBMessage.Controls[0].Controls[2].Controls[0].Controls[0];
dldisplayMessage.DataBind();
yadagiri uppari13y ago
pls tell me sir how to do that..........please i am new to asp.net
please provide code sir
Kunal Vaishya13y ago
Hi,
You can use page code backround Static List<> or DataSet at the Time of Concating Merger data with List or DataSet and Just Display to DataList.