I need to determine which version my access file is. Either 1997 or 2000 How can I do this in C#. I know how to open the file and check to see ifit is read only. But I don't know how to get version information.
System.IO.FileInfo fileInfo = new System.IO.FileInfo(UpdateOptions.MdbFileFolder.ToString() + "Customers.mdb");
In my application I've allowed users to upload Excel 2003 .xls files, and import them into a Gridview. This has been working fine using the following connection string:
[Code]....
Now my users are using Excel 2003, 2007 or 2010, I need to allow the newer file extensions (.XLSX) to be accessible too.
Therefore, within the connection string above I presume I could change the Excel version from 8.0 to 9.0 or 10.0 respectively, but is there much difference between Excel 2007 and Excel 2010 files?
If so, is it possible to 'detect' the Excel file version so that I can use the appropriate connection string to read the data from the files?
Do you have CrystalDecisions.Web dll version 12.0.2000.0?
View 4 RepliesIs it possible to determine the HTTP protocol version (e.g. 1.0 vs. 1.1) used for a request within a .ashx handler? I can see all of the header information except for the version in Request.Params.
If not, what avenues are available to discover the HTTP protocol version when processing an HTTP request in ASP.Net?
I need to determine the clients .NET framework version in my web application. I'm running in partial trust so I can not read the filesystem or registry (Is there an easy way to check .net framework verison using C#?).
System.Environment.Version returns the runtime version, so I can not use that.
I cannot use javascript The only way I can think of at the moment is to try to load a .NET 3.5 dll and catch an exception, but this does not.
Update:
Request.Browser.ClrVersion and Request.Browser.GetClrVersions() will return the .NET framework version(s) installed on the client.
in sql server we are using ntext column to store HTML related data, what is the equivalent datatype in Ms-Access 2000.?
View 1 RepliesI need to retrieve an image from a database file and save it to the file system.
Lets say I have this so far
Code:
Dim query As String = "Select Foto From tblImagenes Where ItemId = ?"
Dim conn As New OleDbConnection(ConfigurationManager.ConnectionStrings("Conexion1").ConnectionString)
Dim com As New OleDbCommand(query, conn)
[Code].......
I-m getting an error about the wrong parameter to the bitmap.
I open a mht file with the streamreader and I do some handling with the file.
Then I would like te open this content with word (200,2003,2007).
What's the correct content type to use for the Response.WriteFile method ?
As normally a mht file has content type multipart/related ...
The code i use is:
[Code]....
How do you do this in ASP.NET? Prefer VB.NET :) I have a file in my App_Data folder called test.mov. It's 500 megabytes. I want to create an ASPX page where it fetches the file, and then displays for a label the approximate download time depending on the user's connection.
It should say
File: test.mov
approximate download time for your connection: 15 minutes
Often, out of sheer desperation I will end up enabling "Everyone" access on a folder that a web app is accessing (perhaps for file creation, reading, etc) because I can't figure which user account to enable access on.
Obviously, this is a very bad thing to do. Is there a way to determine what account IIS is using at that exact moment to access folders (and perhaps other resources like SQL Server, etc)?
Are there logs I can look at that will tell me? Or perhaps some other way? I usually use Windows Auth without impersonation. Not sure if that information is relevant.
I have Membership, Profile and Role providers setup for my .NET MVC website. I would like to say: this Role has access to that Page. How do I 'inject' this code to the RoleProvider? Or do I have to override it somehow? Any leads?(Roles are stored in the default ASP.NET SqlRoleProvider, Pages are stored in a seperate SQL database).
View 2 RepliesI need to check if an authenticated user is authorized to access a directory. I have done this before with a base class library method, I just cannot remember what class it's part of or what it's name was. I think the method was a static method and the class may have had the word Utility in it's name, but I just can't remember or find it on the net. BUT I KNOW I HAVE USED IT! The method definition was something like:
bool SomeTypeWithTheWordUtilityInTheNamePossibly.VerifyUserIsAuthorized(Principal user, string virtualPath)
I'm not using a roles provider in this application and I'm not planning to.
I have a webpage that allows a user to download a specified file. When the file is ready to be fully downloaded (i.e I call the HttpResponse.End or HTTPRepone.Flush) the user is presented with a File Download dialogue.
Is there any way to determine what option the user has selected?
Have they Opened, Saved or Cancelled the File Download once the Flush or End has been sent?
Im trying to import a semiolon seperated file into mssql db 2000 table and I need your help.I can read the file and present the content in a for loop, but I would like to extract values at certain possions.Like "Fel Beskrivning;Konktakt förare; and so on.
View 2 Repliesusing vb.net 2005
I am looping through a directory and grabbing a jpg filename if it matches certain conditions (shown in my code snippet below).
However there might be more than one jpg in the file with the same name string "BarneyIsCool" and in this case I need to get the newest file that contains "BarneyIsCool" .
my question: How do i determine which file is the newest (last one added to the folder) using my vb.net code? the relevant code snippet follows:
[Code]....
So we're having this problem. A user goes to upload a file, and if it's above 10MB, it just kind of times out the page, and clears, and no good error is thrown to describe what happened. Ideally, we would like to examine the file size when the user chooses the file they want to upload but I don't know if this is even possible. Our framework is built with ASP.NET, VB.NET, and Javascript (and ExtJS 3.0), and it runs in IE.
View 6 RepliesI have a asp.net vb.net app, with a upload file control, when i upload the file i can get the type of file the extension : .(extension),But if the user change the extension how i can get the real type of file?
View 1 RepliesI created a survey in vb.net where results are stored in an Excel file.Locally I can access and update the data of the file, but if I put online can not correctly access the excel file.How can I determine the absolute url of the file so, when a user submits the answers they can be inserted correctly in the excel file? Currently I use this to determine the location of the file:
Dim LocalizacaoFicheiro As String = String.Concat(Server.MapPath("."), "RespostasQuestionario.xlsx")
I have some processes that run without an HttpContext in an ASP.NET MVC web application. This process needs to be able to determine the physical path to the Contents directory of the application for reading/writing data. But, since it is without an HttpContext, I don't get to use fancy things like Server.MapPath and such.
View 2 RepliesI have a .net web application hosted in Sharepoint 2007. Recently I added a page to launch an application(.exe) from the code behind of a .aspx page. The applicatoin is launched when I test it on my desktop(without Sharepoint). When I deploy the .aspx page and the dll to the Sharpoint, I get an error "Could not load file or assembly 'CheckService, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null' or one of its dependencies. The system cannot find the file specified.
View 1 RepliesI'm building several user controls (ASCX) for my website and several of them are very similar in what they do. (As a side note, I must create unique UC's even if they're similar because I'm creating widgets for the new Telligent Community themeing system). For example, two of them are different but use the same front-end code to create a 2 or 3 tab panel where you can click a tab and it changes the data below. I have a single JS file to handle these tabs and the animations. I'm currently dynamically adding my JS file reference to the <head> from the user controls' code via:
Literal jsFile = new Literal();
jsFile.Text = string.Format("<script src="{0}"></script>", "/community/themes/test/js/tabbedCallout.js");
Page.Header.Controls.Add(jsFile);
If I have both of these controls on a page though, both will add this JS file reference. How can I do a check to see if it is already added from another control?
I am uploading a .msi file using fileupload control to a central location. Now i need to get version info of this file. I am using the following code.
FileVersionInfo patchFile = FileVersionInfo.GetVersionInfo(completeFilePath)
completeFilePath is the full path of the uploaded file. This code breaks and throws file not found exception.however, if i look down in the physical directory,file exists there.
Am i missing something or will i have to download this uploaded file again to some temp location and then extract version info from this file.
Second option i had was to get version info before uploading the file. In this case i am not able to get complete path of this patch file as fileupload control just gives the fileName and not the complete location.
I have 5 GB data, when I move from SQL server 2000 to 2008 with Import and Export wizard, my LDF size is increased to 30 GB, Can I reduce my LDF file or move. In my one of the table contain around 20 Lakh data which i have normalized in 2008 and create 4 tables, so my data is entering in normalized form in 2008. But due to size by hard disk is full. I have used shrnik command but it reduce to only 1 GB.
View 5 Replieshow to read the data's in the text file using sql server 2000 and 2008. i have a text file in a server and it contains one column name with the multiple column values i need to read that informations and i need to update in a table in the database.
View 2 RepliesI simply want to create one file and then delete it, means I want to access one file subsequently. I am getting the very familiar error as shown in title. (Process can't access the file,) I have tried using file stream and all other stuff that I found from Googling but no success so far. Does any body have small and neat solution? in short, I would like to run the following statements without any error.File.Create("C:\hsp1.txt");
File.Open("C:\hsp1.txt", FileMode.Open, FileAccess.Read, FileShare.None);
