The conversion of a char data type to a datetime data type resulted in an out-of-range ...

Hi,
I couldn't understand why I can′t convert the date. I use dd/mm/yyyy, and I put the correct sintax in my code:

CType(tbVencimento.Text,Date)
but it conti nues recording inside of my database like mm/dd/yyyy, why?
and every moment I receive this error message:

The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.
The statement has been terminated.

Please, help!
Thanks a lot!
Raphael Amador

You should use DateTime.ParseExact to get the format changed.
Dim s As String
s = "25/12/2005"
Dim d As DateTime
d = DateTime.ParseExact(s, "dd/MM/yyyy", Nothing)
Then when it is inserted into the Sql, since it is coming from a DateTime object, the format will be correct and you won't get the out-of-range value error. And it will show as mm/dd/yyyy format as 12/25/2005.
bill
Hi, I tried:

<%@dotnet.itags.org.PageLanguage="VB" %>

<%@dotnet.itags.org.ImportNamespace="System.Data" %>

<%@dotnet.itags.org.ImportNamespace="System.Data.SQLClient" %>

<!DOCTYPEhtmlPUBLIC"-//W3C//DTD XHTML 1.1//EN""http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">

<scriptrunat="server">

ProtectedSub Page_Load(ByVal senderAsObject,ByVal eAs System.EventArgs)

tbLiquido.Text =CType(tbTotNF.Text,Decimal) -CType(tbDesconto.Text,Decimal)

lblIData.Text =CDate(Today)

EndSub

ProtectedSub ddlClientes_SelectedIndexChanged(ByVal senderAsObject,ByVal eAs System.EventArgs)

Dim SQLAsString ="Select CODCLI, RAZAO, ENDERECO, ESTADO FROM CLIENTES WHERE CODCLI = '" & ddlClientes.SelectedItem.Value &"'"

Dim Conex?oAs SqlConnection =New SqlConnection("Data Source=SERV-IPE2;Initial Catalog=IpeSys;Persist Security Info=True;User ID=ASPNET;Password=IpeSys")

Dim ComandoSQLAsNew SqlCommand(SQL, Conex?o)

Conex?o.Open()

Dim drAs SqlDataReader

dr = ComandoSQL.ExecuteReader(System.Data.CommandBehavior.CloseConnection)

dr.Read()

tbENDERECO.Text = dr("ENDERECO")

tbESTADO.Text = dr("ESTADO")

Conex?o.Close()

EndSub

ProtectedSub Gravar_Click(ByVal senderAsObject,ByVal eAs System.EventArgs)

Dim SQLAsString ="Insert into RECEBER(NFNUMERO_receber, EMPRESA_receber, TIPOFAT_receber, EMISSAO_receber, CODCLI_receber, CLIENTE_receber, ENDERECO_receber, ESTADO_receber, TOTALNOTA_receber, VENCIMENTO_receber, BANCO_receber, CCdoBANCO_receber, DESCONTO_receber, LIQUIDO_receber, SALDOREC_receber,IUSER_receber, IDATE_receber) values (" &CType(tbNOTAFISCAL.Text,Decimal) &",'" & ddlEmpresa.SelectedValue &"','" & rblTipoFat.SelectedValue &"','" &CType(tbDataEmissao.Text, DateTime) &"','" & ddlClientes.SelectedItem.Value &"','" & ddlClientes.SelectedItem.Text &"','" & tbENDERECO.Text &"','" & tbESTADO.Text &"','" &CType(tbTotNF.Text,Decimal) &"','" &CType(tbVencimento.Text, DateTime) &"','" & ddlBancoCob.SelectedItem.Text &"','" & ddlBancoCCorrente.SelectedItem.Text &"','" &CType(tbDesconto.Text,Decimal) &"','" &CType(tbLiquido.Text,Decimal) &"','" &CType(tbLiquido.Text,Decimal) &"','" & lblIUSER.Text &"','" &CType(lblIData.Text,Date) &"')"

Dim Conex?oAs SqlConnection =New SqlConnection("Data Source=SERV-IPE2;Initial Catalog=IpeSys;Persist Security Info=True;User ID=ASPNET;Password=IpeSys")

Dim ComandoSqlAsNew SqlCommand(SQL, Conex?o)

Conex?o.Open()

Dim sAsString

s ="25/12/2005"

Dim dAs DateTime

d = DateTime.ParseExact(s,"dd/MM/yyyy",Nothing)

ComandoSql.ExecuteNonQuery()

Conex?o.Close()

Response.Redirect("Lista.aspx")

EndSub

ProtectedSub CancelButton_Click(ByVal senderAsObject,ByVal eAs System.EventArgs)

Response.Redirect("Lista.aspx")

EndSub


But I have the same problem with the out-of-range error. Can you explain me more about your code??
Thanks a lot.
Raphael

Hi, I tried:

<%@dotnet.itags.org.PageLanguage="VB" %>

