|
yeah its the last program of the class i have to turn in, and Ive got through so far, but I feel screwed now. My book is an introduction to visual basic fifth edition, and the problems for chapter 7 Im just clueless on. The stuff is on arrays, and if anyone can help me with this problem I'll give you my eternal love, or I'll paypal you something, what ever works for you 
Josh
|
|
|
|
|
Since the 1.5 million (or so) of us, will probably not have this book, there is nothing we can do to help you. If you have a specific question on code your writing, GREAT!, we can help with that. But that's all. We won't write your code for you.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
I have to agree with Dave, but do feel free to post any question or doubts u are facing... We'll be glad to help 
"Rejoice always, pray without ceasing, in everything give thanks; for this is the will of God in Christ Jesus for you."1Thess. 5:16-18
|
|
|
|
|
I am using Progress Database. The connection to the database is done by DSN connection. I am trying to find out how I can import selected tables and fields from my database to Access. I am using VB 6. Can I also use some sort of validation that will enable the table to be only updated once a day. Can anyone help me on this. Many Thanks.
|
|
|
|
|
Suresh Prasad wrote:
I am trying to find out how I can import selected tables and fields from my database to Access
Can you tell clearly about the your database? What is the name of the database that you want to import your data into Microsoft access?
A thousand mile of journey, begin with the first step.
APO-CEDC
Save Children Norway-Cambodia Office
|
|
|
|
|
I am trying to import into access data from a progress database. This is how it is setup. The access files is called test1.mdb. The progress database is called springbrook1, and the dsn info is as stated in the code (see below). The table name called customer that I want to import into access. I want to be able to import field1, field2 and field3 from the customer table. This is the code that I have got so far. but now I get the following error message:
The Microsoft Jet databse engine cannot find the input table or query 'mySQL2'. Make sure it exists and that its name is spelled correctly.
My code:
Private Sub ImportToAccess()
Dim Con1 As New ADODB.Connection
Dim Con2 As New ADODB.Connection
Dim mySQL1 As String
Dim mySQL2 As String
Dim myDSN As String
Dim mySET As String
myDSN = "DSN=Springbrook1;UID=suresh;PWD=nissan;"
mySET = "set schema 'pub'"
mySQL2 = "select * from customer"
Con1.Open _
"Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=C:\Temp\VB Sample Codes\mcwd\Connect Program\test1.mdb;" & _
"Jet OLEDB:Engine Type=5;"
Con2.Open myDSN
Con2.Execute (mySET)
mySQL1 = "SELECT * INTO [tblCutomer] FROM [mySQL2]"
Con1.Execute mySQL1
Set Con1 = Nothing
Set Con2 = Nothing
Con2.Close
End Sub
|
|
|
|
|
Hi there.
I have a vb.net windows application that starts with a Sub Main which then
loads and displays my main form. The form takes a while to load so I
want to set the cursor to Wait. However when I try to do this from the
module it has no effect.
Can a cursor me changed when there is no form currently being
displayed (i.e. from non-GUI code) and if so how?
Here's my code:
Module modMain
Public Sub Main()
Dim mdiMain As mdiMain
Try
' Do some login stuff here
' Display the waiting cursor
Cursor.Current = Cursors.WaitCursor
mdiMain = New mdiMain
mdiMain.User = frmLogin.User
Debug.Writeline(Cursor.Current.ToString) ' Shows
Cursors.WaitCursor
mdiMain.ShowDialog()
' ...
Daire Cunningham
|
|
|
|
|
Without any actual experience in this... I would say no you can't. The cursor will not change to an hourglass system-wide. It will only change when the cursor is sitting over a form in your application. Since you don't have a form up yet, there is no window handle to send cursor messages to, and therefore, no way to tell it to change the cursor when over your form, which doesn't exist yet).
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
The way MS recommends in their examples is to change the cursor in the NEW function of the given form. This will change the cursor whilst the for is loaded but not yet displayed. You have to change it back at the end of the on_load event though.
|
|
|
|
|
Thanks for the suggestion but it didn't work for me. Could you point me to an MS example where they do this or recommend it.
Thanks,
Daire
Daire Cunningham
|
|
|
|
|
Try dropping a Application.DoEvents() line in immediately after you change the Cursor.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
I just double checked and it only works if the form is being displayed.
So unless there is something on the form you don't want the users to see while it is loading you can put a me.showdialog line as the first line of the load event. I tried that and it works.
|
|
|
|
|
Thanks for that but I kick off my form from a Sub Main in a module. I've tried setting the cursor in Main(), and in my form's New and Load events but to no avail. I'm thinking I'll have to make some sort of splash screen or "Loading" dialog instead.
Here's my code:
Module modMain
Public Sub Main()
Dim mdiMain As mdiMain
Try
' Do some login stuff here
' Display the waiting cursor - but doesn't work
Cursor.Current = Cursors.WaitCursor
mdiMain = New mdiMain
mdiMain.User = frmLogin.User
Debug.Writeline(Cursor.Current.ToString) ' Shows
Cursors.WaitCursor
mdiMain.ShowDialog()
' ...
Daire Cunningham
|
|
|
|
|
What i wana do is on the client side have two text boxes, one for login name the other for password. after the client is connected to the server the user would enter the login name and password and hit a start button, this would send that data in the textboxes to the server, how would i go about sending that data safe and how would i go about checking that info in a access database and returning info that was saved in the database about the person that was loging in.
thanks
|
|
|
|
|
Since Access is a Desktop Database, not a server database, you'r not sending anything to a "server". You're actually just opening a .MDB file from the clients workstation. There is no server involved. Even though the Access database sits on a server, the client acts just like it was sitting on one of it's own local drives. (BTW: Access is terrible for this!)
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
ok what if i was to switch this database over to a sql server how would I go about this?
|
|
|
|
|
|
Is there any way i can bind untyped dataset to crystal report and show the values of dataset in the report.
|
|
|
|
|
sure you can. so long as the report is getting a dataset that is representative of it's defined datasource then you're ok.
the easiest way to do this is using a typed dataset, but if you don't want to or can't, you can just create your dataset however you're going to do that. (read from database, manually etc.) then when you're to the point where you're going to send the data to the report, just insert a breakpoint and write the dataset out to an xsd file. take this xsd file and use it as the source of your report.
I like to export the dataset including both the xml data and the schema definition. this way when you're defining your report you'll be able to preview what the output will look like.
hope this helps. good luck.
-jim
|
|
|
|
|
What im tring to do im sure is very easy im just not sure of now to do it or what the elements are called.
Basically all i want is a list of buttons (like a menu) up the left hand side of the form, and depending on which button you press, a section of the form changes (to the right) indicating the choice.
For example
If i click Button1 on the left TextBox1, Textbox2 appear on the right
If i click Button2 on the left Textbox3, Textbox4 appear on the right (in the same place as Textbox1 and Textbox2 would appear if i clicked Button1)
I guess im after something like frames in html.
What is the best way to do this in VB.NET
Thanks in advance
|
|
|
|
|
Put a bunch of panels on your form, each panel containing the controls that you want to show when a particular button is pressed.
Set all the panel's visible property to false apart from the one you want to show when the form is first loaded.
In the event handler of each button hide the panels that do not relate to the button that was pressed by setting the visible property to false and show the relevant panel by setting its visible property to true.
You can make it all look very tidy using docking and a splitter control.
Hope this helps
Tom
|
|
|
|
|
Alternatively do the same thing using MDI Forms, which has the added benefit of separating the functionality in a more object orientated manner.
|
|
|
|
|
Hi,
I have the following problem and I am wondering what the general way is to fix this.
I have got a form with an edit and a store button and a customized propertygrid for the user to capture some information.
The thing I want to have is that when the user changes a property value in the propertygrid the store button changes from disabled to enabled. I don't want the eventhandler main event handler on the form. I currently have the propertyvaluechanged handler on the customized propertygrid. The form I am using is also a derived form from the standard one. I guess the simple solution would be to create the handler on the form and have the enabled switch in this handler, but then you would have to re-create this routine each time so I am looking for something a bit more generic. Keep in mind that I am still learning a lot about vb, so a solution that you think would be pretty obvious, could very well be completely unknown to me.....
Thanks in advanced
Think, try, think, think, try, think, think, think, try, ASK, think, try, advance on step and start over...
|
|
|
|
|
In your inherited control override the protected sub OnPropertyValueChanged:
<br />
Protected Overrides Sub OnPropertyValueChanged(ByVal e As System.Windows.Forms.PropertyValueChangedEventArgs)<br />
<br />
'Put your code here to fire when the property is changed<br />
<br />
'Make sure you call the base method you are overriding<br />
MyBase.OnPropertyValueChanged(e)<br />
<br />
End Sub<br />
In the base class (Windows.Forms.PropertyGrid) this method will simply fire the PropertyValueChanged event, by overriding the sub you can 'slip' your own code in before the event is fired.
More info on this method is available on MSDN:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemwindowsformspropertygridclassonpropertyvaluechangedtopic.asp[^]
It is worth investigating these protected methods when you inherit from other classes.
Hope this helps
Tom
|
|
|
|
|
I am using a data adapter to fill a typed dataset via a stored procedure with a parameter to match on the key value. When there is a match on the key, everything is fine. When there is a no match situation, the program crashes with the following error even though I am trapping for errors.
"An unhandled exception of type 'System.IndexOutOfRangeException' occurred in system.data.dll
Additional information: There is no row at position -1.
"
The crash location is in the ITEM of the DataTable initialization as follows:
Public Default ReadOnly Property Item(ByVal index As Integer) As OptByLRow
Get
Return CType(Me.Rows(index),OptByLRow)
End Get
End Property
The code I am executing is: (ID = incoming key value)
Dim con As SqlClient.SqlConnection = New SqlClient.SqlConnection("blahblahblah")
Dim dsOpt As OptByL = New OptByL()
Dim command As SqlClient.SqlCommand = New SqlClient.SqlCommand()
Dim daOpt As SqlClient.SqlDataAdapter = New SqlClient.SqlDataAdapter()
Dim LID As SqlClient.SqlParameter = New SqlClient.SqlParameter()
command.Connection = con
command.CommandText = "stpOptByL"
command.CommandType = CommandType.StoredProcedure
LID.ParameterName = "@L_id"
LID.DbType = DbType.String
LID.Size = 10
LID.Value = ID
command.Parameters.Add(LID)
daOpt.SelectCommand = command
Try
daOpt.Fill(dsOpt, "OptByL")
Catch ex As Exception When dsOpt.OptByL.Rows.Count = 0
MessageBox.Show("Empty dataset")
Catch exc As Exception
Throw exc
End Try
Return dsOpt
Can anyone help me out?
TIA
Happy Hunting
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
