RE: File Import Wizard
- From: stcheng@xxxxxxxxxxxxxxxxxxxx (Steven Cheng[MSFT])
- Date: Mon, 03 Oct 2005 03:51:26 GMT
Hi David,
Welcome to MSDN newsgroup.
>From your description, you're wanting to build a file import system which
allow the client user to provide some files (some wellknown format) and
then import the file content as records into the database server, also the
system is web based, yes?
As for such application, I think we can separate it into two parts:
1. In the ASP.NET web page, we provide a wizard like UI to collect
information from the clientuser, also use a <input file ..> element to let
the client user upload file. Then, when the user submit the page, the data
and file will be posted to the server for processing.
2. In the ASP.NET webapp's serverside, we just use our serverside code
logic to parse the uploaded file stream and loop through the text datas in
it and build SQL data execution command to insert data into database. This
is the same as we programmatically import a file into database in winform
or console application, you can make the parsing and accessing database's
code into a separate component.
Currently I haven't found any existing code samples, if you have any
further and more detaild question, we can have some further discussion on
them.
Thanks,
Steven Cheng
Microsoft Online Support
Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)
--------------------
| From: "David Berry" <dberry@xxxxxxxx>
| Followup-To: microsoft.public.dotnet.languages.vb
| Subject: File Import Wizard
| Date: Sun, 2 Oct 2005 11:50:56 -0400
| Lines: 83
| MIME-Version: 1.0
| Content-Type: multipart/alternative;
| boundary="----=_NextPart_000_000A_01C5C747.8CD60990"
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2527
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2527
| Message-ID: <#YfDVk2xFHA.3180@xxxxxxxxxxxxxxxxxxxx>
| Newsgroups:
microsoft.public.dotnet.general,microsoft.public.dotnet.languages.vb
| NNTP-Posting-Host: adsl-64-252-4-30.adsl.snet.net 64.252.4.30
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP14.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.dotnet.languages.vb:108605
microsoft.public.dotnet.general:51140
| X-Tomcat-NG: microsoft.public.dotnet.general
|
| Hi All. I'm looking for any help or sample code that can show me how to
make a file import wizard in ASP.NET (VB preferred) like the one that MS
Access uses. I'm working on a web site where the user has the ability to
upload a file (.txt or .csv). The data in the file may be comma
delaminated, tab delaminated, fixed width etc (we don't know).
| What I'd like to create is something like MS Access uses to import an
Excel file into the database. Access has a wizard that walks the user
through steps such as - is the first row the header, ignore the first "x"
number of rows, is it comma, tab, semi colon etc delaminated, allows you to
adjust what data goes in what field etc And then does the import into the
database. I need to recreate something exactly like this but web-based.
I'd also like the user to be able to store their preferences so that the
next time they go to upload the same type of file the can just choose a
pre-made preference that knows what to do. The file would then get
imported into a database (Access or SQL Server).
| Any suggestions on where to start or code samples to look at?
| Thanks
|
.
- Follow-Ups:
- RE: File Import Wizard
- From: Steven Cheng[MSFT]
- RE: File Import Wizard
- Prev by Date: Re: Obtain a MAC address from a connected socket
- Next by Date: Re: Displaying a unicode character
- Previous by thread: Re: Obtain a MAC address from a connected socket
- Next by thread: RE: File Import Wizard
- Index(es):
Relevant Pages
|
Loading