<%@dotnet.itags.org.ImportNamespace="System.Data" %>

<%@dotnet.itags.org.ImportNamespace="System.Data.SQLClient" %>

<!DOCTYPEhtmlPUBLIC"-//W3C//DTD XHTML 1.1//EN""http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">

<scriptrunat="server">

ProtectedSub Page_Load(ByVal senderAsObject,ByVal eAs System.EventArgs)

tbLiquido.Text =CType(tbTotNF.Text,Decimal) -CType(tbDesconto.Text,Decimal)

lblIData.Text =CDate(Today)

EndSub

ProtectedSub ddlClientes_SelectedIndexChanged(ByVal senderAsObject,ByVal eAs System.EventArgs)

Dim SQLAsString ="Select CODCLI, RAZAO, ENDERECO, ESTADO FROM CLIENTES WHERE CODCLI = '" & ddlClientes.SelectedItem.Value &"'"

Dim Conex?oAs SqlConnection =New SqlConnection("Data Source=SERV-IPE2;Initial Catalog=IpeSys;Persist Security Info=True;User ID=ASPNET;Password=IpeSys")

Dim ComandoSQLAsNew SqlCommand(SQL, Conex?o)

Conex?o.Open()

Dim drAs SqlDataReader

dr = ComandoSQL.ExecuteReader(System.Data.CommandBehavior.CloseConnection)

dr.Read()

tbENDERECO.Text = dr("ENDERECO")

tbESTADO.Text = dr("ESTADO")

Conex?o.Close()

EndSub

ProtectedSub Gravar_Click(ByVal senderAsObject,ByVal eAs System.EventArgs)

Dim SQLAsString ="Insert into RECEBER(NFNUMERO_receber, EMPRESA_receber, TIPOFAT_receber, EMISSAO_receber, CODCLI_receber, CLIENTE_receber, ENDERECO_receber, ESTADO_receber, TOTALNOTA_receber, VENCIMENTO_receber, BANCO_receber, CCdoBANCO_receber, DESCONTO_receber, LIQUIDO_receber, SALDOREC_receber,IUSER_receber, IDATE_receber) values (" &CType(tbNOTAFISCAL.Text,Decimal) &",'" & ddlEmpresa.SelectedValue &"','" & rblTipoFat.SelectedValue &"','" &CType(tbDataEmissao.Text, DateTime) &"','" & ddlClientes.SelectedItem.Value &"','" & ddlClientes.SelectedItem.Text &"','" & tbENDERECO.Text &"','" & tbESTADO.Text &"','" &CType(tbTotNF.Text,Decimal) &"','" &CType(tbVencimento.Text, DateTime) &"','" & ddlBancoCob.SelectedItem.Text &"','" & ddlBancoCCorrente.SelectedItem.Text &"','" &CType(tbDesconto.Text,Decimal) &"','" &CType(tbLiquido.Text,Decimal) &"','" &CType(tbLiquido.Text,Decimal) &"','" & lblIUSER.Text &"','" &CType(lblIData.Text,Date) &"')"

Dim Conex?oAs SqlConnection =New SqlConnection("Data Source=SERV-IPE2;Initial Catalog=IpeSys;Persist Security Info=True;User ID=ASPNET;Password=IpeSys")

Dim ComandoSqlAsNew SqlCommand(SQL, Conex?o)

Conex?o.Open()

Dim sAsString

s ="25/12/2005"

Dim dAs DateTime

d = DateTime.ParseExact(s,"dd/MM/yyyy",Nothing)

ComandoSql.ExecuteNonQuery()

Conex?o.Close()

Response.Redirect("Lista.aspx")

EndSub

ProtectedSub CancelButton_Click(ByVal senderAsObject,ByVal eAs System.EventArgs)

Response.Redirect("Lista.aspx")

EndSub


But I have the same problem with the out-of-range error. Can you explain me more about your code??
Thanks a lot.
Raphael

The conversion of a char data type to a datetime data type resulted in an out-of-range dat

getting this error - i think its because im trying to put english date
format into american date format
(asp to sql server 2000)

im getting the date using
mortsourcedlabel.Text = Date.Today
mortsourcedlabel.Visible = True
mortsourced.Visible = False

which throws the date out (in uk format) to 13/02/2004 - all well and good
but -
im assuming that its going out of range as sql needs 02/13/2004
heh im guessing ive been testing code the past 2 weeks -- and now its the
13th which has now thrown up the error!
how do i change the date format not in the code above (i still need to see
the date in english-UK format on the page) but before the sql statement
(maybe in my stored procedure?)
thanks

marknm i sussed it with :-

Dim msl As String = mortsourcedlabel.Text.ToString ' date
Dim day, month, year As String
If mortsourcedlabel.Text.ToString = "" Then
msl = "01/01/1900"
Else
Dim mydate As Date
mydate = mortsourcedlabel.Text.ToString
day = mydate.Day.ToString
month = mydate.Month.ToString
year = mydate.Year.ToString
msl = month + "/" + day + "/" + year
End If

