|
You can't use a DataReader for Forward/Backward navigation. It's a forward-only reader.
You'll have to use a DataAdapter and DataSet for this.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Ok, Can you send me any link for that?
Thanks 
|
|
|
|
|
All you have to do is search the articles...
Here[^], this article explains the concepts quite well, though the code is in C#, it's easily convertible to VB.NET.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Hi.
You can not use DataReader for backward reading. You can use disconnected DB.
To use that you can use DataSets and DataAdapters.
Here is a quick and simple tutorial:
http://www.csharp-station.com/Tutorials/AdoDotNet/Lesson05.aspx
The tutorial is in C# but the syntax is similar to VB.NET.
Have fun.
HL
|
|
|
|
|
when a sentence is written in text box with space in every word ,, how to break the sentence for each (space event)word and send it to the next texbox followed in VB application ?
dinu
|
|
|
|
|
if im getting ur question right u can do this in following way:
>> keypress event of text box1
if chr(keyascii) = " " then
text2.setfocus
end if
write the same code in key press event of each textbox and set focus to next text box
Noshaba
|
|
|
|
|
Your question is difficult to understand. You can split your senesce like this
Dim words() As String = Split(TextBox1.Text, " ")
and get each word like this
Textbox2.Text = words(0)<br />
Textbox2.Text = words(1)
Chatura from Pearl of the Indian Ocean
|
|
|
|
|
Dear friends,
How can I zip a folder from my vb6 program. so that I can attach it to the mail which I am sending through the program. Please give me the sample code how can I send a folder which content a lot of picture by email through the vb6 program.
Your quick response will be highly appreciated.
Thanks
Murtuza Patel.
|
|
|
|
|
If you want code handed to you, a little Google goes a long way...
http://www.codeguru.com/vb/gen/vb_graphics/fileformats/article.php/c6743/[^]
VB6 doesn't have anything in it that will do this natively, so you have to have some kind of library to di it for you, or implement your own. Using someone elses library would be FAR quicker.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
-- modified at 9:03 Saturday 18th March, 2006
|
|
|
|
|
Hi to all,
I created an window explorer application.For the enhancement of features , I want to create the password for the file or folder on right clicking the node.Can somebody send me any link or code.
Thanks 
|
|
|
|
|
You have to provide more information for someone to be able to help you.
You have described something that uses a password, but not what the password is supposed to be used for. Is it supposed to protect the file or folder, or what? What specifically is it that you need help with? Creating a password? Store a password somewhere? Handle password protection? Handling the event of right clicking?
---
b { font-weight: normal; }
|
|
|
|
|
Hi,
I mean , if the user applies the password on any file or folder then next time the security get maintained for the
later.User should be able to open that file or folder if
correct password is typed .I want that kind of program in vb.net.
If you can send any code or link.
I am in urgent need of it.
Thanks
|
|
|
|
|
What you're thinking of has been asked a dozen times before...
You can't do this without a black-belt in writing NTFS Filesystem Extensions. You can't attach a password to a folder. It's just not practical because it's a huge pain to administer. Protecting the contents of a folder is what NTFS permissions is for.
You CAN, however, do something along the lines of how Windows XP handles .ZIP files. You can double-click any .ZIP file and XP/2003 will treat it as though it's a folder. Password protected .ZIP's are, however, not supported. This would require you to write a Shell Extension. Again, not for the faint of heart or weak in COM Interop skills.
Looking at your post history tells me that you're nowhere near understanding Shell and NTFS internals enough to pull either of these things off.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Can you send me any link?
Thanks
|
|
|
|
|
Hi all,
does any one knows whats is equivalent to this code in mysql to ms sql
datetimeInDatabase > DATE_SUB('"& datetime.now() &"',INTERVAL 1 HOUR);"
background:
user clicks submit and the date gets stored in the database.
if the user have click send in last 1 hour (i check the datetime entered in db (e.g datetimeInDatabase) i dont want to add it to database. if i use above sql and run in ms sql it gives me exception so i am thinking the sql is wrong and need to convert to ms sql.
please help
thanks
robin
|
|
|
|
|
Yes the TSQL is malformed. Lookup the DATEDIFF() and GETDATE() functions in the SQL Books Online (or Google them - it'll be faster).
BTW, is this 'online dating' service you are writing a commercial venture or just something you are playing around with?
...Steve
1. quod erat demonstrandum
2. "Give a man a fish and you've fed him for a day. Teach him how to fish and you've fed him for life." I read that somewhere once
(Translation: I'll show you the way, but not write the code for you.)
|
|
|
|
|
Yeah i am building one but not to play around. once the site is fully functional i might deploy it and show them to potential buyers can you please tell me why u asking me? happy to answer honestly.
|
|
|
|
|
I'm asking because quite frankly the type and number of questions you are asking about programming indicate that you have little experience doing so.
This in itself is not a problem as we all had to start somewhere, but if you are building an app for commercial use - whether for an employer or for sale to potential customers - you really should be reading up more on the tools you use to construct it. BTW are there not too many 'dating websites' out there already (i.e. what makes your application more attractive to potential clients than those already on the market)?
Many of the questions so far would have quite easily been solved with a brief reading of the relevant parts of said manuals - which are provided with Visual Studio and are freely searchable online.
This is the reason that I have been a bit short in my answers to your questions. I firmly believe that one should exhaust all other avenues for resolution before posting on this board. You are by no means "Robinson Crusoe" and others have also trod this same line. If I, or anyone else, simply posts the answer, you'll never get the experience of researching it for yourself.
My aim is to help people help themselves wrt programming - hence my signature lines.
All the best in your venture.
...Steve
1. quod erat demonstrandum
2. "Give a man a fish and you've fed him for a day. Teach him how to fish and you've fed him for life." I read that somewhere once
(Translation: I'll show you the way, but not write the code for you.)
|
|
|
|
|
I am new to using delegates and am getting "Error Binding To Target Method" error on the CreateDelegate line. What am I doing wrong? Thanks in Advance.
Private Sub Form1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Dim sTest As String = "MyTest"
Dim test As ToolStripMenuItem
Dim currentType As Type = Me.GetType
Dim method As MethodInfo
Dim delTest As [Delegate]
method = currentType.GetMethod(sTest)
If Not method Is Nothing Then
MsgBox(method.Name)
delTest = CreateDelegate(GetType(EventHandler), method)
test = New ToolStripMenuItem("Testing", Nothing, delTest)
Else
test = New ToolStripMenuItem("Testing")
End If
MyBase.mnuMain.Items.Add(test)
End Sub
Public Sub MyTest(ByVal sender As Object, ByVal e As EventArgs)
MsgBox("testing")
End Sub
|
|
|
|
|
This isn't working because, for some reason, MyTest's signature doesn't match the signature of EventHandler.
You'll run into another problem after that one's fixed. The method you're binding the delegate to must be a Shared method (Static in C#).
Imports System.Reflection
Imports System.Delegate
.
.
.
Public Shared Sub MyTest(ByVal sender As Object, ByVal e As EventArgs)
MsgBox("Testing...")
End Sub
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
|
Hi Below is my query that i am trying to run
-------
SELECT ProfileID FROM profiles WHERE ProfileStatusID=2 ORDER BY ProfileID DESC LIMIT 0, 3;
-------
ms sql server doesnt understand limit so i dont know how can i modify my query which gives me same result. many thanks in forward.
robin
|
|
|
|
|
The amount of questions you are posting on this board show that you really should RTFM a whole lot more.
Simple really - use the SELECT TOP function. You'll find a reference to it in the SQL Books Online (you ahve installed them havn't you) 
...Steve
1. quod erat demonstrandum
2. "Give a man a fish and you've fed him for a day. Teach him how to fish and you've fed him for life." I read that somewhere once
(Translation: I'll show you the way, but not write the code for you.)
|
|
|
|
|
what is RTFM? i know selecting top rows but i was just confused whether it produces the same effect as it did by mysql.
|
|
|
|
|
RTFM[^] on Wikipedia...Enjoy! 
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
