Formatting gridview based on row data Part 9

[@marklesterechavez7228]

I sorted it out. sorry I was just a little bit frustrated that time. Thanks. By the way I used e.Row[col].cssclass. Thanks!

[@marklesterechavez7228]

Hi Mr. Venkat, I was just wondering, how can I add the ItemStyle-CssClass programmatically because I'm not using sqldatasource where you can put it in the boundfield element. I've been trying to use rowdatabound event but I have no idea how to access it. I hope you get my point. Thanks. Love your videos as usual.

[@niharikagurnani]

Hi Venkat, I tried this one, the salary is being read as "₹ 10,000.00" and a runtime exception is thrown "Input string was not in a correct format". I haven't added country culture as a column in my table, passing it as a string, still the culture is default. Sharing my code snippet here : if (e.Row.Cells[1].Text == "Niharika") { int salary = Convert.ToInt32(e.Row.Cells[3].Text); string countryCulture = "en-US"; string strFormattedSalary = string.Format (new System.Globalization.CultureInfo(countryCulture), "{0:c}", salary); e.Row.Cells[3].Text = strFormattedSalary; }

[@sayslah]

Just in case somebody wants to format the local time of a UTC datetime, I got it to work by using this code: protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { DateTime time = Convert.ToDateTime(e.Row.Cells[4].Text); TimeZoneInfo estZone = TimeZoneInfo.FindSystemTimeZoneById("Eastern Standard Time"); DateTime estTime = TimeZoneInfo.ConvertTimeFromUtc(time, estZone); string finalTime = estTime.ToString("h:mm tt"); e.Row.Cells[4].Text = finalTime; } } When you run the webform, my gridview displays the time as 2:33 PM for a UTC field that displayed prior to this code as 6:33 PM (I am eastern daylight savings as of today). I only show this because I had a helluva time trying to find any help about this time issue.

[@jamet60]

hello venkat, i wanna ask you somthing about culture, how can i find full list to change culture? i mean if india =en-IN then how about query for indonesia? thanks before

[@madhukumar2050]

Using data key concept we can access visible=false data directly

[@gwonmhz5285]

Sir,I am getting the format exception in salary despite my code is exactly like yours.Salary is of type money in database. Help..

[@Vishalsingh-ve8tu]

sir......i get the error in this line (e.Row.RowType = DataControlRowType.DataRow) type casting problem.....what is solution of this error please post it.....Thank!

[@GrayMonk100]

I assume that Gridview is ASP only and not available in Windows forms. I looked around for it and did not find it.

[@dharmitvyas8547]

Hi vishal singh , you have not added the double equal to operator "==" , your code must look like this if(e.Row.RowType == DataControlRowType.DataRow) { // do stuff }

[@kavithavishwanathen6778]

thank u sir

[@kushalkamboj2082]

thanks

[@hprince20]

yes iam also getting error like "input string is not in correct format" and the error is on this line " int AnnualSalary = Convert.ToInt32(e.Row.Cells[2].Text); " how to rectify this mr.venkat ..? need help