cheers

mark

The conversion of a char data type to a datetime data type resulted....

Hi,

I'm trying to insert a date time value into a SQL Server Database field of type date time using a c# web form.
I get the following error...
"The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value. The statement has been terminated"

My SQL looks like this:

INSERT INTO tblname (fldname) VALUES ('" + DateTime.Now.ToString() + "')"

What am I doing wrong?Remove the ToString() method as that is changing the DateTime type to a string (or Char type) ...at least thats what it looks like.
Nope sorry to say that didn't work.

My C# now looks like

SqlConnection myConn = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["eTeam_ConnectionString"].ToString());
string mySQL = "INSERT INTO tblname (datestamp) VALUES ('" + DateTime.Now + "')";
SqlCommand myCMD = new SqlCommand(mySQL, myConn);
myConn.Open();
myCMD.ExecuteNonQuery();
myConn.Close();
myCMD.Dispose();
myConn.Dispose();

And the field 'datestamp' is a SQL Server Data Type datetime

Anyone else?
You can use getDate() method of SQL server to update date.

INSERT INTO tblname (datestamp) VALUES (getDate())";
Thanks for that - definately half way to solving my problem.
What if I need to take a value from an ASP:Calendar control?
Is there a ToDate() function that will convert it as required?
You can use

Calendar1.SelectedDate.ToShortDateString())

which will convert this date into short date format.

The dreaded asp.clipboard

Hello all

I have the need to copy something to the clipboard via 3rd party type library and then pick it up on the .NET side via the clipboard (all server-side). To complicate the issue, the application needs to be web oriented (ASP.NET)

I have a console version that work, but I can't seem to get the ASP side working. I have included the Forms assembly and I'm able to write to the clipboard via the 3rd party, but the clipboard is always unassigned (null) in ASP.NET when in fact the clipboard can be pasted into PhotoShop

I've searched a lot of articles about this issue. Some suggest that it's a permissions issue. To rule out permissions, I have the site impersonate. The impersonating identity is myself and since I can past into Photoshop, I can only assume my identity has access to the clipboard

Any insight is appreciated

Thanks
Bilthis is a permissions issue. your aspnet account needs permission to
manipulate system resources on the desktop

--
Regards,
Alvin Bruney
[ASP.NET MVP http://mvp.support.microsoft.com/default.aspx]
Got tidbits? Get it here... http://tinyurl.com/27cok
"Bill Belliveau" <anonymous@.discussions.microsoft.com> wrote in message
news:06D644D5-E7C1-47D1-97AC-826157A1BFA2@.microsoft.com...
> Hello all,
> I have the need to copy something to the clipboard via 3rd party type
> library and then pick it up on the .NET side via the clipboard (all
> server-side). To complicate the issue, the application needs to be web
> oriented (ASP.NET).
> I have a console version that work, but I can't seem to get the ASP side
> working. I have included the Forms assembly and I'm able to write to the
> clipboard via the 3rd party, but the clipboard is always unassigned (null)
> in ASP.NET when in fact the clipboard can be pasted into PhotoShop.
> I've searched a lot of articles about this issue. Some suggest that it's
> a permissions issue. To rule out permissions, I have the site
> impersonate. The impersonating identity is myself and since I can past
> into Photoshop, I can only assume my identity has access to the clipboard.
> Any insight is appreciated.
> Thanks,
> Bill
Alvin,
Thanks for the response

Maybe I'm missing something else then. Before impersionation I tried setting the processModel user to SYSTEM, and had the same problem. I have also added the ASPNET account to the 'run as part of the operation system' policy with no luck

When I call, clipboardData.GetDataPresent(DataFormats.Bitmap) the exception being returned is null object (Object reference not set to an instance of an object.). The most likely cause is permissions, but as far as I can tell I've tried giving the adequate permissions - or am I missing something

Thanks again
Bill
can you impersonate to an authenticated user and see if this works?

Otherwise post your code and i'll work with you on it

--
Regards,
Alvin Bruney
[ASP.NET MVP http://mvp.support.microsoft.com/default.aspx]
Got tidbits? Get it here... http://tinyurl.com/27cok
"Bill Belliveau" <anonymous@.discussions.microsoft.com> wrote in message
news:C8A65D45-FCD3-4871-A822-79EA22F5E7A7@.microsoft.com...
> Alvin,
> Thanks for the response.
> Maybe I'm missing something else then. Before impersionation I tried
> setting the processModel user to SYSTEM, and had the same problem. I have
> also added the ASPNET account to the 'run as part of the operation system'
> policy with no luck.
> When I call, clipboardData.GetDataPresent(DataFormats.Bitmap) the
> exception being returned is null object (Object reference not set to an
> instance of an object.). The most likely cause is permissions, but as far
> as I can tell I've tried giving the adequate permissions - or am I missing
> something?
> Thanks again.
> Bill

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
>
>
>
>