|
Hi,
first of all those DBF files are corrupted. It's not within the spefications of the format although I know that there are several ways to create such files. The only way I found to read such files was very lowlevel. Have a look here[^] or here[^]. Those sites describe the whole format of DBF files. Given this information you can either read the data yourself or just change the columns names so that each one has a unique name.
Robert
|
|
|
|
|
exactly what I needed.!
I appended a number series to the fieldnames. pretty dissapointed by the limited size of the fields. SO I had to truncate some of the letters. After that I was able to connect to it Using the VIsualFOxfrom Oledbprovide - it works !
Thank you.: -D
U Xux
|
|
|
|
|
Please help me.
I'm using VB.Net 2003. i need to make just like a taskbar on my mdi documents. So i can make my own buttons to choose which windows need to to be active.
-- modified at 20:20 Thursday 3rd August, 2006
|
|
|
|
|
Do you mean a toolbar?
Steve
|
|
|
|
|
Yes Steve,
Toolbar , because I'm using the MDI control and the parent will contains different child form in it. I think I need to popolate buttons bellow to specify which child form is active. And to do that only toobarbutton is all I know. And if I right click the button, then chhose closed[X]; also the child window or form will be out of that screen. Only the remaining child form and it's corresponding button will remain. Please help me how.
Thanks.
Ariel
|
|
|
|
|
Each Toolbar has a ToolBarButton collection.
Are you using Visual Studio?
Look up the help for 'ToolBarButton'.
You use the Add and AddRange methods to add buttons to your toolbar.
Steve
|
|
|
|
|
can i set the datareport
in vb6 with the recordset object that use DAO 3.51
dim rs as recordset
set rs=db.openrecordset("select * from table")
set datareport1.datasource=rs
the debuger tell me that the datareport1 can not be set
can any one help me please
thanks
BE OR NOT TO BE
|
|
|
|
|
Datasource is a string, no?
A man said to the universe:
"Sir I exist!"
"However," replied the Universe, "The fact has not created in me A sense of obligation."
-- Stephen Crane
|
|
|
|
|
i want to pass values from a form into a class and then retreive those values from the class and display it on a new form? Can you please explain to me how i should go about it? thank you
Nothing lasts but nothing is lost
|
|
|
|
|
Solly74 wrote: i want to pass values from a form into a class
You do know that a form is just a type of class. So what you are saying is: I want to pass values from one class into another class
Anyway, this article[^] might help.
|
|
|
|
|
no i retreived values from a table in a datagrid and assigned it to properties of a class. now i want to take those values and display them in textboxes on a new form. thanks
Nothing lasts but nothing is lost
|
|
|
|
|
Is the class public?
Do you just want to pass values from Form1 and display them on Form2?
Steve
|
|
|
|
|
no i retreived values from a table in a datagrid and assigned it to properties of a class. now i want to take those values and display them in textboxes on a new form. thanks
Nothing lasts but nothing is lost
|
|
|
|
|
So the values are in a dataset table?
If so, just get them out of the dataset.
If they are in a class, have you used Properties with Get/Set?
Are the properties public or shared or are they private?
If you can explain in a bit more detail, we may be able to solve your problem quicker...
Steve
|
|
|
|
|
its in class yeah. so now i want to retreive those values onto another form, the properties are private yeah!
Nothing lasts but nothing is lost
|
|
|
|
|
and yeah i used get/set for the properties
Nothing lasts but nothing is lost
|
|
|
|
|
If they are private, only methods of that class can access them.
Are you inheriting from this class? If not, you will have to put them in a public variable or Array to access them in another form/class.
Steve
|
|
|
|
|
nope no inheritance, so im gna try an make the properties public an check. thanks
Nothing lasts but nothing is lost
|
|
|
|
|
OK. Well if that works, you should then alter the keyword to the least access required. Maybe 'Friend'.
Depending on what you choose, you may have to qualify the property with the class name e.g.
classname.property
Public properties are accessible even outside your application which presents a security issue. Only use public if you want them to accessed in this way.
Steve
|
|
|
|
|
just tried it now, didnt work. the textboxes appear empty on the new form
off the topic, can u give me a theoretical answer to how one would solve concurrency errors please.
thank you
Nothing lasts but nothing is lost
|
|
|
|
|
If the form/class is closed/terminated then you will not be able to get the properties. They will need to be initialised first.
Why are you putting them in a class?
What concurrency errors are you getting?
Steve
|
|
|
|
|
the table is a table holding customer information, so i display it on a form, then if one highlites a row on the table in the datagrid and clicks on edit it supposed to bring up a form with the selected rows information displayed in textboxes for editing purposes.
not getting any concurrency errors, need a theoretical solution for documentation purposes.
Nothing lasts but nothing is lost
|
|
|
|
|
OK. So your datagrid is bound to a dataset table?
Can't you just get the record ID from the row clicked and pass that value to the WHERE clause of the other form's query/DataAdapter/DataReader?
If the datagrid is bound to a dataset table, why not edit it in the grid and update the dataset table?
You should post your concurrency question as a separate item.
You will get better response that way.
General theory is to 'handle' the errors somehow. For example:
Execute the command to update the database from within a Try...Catch block.
If an exception is raised, inspect the Catch statement's Row property to determine what caused the violation.
Add code to resolve the error based on your application's business rules.
Is that what you are looking for?
Steve
|
|
|
|
|
Yeah it is bound. so u suggestin i use an SQL statement to retreive the row of the table?
k im gna look into tht and give it a go
i did post it in the general section but no response yet
yeah tht is sort of what im looking for, but somehthing more high level, coz its for people that hardly know anything about code.
Nothing lasts but nothing is lost
|
|
|
|
|
Absolutely. The data is there in the dataset.
Just get the record ID from the grid row clicked.
Use something like:
SelectedRow = myGrid.CurrentCell.RowNumber
RecordID = myGrid.Item(SelectedRow, ColumnIndex)
Where 'ColumnIndex' is the index of the column containing the unique ID of the record. Then use that value in your query for the form.
Depending on how your form is set up, you could just find the record in the dataset and set your form's BindingContext to that position.
I don't mean to sound like an over-bearing parent but, if you had given that detailed explanation earlier, we could have got to this point much quicker!
Well, I'm sure you can make something high level out of that?
For example:
Use structured error handling to catch concurrency errors and resolve errors by utilising code that conforms to business rules...etc
Steve
-- modified at 21:14 Thursday 3rd August, 2006
|
|
|
|