Comments by Choroid (Top 43 by date)

Well I added this private Delegate UpdateTextBoxWith()
and re wrote this userControl.Invoke(UpdateTextBoxWith(),newText);
here is the ERROR NuGet Error NU1201
I have net frame work 4.8 Severity Code Description Project File Line Suppression State
Error NU1201 Project WinFormsControlLibrary is not compatible with net48 (.NETFramework,Version=v4.8) / win. Project WinFormsControlLibrary supports: net5.0-windows7.0
This only happens when I use delegate and Invoke OK I get the UserControls I was trying in the
original code to create a SQLite DB YES I diverted to just see if I could communicate with the
UserControls Project Sorry my mistake

I know the Error type Compiler Error CS1061 Tried a few fixes with this link
https://learn.microsoft.com/en-us/dotnet/csharp/programming-guide/classes-and-structs/extension-methods
The Binding Extension Method and Layer-Specific Functionality Code in frmStart Parent Project FWW
public string newText { get; set; }
public void btnCreateDB_Click(object sender,System.EventArgs e)
{
newText = "Hello";
Hide();
UserControl userControl = new UserControl();
userControl.UpdateTextBoxWith(newText);
userControl.Show();

This is the line that generates the ERROR tried changing a number of ways to fix the formatting
NO LUCK will continue any other suggestions ? Thanks

OK I am close but the Windows Form Control Library gets called but it does not acknowledge.
I used your solution and followed this with a label
https://stackoverflow.com/questions/56573520/handle-class-library-project-through-a-windows-form-project
Code on Control
public class Form1
{
private object lblWFC;

public void UpdateTextBoxWith(string newText)
{
lblWFC = newText;
}
}

private void UserControl1_Load(object sender, EventArgs e)
{
lblWFC.Text = "Hi we are here";
}
Code on frmStart
private void btnCreateDB_Click(object sender, System.EventArgs e)
{
Hide();
UserControl userControl = new UserControl();
//var form = new UserControl.UserContrlo();
userControl.UpdateTextBoxWith("New Text");
userControl.Show();
ERROR UserControl does not contain a definition for UpdateTextBoxWith are you missing an assembly reference ? I used WinFormsControlLibrary NOT WinFormsClassLibrary Thanks for the reply

Dave Kreskowiak I have managed to implement the Update and Save functions
The killer is the Read which goes the other direction from Update and Save
with regards to the form The Create should be easy.
Because I use SQLite and AddWithValue still thinking about how that works with CRUD in a project
Need to find some code and have a look. It took me a while to realize some code is very cookie cutter. So I learned one way and have not changed my process with DB work.
Time for new adventures and expanded thinking

Dave Kreskowiak Still learning C# Sounds like a great design.
Learning to call Methods or Functions in another form is the first step.
Perhaps I can tackle using Methods or Functions in a project can be the second step.
Have a nice day thanks for the suggestion.

Bill I guess I am the OP and as for OP's response to your solution, they may remain confused and "needy." Graeme_Grant solution helped me a great deal as for "needy" In regards to this question the OP spent the better part of a week 6 hours a day trying to solve the issues before posting so if that qualify s as "needy" so be it YES point systems suck and offer little benefit Guess I could just hang on SO The response was deleted that is nice it still shows up in my IN BOX

Graeme_Grant First Thanks for the Help. It took me a while to understand your code in the Split
I could not get the code in button2 to fire no idea. YES I need to learn how to test code with
the tools that Visual Studio 2019 has. As for my unorthodox naming sorry it is a bad habit from
my days with a Apple /// every bit was precious.The double counting of variables was a mistake
of putting things in InitializeComponent that should NOT have been added there see My Solution

CHill60 My apologizes I assure you I am not a rep-point hunter
I will follow your advice and use the Improve Solution link

Gerry I tend to agree that might make it easier
just determined to put the concept in two if
statements one to count up and one to count down
when adding text and deleting text
I am close just too much of a mess to post updated code today
Thanks for the response

Griff I wrote this line in my code @tfxInfo) notice the "t" is not needed
your code works I will test my original code which I understand but never
saw the need for this part of the line "DbType.String"
Thank You Very Much

Updated the question as I am now seeing the ERROR
Will try your code and get back
If you have time please look at the ERROR
The DB is in the BIN folder where it should be and the table is in the DB

Bill I created a new application and tested your code
YES VS 2019 WinForms C# Net 4.8
I believe your code will work
namespace WFTest
{
static class Program
{
///

/// The main entry point for the application.
///

[STAThread]
static void Main()
{
Application.EnableVisualStyles();
Application.SetCompatibleTextRenderingDefault(false);
Application.Run(new frmStart());
}
}
}

Bill Thanks for the code Sorry to say I tried both options and NO RESULTS
the frmStart is the entry point for the C# application
This is a little more than a puzzle as I see your code posted as answers on a number of sites
Something is stopping the app from reading the keyboard

Works like a charm! I guess years of programming you learn a few tricks along the way
How it works still a bit of a puzzle ? Time to do a little reading C# is NOT VB.Net

Griff just tested the code NO RESULTS yes I have the KeyPreview set to True looked at the CancelButton but I did not want another button on the form Thank You for the override explanation all the answers I looked at I never saw code constructed for this task that way Live and Learn

Thanks Yes the DB will only store the links to the files on the C drive
Just using the DGV to view the Link Path

Richard This got way more complex than I could have ever believed possible
Here is the solution to the issue it was a Windows 7 and the Registry File
Here is a link to the solution
https://stackoverflow.com/questions/70674832/windows-7-could-not-create-ssl-tls-secure-channel-system-net-webexception

Can you take a look at my Solution and the ERROR

I see some other third party apps Adobe v11.0.0.379 AOMEI backup sqlite3.dll 3.9.2.0 DB Browser sqlite2.dll no version BIG concern is VS x64 and x86 SQLite.Interop.dll ver 1.0.109.0 I see this as a BUG if the Interop is the offending dll

See My Next two comments

@SandeepMewara I tried that alternative using System.Data.SQLite NO CORE no results same ERROR See my comment above

@SandeepMewara so VS 2019 has SQLite.Interop.dll v 1.0.109.0 under C:\Program Files (x86)\Microsoft Visual Studio\2019\Community\Common7\IDE\PrivateAssemblies\x86 and x64 What do I need to change ? And Where do I need to change OTHER Interop.dll have for System.Data.SQLite.Core have v1.0.113.0

@SandeepMewara Little confused assembly version on the system How to Find SQLite on system I have never used it except in VS 2019 I guess a global search of Drive C Holly Crap SQLite is every where I have perhaps a Kotlin project that uses it I also have DB Browser that uses it AND Adobe Reader ? Need better search term like SQLite dll ?

Thanks for the advice and links looks like I can use the Module not sure I will just got lazy writing the same code on different forms

By incorporating "Using" resources disposed YES better idea I knew that just had fit implementing
DGV fill I wanted to manually manage the Adding to the DGV I did write code that used a reader and datatable
ParentTable only has two values PID and Name
While this project only will only Insert and Create the two table I get what you are saying NOT a good idea "modularize"
I will post improved code the commented out code GUESS not a good idea to paste code ? I do not know how to get around Db hard coded name and table?
After thought by implementing "Using" do I still need to con.Close & reader.Close?
Thank You for the reply that supplied a lot of learning and valuable advice

@Richard-MacCutchan Thanks I agree less commented out code would be ideal Guess I have become complaint shy from StackOverflow use where You did not show us enough of what you tried. I will post my completed code below for others that might want to see the finished product My frustration with this issue is I did this in JavaFX in about 10 min as a novas

Luc Just tested and it works I can not edit my solution which I find frustrating
My solution while it worked was code I did not understand OH the joy of learning
VB.Net has its own very useful idea of PATHS coming from NetBeans it was easy as long
as the Object was in the Project you could find it Guess it is the same for
VB.Net just learning what "My" does has been an eye opener Thanks

Luc
For any one who sees Solution 3 I only works on a project with one form
If you have multiple forms the code prevents navigation to other forms
NOT A SOLUTION If someone would like to explain this failure please feel free

Luc so setting the icon in the properties box as long as the icon is in some folder in the project and I use the path to that folder to set the icon in the properties box?

Luc I did try embedded resource no luck it has always been set to content I have even tried a 16X16 with 8 bit depth no luck Is it possible to send me one of your icons I guess I need to post an e-mail address in the comments then delete once you have it

Luc Pattyn I also have the Maximize Box set to True as I was told this could not be false Why is it so Impossible to manage the titlebar? I have search for 2 days looking for the name of the items in the titlebar

Luc I did that Right Click Project > Properties > Application > Browse I now have the icon in the ill named folder Resources selected it and all I see is the default icon

Richard I might not have been clear the folder I am talking about is one I create named Resources This was a bad choice for the name As I am not talking about any folder under Resources.resx I should have named the folder Images

Thank you I have tested that code with no results
I will try a few more tweekes the printer does not respond the print service does find the printer and even tells me the job is DONE but no results on paper

Your links are to Graphic printing with the old java.awt API
I am looking for help with javax.print API
FYI you have to have the mouse over the page to see the Improve question which
in its self is a long way from the Words EDIT yes I know it has a tool tip
lesson learned Still looking for help with printing to a printer
thanks

Well I looked all over the page for a EDIT button Let me ASK you where it is at
I do not mean to be impolite but the answer I am looking for is why the code
does not work TRUST me I do not post here till I have tried every document know
to man I stated I looked at every site in my POST