Search:

I would be happy to fit the entire form to the printer page or draw a rectangle on the form and do the same. Can anybody direct me to some code?
Thanks

Thanks. Regret that I cannot print to fit the page form there, so I will start a new thread. Thanks

I have the following code that throws the following error.
The path is correct and when I click on it from my File Explorer, it opens up. Any suggestions?
Thanks


...

I have written several VB Net applications and distributed by placing the exe and dll's in the same folder. This has worked until most recently when the user gets the message "You must install .NET...

That's it. I must have populated it twice and when I sorted it, I got the consecutive pairs.
Thanks everyone.

Should I somehow mark this as resolved?
Richard

My Code



Dim rw As DataRow()
Dim sWhere As String = ""
Dim sOrder As String = "RING_PART_NUMBER ASC"


rw = dsParam.Tables("INTERNAL_RETAINING_RINGS").Select(sWhere, sOrder)

In my fantasy world I would build the dataset and add relations that would behave like an inner join and call "something?" that would act like the whole table.



Sub loadDataset()
Dim da As...

I must admit my ignorance on this subject. I am way over my head and do not want to waste your time.

I do not understand commands and parameters, but it seems to me that I would need to add a...

I have to admit that I am lost here.
My table RH has about 45 fields. My table LH also has about 45 fields and my table Main has about 20 fields.
If I add a row and correctly populate all 100+...

With the code corrected and the table row added via the DataGrid as shown






Private Sub ThreeTables()

Attached is the image that I did not upload properly before.
The database has Three tables

Main: Has the main properties for the two other tables
LH: Has the left side properties
RH: Has the...

I have returned to this problem that I have not managed to solve with a simplified example.

Here is the code that I am currently trying




Private Sub ThreeTables()

Dim con As New...

That's what I was looking for. I have 10 columns in my first table and about 60 columns in each of the other two. Do I have to list the columns explicitly or is there a global expression that I can...

Some History:

I have an access database that has over 120 fields. When I try to save changes I get an error that the table is too complex. My smaller tables save with no problems.

I have...

I have created a number of propriety applications that live on the company server.

When a user requests an update, all these files are copied to their hard drive so that when they are off line,...

Building on a theme that I touched upon in

https://www.vbforums.com/showthread.php?890116-Publishing-a-Visual-Basic-Net-application&p=5507691#post5507691

The full scope of my situation is as...

That is an excellent solution.
Thank you very much.

showing the whole "AddInletCurve" routine is not practical here, but here is some of the code. I have verified that these lines are executed for both the instance where the legend appears and the...

I have a chart on a form that has all its default properties unchanged from when I added it from the toolbox.

Call a routine named "AddInletCurve" during runtime and it behaves as desired. In...

I was not able to find a resource for Publishing that would install all the projects library files in the GAC during a software installation. I did find examples for creating a single dll and...

Here’s the Big Picture

Years ago, I developed a suite of VB6 engineering programs that I made available to all the engineers in my company. I placed the executables in a folder system according...

Excellent,

In the VB6 Windows 7 World the library files were installed in the windows /System /System32 / or /SysWOW64 folders and any program could get to them.

In that VB6 world I developed a...

Yes, it was already in place.

All I did was to move the executable, that was in that same folder as the library files, to a different place.

The program would open up and behave normally up to...

Thank you, I hope my response is directed to the Application Deployment site.

I The PowerPacks Library is automatically included in the distribution.

When I check a computer where the...

If I understand Publishing correctly, I have an option to make the application available offline or only online.

I wish to make the application available offline When the application is installed...

Thanks for your thoughts. I was stuck in a database conversion routine updating an Access database from a vb6 application to vb net. I figured out a work around.

This is my first deployment of a VB Net application.
I believed I published it correctly
It runs perfectly on the computer that created it. (Windows 10)

But when I Install it on a Windows 7...

I developed a routine to generate an Update command that constructed a SET statement that included every column in any DataTable and a Where statement pointing to the rows Primary Key.

This worked...

Thank you for that correction. It allowed my code to run without any errors.
Regrettably, the database did not change because the rowstate was not triggered.

Because I don't fully understand how...

I suspect that I an not creating the update command properly. Can you take a look?



Public Sub TestPortPlate()
Dim dt As New DataTable
Dim sCol As String
Dim sKey As String
Dim da...

I think my table is poorly constructed (that's the way I got it, and I can't change it)

The process that I outlined above works on simple tables, but this particular table has many similar columns...

This is the process

At the start of the program I load an array of tables and adapters from a database




For i = 0 To UBound(gsTableNames)
Sql = "Select * from " & gsTableNames(i)...

This works nicely
Thanks
How do I mark the topic as RESOLVED?

This almost works.

It fails however on tables that already have a primary key (not of the same name)

Any suggestions?

I have a DataTable that has 192 columns.

When one of the rows is selected through an interface. some of those column values get loaded into unbound text boxes.

When the user exits the form, all...

I am referring to deleting contents the DataTable and then using the DataAdapter to update the database.
Perhaps I could use the method you suggest and then reload the DataTable from the Database. ...

OK, I like it

Is their a bulk method for deleting all the rows in a DataTable such that the RowState for all rows is set to Deleted.

I have a table with several thousand records that I constantly clean out and...

Thanks,
I am not sure you can do this on a Database Table that is already populated, but this would fit in my first routine above where I create an empty clone of the database and its tables, add...

Fortunately I run no query's

Regrettably I inherited the Database so I am stuck with the column names

Thanks I have applied your recommendations

Richard