Tuesday, July 21, 2009

Second Post

Following Post is imported from,
http://salmonriaz.blogspot.com/

which is not my non .Net Programing blog, just for personal thoughts and writings,

---------------------------------------

OK So finally i thought i should write my first post, so there it goes,

Sometimes small problems end up taking way longer time that you would think,

I have been trying to set selected value of rad combo box to a value matching my DataBase value,

as follows,

DataSet ds = cs.GetUserID(new Guid(Session["CompanyID"].ToString()));
if (!(ds.Tables[0].Rows[0]["UserID"].Equals(DBNull.Value)))
ddlContact.SelectedValue = ds.Tables[0].Rows[0]["UserID"].ToString();

Did'nt realise that C# on the most part is case sensative and Guids are saved in CAPS in SQL Database, so this wasnt working...

==> Just Added .ToUpper() and it work as follows,

DataSet ds = cs.GetUserID(new Guid(Session["CompanyID"].ToString()));
if (!(ds.Tables[0].Rows[0]["UserID"].Equals(DBNull.Value)))
ddlContact.SelectedValue = ds.Tables[0].Rows[0]["UserID"].ToString().ToUpper();

Thought i should share :)

No comments:

Post a Comment