Showing posts with label based. Show all posts
Showing posts with label based. Show all posts

Saturday, March 31, 2012

The best file format to import/export data into sql database through asp.net application

Hi,

We are developing a SQL server based asp.net application. As part of
requirement we should allow users import/export some relational data through
web user interface. We are investigation which file format would be the most
efficient format to import export relational data.

So far we came up with two options: XML and Access MDB files and we prefer
MDB files.

Is there any better file format for import/export data?

Any help would be appreciated,
MaxThe format is not part of the requirements ? What is the exact purpose ?

IMO users are more used to spreadsheet files rather than to xml or even
Access files. Of course it depends if the overall goal is to import/export
data to automated systems or if this is to allows users to handle those
files by themselves in a familiar tool...

My personal default preference would be likely Excel files but your berst
bet is liekly to ask them what they intend to do with those files...

--
Patrice

"Max2006" <alanalan1@dotnet.itags.org.newsgroup.nospama crit dans le message de news:
OtaUPQpCIHA.464@dotnet.itags.org.TK2MSFTNGP02.phx.gbl...

Quote:

Originally Posted by

Hi,
>
We are developing a SQL server based asp.net application. As part of
requirement we should allow users import/export some relational data
through web user interface. We are investigation which file format would
be the most efficient format to import export relational data.
>
So far we came up with two options: XML and Access MDB files and we prefer
MDB files.
>
Is there any better file format for import/export data?
>
Any help would be appreciated,
Max
>
>
>


CSV is what I would pick.

"Max2006" <alanalan1@dotnet.itags.org.newsgroup.nospamwrote in message
news:OtaUPQpCIHA.464@dotnet.itags.org.TK2MSFTNGP02.phx.gbl...

Quote:

Originally Posted by

Hi,
>
We are developing a SQL server based asp.net application. As part of
requirement we should allow users import/export some relational data
through web user interface. We are investigation which file format would
be the most efficient format to import export relational data.
>
So far we came up with two options: XML and Access MDB files and we prefer
MDB files.
>
Is there any better file format for import/export data?
>
Any help would be appreciated,
Max
>
>
>


I see nothing wrong with MDB as asp.net has a data provider for it. You can
read it directly into SQL Server using dataset, I would think.

David
"Max2006" <alanalan1@dotnet.itags.org.newsgroup.nospamwrote in message
news:OtaUPQpCIHA.464@dotnet.itags.org.TK2MSFTNGP02.phx.gbl...

Quote:

Originally Posted by

Hi,
>
We are developing a SQL server based asp.net application. As part of
requirement we should allow users import/export some relational data
through web user interface. We are investigation which file format would
be the most efficient format to import export relational data.
>
So far we came up with two options: XML and Access MDB files and we prefer
MDB files.
>
Is there any better file format for import/export data?
>
Any help would be appreciated,
Max
>
>
>


CSV (Comma Separated Values) is generally considered to be the most
platform-agnostic file format.
-- Peter
Recursion: see Recursion
site: http://www.eggheadcafe.com
unBlog: http://petesbloggerama.blogspot.com
BlogMetaFinder: http://www.blogmetafinder.com
"Max2006" wrote:

Quote:

Originally Posted by

Hi,
>
We are developing a SQL server based asp.net application. As part of
requirement we should allow users import/export some relational data through
web user interface. We are investigation which file format would be the most
efficient format to import export relational data.
>
So far we came up with two options: XML and Access MDB files and we prefer
MDB files.
>
Is there any better file format for import/export data?
>
Any help would be appreciated,
Max
>
>
>
>

Wednesday, March 28, 2012

The clicking twice hair pulling doesnt do anything problem!

I have a single page in which everything is loaded from user controls based upon a specific value in the URL. The user controls are dynamically loaded (only load the user controls I need based upon the key in the URL). Within the user control is a form with a single button. When I click the button, nothing happens. When I click it again it does a full postback but all user controls are gone and I haven't the slightest idea if it upated or not. Now the form is in an update panel so it shouldn't be doing a post back.

To reiterate:

