I worked out that i needed to sort by ID (ORDER BY) in the readers SQL statement. The reader will cycle through all the records and the last ID will be saved to my variable. Thanks for replying though maytel
Hi,
I'm having trouble retrieving an ID field from records I insert into an Access database. The record inserts fine, but then when I read the database again, even if i create new oledb connection and command objects, it doesn't add the new record to the reader, but when i open the database...
Well, obviously my "improved" solution was flawed. So I thought I should post the script I ended up with, tested and complete:
<script runat="server" language="VB">
Sub Page_Load(Sender as Object, e as EventArgs)
Dim sHost as String
Dim sPath as String
Dim iStart as Integer...
ok...ummm made it a bit more efficient:
<script runat="server" language="VB">
Sub Page_Load(Sender as Object, e as EventArgs)
Dim sHost as String
Dim sPath as String
sHost = Request.URL.Host
If sHost <> "xyz123.com.au" Then
Response.Redirect("http://" & sHost &...
Found the object almost immediately after posting haha, thx anyway. If you're interested, this is what I was trying to achieve - a simple redirection script for multiple sites hosted within subfolders of a domain (using aliases):
<script runat="server" language="VB">
Sub Page_Load(Sender as...
Hey,
I'm pretty new to the whole web development side of things. Now, the problem is, i have the code, i just need a page property (the URL) to continue. Here is my code:
<script runat="server" language="VB">
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs)...
Like I've already stated, there is return type, void if you like. There is no problem with the class when it is added as an item to the project, it is when I try and reference the dll file it is contained in externally that I get the problem. Am I making any sense at all?
Ok, I tried rebuilding the dll file and the new project and that had no positive effect.
The procedures I am trying to call are just straight forward procedures, don't return any values, only starts or stops services. When it gets to those procedure, the processing stops and gives a warning...
Hi,
I have built a dll file, and created a reference to it in a new project. Now when I go to run my new project, whenever it references the class from the DLL file I get an InvalidCastException. This doesn't happen if I add the class as an existing item to my new project, only when I...
Hi,
I was wondering if there is a way to refresh the icons in the system tray. If I kill the process, the icon stays in the taskbar until i wave the mouse pointer over it, then it disappears, even though the process has been killed. If I exit through right clicking on the icon in the taskbar it...
Hi,
I have a Western Digital HD(WDC WD800BB) that crashed recently, I have put it as a slave to a new HD to try and recover or get it working somehow. It shows up in bios as the slave drive, and even shows up as a disk drive in Device Manager, but when I click on Disk Management it freezes my...
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbcon/html/vbconintroductiontothedatagridcontrol.asp
There are links on this page also that will take you as far in depth to knowing the Datagrid control as you want. I strongly suggest you check out the MSDN online before asking...
You've showed the code for opening a connection and navigating to the first record in the table. Where do you populate the datagrid? Are you populating the datagrid with code or using the GUI?
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.