Comments by Choroid (Top 59 by date)

I will explore if Ad blocker is turned ON in Firefox but last time I looked I did not see any ON/OFF setting for Ad Blocker I have Version 115.12 ESR because I have W7

My Bad Dave the original app was trying to open using Firefox which was the default browser so YouTube would see Firefox and just not play the video because Google see's Firefox as Ad blocker. Yes I now call chrome.exe + the URL to the YT channel

Richard I agree I should have explained that Google will not load YouTube videos unless you have Google Chrome open sadly I thought I needed to be logged in to Google to make the YouTube video play. I had already used Jo_vb.net code link when he posted his Solution See Response to OG's Solution Thanks for the insight

Paul "OG" first thanks for the answer. The app is for my use only but that said I do agree with what you point out changing system wide settings without explaining to the EU not good UI design. I almost had the problem solved with this code you will see the mistake I kept thinking I need to log in to Google.
'Dim browser As String
'browser = "http://www.google.com/"
'Process.Start(browser)
'Process.Start(webPAGE)

I need to use Google Chrome to view YouTube video's
If I use my default Browser Firefox YouTube will not play the video
Thanks for the code link I used that link to open a browser
see my improved statement under what I have tried

Windows Forms AND I should have learned by now that MS web pages are for every dialect Thanks for the answer I changed the tabindex to zero and tbEV.Focus(); now works when the form is revisited or gains focus returning from the frmDialog pop up message

No Error Message When I had the ActiveControl expressed this way this.ActiveControl = tbEV;
with the return statement used upon closing the frmStart I would get a error at the
this.ActiveControl = tbEV; So I removed the this statement and the return was not needed
I agree too much happening will try to comment out the If Else routine Thanks

Andre Oosthuizen It is data from one table to another table in the same DB
If you read the first line in the Private Sub DataPull() that explains it all

Richard I posted and answer sort of. I feel a little ashamed it was AI generated code I found and did not notice till after I refactored it a little and went back to the site I copied it from
I still do not know how to use ImportRow and I am trying to workout how to fix this codes one
short coming

Thought about that but just really want to learn how Clone & Copy OR importrow work

Some what agree Richard but that still leaves the data I move to the other database in the original database. The ideal would be to have the archive data in the original app and still be able to access it. It is a Check Book app and 2 year old data is filling up my DGV. YES I know I could filter it to only show a range of years. Archiving data and bulk removal was the intended goal. Thanks

Richard Thanks I was so happy when it worked I posted my code in haste
I have since gone back and cleaned up a few things and decided to use list.Count as you suggested.
Also noticed I was making a call to the Class Library three times when I only need one call
Really Appreciate the comment

Graeme_Grant Thanks for the time you spent on this answer it is HUGE
I need to expand my knowledge on Classes & Interfaces as well working with obj relation mapping
Need to fix VS every time I create something it makes it Private ?
I try to use camelCase but bad habits when creating test projects I just use odd naming
Thanks

Griff agreed it does nothing I found the code on CP and just copied it without knowing how it works
Lots to learn still looking for a good FREE book or a course that covers a wide range of topics
Tutorials Teacher has been the best site Thanks

Griff Great it Works! As long as I only want one record and I do not close the app.
I added a UserData Class with additional line of code public UserData() {} in the frmSelect.
The issue is the ID is not being transferred to frmADE and as of now I have a nullpointer in the Class Library when I try to readData. I think the issue is because when I first built this I had the DB in the Class Library ONLY and when I added it the error was sqlite interop dll not found.
I deleted SQLite and reinstalled NuGet then wanted it installed inboth Projects.
If I detach the Class Library and put SQLite in this project only that might work
BUT the issue is the frmSelect loads the DataGridView and I do not know how to populate the
DGV Rows in another form or Class Library so until I can solve that putting the DB in the
Class Library project will not work. The time you spent on this answer is GREATLY appreciated
My best wished to you and herself. Consolation I learned how to construct UserData Class yea

Graeme_Grant It has been a bit of a slog I switched to Class Library and made a project to change the text in a textbox on a form added to the Class Library Project it works AND Learning was valuable
NOW to put the SQLite methods in the Class Library I have been reading and not sure if the instances of the SQLite in the Main Project will be utilized by the Class Library Project ? Thanks for the help

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