1. single page (call it default.aspx)
2. click a link with the key in the url (kind of like "?k=1048")
3. default.aspx runs through a case statement and find the key value that matches the URL then loads the user control.
4. user control has form on it
5. click the submit button, nothing happens. Click it again and it does a postback and all user controls are gone (AJAX didn't work).

So, any ideas about having to click twice and also why the update panel doesn't seem to be working?

thanks

^_^

ps. if i put the user control in a completely separate page where it isn't dynamically loaded, things work as intended.

To start with, when using Dynamic Controls, you should already know that you should RECREATE your controls on every page request. Keeping this in mind, you should keep track of which UserControl was loaded before and then reload it again!

Hope this helps,
Regards


That's nice but didn't help at all nor directed me to even an idea

What I did find was that when I removed the triggers from the update panel then the double-clicking went away and it operated as intended. but I wonder what will happen when I have multiple controls on a page that each have an update panel and I update one, will it cause the others to fire as well even with the mode set to conditional.

Does anyone have an idea of this cause that knows what they are talking about.

thanks

Saturday, March 24, 2012

the dreaded WAT is not working

Hi folks, using ASP.net 2.0 VS 2005 and C# on XP pro
I'm using a file based ASP.net web type on my local machine
I've not had this problem before, but I started a brand new website and I
clicked on the ASP.net configuration icon in solution explorer and I get thi
s
message
'An error was encountered. Please return to the previous page and try again.
'
when I click the link that says 'how do I use this tool' I get the message
that 'the tool has timed out'
how can I make this flaky heap of junk show me the normal 4 tabs
regards and many thanks in advance
CharlesAASP.Net requires a web server running the ASP.Net ISAPI to work. It is
HTTP-Protocol-based, and can not be run as a file-based web.
HTH,
Kevin Spencer
Microsoft MVP
Ministry of Software Development
http://unclechutney.blogspot.com
If you have little, is that your lot?
"CharlesA" <CharlesA@.discussions.microsoft.com> wrote in message
news:4AAB887E-3954-47D4-A51B-62FE56C43B60@.microsoft.com...
> Hi folks, using ASP.net 2.0 VS 2005 and C# on XP pro
> I'm using a file based ASP.net web type on my local machine
> I've not had this problem before, but I started a brand new website and I
> clicked on the ASP.net configuration icon in solution explorer and I get
> this
> message
> 'An error was encountered. Please return to the previous page and try
> again. '
> when I click the link that says 'how do I use this tool' I get the message
> that 'the tool has timed out'
> how can I make this flaky heap of junk show me the normal 4 tabs
> regards and many thanks in advance
> CharlesA
Did you create the membership database with the aspnet_regsql tool ?
If you have not yet created the membership database, exit the Web Site
Administration tool, use the aspnet_regsql command-line utility to create
and configure the database, and then return to the WAT to set the provider.
aspnet_regsql.exe is located in the .Net Framework directory :
Drive:\WINDOWS\Microsoft.NET\Framework\v2.0.50727
Juan T. Llibre, asp.net MVP
asp.net faq : http://asp.net.do/faq/
foros de asp.net, en espaol : http://asp.net.do/foros/
===================================
"CharlesA" <CharlesA@.discussions.microsoft.com> wrote in message
news:4AAB887E-3954-47D4-A51B-62FE56C43B60@.microsoft.com...
> Hi folks, using ASP.net 2.0 VS 2005 and C# on XP pro
> I'm using a file based ASP.net web type on my local machine
> I've not had this problem before, but I started a brand new website and I
> clicked on the ASP.net configuration icon in solution explorer and I get t
his
> message
> 'An error was encountered. Please return to the previous page and try agai
n. '
> when I click the link that says 'how do I use this tool' I get the message
> that 'the tool has timed out'
> how can I make this flaky heap of junk show me the normal 4 tabs
> regards and many thanks in advance
> CharlesA
Kevin, are you sure about that? I seem to remember using it on a machine the
other day (not my home one) with a file based system
Juan, surely I don't have to create the database first, how does the WAT
tool know that I want to do data stuff, I might just want to change some
config type things
I'm willing to give it a go, but I thought that the WAT tool itself created
the databases in App_data and that you used aspnet_regsql to change the
location of the database
Thanks for your posts so far any further reaction to what I've said here
would be really appreciated
Regards
CharlesA
Hi,
CharlesA wrote:
> Kevin, are you sure about that? I seem to remember using it on a machine t
he
> other day (not my home one) with a file based system
You can use file-based web in ASP.NET 2.0 only (not 1.1), and only from
Visual Studio, because it has a built-in development web server. You
cannot however run ASP.NET based pages/services using the file:// protocol.
So you're both right ;-)
HTH,
Laurent

> Juan, surely I don't have to create the database first, how does the WAT
> tool know that I want to do data stuff, I might just want to change some
> config type things
> I'm willing to give it a go, but I thought that the WAT tool itself create
d
> the databases in App_data and that you used aspnet_regsql to change the
> location of the database
> Thanks for your posts so far any further reaction to what I've said here
> would be really appreciated
> Regards
> CharlesA
Laurent Bugnion, GalaSoft
Software engineering: http://www.galasoft-LB.ch
PhotoAlbum: http://www.galasoft-LB.ch/pictures
Support children in Calcutta: http://www.calcutta-espoir.ch
thanks Laurent,
i am indeed using http://
I moved to a local IIS based website (through a virtual dir) and there I
can't even see my default.aspx let alone use the WAT
this is the error I get
This error (HTTP 500 Internal Server Error) means that the website you are
visiting had a server problem which prevented the webpage from displaying.
despite having used added in MAIN\ASPNET (main is my machine name) into the
directory security tab
I had none of these security probs in .net 1.1, now with VS 2005 I can't use
my local IIS anymore and if I try to use the WAT I'm told that it has timed
out, what am I missing (I'm at home and I'm the admin) any ideas on the
missing steps that I failed to take after installing both VS2005 with .net
2.0 and SServer 2005 on an XP pro machine?
Regards and thanks again for any help
CharlesA
just out of interest folks...if I go for a complete reinstall of all this (t
o
sort it out) what do I install first,
a) .Net2.0/Visual Studio 2005 and then SQL server 2005
b) the othe way round
c) it doesn't matter
Regards
CharlesA
re:
> I might just want to change some config type things
There's very little you can change in web.config using the WAT.
If that's all you want to do, change the website to http-based,
and use the ASP.NET configuration manager in the MMC.
Using the WAT for minor web.config configuration changes is spotty,
at best, since there's a lot of settings you don't have access to from the W
AT tool.
Juan T. Llibre, asp.net MVP
asp.net faq : http://asp.net.do/faq/
foros de asp.net, en espaol : http://asp.net.do/foros/
===================================
"CharlesA" <CharlesA@.discussions.microsoft.com> wrote in message
news:DC414BA9-AF4E-41B2-A50B-D35C2C6C38A2@.microsoft.com...
> Kevin, are you sure about that? I seem to remember using it on a machine t
he
> other day (not my home one) with a file based system
> Juan, surely I don't have to create the database first, how does the WAT
> tool know that I want to do data stuff, I might just want to change some
> config type things
> I'm willing to give it a go, but I thought that the WAT tool itself create
d
> the databases in App_data and that you used aspnet_regsql to change the
> location of the database
> Thanks for your posts so far any further reaction to what I've said here
> would be really appreciated
> Regards
> CharlesA
re:
> a) .Net2.0/Visual Studio 2005 and then SQL server 2005
.Net2.0, SQL Server 2005 (Express, presumably), then Visual Studio 2005
Juan T. Llibre, asp.net MVP
asp.net faq : http://asp.net.do/faq/
foros de asp.net, en espaol : http://asp.net.do/foros/
===================================
"CharlesA" <CharlesA@.discussions.microsoft.com> wrote in message
news:D26EC97F-863C-4476-A551-36D330EDBDE4@.microsoft.com...
> just out of interest folks...if I go for a complete reinstall of all this
(to
> sort it out) what do I install first,
> a) .Net2.0/Visual Studio 2005 and then SQL server 2005
> b) the othe way round
> c) it doesn't matter
> Regards
> CharlesA
ah yes Juan, but I needed to follow some steps in a tutorial so that
eventually I can use the Membership stuff, now either my website full stop
doesn't work with IIS or my WAT doesn't work with either the built-in web
server or IIS
Regards and thanks,
Charles

