Sajith Premachandran IT Professional

Search This Blog

February 22, 2010

Get link
Facebook
X
Pinterest
Email
Other Apps

http://arrao4u.wordpress.com/
http://ramaraojvh.blogspot.com/
http://bikashray.blogspot.com/

Get link
Facebook
X
Pinterest
Email
Other Apps

Comments

Change Color of Gridview row on mouseover

protected void gridRole_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { e.Row.Attributes["onmouseover"] = "this.style.cursor='hand';this.style.textDecoration='underline';this.style.background='#E2DED6';"; e.Row.Attributes["onmouseout"] = "this.style.textDecoration='none';this.style.background='none';"; } }

Sql Function for String Concatenation

create function dbo.test2(@l3code varchar(20)) RETURNS varchar(2000) As BEGIN Declare @var varchar(2000) set @var='' Select @var = @var +'#'+ keyword from keyword where level3code=@l3code group by level3code,keyword return @var END select distinct level3code,dbo.test2(level3code) from keyword

Bind Array to Gridview

int[] intArray = { 1, 2, 3, 4, 5 }; GridView1.DataSource = intArray; GridView1.DataBind();

Powered by Blogger

Comments

Post a Comment