#include #include //Whence data //asynchronous programming

Hi, I suppose that when you say target address of a hyperlink, you meant the location you are taking when you click on a hyperlink? Here is what we are trying to accomplish. We have directory on our server where several documents are stored. Then the excel file contains hyperlinks to those documents. For instance, one of the columns, called Director for example, the Director is hyperlinked Director. On the excel file, it is clearly hyperlinked and when clicked, takes you to the Files directory and Director file. There are over 600 of these records on excel. What we are trying to do is import the contents of the excel file to the database then use our .net app to display these records on our site so users can visit the site search for any title info, find it, cick the hyperlink to take him/her to the file on the server. So, after importing the file to the database, all you see now is the text Director. The hyperlink is stripped away.

WOW, knowledge is power. Thank you very much sir and great to hear from you again :) With your advise, I was able to successfully use ClosedXML and it is working great. I still have this solution you provided here as a back up. Thank you again.

Can someone please help? I have attached two screenshots to help explain the issue I am having. The first screenshot shows what happens when I value is selected from DropDownList2. It automatically displays the row with 5 columns with values. https://www.kenig-dev.tech/wp-content/uploads/2023/03/1.png[^] The second screenshot shows when the user changes the value of DropDownList2 from 1 to 2. Rather than retain the first row with values and add a second black row, the first row was reset and replaced with 2 blank rows. https://www.kenig-dev.tech/wp-content/uploads/2023/03/2.png[^] How can we retain the first row with its values while adding a second blank row that allows user to enter values into that second row?

Thank you for your response sir but it did not work. In other words, the value of WI did not get copied to the mailState DropDownList. I tried hardcoding the State value since that will always be the same like this: var thestate = 'WI'; if (thestate !== "") { $('#mailState').val(thestate); } It appears to change something on the mailState dropdownlist but did not display that WI value in the dropdown. Instead, it showed blank value as the selected value on the mailState dropdownlist box.

samflex wrote: The method says Update(...) No, it says updateSal_Click(object sender, EventArgs e), which is clearly an event handler that is called when the user clicks a button or other control. And the result of the LINQ query is returned in the Text field of the newTotal item, which is most likely a field on the form.

Thank you very much sir.

"{" is not part of a date. The exception is correct. Bastard Programmer from Hell :suss: "If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.

Thank you so so so much sir. Your complete grasp of technology is truly amazing. No way I get this solution without your unflinching support and incredible patiences. May God continue to bless more.

Oh man! Getting the following error: Unhandled exception. System.InvalidCastException: Unable to cast object of type 'SelectArrayIterator`2[System.String,System.Threading.Tasks.Task]' to type 'System.Collections.Generic.IEnumerable`1[System.Threading.Tasks.Task`1[System.Boolean]]'. It says line 21 which is this line: IEnumerable> tasks = (IEnumerable>)args.Select(async url => This is the second line in Main(). Just for clarity sir, this is your version: IEnumerable < Task > tasks = args.Select(async url => However, when I ran it, I got: CS0266 Cannot implicitly convert type 'System.Collections.Generic.IEnumerable' to 'System.Collections.Generic.IEnumerable>'. An explicit conversion exists (are you missing a cast?) When I selected the suggested explicit cast option, the error went away but then I got the other error during testing. The error occurred when I tried passing one URL as an argument to test like: showserverstatus.exe google.com UPDATE: It's always something!!! I got the error worked out; just took me awhile to figure out what was missing - return... Now, email is not working. Not getting sent. UPDATE: Once again, I panicked and didn't calm down to look for solutions. Now, it is working. It turns out that I added myemail.com.net which obviously will make it hard to receive an email. After correcting it, everything is fine now. My Lord, it is impossible to express my most heartfelt gratitude for your patience, incredible ingenuity and most of all, you don't insult me. Thank you very much sir, THANK YOU!!!

Perfect, perfect!!! Thank you so much sir. Incredible!

string lbText = ((LinkButton)grvSpeakers.HeaderRow.Cells\[i\].Controls\[0\]).Text; The message suggests that the i index is invalid for the number of cells in the row, or Controls does not contain any items. You need to use the debugger to find out which one is the problem.