the dreaded WAT is not working

Hi folks, using ASP.net 2.0 VS 2005 and C# on XP pro

I'm using a file based ASP.net web type on my local machine

I've not had this problem before, but I started a brand new website and I
clicked on the ASP.net configuration icon in solution explorer and I get this
message

'An error was encountered. Please return to the previous page and try again. '

when I click the link that says 'how do I use this tool' I get the message
that 'the tool has timed out'

how can I make this flaky heap of junk show me the normal 4 tabs

regards and many thanks in advance

CharlesAASP.Net requires a web server running the ASP.Net ISAPI to work. It is
HTTP-Protocol-based, and can not be run as a file-based web.

--
HTH,

Kevin Spencer
Microsoft MVP
Ministry of Software Development
http://unclechutney.blogspot.com
If you have little, is that your lot?

"CharlesA" <CharlesA@.discussions.microsoft.comwrote in message
news:4AAB887E-3954-47D4-A51B-62FE56C43B60@.microsoft.com...

Quote:

Originally Posted by

Hi folks, using ASP.net 2.0 VS 2005 and C# on XP pro
>
I'm using a file based ASP.net web type on my local machine
>
I've not had this problem before, but I started a brand new website and I
clicked on the ASP.net configuration icon in solution explorer and I get
this
message
>
'An error was encountered. Please return to the previous page and try
again. '
>
when I click the link that says 'how do I use this tool' I get the message
that 'the tool has timed out'
>
how can I make this flaky heap of junk show me the normal 4 tabs
>
regards and many thanks in advance
>
CharlesA


