|
hai,
many of the coding to UPLOAD EXCEL TO DATABASE consist of intermediate conversion (.csv) and uploading data from .csv file to database.
There is a way to upload data directly from EXCEL to DATABASE. But many programmers not following it. why?
What are all the advantage for the "EXCEL --> CSV --> Database" process?
What are all the disadvantage for the "EXCEL --> Database" process?
Thanks in advance. - KARAN
modified on Thursday, June 26, 2008 5:14 AM
|
|
|
|
|
Excel can read a csv, and a csv is just text. This means you can put it in your DB as text, and search it. An xls is a binary file, you can insert it, but not search it.
Christian Graus
Please read this if you don't understand the answer I've given you
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
If the excel file contains any alphanumeric characters, it will be diffcult to read the data to database. For eg. If a column in excel contains a mix of both alphabetic and numeric characters, the data will not read to dataset and thereby to database.
Eventhough there are a couple of workarounds for this which is difficult to implement sometimes, it is very easy when we convert the file into csv file. Any types of characters in csv file will be read to database without any issue.
Success is the good fortune that comes from aspiration, desperation, perspiration and inspiration.
|
|
|
|
|
This is my Login Page URL
http://localhost:3271/NocSystem/LoginPage.aspx
This is my Admin(Home)Page URL
http://localhost:3271/NocSystem/AdminPage.aspx
If i copy & paste the home pages URL with another Browser it is loading.I want to avoid that.Because if one of user got that URL he can easily access to my web base system through my web server.I'm developing this system to run @ my office's web server.
If one of user copy and paste that URL i wanna redirect to my Login Page.How can i do that...?
CheeN
|
|
|
|
|
1)Add a session in the login page.
2)Check for the session in all other pages.
If session not available redirect to login page.
3)Remove the session at logout.
|
|
|
|
|
Thankx $herin...REally thankx... i got it....wow....wwww
CheeN
|
|
|
|
|
|
Use Authendication
Sathya
|
|
|
|
|
have you checked out the custom asp.net login control, you can do the sort of thing you are asking for with that i think
We are not a Code Charity
|
|
|
|
|
I want some code to run on a web server at specified times compared to it only running when people visit the website.Basically i want to check the expiry date of the customers which is in database and send mails automatically, So how do i do it.Server is hosted by some third party which holds other sites also.
coolsatty
|
|
|
|
|
for that you should write a windows service
wasim khan
|
|
|
|
|
if you are using sqlserver you can also use jobs
and for sending mail use the sql server itself
I Wish the Life Had CTRL-Z
Wizards First Rule : People are fool,they believe what they want to believe or what they afraid to believe
www.subaitech.blogspot.com
|
|
|
|
|
read this post, looks like what you were after
http://forums.asp.net/p/1272455/2409553.aspx
We are not a Code Charity
|
|
|
|
|
iam having both horizontal and vartical scroll bars but when page is loading first time the horzontal scroll bar is getting stuck ie not moving.how can i solve this problem
|
|
|
|
|
are you using javascript for movint scroll bar or controlling it?
if yes then check the code for page loading
Sunny
|
|
|
|
|
Can you move the scroll bar if you re fresh the page after it first loadS?
We are not a Code Charity
|
|
|
|
|
yes and also if i right click and click on move to left also it is moving but it is not moving for the first time
|
|
|
|
|
Can you post the code you have for on_page_load event
We are not a Code Charity
|
|
|
|
|
How can I add a fav icon to my asp application? Thanks
|
|
|
|
|
you can use meta tag or a favicon image for this man.
|
|
|
|
|
using this
<link rel="shortcut icon" type="image/x-icon" href="/favicon.ico" />
<link rel="icon" type="image/x-icon" href="/favicon.ico" />
|
|
|
|
|
Can you please explain the code. in the href tag what code i need to add please?
|
|
|
|
|
<link rel="shortcut icon" type="image/x-icon" href="/favicon.ico" />
<link rel="icon" type="image/x-icon" href="/favicon.ico" />
in href tag you need not to do any code you just create an icon file with name favicon and put the path of that file in href ok?
Sunny
|
|
|
|
|
|
what are the dimensions of the icon?
|
|
|
|