You searched for the word(s): userid:705027

More Search Options

RSS Available

• 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