Did you create the membership database with the aspnet_regsql tool ?

If you have not yet created the membership database, exit the Web Site
Administration tool, use the aspnet_regsql command-line utility to create
and configure the database, and then return to the WAT to set the provider.

aspnet_regsql.exe is located in the .Net Framework directory :

Drive:\WINDOWS\Microsoft.NET\Framework\v2.0.50727

Juan T. Llibre, asp.net MVP
asp.net faq : http://asp.net.do/faq/
foros de asp.net, en espaol : http://asp.net.do/foros/
===================================
"CharlesA" <CharlesA@.discussions.microsoft.comwrote in message
news:4AAB887E-3954-47D4-A51B-62FE56C43B60@.microsoft.com...

Quote:

Originally Posted by

Hi folks, using ASP.net 2.0 VS 2005 and C# on XP pro
>
I'm using a file based ASP.net web type on my local machine
>
I've not had this problem before, but I started a brand new website and I
clicked on the ASP.net configuration icon in solution explorer and I get this
message
>
'An error was encountered. Please return to the previous page and try again. '
>
when I click the link that says 'how do I use this tool' I get the message
that 'the tool has timed out'
>
how can I make this flaky heap of junk show me the normal 4 tabs
>
regards and many thanks in advance
>
CharlesA


Kevin, are you sure about that? I seem to remember using it on a machine the
other day (not my home one) with a file based system

Juan, surely I don't have to create the database first, how does the WAT
tool know that I want to do data stuff, I might just want to change some
config type things

I'm willing to give it a go, but I thought that the WAT tool itself created
the databases in App_data and that you used aspnet_regsql to change the
location of the database

Thanks for your posts so far any further reaction to what I've said here
would be really appreciated

Regards
CharlesA
Hi,

CharlesA wrote:

Quote:

Originally Posted by

Kevin, are you sure about that? I seem to remember using it on a machine the
other day (not my home one) with a file based system


You can use file-based web in ASP.NET 2.0 only (not 1.1), and only from
Visual Studio, because it has a built-in development web server. You
cannot however run ASP.NET based pages/services using the file:// protocol.

So you're both right ;-)

HTH,
Laurent

Quote:

Originally Posted by

Juan, surely I don't have to create the database first, how does the WAT
tool know that I want to do data stuff, I might just want to change some
config type things
>
I'm willing to give it a go, but I thought that the WAT tool itself created
the databases in App_data and that you used aspnet_regsql to change the
location of the database
>
Thanks for your posts so far any further reaction to what I've said here
would be really appreciated
>
Regards
CharlesA


--
Laurent Bugnion, GalaSoft
Software engineering: http://www.galasoft-LB.ch
PhotoAlbum: http://www.galasoft-LB.ch/pictures
Support children in Calcutta: http://www.calcutta-espoir.ch
thanks Laurent,

i am indeed using http://

I moved to a local IIS based website (through a virtual dir) and there I
can't even see my default.aspx let alone use the WAT

this is the error I get

This error (HTTP 500 Internal Server Error) means that the website you are
visiting had a server problem which prevented the webpage from displaying.

despite having used added in MAIN\ASPNET (main is my machine name) into the
directory security tab

I had none of these security probs in .net 1.1, now with VS 2005 I can't use
my local IIS anymore and if I try to use the WAT I'm told that it has timed
out, what am I missing (I'm at home and I'm the admin) any ideas on the
missing steps that I failed to take after installing both VS2005 with .net
2.0 and SServer 2005 on an XP pro machine?

Regards and thanks again for any help
CharlesA
just out of interest folks...if I go for a complete reinstall of all this (to
sort it out) what do I install first,

a) .Net2.0/Visual Studio 2005 and then SQL server 2005
b) the othe way round
c) it doesn't matter

Regards
CharlesA
re:

Quote:

Originally Posted by

I might just want to change some config type things


