not setting color,font to text box in asp.net

hi...I have textbox and font window is there.After typing message in textbox then iam applying font size ,color,etc by javascript.After click send butto

then i am storing same data in db then displaying in chat window but no color,font is showing in chat window

aspx:

function ChangeFontColor() {

var fontColor = document.getElementById("<%# DropDownList2.ClientID %>").value;

if (fontColor != "Select") {

document.getElementById("<%# txtCompose.ClientID %>").style.color = fontColor;

}

function ChangeFontSize() {

var font = document.getElementById("<%# DropDownList3.ClientID %>").value;

if (font != "Select") {

document.getElementById("<%# txtCompose.ClientID %>").style.fontSize = font;

}

}
codebehind:

protected void btnSend_Click(object sender, EventArgs e)

{

try

{

if (txtCompose.Text.Trim() == "")

{

Alert.Show("Please enter message");

}

else

{

ViewState["txtMessage"] = txtCompose.Text.Trim();

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

SqlParameter param2 = new SqlParameter("@message", ViewState["txtMessage"].ToString());

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

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

String stm = "sp_ChatInsert";

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

getMessage();

txtCompose.Text = "";

}

catch (Exception ex)

{

Response.Write(ex.Message);

}

public void getMessage()

{

try

{

string strSql = "sp_GetChatMessage";

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

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

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

if (ViewState["Table"] != null)

{

ds3 = (DataSet)(ViewState["Table"]);

ds3.Merge(ds);

ViewState["Table"] = ds3;

}

else

{

ViewState["Table"] = ds;

ds = null;

}

dldisplayMessage.DataSource = null;

dldisplayMessage.DataBind();

dldisplayMessage.DataSource = (DataSet)ViewState["Table"];

dldisplayMessage.DataBind();

}

5 Replies

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

yadagiri uppari13y ago
sorry i didn't get ....how to save data in database...if possible help with piece of code
Iftikar Hussain13y ago
using this you will not able to save formatted text in your database. There is two way you can do this

1. Save both font style and font color to database and while retrieving same way display it
2. Use RichTextBox

refer this like

http://stackoverflow.com/questions/13638169/how-to-preserve-formatting-in-a-multi-line-text-box

Regards,
Iftikar
yadagiri uppari13y ago
aspx:
function ChangeFontColor() {
var fontColor = document.getElementById("<%# DropDownList2.ClientID %>").value;
if (fontColor != "Select") {
document.getElementById("<%# txtCompose.ClientID %>").style.color = fontColor;
}

}
function ChangeFontSize() {
var font = document.getElementById("<%# DropDownList3.ClientID %>").value;
if (font != "Select") {
document.getElementById("<%# txtCompose.ClientID %>").style.fontSize = font;
}
}
codebehind:
protected void btnSend_Click(object sender, EventArgs e)
{
try
{
if (txtCompose.Text.Trim() == "")
{
Alert.Show("Please enter message");
}
else
{
ViewState["txtMessage"] = txtCompose.Text.Trim();
SqlParameter param1 = new SqlParameter("@senderid", Session["MemberID"]);
SqlParameter param2 = new SqlParameter("@message", ViewState["txtMessage"].ToString());
SqlParameter param3 = new SqlParameter("@date", DateTime.Now);
SqlParameter param7 = new SqlParameter("@receiverid", Session["ConnectedMemId"]);
String stm = "sp_ChatInsert";
SqlHelper.ExecuteNonQuery(CommonSetting.GetConnectionString(true), CommandType.StoredProcedure, stm, param1, param2, param3, param7);

getMessage();
txtCompose.Text = "";
}
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
}

public void getMessage()
{
try
{

string strSql = "sp_GetChatMessage";

SqlParameter param5 = new SqlParameter("@senderid", Session["MemberID"]);
SqlParameter param6 = new SqlParameter("@receiverid", Session["ConnectedMemId"]);

ds = SqlHelper.ExecuteDataset(CommonSetting.GetConnectionString(true), CommandType.StoredProcedure, strSql, param5, param6);
if (ViewState["Table"] != null)
{

ds3 = (DataSet)(ViewState["Table"]);
ds3.Merge(ds);
ViewState["Table"] = ds3;
}
else
{
ViewState["Table"] = ds;
ds = null;
}
dldisplayMessage.DataSource = null;
dldisplayMessage.DataBind();
dldisplayMessage.DataSource = (DataSet)ViewState["Table"];
dldisplayMessage.DataBind();

}
Riyaz Akhtar13y ago
is it possible u to share the code?
Iftikar Hussain13y ago
Hi,
Are you trying to store the formatted font in your database?

Regards,
Iftikar