extreme basics: cant

Showing posts with label cant. Show all posts

Monday, March 26, 2012

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

Thursday, March 22, 2012

The file exist but cant delete on server (c#)

Hi all, have an c# page that allows users to uploaded files to the server. I was hoping to also hoping to allow users to delete files aswell. I have the following code, but it dose no delete the file, even though it can find the file (the response.write outputs). Here is my code:

if(File.Exists(sPhysicalPath + @dotnet.itags.org."\" + sOrgFileName)){
Response.Write("delete");
File.Delete(sPhysicalPath + @dotnet.itags.org."" + sOrgFileName);
}

Any suggestions appreciated.

Thanks,

Hi,

by default, and for security reasons, ASP.NET doesn't have the privileges to perform IO actions like deleting a file. You can create a new windows user account that has the same privileges as the ASP.NET account and augment it with the needed privileges to delete certain files on the disk. After that you can impersonate your application with that new account by setting, in the web.config of your application, the<identity impersonate="true" userName="yournewaccount" />

Grz, Kris.

the first disappointing thing I find in ASP.NET

I cant believe thath with ASP.NET we loose the ability to make POST
requests to another webforms in another application...
I say this because of my last question "Redirect by POST method to another
applications" , which had two answers, but none of them so simple like in
the old ASP:
<form name="form2" method="post"
action="http://anotherServer/anotherApp/anotherForm.aspx">
<input name="user" type="text" id="user"/>
<input name="password" type="password" id="password" />
</form>
Any opinions?As a general rule for this or any other forum, you need to say "I"m using
1.1" or "I'm using 2.0".
This situation has been addressed in Asp.Net 2.0.
Are you using 1.1 or 2.0?
"gustav" <gustavo@.webserver.com.ar> wrote in message
news:uWgGk59aHHA.960@.TK2MSFTNGP03.phx.gbl...
> I cant believe thath with ASP.NET we loose the ability to make POST
> requests to another webforms in another application...
> I say this because of my last question "Redirect by POST method to another
> applications" , which had two answers, but none of them so simple like in
> the old ASP:
> <form name="form2" method="post"
> action="http://anotherServer/anotherApp/anotherForm.aspx">
> <input name="user" type="text" id="user"/>
> <input name="password" type="password" id="password" />
> </form>
> Any opinions?
>
http://www.codeproject.com/aspnet/PostToAnotherPage.asp
"gustav" <gustavo@.webserver.com.ar> wrote in message
news:uWgGk59aHHA.960@.TK2MSFTNGP03.phx.gbl...
> I cant believe thath with ASP.NET we loose the ability to make POST
> requests to another webforms in another application...
> I say this because of my last question "Redirect by POST method to another
> applications" , which had two answers, but none of them so simple like in
> the old ASP:
> <form name="form2" method="post"
> action="http://anotherServer/anotherApp/anotherForm.aspx">
> <input name="user" type="text" id="user"/>
> <input name="password" type="password" id="password" />
> </form>
> Any opinions?
>
PS
I'd change careers before going back to ASP.
I know I (like we all did) thought it was

in 1997, but man, its like
pulling teeth even looking at it with Asp.Net 2.0 in existence.
..
"gustav" <gustavo@.webserver.com.ar> wrote in message
news:uWgGk59aHHA.960@.TK2MSFTNGP03.phx.gbl...
> I cant believe thath with ASP.NET we loose the ability to make POST
> requests to another webforms in another application...
> I say this because of my last question "Redirect by POST method to another
> applications" , which had two answers, but none of them so simple like in
> the old ASP:
> <form name="form2" method="post"
> action="http://anotherServer/anotherApp/anotherForm.aspx">
> <input name="user" type="text" id="user"/>
> <input name="password" type="password" id="password" />
> </form>
> Any opinions?
>
using 1.1, cantt migrate to 2.0 yet ( in my first message it said ASP.NET
1.1)
"sloan" <sloan@.ipass.net> escribi en el mensaje
news:%23Bo7uA%23aHHA.4552@.TK2MSFTNGP05.phx.gbl...
> As a general rule for this or any other forum, you need to say "I"m using
> 1.1" or "I'm using 2.0".
> This situation has been addressed in Asp.Net 2.0.
> Are you using 1.1 or 2.0?
>
>
> "gustav" <gustavo@.webserver.com.ar> wrote in message
> news:uWgGk59aHHA.960@.TK2MSFTNGP03.phx.gbl...
>
"sloan" <sloan@.ipass.net> wrote in message
news:%23ga%23BC%23aHHA.4000@.TK2MSFTNGP02.phx.gbl...

> I'd change careers before going back to ASP.
> I know I (like we all did) thought it was

in 1997, but man, its like
> pulling teeth even looking at it with Asp.Net 2.0 in existence.
You'll be saying exactly the same thing about ASP.NET 2 in 10 years...
asp.net 1.1 only allows one form with runat server and render the
current page as target. the only way to override this is with
javascript. you can other forms with different targets, just without the
runat=server, which is just as easy as asp.
-- bruce (sqlwork.com)
gustav wrote:
> I cant believe thath with ASP.NET we loose the ability to make POST
> requests to another webforms in another application...
> I say this because of my last question "Redirect by POST method to another
> applications" , which had two answers, but none of them so simple like in
> the old ASP:
> <form name="form2" method="post"
> action="http://anotherServer/anotherApp/anotherForm.aspx">
> <input name="user" type="text" id="user"/>
> <input name="password" type="password" id="password" />
> </form>
> Any opinions?
>
"gustav" <gustavo@.webserver.com.ar> wrote in message
news:uWgGk59aHHA.960@.TK2MSFTNGP03.phx.gbl...
> I cant believe thath with ASP.NET we loose the ability to make POST
> requests to another webforms in another application...
> I say this because of my last question "Redirect by POST method to another
> applications" , which had two answers, but none of them so simple like in
> the old ASP:
> <form name="form2" method="post"
> action="http://anotherServer/anotherApp/anotherForm.aspx">
> <input name="user" type="text" id="user"/>
> <input name="password" type="password" id="password" />
> </form>
> Any opinions?
>
One possible work around in some situations is you can use the override
render to change to action on the form as follows.
Protected Overrides Sub Render(ByVal writer As HtmlTextWriter)
Dim _stringBuilder As StringBuilder = New StringBuilder()
Dim _stringWriter As StringWriter = New StringWriter(_stringBuilder)
Dim _htmlWriter As HtmlTextWriter = New HtmlTextWriter(_stringWriter)
MyBase.Render(_htmlWriter)
Dim html As String = _stringBuilder.ToString()
Dim start As Integer = html.IndexOf("action=")
if start <> -1 then
html = html.Insert(start + 8, "someother place to post")
end if
writer.Write(html)
End Sub
You're probably right.
But ...
<include > files (and source safing this with the vss "share" function)
and no OO. Rough stuff.
"Mark Rae" <mark@.markNOSPAMrae.com> wrote in message
news:%23A3dcS%23aHHA.4772@.TK2MSFTNGP05.phx.gbl...
> "sloan" <sloan@.ipass.net> wrote in message
> news:%23ga%23BC%23aHHA.4000@.TK2MSFTNGP02.phx.gbl...
>
like
> You'll be saying exactly the same thing about ASP.NET 2 in 10 years...
>
"gustav" <gustavo@.webserver.com.ar> wrote in message
news:uWgGk59aHHA.960@.TK2MSFTNGP03.phx.gbl...
> I cant believe thath with ASP.NET we loose the ability to make POST
> requests to another webforms in another application...
> I say this because of my last question "Redirect by POST method to another
> applications" , which had two answers, but none of them so simple like in
> the old ASP:
> <form name="form2" method="post"
> action="http://anotherServer/anotherApp/anotherForm.aspx">
> <input name="user" type="text" id="user"/>
> <input name="password" type="password" id="password" />
> </form>
> Any opinions?
>
Another option is to build an html form without the runat tag and use
placeholders to fill the variable data into the form
Mike

the first disappointing thing I find in ASP.NET

I cant believe thath with ASP.NET we loose the ability to make POST
requests to another webforms in another application...

I say this because of my last question "Redirect by POST method to another
applications" , which had two answers, but none of them so simple like in
the old ASP:

Any opinions?As a general rule for this or any other forum, you need to say "I"m using
1.1" or "I'm using 2.0".

This situation has been addressed in Asp.Net 2.0.

Are you using 1.1 or 2.0?

"gustav" <gustavo@.webserver.com.arwrote in message
news:uWgGk59aHHA.960@.TK2MSFTNGP03.phx.gbl...

Quote:

Originally Posted by

I cant believe thath with ASP.NET we loose the ability to make POST
requests to another webforms in another application...
>
I say this because of my last question "Redirect by POST method to another
applications" , which had two answers, but none of them so simple like in
the old ASP:
>
<form name="form2" method="post"
action="http://anotherServer/anotherApp/anotherForm.aspx">
<input name="user" type="text" id="user"/>
<input name="password" type="password" id="password" />
</form>
>
Any opinions?
>
>

http://www.codeproject.com/aspnet/PostToAnotherPage.asp
"gustav" <gustavo@.webserver.com.arwrote in message
news:uWgGk59aHHA.960@.TK2MSFTNGP03.phx.gbl...

Quote:

Originally Posted by

I'd change careers before going back to ASP.

I know I (like we all did) thought it was cool in 1997, but man, its like
pulling teeth even looking at it with Asp.Net 2.0 in existence.

...

"gustav" <gustavo@.webserver.com.arwrote in message
news:uWgGk59aHHA.960@.TK2MSFTNGP03.phx.gbl...

Quote:

Originally Posted by

using 1.1, cantt migrate to 2.0 yet ( in my first message it said ASP.NET
1.1)

"sloan" <sloan@.ipass.netescribi en el mensaje
news:%23Bo7uA%23aHHA.4552@.TK2MSFTNGP05.phx.gbl...

Quote:

Originally Posted by

As a general rule for this or any other forum, you need to say "I"m using
1.1" or "I'm using 2.0".
>
This situation has been addressed in Asp.Net 2.0.
>
Are you using 1.1 or 2.0?
>
>
>
>
"gustav" <gustavo@.webserver.com.arwrote in message
news:uWgGk59aHHA.960@.TK2MSFTNGP03.phx.gbl...

Quote:

Originally Posted by

>I cant believe thath with ASP.NET we loose the ability to make POST
>requests to another webforms in another application...
>>
>I say this because of my last question "Redirect by POST method to
>another
>applications" , which had two answers, but none of them so simple like in
>the old ASP:
>>
><form name="form2" method="post"
>action="http://anotherServer/anotherApp/anotherForm.aspx">
> <input name="user" type="text" id="user"/>
> <input name="password" type="password" id="password" />
></form>
>>
>Any opinions?
>>
>>

>
>

"sloan" <sloan@.ipass.netwrote in message
news:%23ga%23BC%23aHHA.4000@.TK2MSFTNGP02.phx.gbl.. .

Quote:

Originally Posted by

I'd change careers before going back to ASP.
>
I know I (like we all did) thought it was cool in 1997, but man, its like
pulling teeth even looking at it with Asp.Net 2.0 in existence.

You'll be saying exactly the same thing about ASP.NET 2 in 10 years...
asp.net 1.1 only allows one form with runat server and render the
current page as target. the only way to override this is with
javascript. you can other forms with different targets, just without the
runat=server, which is just as easy as asp.

-- bruce (sqlwork.com)

gustav wrote:

Quote:

Originally Posted by

"gustav" <gustavo@.webserver.com.arwrote in message
news:uWgGk59aHHA.960@.TK2MSFTNGP03.phx.gbl...

Quote:

Originally Posted by

One possible work around in some situations is you can use the override
render to change to action on the form as follows.

Protected Overrides Sub Render(ByVal writer As HtmlTextWriter)

Dim _stringBuilder As StringBuilder = New StringBuilder()
Dim _stringWriter As StringWriter = New StringWriter(_stringBuilder)
Dim _htmlWriter As HtmlTextWriter = New HtmlTextWriter(_stringWriter)
MyBase.Render(_htmlWriter)

Dim html As String = _stringBuilder.ToString()
Dim start As Integer = html.IndexOf("action=")

if start <-1 then

html = html.Insert(start + 8, "someother place to post")
end if
writer.Write(html)

End Sub
"gustav" <gustavo@.webserver.com.arwrote in message
news:uWgGk59aHHA.960@.TK2MSFTNGP03.phx.gbl...

Quote:

Originally Posted by

Another option is to build an html form without the runat tag and use
placeholders to fill the variable data into the form

Mike
You're probably right.

But ...

<include files (and source safing this with the vss "share" function)

and no OO. Rough stuff.

"Mark Rae" <mark@.markNOSPAMrae.comwrote in message
news:%23A3dcS%23aHHA.4772@.TK2MSFTNGP05.phx.gbl...

Quote:

Originally Posted by

"sloan" <sloan@.ipass.netwrote in message
news:%23ga%23BC%23aHHA.4000@.TK2MSFTNGP02.phx.gbl.. .
>

Quote:

Originally Posted by

I'd change careers before going back to ASP.

I know I (like we all did) thought it was cool in 1997, but man, its

Quote:

Originally Posted by

Quote:

Originally Posted by

pulling teeth even looking at it with Asp.Net 2.0 in existence.

>
You'll be saying exactly the same thing about ASP.NET 2 in 10 years...
>
>

gustav wrote:

Quote:

Originally Posted by

That's just plain HTML, and it still works in ASP.NET.

Actually, if you want the post to take place in the browser, that's the
only way to do it.

Alternatively, if you want to post a request and handle the response in
the server code instead, you can use a HttpWebRequest object.

--
Gran Andersson
_____
http://www.guffa.com

Monday, March 26, 2012

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

Thursday, March 22, 2012

The file exist but cant delete on server (c#)

the first disappointing thing I find in ASP.NET

the first disappointing thing I find in ASP.NET

extreme basics

Blog Archive

About Me