|
You can use multiple tables in the same data set. But, you cannot use a single DataAdapter to fill it. The DA's only work with queries that work on a single database table at a time. You CAN, like in your example, use multiple DA's on the same dataset.
|
|
|
|
|
i hav a table with schema
id int
name varchar
i declare trow as personrow
i bind it to a gridview onselectedindexchange i got the row selected by user as
dim row as gridviewrow = gridview1.selectedrow
how can i cast row to personrow
|
|
|
|
|
You don't. A GridViewRow represents the row in the GridView control, not the data inside it. You can use the returned GridViewRow object's DataItem propety to get a reference back to the data item that row is bound to.
|
|
|
|
|
hi
I form a loop display all do
|
|
|
|
|
In what context?
Are you trying to get the form names and show them in a list or are you really trying to show every form in your app?
|
|
|
|
|
Hi all,
has anybody work with data format "jdf"?
For example reading and writing?
Thanks for help
|
|
|
|
|
Is this a survey question or did you have an actual problem you were trying to solve?
Your best source of information on JDF is going to be Adobe.
|
|
|
|
|
scenario:
I have a Sql Server in Rome and a shared server dir (with the access database)
on a Server in New York.
I have permission on sever dir and databse.
The database table on sql Server have exactlly the same structure of Access
table database. (the table on Sql Server have 200.000 records and 48 columns).
Now i want to recopy all records from Rome(sql server) to NewYork (Access
database).
Wath is the best way in terms of time to recopy all records fom sql server to
access database.
note:
I want to use in my app the ADO drive and vb6 classic.
naturally other way are welcome
|
|
|
|
|
sal21 wrote: Wath is the best way in terms of time to recopy all records fom sql server to
access database.
One option is to Replicate[^] it
I are Troll 
|
|
|
|
|
Hi Eddy.... tks for tip but sure not for me i know only VB6...
Can you post a code to use with vb6 classic?
Tks for patience.
Sal.
|
|
|
|
|
Hi Eddy....
tks for tip but sure not for me i know only VB6...
Can you post a code to use with vb6 classic?
Tks for patience.
Sal.
|
|
|
|
|
sal21 wrote: Hi Eddy....
tks for tip but sure not for me i know only VB6...
Can you post a code to use with vb6 classic?
Replication is done over SQL Server, and it doesn't speak VB6, only SQL. You should be able to talk to your Access-database using VB6 and ADO without any problems.
Alternatively, you could write some code in VB6 to do the import manually; creating an ADODB.Connection to SQL and writing it in your Access database. I'm going to guess that that's the code that you're interested in?
I are Troll
|
|
|
|
|
I have tested this way but the code run very, very slow...
Tell me if thei prob is your and post me a vb6 code
|
|
|
|
|
sal21 wrote: I have tested this way but the code run very, very slow...
sal21 wrote: (the table on Sql Server have 200.000 records and 48 columns).
SQL Server and Microsoft Access don't store their data in "exactly" the same way. Moving 200k records takes time. How long did it take?
Replicating to a linked server is the easy and painless way. Yes, it's possible to do it manually. Yes, you can read the data from SQL Server, and update it in Microsoft Access. That it's possible doesn't make it a good idea though.
Do you only need a read-only copy, or is it required to update the SQL Server-data with the changes in the Access-database? If you're satisfied with a read-only copy, then you could simply copy each table into an empty Access database. Should indeed be faster than replication.
Your best option would then be to execute an select into or something similar, from your SQL Server into your linked server. That would at least be a lot easier than reading data from connection 1 and writing it into connection 2.
sal21 wrote: Tell me if thei prob is your and post me a vb6 code
I can't write any specific VB6-code without seeing the physical server. I'll require a plane-ticket from Maastricht to Rome and lot's of coffee 
I are Troll
|
|
|
|
|
Two questions from a VB.Net beginner:
1. How can I center text in a table cell in a Word document that I have created with VB.Net?
2. How can I make the first row of my table repeat at the top of each page on which the table carries over?
I can't find the methods in visual basic for either action.
Thanks
Bill
|
|
|
|
|
Well, I will answer my own questions.
bhogsett wrote: 1. How can I center text in a table cell in a Word document that I have created with VB.Net?
'center all the text
oTable.Rows.Alignment = Word.WdRowAlignment.wdAlignRowCenter
bhogsett wrote: 2. How can I make the first row of my table repeat at the top of each page on which the table carries over?
oTable.Rows(1).HeadingFormat = True
I needed to place the above after the with that applied a style (Contemporary) to the table.
oTable is obviously the table object.
I found it very difficult to find these answers.
Bill
|
|
|
|
|
Hi,
I wonder if anyone can help me with the error I am getting when I try and run my application in VB 2008.
"Form1.vb cannot be modified at this time"
I have tried Tools/Option/Build and Run/ Don't save any changes.
This does not work and I would want the choice to save changes everytime I run my app.
When I put say a button on the form the first time, it works. If I add another say button then that is when I get the problem. Basically adding anything to a form gets the error.
modified on Thursday, January 14, 2010 4:13 AM
|
|
|
|
|
It seems to me that there is something not releasing the file.
Does this happen the first time you run your app or only after that?
How to solve a Programing error:
1. Spell check
2. Debug
3. http://www.codeproject.com
|
|
|
|
|
Thanks for getting back.
It happens when I change something on the form i.e. works first time but if I change anything, I get the error.
|
|
|
|
|
The same thing happened to me.
It seems to be a problem with VS itself and not your app or system.
Try to reinstall VS, and apply any and all updates.
Its a long way but, it fixed my problem.
How to solve a Programing error:
1. Spell check
2. Debug
3. http://www.codeproject.com
|
|
|
|
|
I tried re-installing but get the same error.
I do have problems updating the SP1. Maybe if I can get this loaded then it should solve my problem.
|
|
|
|
|
I tried re-installing and I still get the same problem.
This may help, when I save before running, it works. No use as I want to run my app before saving changes.
|
|
|
|
|
Could you post my a copy of your code?
Maybe it's something there.
And also check that your IDE is "Stopped" before you try to change anything.
|
|
|
|
|
Thanks josefvz for getting back.
I have written no code yet. I have just installed VS 2008 onto my PC. I put a button onto a form, pressed F5. It worked. I then put another button onto the same form and tried to run. I got the error. I then saved everything, it worked.
I am also having problems installing SP 1.
|
|
|
|
|
So the IDE DEFINITLY STOPS EXECUTION before you add the 2nd button?
How to solve a Programing error:
1. Spell check
2. Debug
3. http://www.codeproject.com
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
