View Complete Post
I don't know where to put this question.
I have a problem in excel. Basically, I want to write data in my excel template from my sql server database. The problem is some cells in the excel has some validation where i can only input data that is exist to the pre-defined data in the cell( i dont know how to call this but it simply pop up when i select that particular cell and will show me the data on it). if the data i inputted not exist then the error will pop up. I only want that pop up error to no be displayed and will continue the process. Currently the system works fine except that i need to press the OK button in the pop up error just to proceed. I am building web application using vs 2005.
Can somebody help me?
I've tried this method in my code behind to try and validate that the Fileupload control has a file or not. I get the error message the the event "Server Validate" cannot be found. Can anyone tell why? Thanks.
Public Sub CustomValidator1_ServerValidate(ByVal source As Object, ByVal args As System.Web.UI.WebControls.ServerValidateEventArgs) Handles CustomValidator1.ServerValidate
' Get file name Dim uploadAvatar As FileUpload = DirectCast(AdvertisementForm.FindControl("uploadAvatar"), FileUpload) Dim UploadFileName As String = uploadAvatar.PostedFile.FileName If UploadFileName = "" Then ' There is no file selected args.IsValid = False Else Dim Extension As String = UploadFileName.Substring(UploadFileName.L
I need to make validation for Textbox to allow enter integer stated by 9 or 6 or 5 , and also maximum 8 digits , how to do that ?
In VS 2008 there is a very useful feature of background HTML validation - it checks if CSS class name is valid i.e. it exists in one of the linked css files. But VS 2010 Express does not do that any more. And the relevant setting in Options->Text Editor->HTML->Validation->in CSS is not there. Ok, maybe they made it paid for option? VS 2010 Professional? Not there. Or maybe VS 2010 Ultimate? Not a trace.
1. am I blind?
2. they decided it is too convenient to use and removed it?
3. they will "introduce" it in SP1?
What is going on? That one thing made me move back to VS 2008 web developer.
I have two columns with id,name in the excel sheet.I want to convert into xml file in the below format
<?xml version="1.0" encoding="utf-8"?>
<guide xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
suggest me with sample code in ASP.NET.
I have a web app where user uploads a file.
File is saved in server locally and I want to read some data from it.
Currently my development server has office 2003.
So do I need office 2007 in order to be able to read an excel from office 2007 ?
What are other requirements ?
I tried a test, using
Microsoft.Office.Interop.Excel.Application excelApp = new Microsoft.Office.Interop.Excel.Application();Microsoft.Office.Interop.Excel.Workbook wrkBook; // = new Microsoft.Office.Interop.Excel.Workbook();wrkBook = excelApp.Workbooks.Open(@"C:\www\excel_files\b.xls", ....);
But When trying to open the file I get the error:
Exception from HRESULT: 0x800A03EC
So I'm wondering what I'm missing.
I am validating user from Login.xlsx file. It was working fine by validating email and password from that file. For testing i got new file same contents of file but added some more user names.
So after that when i validating the user i am getting the following error "Data type mismatch in criteria expression".
But when i replaced the new to old one it is working fine. The contens of both files are the same. So why this kind of error happened.