|
I am developing an Asp.net 2.0 (VB.Net) application. I am trying to develop a feature to export a dataset to excel.
After clicking export to excel button events, It gives pop up window asking 'do you want to open save or cancel', When I click 'open'
an issue accurs:
when ever it open with excel 2007 It gives another alert popup window saying that "Do you want to open this file" with two buttons Yes or No when I click one of them it opens.( it opens without any alert popup message window in excel 2000, 2003 and all versions of excel),
I am asked to avoid alert message, While opening in Excel 2007.
I have tried both . Excel(xsl) and .csv methods.
Please let me know if you have some other methods for exporting Dataset(datatable) to Excel with out this alert message that I get in Excel 2007.
I would appreciate your help on this.
Thanks in Advance
Mohamed Arif
PS: I want the excel report's header and column headers to dynamically change according to the user selection in the previous page, But the data being the same from dataset(datatable).
|
|
|
|
|
Do you have any example or code snippet for doing export to excel by using Xml templates,If so please send me. I would appreciate your help on this.
Thanks
Mohamed
|
|
|
|
|
Hi,
I have a table and I want to display employeesName in my GridView that when I click on any item it opens the
C:\file1.jpg or C:\file2.jpg. How can I do this with hyperlinks.
Please help me this is very urgent.
EmployeeID EmployeeName photo URL
----------- ------------------------------------------ --------------------------------------------------
1 mary file1.jpg C:\file1.jpg
2 johnes file2.jpg C:\file2.jpg
3 william file3.jpg C:\file3.jpg
seema
|
|
|
|
|
I am a beginner trying to use ASP.NET for web development and have installed .Net framework 2.0, Visual Studio 2005 professional edition and Internet Information Services (IIS). I am having a problem with the configuration as a result I can't run the page. I normally get the error message "unable to start debugging on the web server. The server does not support debugging of ASP.NET or ATL Server Applications"
Please can any one help me with this problem? Thanks.
The only permanent situation is change
|
|
|
|
|
Go to the IIS.
Right click the "virtual directory" of your application.
Select "Properties".
Go to "Directory Security" -Tab - (click).
click on Edit.
Enable "anounymous access". Click Ok.
Let me know if that worked for you.
Felipe
|
|
|
|
|
Thanks Felipe, but it still did not work. I am using IIS 5.1
Regards
The only permanent situation is change
|
|
|
|
|
Then try adding a Global.asax and/or Web.config.
If have those the last thing I can think of is:
Go the IIS, right click the virtual directory go to the ASP.NET Tab and select the Version 2.0.
Let me know how it goes.
Felipe
|
|
|
|
|
How to store and display data into xml file insted of sql or oracle DB from asp.net application
Thanks in Adv
|
|
|
|
|
Hi gopalakatla,
You can store & retrieve data to xml file using dataset object.
In the DataSet class, WriteXml() method which take file name as
argument is used to write data as xml data to the file. Through ReadXml()
method which take file name as argument is used to read or loaded xml data to DataSet object.
If you want operation similar to sql or oracle i.e using query, then you have
to write a separate utility class for doing query operation.
|
|
|
|
|
Hi,
I need to generate a report for top 10 share holders. its not that the first top 10 values. Its the top 10 share holders ( values). I am writing the query in sql server. Please help me to get top 10 share holder values.
Thank you.
Vasini
|
|
|
|
|
|
Combine order by clause and Top keyword.
Regards,
Arun Kumar.A
|
|
|
|
|
Is there a way to validate several fields on a form with ONE validation control?
The scenario - 10 fields, at least one of them needs an entry before proceeding to the next page.
I need to check if all fields are null (empty, blank) and return an error message
|
|
|
|
|
Don't repeat the same question. Continue with your original thread, espesially since you have been answered there
only two letters away from being an asset
|
|
|
|
|
I am planning to learn ASP.NET to broaden my .net skills. Is ASP.NET easy to learn? How long did it take to get a grasp on how to use it? Are there any tutorials or websites that will help me achieve my goal?
|
|
|
|
|
|
ToddHileHoffer wrote: ASP.Net is tricky compared to windows apps.
When .NET first came out I found it much easier to get to grips with Windows apps. than ASP.NET apps. The latter was especially confusing having had some experience with classic ASP.
Kevin
|
|
|
|
|
I am relatively new to Asp.Net. Here's my question:
I need to do a simple http POST to a service URL (at a different domain) with all the parameters in the query string. For security purposes the service URL is using http BASIC authentication under https.
I need to add an "Authorization" header with a Base64 encoded username and password to gain access to the service.
For the sake of illustration, assuming the login is: Abcdef and the password is aBC123abc -- what would the coding look like (in VB)? Where specifically would the coding be placed?
Thanks!
Bruce K.
|
|
|
|
|
String auth = userID + ":" + password;
byte[] binaryData = Encoding.UTF8.GetBytes(auth);
auth = Convert.ToBase64String(binaryData); // Using base64 encoding
auth = "Basic " + auth; //This specifies it to use Basic Authentication
// Prepare web request
HttpWebRequest webRequest = (HttpWebRequest)WebRequest.Create(myURL);
// Add the standard headers
webRequest.Method = "POST";
webRequest.ContentType = "application/x-www-form-urlencoded";
webRequest.ContentLength = 0;
// Add this additional header
webRequest.Headers[“AUTHORIZATION”] = auth;
HttpWebResponse webResponse = (HttpWebResponse)webRequest.GetResponse();
|
|
|
|
|
Thank you very much Felipe!
Ok - here come the "dumb" questions - sorry!
Where do I place this code?:
String auth = userID + ":" + password;
byte[] binaryData = Encoding.UTF8.GetBytes(auth);
auth = Convert.ToBase64String(binaryData); // Using base64 encoding
auth = "Basic " + auth; //This specifies it to use Basic Authentication
Does this go in the web.config file? If not where?
Same question for:
// Prepare web request
HttpWebRequest webRequest = (HttpWebRequest)WebRequest.Create(myURL);
Where do I place this code?
And lastly are the standard (and additional) headers added in the document headers section of IIs in the virtual directory that contains the asp.net form page? If not where?
Thanks for your patience.
Bruce K.
|
|
|
|
|
Say I have 10 fields. Is there a way to check that all 10 fields are not null on the client? I am able to check on the server but would prefer to do client-side checking. The standard ASP.Net validation controls seem to be for only one field at a time.
Thank you.
Patrice in Irvine
|
|
|
|
|
Use a CustomValidator control and use the ClientValidationFunction to check all fields you are interested in.
only two letters away from being an asset
|
|
|
|
|
Hello Mark,
I posted an updated question that may be clearer than my original question.
Here it is...
Is there a way to validate several fields on a form with ONE validation control?
The scenario - 10 fields, at least one of them needs an entry before proceeding to the next page.
I need to check if all fields are null (empty, blank) and return an error message
I just checked out the ClientValidationFunction but it seems(to me) that I can still only validate against one field at a time. Is that true or do you think I can use this function to validate against multiple fields with ONE validation control?
Thank you for your earlier response.
Patrice
|
|
|
|
|
...ClientValidationFunction to check all fields you are interested in.
only two letters away from being an asset
|
|
|
|
|
I'll look at it again. Thank you so much.
Patrice
|
|
|
|