Never mind, I found out what was wrong. It was the select statement, it didn't like the alias. I removed the alias and it works. Thanks for reading.
"select (bla...) as telephone_type
Hi,
I got this error from an ASP page when trying to update a recordset
(here is how I opened it:
rs.Open cmd, , adOpenDynamic, adLockBatchOptimistic)
-----ERROR -----------
Microsoft Cursor Engine error '80040e21'
Multiple-step operation generated errors. Check each status value...
Session_OnEnd is only fired when the session.abandon is called, ie when the session is ended. Closing the browser doesn't end the session since that action happens on the client side, so there is no way the server can tell, as a result your session is still there...
Hi all,
I have a form where users can enter some data and then submit. When they hit the browser's back button, I would like them to see the data they have entered and edit it. But, when they hit back, all the data in the textboxes is gone. How can I make the browser to cache all the imputs. Thanks
on code-behind page: 2 steps:
1)
Private Sub myDatalist_ItemDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.DataListItemEventArgs) Handles myDatalist.ItemDataBound
If e.Item.ItemType = ListItemType.EditItem Then...
It's easy. Just set it on your aspx page, something like this:
<asp:linkbutton CommandName="Update" Text="Update" Runat="server" ID="lbtnItemUpdate" CausesValidation="true" />
<asp:linkbutton CommandName="Cancel"...
Thanks George, for the inputs, but it still doesn't work.
I already had <authentication mode="Windows"/>
As for the username and password, I'm not sure since I'm using Visual FoxPro as the database.
My guess is it has something to do with the aspnet account on both machines A and B...
Hi all,
I have my asp.net application on machine A and trying to access to the database on machine B on the same network. Can someone help me on how to configure both machines to make this work?
Machine B already has ASPNET account which provides access rights.
I also have set
<identity...
you put the javascript code in your .aspx page. It's quite standard to use javascript with vb.net in ASP.Net. Afterall, the client-side script that ASP.NET uses is javascript.
cheers,
this is what I'm using, insert it into your HTML:
(note that "btnSubmit" is your submit button id)
<HEAD>
<script lang="Javascript">
function onkey()
{
if(window.event.keyCode==13){
document.getElementById("btnSubmit").focus();
}
}
</script>...
Hi there,
You need to set focus to the submit button. If your page has only one button, then the focus is set on that button by default, but if your page has several buttons, then it might be set to some other button.
Use javascript to set the focus on the desired button, but this doesn't work...
Hello,
I'm having problem calling stored procedures from Visual FoxPro database. I got the following exception error:
"System.Data.OleDb.OleDbException: Unrecognized command verb"
Here is my code snipet:
Dim oConn As OleDbConnection = New...
Hi all,
I want to implement an application which requires the users to log in the view several pages inside. To do this, I'm using session objects to keep track of the logged-in user between the pages. However I also see ASP.NET has the FormsAuthentication feature that seems to do the same job...
since you said "post anything", well then... :)
it's not the problem with your code. I had the same problem before. what I had was an input page and a submit button. everytime the refresh button is clicked, the focus goes to the submit button and the inputs are added to the database...
I found this article, I think it helps you:
http://www.devx.com/dotnet/Article/6999
according to this article, you can change your pc language setting through the control panel. (you'll need more research on how to do this).
As for culture setting, the setting should be "en-GB", not...
you can do it in 2 ways:
lblDate.Text = (FormatDateTime("{0:dd/MM/yyyy}", txtDate.Text)
OR use system threading like this:
Dim culture As CultureInfo = CultureInfo.CreateSpecificCulture("en-UK")
System.Threading.Thread.CurrentThread.CurrentCulture = culture...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.