Home
Get Started
Learn
Downloads
AJAX
MVC
Community
Wiki
Forums
Sign in
|
Join
Home
›
ASP.NET Forums
›
Search
Search
You searched for the word(s): userid:705027
More Search Options
RSS Available
Matching Posts
opening excel file in .net
I am using vb.net 2008 (.net 3.5) and am trying to open a excel file and then read the content from it. Currently I have hard-coded the directory of the file like "C:\imports\". I want the user to be able to locate the file on the computer and automatically open it. I am not sure of how to open this directory without hard-coding this. So far this is what I have which works : Dim file_nm As String = FileUpload1.FileName Dim dir As String = "C:\imports" Dim connection As String
Posted to
Enterprise Services Integration
(Forum)
by
topcatin
on 10/28/2009
Re: opening excel file in .net
Thanks for your response. No, I let the user choose the file in the "Fileupload" control and then I will upload it to a folder "Imports" in my project location and then read it from there. I want to know how to upload this file to a folder "Imports" which is inside my project. this is what I am trying to do: Dim loc_imports = Server.MapPath("\Excimp\Imports") FileUpload1.SaveAs(file_loc) -->uploads to the server then read the contents from the excel file
Posted to
Enterprise Services Integration
(Forum)
by
topcatin
on 10/28/2009
Re: Open new window in code_behind of a button _Click event
Add this in your code-behind when you are ready to open the new browser window: Response.Write("<SCRIPT language=javascript>var w=window.open('"+YOURPAGEWITHQUERYSTRING+"');</SCRIPT>");
Posted to
Web Forms
(Forum)
by
topcatin
on 11/14/2008
Re: Making sure parameterized query syntax is secure
hmm interesting. I read somewhere that stored-procedures are safer coz it treats it as text. Whatever be the case, it is better to write a small function which removes special characters or keywords like "select" "delete" etc.
Posted to
SQL Server, SQL Server Express, and SqlDataSource Control
(Forum)
by
topcatin
on 11/14/2008
Re: Restricting user actions
Why dont you show the controls based on the role of the user?
Posted to
Security
(Forum)
by
topcatin
on 11/14/2008
Re: Making sure parameterized query syntax is secure
The safest way to query a database is using stored procedures. In stored procedures, sql injection is not possible because stored procedures treats everything as text.
Posted to
SQL Server, SQL Server Express, and SqlDataSource Control
(Forum)
by
topcatin
on 11/14/2008
Re: Verifying email address exists or not
Kyle's suggestion is the best. But it really depends on how critical this application is. If it is something trivial, sending emails back to the user can get the user annoyed easily :)
Posted to
Security
(Forum)
by
topcatin
on 11/13/2008
Re: Using a Form to Insert Data to a Sql Database
Check the following line: sqlcmd.Parameters.Add("@CatID", SqlDbType.Int) 20 21 sqlcmd.Parameters("@CatID").Value = ddlCat.SelectedValue selected value is probably a string. To get the ID, you will have to use, ddlCAT.SELECTEDITEM.VALUE
Posted to
Web Forms
(Forum)
by
topcatin
on 11/12/2008
Re: Verifying email address exists or not
Keep in mind that people can also use somebody else's email which may be valid but still is invalid because the user used another email which is not even his/her's. The best is to just check the syntax, rather than the domain.
Posted to
Security
(Forum)
by
topcatin
on 11/12/2008
Re: what to study??
Nishant, I didnt know IIT was only for our country. My post was based on my experience. Well it is sad then to hear that even IIT it is book and then vomitting. But it hasnt helped a lot when you go and work. No doubt our degrees are accepted all over the world, but only some universities in India are recognized outside. But does a Indian engg course help you in any way when you get in the job? May be very little but not a lot. Working in real world is more than "hello world" programs and
Posted to
Getting Started
(Forum)
by
topcatin
on 11/11/2008
Page 1 of 36 (360 items) 1
2
3
4
5
Next >
...
Last ยป
ASP.NET:
T4CSS: A T4 Template for .Less CSS With Compression
WindowsClient:
JSON-P: An Elegant Hack
Channel 9:
Photosynth Update and New UI
Channel 9:
First Look: Streetside in Bing Maps
Channel 9:
Coding4Fun at PDC 2009
WindowsClient:
10 Must-See PDC 09 Sessions
Channel 10:
Photosynth Updated with New Release and New UI
Channel 10:
WindowsBlinds 7 Now Works with Windows 7
Channel 10:
Zune HD Launches New Colors
ASP.NET:
PDC09: ASP.NET MVC 2: Ninjas Still on Fire Black Belt Tips
ASP.NET:
Hanselminutes Podcast 188: ASP.NET MVC 2 Beta with Phil Haack
ASP.NET:
Hanselminutes Podcast 186: .NET Debugging 101 with Tess Ferrandez
TechNet Edge:
WinRE and free stuff with Sean Kearney
WindowsClient:
XslCompiledTransform and large template elements
WindowsClient:
The Future of Client App Dev : WPF and Silverlight Convergence
Channel 9:
PDC09 GeekFest Party
Channel 10:
How to Use "Play to" and "Remote Media Streaming" in Windows 7
Channel 9:
The Visual Studio Documentary: Jeff Hadfield Full Length Interview
TechNet Edge:
Managing Your Entire World - Tech Focus November 2009 Part 3
Channel 9:
The Access Show: Managing Access Databases with SharePoint
Microsoft Communities
ASP.NET
Channel 8
Channel 9
Channel 10
IIS.NET
Silverlight
TechNet Edge
WindowsClient
Mix Online