Umer khan

Total Ranking points:815

Top Questions

6 how check for not null against a field in mongodb using mongodb compass?

5 Display text vertically readable from bottom to top using css?

4 is it possible to limit text to specified N number of lines using css?

4 how to implement Cache Busting technique of "File path versioning" or "File name versioning" for asp.net mvc site?

4 how to dynamically generate pdf file from html in C# using ItextSharp ?

4 add header on every page while dynamically generate pdf from html using iTextSharp in asp.net(C#)?

4 how to setup a "website down for maintenance" page for any major updates in a asp.net (MVC) website?

3 cookie value breaking at comma in some browsers

3 what is maximum numbers of cookies allowed in website and what is maximum size of a web browser's cookie?

3 unable to access same MemoryStream multiple times, getting the MemoryStream closed on second attempt in C#?

Top Answers

6 I had similar sort of problem when I had installed visual studio 2019 fresh instance and in my case the issue was with the package source that was not set properly due to fresh installation of visual studio, so for setting the package source for visual studio we need to go to Tools > Options > NuGet Package Manager > Package Sources and set following values: Name: nuget.org Source: https://api.nuget.org/v3/index.json

5 These types of issues are very common and mostly following are the main reasons for such issues: -Wrong date & time on your computer (or device you are using) -Antivirus blocks SSL connections -Browser’s cookies & cached files -DNS cached But in your case I believe it is most probably cache issue but it seems to be DNS cache issue, so you just need to clear the DNS cache for which you can open the Command Prompt and use the following to clear the DNS cache: ipconfig /flushdns

4 You can simple use following code to set/ increase the session timeout for example if you want to setup the timeout for an hour. <system.web> <sessionState timeout="60"></sessionState> </system.web> Note: In the above code 60 is for 60minutes

4 You can use the following code for both IIS versions, it will make the server variable empty in the response header. <rewrite> <outboundRules> <rule name="ModifyServer"> <match serverVariable="RESPONSE_SERVER" pattern=".*" /> <action type="Rewrite" value="" /> </rule> </outboundRules> <rewrite>

4 As per the most of the Browser’s default functionality the field before the password is assumed as Username and it uses the last logged in data automatically even if we do autocomplete="off". The simplest solution would be to set your fields autocomplete’s values as follows: autocomplete = "new-code" autocomplete = "new-password" autocomplete = "new-confirm-password" Note: The above solution will work only in HTML5 supported browsers.

3 You can easily achieve this by just adding the three lines to your code as shown and a method to get your column name. So your final code will be similar to the following code. List<string> myValue = new List<string>(); Range usedRange = sheet.UsedRange; int lastUsedcolumn = usedRange.Column + usedRange.Columns.Count - 1; string Column = GetExcelColumnName(lastUsedcolumn); //In the above line you have got the last column name //In the following line you will be appending your row number string endRange= Column +1; foreach (Range row in sheet.Cells.Rows.Range["A1", endRange]) { Range cell = (Range)row.Cells[1, 1]; if (cell.Value2 != null) { myValue.Add(Convert.ToString(cell.Value2)); } } public string GetExcelColumnName(int columnNumber) { int num1 = columnNumber; string str = string.Empty; int num2; for (; num1 > 0; num1 = (num1 - num2) / 26) { num2 = (num1 - 1) % 26; str = Convert.ToChar(65 + num2).ToString() + str; } return str; }

3 hi Samantha, It would be good if you can provide some code that you have tried so that the answer can be more specific, but as far as I understood your problem you can update the series or Legend item text by using its Name property for example the following code will update its text exactly as per your requirement. You just need to get your chart's SeriesCollection and update the Name for all items in the series collection. var sc = chart.SeriesCollection(); int counter = 1; int total = sc.Count + 1; do { var seriesTemp = sc.Item((counter)); seriesTemp.Name = "my series" + " " + counter; counter++; } while (counter != total);

3 Hi peter, It seems to be that you have minified your css? if so then I have also faced same problem few months back and main cause of the problem is that some minification tools minify css's hexadecimal values as well. for example in your case check out your css your "glyphicon-log-in" hexadecimal value "\e161" must be converted to "î…¡". which might be read by some browsers/sometimes correctly but some will unable to do so. So for a solution you need to replace these values to the actual hexadecimal value explicitly. Find and replace the following chunk in your minified file. .glyphicon-asterisk:before { content: "\2a"; } .glyphicon-plus:before { content: "\2b"; } .glyphicon-euro:before { content: "\20ac"; } .glyphicon-minus:before { content: "\2212"; } .glyphicon-cloud:before { content: "\2601"; } .glyphicon-envelope:before { content: "\2709"; } .glyphicon-pencil:before { content: "\270f"; } .glyphicon-glass:before { content: "\e001"; } .glyphicon-music:before { content: "\e002"; } .glyphicon-search:before { content: "\e003"; } .glyphicon-heart:before { content: "\e005"; } .glyphicon-star:before { content: "\e006"; } .glyphicon-star-empty:before { content: "\e007"; } .glyphicon-user:before { content: "\e008"; } .glyphicon-film:before { content: "\e009"; } .glyphicon-th-large:before { content: "\e010"; } .glyphicon-th:before { content: "\e011"; } .glyphicon-th-list:before { content: "\e012"; } .glyphicon-ok:before { content: "\e013"; } .glyphicon-remove:before { content: "\e014"; } .glyphicon-zoom-in:before { content: "\e015"; } .glyphicon-zoom-out:before { content: "\e016"; } .glyphicon-off:before { content: "\e017"; } .glyphicon-signal:before { content: "\e018"; } .glyphicon-cog:before { content: "\e019"; } .glyphicon-trash:before { content: "\e020"; } .glyphicon-home:before { content: "\e021"; } .glyphicon-file:before { content: "\e022"; } .glyphicon-time:before { content: "\e023"; } .glyphicon-road:before { content: "\e024"; } .glyphicon-download-alt:before { content: "\e025"; } .glyphicon-download:before { content: "\e026"; } .glyphicon-upload:before { content: "\e027"; } .glyphicon-inbox:before { content: "\e028"; } .glyphicon-play-circle:before { content: "\e029"; } .glyphicon-repeat:before { content: "\e030"; } .glyphicon-refresh:before { content: "\e031"; } .glyphicon-list-alt:before { content: "\e032"; } .glyphicon-flag:before { content: "\e034"; } .glyphicon-headphones:before { content: "\e035"; } .glyphicon-volume-off:before { content: "\e036"; } .glyphicon-volume-down:before { content: "\e037"; } .glyphicon-volume-up:before { content: "\e038"; } .glyphicon-qrcode:before { content: "\e039"; } .glyphicon-barcode:before { content: "\e040"; } .glyphicon-tag:before { content: "\e041"; } .glyphicon-tags:before { content: "\e042"; } .glyphicon-book:before { content: "\e043"; } .glyphicon-print:before { content: "\e045"; } .glyphicon-font:before { content: "\e047"; } .glyphicon-bold:before { content: "\e048"; } .glyphicon-italic:before { content: "\e049"; } .glyphicon-text-height:before { content: "\e050"; } .glyphicon-text-width:before { content: "\e051"; } .glyphicon-align-left:before { content: "\e052"; } .glyphicon-align-center:before { content: "\e053"; } .glyphicon-align-right:before { content: "\e054"; } .glyphicon-align-justify:before { content: "\e055"; } .glyphicon-list:before { content: "\e056"; } .glyphicon-indent-left:before { content: "\e057"; } .glyphicon-indent-right:before { content: "\e058"; } .glyphicon-facetime-video:before { content: "\e059"; } .glyphicon-picture:before { content: "\e060"; } .glyphicon-map-marker:before { content: "\e062"; } .glyphicon-adjust:before { content: "\e063"; } .glyphicon-tint:before { content: "\e064"; } .glyphicon-edit:before { content: "\e065"; } .glyphicon-share:before { content: "\e066"; } .glyphicon-check:before { content: "\e067"; } .glyphicon-move:before { content: "\e068"; } .glyphicon-step-backward:before { content: "\e069"; } .glyphicon-fast-backward:before { content: "\e070"; } .glyphicon-backward:before { content: "\e071"; } .glyphicon-play:before { content: "\e072"; } .glyphicon-pause:before { content: "\e073"; } .glyphicon-stop:before { content: "\e074"; } .glyphicon-forward:before { content: "\e075"; } .glyphicon-fast-forward:before { content: "\e076"; } .glyphicon-step-forward:before { content: "\e077"; } .glyphicon-eject:before { content: "\e078"; } .glyphicon-chevron-left:before { content: "\e079"; } .glyphicon-chevron-right:before { content: "\e080"; } .glyphicon-plus-sign:before { content: "\e081"; } .glyphicon-minus-sign:before { content: "\e082"; } .glyphicon-remove-sign:before { content: "\e083"; } .glyphicon-ok-sign:before { content: "\e084"; } .glyphicon-question-sign:before { content: "\e085"; } .glyphicon-info-sign:before { content: "\e086"; } .glyphicon-screenshot:before { content: "\e087"; } .glyphicon-remove-circle:before { content: "\e088"; } .glyphicon-ok-circle:before { content: "\e089"; } .glyphicon-ban-circle:before { content: "\e090"; } .glyphicon-arrow-left:before { content: "\e091"; } .glyphicon-arrow-right:before { content: "\e092"; } .glyphicon-arrow-up:before { content: "\e093"; } .glyphicon-arrow-down:before { content: "\e094"; } .glyphicon-share-alt:before { content: "\e095"; } .glyphicon-resize-full:before { content: "\e096"; } .glyphicon-resize-small:before { content: "\e097"; } .glyphicon-exclamation-sign:before { content: "\e101"; } .glyphicon-gift:before { content: "\e102"; } .glyphicon-leaf:before { content: "\e103"; } .glyphicon-eye-open:before { content: "\e105"; } .glyphicon-eye-close:before { content: "\e106"; } .glyphicon-warning-sign:before { content: "\e107"; } .glyphicon-plane:before { content: "\e108"; } .glyphicon-random:before { content: "\e110"; } .glyphicon-comment:before { content: "\e111"; } .glyphicon-magnet:before { content: "\e112"; } .glyphicon-chevron-up:before { content: "\e113"; } .glyphicon-chevron-down:before { content: "\e114"; } .glyphicon-retweet:before { content: "\e115"; } .glyphicon-shopping-cart:before { content: "\e116"; } .glyphicon-folder-close:before { content: "\e117"; } .glyphicon-folder-open:before { content: "\e118"; } .glyphicon-resize-vertical:before { content: "\e119"; } .glyphicon-resize-horizontal:before { content: "\e120"; } .glyphicon-hdd:before { content: "\e121"; } .glyphicon-bullhorn:before { content: "\e122"; } .glyphicon-certificate:before { content: "\e124"; } .glyphicon-thumbs-up:before { content: "\e125"; } .glyphicon-thumbs-down:before { content: "\e126"; } .glyphicon-hand-right:before { content: "\e127"; } .glyphicon-hand-left:before { content: "\e128"; } .glyphicon-hand-up:before { content: "\e129"; } .glyphicon-hand-down:before { content: "\e130"; } .glyphicon-circle-arrow-right:before { content: "\e131"; } .glyphicon-circle-arrow-left:before { content: "\e132"; } .glyphicon-circle-arrow-up:before { content: "\e133"; } .glyphicon-circle-arrow-down:before { content: "\e134"; } .glyphicon-globe:before { content: "\e135"; } .glyphicon-tasks:before { content: "\e137"; } .glyphicon-filter:before { content: "\e138"; } .glyphicon-fullscreen:before { content: "\e140"; } .glyphicon-dashboard:before { content: "\e141"; } .glyphicon-heart-empty:before { content: "\e143"; } .glyphicon-link:before { content: "\e144"; } .glyphicon-phone:before { content: "\e145"; } .glyphicon-usd:before { content: "\e148"; } .glyphicon-gbp:before { content: "\e149"; } .glyphicon-sort:before { content: "\e150"; } .glyphicon-sort-by-alphabet:before { content: "\e151"; } .glyphicon-sort-by-alphabet-alt:before { content: "\e152"; } .glyphicon-sort-by-order:before { content: "\e153"; } .glyphicon-sort-by-order-alt:before { content: "\e154"; } .glyphicon-sort-by-attributes:before { content: "\e155"; } .glyphicon-sort-by-attributes-alt:before { content: "\e156"; } .glyphicon-unchecked:before { content: "\e157"; } .glyphicon-expand:before { content: "\e158"; } .glyphicon-collapse-down:before { content: "\e159"; } .glyphicon-collapse-up:before { content: "\e160"; } .glyphicon-log-in:before { content: "\e161"; } .glyphicon-flash:before { content: "\e162"; } .glyphicon-log-out:before { content: "\e163"; } .glyphicon-new-window:before { content: "\e164"; } .glyphicon-record:before { content: "\e165"; } .glyphicon-save:before { content: "\e166"; } .glyphicon-open:before { content: "\e167"; } .glyphicon-saved:before { content: "\e168"; } .glyphicon-import:before { content: "\e169"; } .glyphicon-export:before { content: "\e170"; } .glyphicon-send:before { content: "\e171"; } .glyphicon-floppy-disk:before { content: "\e172"; } .glyphicon-floppy-saved:before { content: "\e173"; } .glyphicon-floppy-remove:before { content: "\e174"; } .glyphicon-floppy-save:before { content: "\e175"; } .glyphicon-floppy-open:before { content: "\e176"; } .glyphicon-credit-card:before { content: "\e177"; } .glyphicon-transfer:before { content: "\e178"; } .glyphicon-cutlery:before { content: "\e179"; } .glyphicon-header:before { content: "\e180"; } .glyphicon-compressed:before { content: "\e181"; } .glyphicon-earphone:before { content: "\e182"; } .glyphicon-phone-alt:before { content: "\e183"; } .glyphicon-tower:before { content: "\e184"; } .glyphicon-stats:before { content: "\e185"; } .glyphicon-sd-video:before { content: "\e186"; } .glyphicon-hd-video:before { content: "\e187"; } .glyphicon-subtitles:before { content: "\e188"; } .glyphicon-sound-stereo:before { content: "\e189"; } .glyphicon-sound-dolby:before { content: "\e190"; } .glyphicon-sound-5-1:before { content: "\e191"; } .glyphicon-sound-6-1:before { content: "\e192"; } .glyphicon-sound-7-1:before { content: "\e193"; } .glyphicon-copyright-mark:before { content: "\e194"; } .glyphicon-registration-mark:before { content: "\e195"; } .glyphicon-cloud-download:before { content: "\e197"; } .glyphicon-cloud-upload:before { content: "\e198"; } .glyphicon-tree-conifer:before { content: "\e199"; } .glyphicon-tree-deciduous:before { content: "\e200"; } .glyphicon-briefcase:before { content: "\1f4bc"; } .glyphicon-calendar:before { content: "\1f4c5"; } .glyphicon-pushpin:before { content: "\1f4cc"; } .glyphicon-paperclip:before { content: "\1f4ce"; } .glyphicon-camera:before { content: "\1f4f7"; } .glyphicon-lock:before { content: "\1f512"; } .glyphicon-bell:before { content: "\1f514"; } .glyphicon-bookmark:before { content: "\1f516"; } .glyphicon-fire:before { content: "\1f525"; } .glyphicon-wrench:before { content: "\1f527"; }

2 You can get the complete lists of controls with their identifiers,types and much more information of all the office controls, which can be downloaded from following Links(as per the version requirements) in which you will find a file named "powerpointcontrols.xlsx" which will have your required information. 1) Documentation for Office 2016 2) Documentation for Office 2013 3) Documentation for Office 2010 Hope this will help you!

2 You can simply iterate through a specified row or specified Range by using the following code, in which you can update your range as per your requirement. List<string> myValue = new List<string>(); foreach (Microsoft.Office.Interop.Excel.Range row in sheet.Cells.Rows.Range["A1","D1"]) { Microsoft.Office.Interop.Excel.Range cell = (Microsoft.Office.Interop.Excel.Range)row.Cells[1, 1]; if (cell.Value2 != null) { myValue.Add(Convert.ToString(cell.Value2)); } }

Top Tags Created

8 web.config

4 IIS URL Rewrite

3 MongoDB

3 search engine

2 Git

2 Version Control

2 .NET Core

2 Cookie(Browser's Cookie)

2 CSV

1 Heroku

Top Tags Used

19 C#

17 Asp.Net

16 ASP.NET MVC

8 HTML

7 IIS (Internet Information Services)

7 JavaScript

6 web.config

5 JQuery

4 Visual Studio Tools for Office (VSTO)

4 Microsoft Excel