|
|
Hi Group,
I need an Urgent Help.
I have been connecting my application to a remote mysql database(For development it is in lan only).
I fail to retrieve data from database
I have used this:
<br />
if rs.eof then<br />
rs.movefirst ' have also used rs.movelast<br />
else<br />
rs.movelast<br />
endif<br />
but it does not help.......
Tell me how to rectify it....
Thanks
Amit
amit mishra
|
|
|
|
|
you also need to check for rs.bof. If the recordset is empty (no rows returned) BOTH eof and bof will be true, and movefirst, movelast, movenext, moveprevious and move(bmk) will all return an error, sice there is no record to move to.
Absolute faith corrupts as absolutely as absolute power
Eric Hoffer
All that is necessary for the triumph of evil is that good men do nothing.
Edmund Burke
|
|
|
|
|
Can anyone tell me the code to select a datagrid row. Getting mixed up and any help would be greatly appreciated.
Example
Have the following rows in a datagrid.
EmpID Employee Department
1 Jones Accounts
2 Smith Sales
3 Green Sales
4 Ross Accounts
I want to select say emp ID 2.
What properties do I have to use to display
2, Smith and Sales onto 3 seperate variables.
I think it is something to do with the datagrid click but cannot work out how to assign the column values to a variable.
|
|
|
|
|
Worked it out. It is as follows
datagrid.Item(datagrid.CurrentRowIndex, 0)
|
|
|
|
|
datagrid1.tables(0).rows(2)
amanpreetsingh
|
|
|
|
|
Use the Select method of the DataGrid.
|
|
|
|
|
i need help with vb.net code for forward and back navigational buttons for a picturebox.the picturebox loads images and their associated text(the text files contain titles and refence nos.for the images) from a folder.their are actually two pairs.One forward and back pair of buttons is for navigating previously selected(loaded) images.the other pair of forward and back is for navigating the filed images startin from the currently selected image.
Also need code for searching for the images using their reference numbers or title.
|
|
|
|
|
Nzyimi wrote:
i need help with vb.net code for forward and back navigational buttons for a picturebox.
I take it you haven't written any code for this yet? Break the problem down into simpler parts. You have to maintain two lists of images for navigation. One list will be the "previously loaded" list. The other, the list of files in a particular directory. This is easy using an ArrayList. The buttons for forward and backward would just increment and decrement an index value pointing at the currently in-use indexes into those two arrays.
Nzyimi wrote:
Also need code for searching for the images using their reference numbers or title.
You must be mistaking us for RentACoder. We don't get paid to write code for other people here. We will help you with your code, not write it for you.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
sory 4 that cant rent a coder nywayz coz its skool project n live in Kenya,Africa.thanx 4 tip. do u have site i can get docs that might help.....in coding in VB.net
|
|
|
|
|
Nzyimi wrote:
its skool project
That's why we always say we will help with YOUR code.
Nzyimi wrote:
do u have site i can get docs that might help.....in coding in VB.net
MSDN - Visual Basic and Visual C#[^] The best place to look right now is in your books. Everything you need has been covered up to this point.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
besides pics my proj loads text(title and ref. no.)from textfiles in the folder containing the pics.the proj is supposed to search for pics using the title and ref no.i can only get it to search title(first line in the text file).any tips on how u can search for the ref no.
|
|
|
|
|
Maybe you should post your some sample code and a sample of the text file you are working with. Otherwise, it defeats the purpose of asking for help here.
|
|
|
|
|
this is the code for the open button(for opening the images and text files in the folder).
Imports System.IO
Public Class Form3
Inherits System.Windows.Forms.Form
Dim y As Integer = 0
Dim z As Integer = 0
Dim w As Integer = 0
Dim c As Integer = 0
Structure Imagefile
Public image As Bitmap
Public title As String
Dim text As String
End Structure
Dim x(16) As Imagefile
Private Sub MnuFileOpen_Click(ByVal sender As System.Object, ByVal e As System.EventArgs)
With OpenFileDialog1
With OpenFileDialog1
.Title = "choose a picture to display"
.ShowDialog()
PictureBox1.Image = Image.FromFile(.FileName)
End With
End With
Dim textfilename As String
textfilename = OpenFileDialog1.FileName
textfilename = StrReverse(textfilename)
textfilename = textfilename.Remove(0, 4)
If textfilename.StartsWith(".") Then
textfilename = textfilename.Remove(0, 1)
End If
textfilename = StrReverse(textfilename)
textfilename = textfilename & ".txt"
Dim fs As StreamReader
fs = File.OpenText(textfilename)
Richtextbox1.Text = fs.ReadToEnd
With x(c)
.image = PictureBox1.Image
End With
With x(y)
.text = Richtextbox1.Text
End With
c += 1
y += 1
End Sub
the part for back and forward buttons which navigate from the current file and move back and forward according to the filed images in the folder has defeated me.as in the back forward navigate according to the way they are arranged in the folder..some help
|
|
|
|
|
I'm having a problem understanding how to register Windows Shell extensions, specifically for PropertySheet extensions and their handlers.
I am not too happy with the way it's done here -
http://www.codeproject.com/cs/miscctrl/HadiPropertySheet.asp
- "Property Sheet Shell Extension in C#"
I think this can be done with PInvoke, rather than RegAsm.exe. Obviosuly, the batch file for putting the keys and appropriate GUID into the registry can be done in code (and would be less error-prone).
Also, can anyone direct me to an example in VB.NET for the same sort of thing that's described in that article? That is, a property sheet extension example.
Thanks for any help - Ian Thomas
|
|
|
|
|
You COULD code your own RegAsm to do this, but why reinvent the wheel?
RegAsm is used to register the assembly, it's classes and methods, with COM so the Shell knows where and how to get at the functions it needs to call when a Property page goes up. Since the .DLL needs some external application to kick off any of it's functions, including registration, how do you expect to get the .DLL regsitered without using an external program to do it, like RegAsm or an .MSI installer?
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Registration-less activation IS possible, but it's only supported in Windows XP SP2 and Windows 2003.
Read up on it here[^].
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Hi,
I want to open calendar view for multiple recipients in the same
window.
The view has to be called from .net, when we select more than one person
it has to display the calendar of those two persons in the same outlook
window.
(i.e. How we are creating recipients object for creation of new appointment
or mail like that)
olRecpts = appointmentItem.Recipients()
olRecpt = olRecpts.Add("santosh")
olRecpt = olRecpts.Add("tim")
olRecpt = olRecpts.Add("mark")
olRecpt = olRecpts.Add("rambabu")
' this is for distribution list
oDistList = myOut.CreateItem(OlItemType.olDistributionListItem)
oDistList.Addmembers(olRecpt)
The above code is for creation of new Appointmnet, mail for multiple
recipients.
In the same way i want to view the calendar of more than one person.
Can any one help me regarding this problem.
Regards,
Santosh.
|
|
|
|
|
I don't think you can do that because of the outlook security but in case I'm wrong and you don't get a response here on CP, There is an Outlook forum here, with a vb.net section:
http://www.outlookcode.com/forums.aspx[^]
|
|
|
|
|
The play list configuration allows the user to generate as many play list as possible.Each play list is a series of contents which plays one after another. A play list is an xml file that contains the list of files to play.The system shall also allow the operator to preview the play list and allow him to 'fast forward'. The following contents are supported:
- scrolling text with different properties
- powerpoint slide show.
- images, logos , photos,animations..
- Video ( MPEG1,MPEG2,AVI,Quicktime movie,Real video,Microsoft Windows video...)
Thanks for guidance.
|
|
|
|
|
Are you developing a PlayList or a Player to play the items in the PlayList?
What are you having the problem with?
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
A playlist
Thanks for guidance.
|
|
|
|
|
OK. A playlist is nothing but a bunch of filenames, preferrably fully qualified paths. You can do that with an array or collection.
Dim playList As ArrayList
playList.Add("C:\playthis\song.wma")
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
hm.....how abt a player??
Thanks for guidance.
|
|
|
|
|
Now you've got a HUGE problem. Each of the file types you want to support is a different file format and requires different components to understand and play that format. If you want to write an app to "play" all these formats, you'll have to figure out which components to use to play each file extension. Each file will have different requirements, and different controls, for controlling the playback.
You could write your application to launch the manufacturers player for all these formats, if they're all installed.
Another option would be to design your application as a plug-in framework. Each plug-in supporting a different file format. This method is going to be FAR more complex though.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|