There's very little you can change in web.config using the WAT.

If that's all you want to do, change the website to http-based,
and use the ASP.NET configuration manager in the MMC.

Using the WAT for minor web.config configuration changes is spotty,
at best, since there's a lot of settings you don't have access to from the WAT tool.

Juan T. Llibre, asp.net MVP
asp.net faq : http://asp.net.do/faq/
foros de asp.net, en espaol : http://asp.net.do/foros/
===================================
"CharlesA" <CharlesA@.discussions.microsoft.comwrote in message
news:DC414BA9-AF4E-41B2-A50B-D35C2C6C38A2@.microsoft.com...

Quote:

Originally Posted by

Kevin, are you sure about that? I seem to remember using it on a machine the
other day (not my home one) with a file based system
>
Juan, surely I don't have to create the database first, how does the WAT
tool know that I want to do data stuff, I might just want to change some
config type things
>
I'm willing to give it a go, but I thought that the WAT tool itself created
the databases in App_data and that you used aspnet_regsql to change the
location of the database
>
Thanks for your posts so far any further reaction to what I've said here
would be really appreciated
>
Regards
CharlesA


re:

Quote:

Originally Posted by

a) .Net2.0/Visual Studio 2005 and then SQL server 2005


..Net2.0, SQL Server 2005 (Express, presumably), then Visual Studio 2005

Juan T. Llibre, asp.net MVP
asp.net faq : http://asp.net.do/faq/
foros de asp.net, en espaol : http://asp.net.do/foros/
===================================
"CharlesA" <CharlesA@.discussions.microsoft.comwrote in message
news:D26EC97F-863C-4476-A551-36D330EDBDE4@.microsoft.com...

Quote:

Originally Posted by

just out of interest folks...if I go for a complete reinstall of all this (to
sort it out) what do I install first,
>
a) .Net2.0/Visual Studio 2005 and then SQL server 2005
b) the othe way round
c) it doesn't matter
>
Regards
CharlesA


ah yes Juan, but I needed to follow some steps in a tutorial so that
eventually I can use the Membership stuff, now either my website full stop
doesn't work with IIS or my WAT doesn't work with either the built-in web
server or IIS
Regards and thanks,
Charles

FYI

"Kevin Spencer"

Quote:

Originally Posted by

ASP.Net requires a web server


Not really - just a process to handle:

HttpRuntime.ProcessRequest Method
Drives all ASP.NET Web processing execution

Quote:

Originally Posted by

running the ASP.Net ISAPI to work. It is
HTTP-Protocol-based, and can not be
run as a file-based web.
>


Well it all depends on what your goal is:
perhaps a sales CD (etc.) that looks like
it is using a "web server", or whatever!

Anyway here are two oldies but goodies:

"HTML is often thought of as the sole
domain for Web applications. But HTML's
versatile display attributes are also
very useful for handling data display of
all sorts in desktop applications. "

Hosting the ASP.Net Runtime in desktop applications
http://www.west-wind.com/presentati...pnetruntime.asp
Executing ASPX pages without a web server
http://radio.weblogs.com/0105476/st...AWebServer.html
I stand corrected! Or at least, adjusted!

--
;-),

Kevin Spencer
Microsoft MVP
Ministry of Software Development
http://unclechutney.blogspot.com
If you have little, is that your lot?

"Flowering Weeds" <floweringnoweedsno@.hotmail.comwrote in message
news:Od3tmiQBHHA.3536@.TK2MSFTNGP03.phx.gbl...

Quote:

Originally Posted by

>
>
FYI
>
"Kevin Spencer"
>

Quote:

Originally Posted by

>ASP.Net requires a web server


>
Not really - just a process to handle:
>
HttpRuntime.ProcessRequest Method
Drives all ASP.NET Web processing execution
>

Quote:

Originally Posted by

>running the ASP.Net ISAPI to work. It is
>HTTP-Protocol-based, and can not be
>run as a file-based web.
>>


>
Well it all depends on what your goal is:
perhaps a sales CD (etc.) that looks like
it is using a "web server", or whatever!
>
Anyway here are two oldies but goodies:
>
"HTML is often thought of as the sole
domain for Web applications. But HTML's
versatile display attributes are also
very useful for handling data display of
all sorts in desktop applications. "
>
Hosting the ASP.Net Runtime in desktop applications
http://www.west-wind.com/presentati...pnetruntime.asp
>
Executing ASPX pages without a web server
http://radio.weblogs.com/0105476/st...AWebServer.html
>
>
>
>