Got it, thanks for looking

Hi there, @shaktidevelops! I have updated the Dropbox link with the Part 5 source code: www.dropbox.com/scl/fi/62r9kltm4d194x4f3cl2v/SQLTutorial-PT5.zip?rlkey=e60ij41lefzl47qf4jtt466gb&dl=0 I hope it helps!

Thank you!

Awesome! Very happy you're enjoying the series! SQL server is still my favorite DB to work with. :-)

Hi, @pw3111! The index out of range prevention is only to handle errors when clicking to the far top or left where a negative index value was produced. The casting error you're seeing seems more related to the actual data in your dgv or database where it's trying to translate or do something with a NULL record from your table. Are you using this for another project or just copying the tutorial? It's a little tricky to troubleshoot without seeing the code and data and I'm a little rusty, but if it's a small project you could share, I can see if I can figure out the issue.

@@VBToolbox on my access data base, there is a blank row at the bottom with a * on the far left. This is where a new entry will go and is present on all Access databases I build. It’s when I Click into this row that the error occurs. On your “delete “ example program, there is no blank line at the bottom of your database so there is nothing to click into to cause the error. How did you accomplish this as all my databases have this empty bottom row? I can hide this bottom row by choosing “Addaddition=false” in the database properties but then I can’t enter a new record. Thanks for any help.

Problem solved!, On datagridview for my delete forms, I clicked on the top right hand corner of the datagridview and unchecked the “enable adding” option. I left it checked on the any forms where I wanted to add data. Once again your videos have been very educational and your replies have been very helpful as well as they point me in the right direction and make me think. Thanks.

@@pw3111 Hello! Sorry I wasn't able to get back earlier. That is great news that you were able to resolve the issue! Thank you for sharing the resolution. It may be helpful in the event that someone else encounters something similar. :-)

You're very welcome! 😀 I'm happy that the videos were helpful.

Hi there, PW! This is absolutely possible and I had actually created a DBControl (ExcelControl) class a long time ago, but I don't think I ever made a tutorial on it. DropBox Link: www.dropbox.com/s/n344lectco5uw2p/ExcelADO.zip?dl=0 It's slightly different than the others, but still very similar and usage on the application side should be the same. Please bear in mind that this is many years old now and the connection string might need a little tweaking for newer versions of Excel. Connectionstrings.com is a wonderful resource for these and should have everything you need for the ACE and JET drivers for excel (and every other database). I hope it helps!

Oops! Sorry about the last link. That actually was for the entire Excel project I had made, I think - which could still be useful as an example. I meant to send this text link, which is just the class code: www.dropbox.com/s/4xutj0fvz10c9wq/ExcelControl.txt?dl=0

Thanks. I'll certainly put it to good use😁@@VBToolbox

Is it possible to have a "wildcard" file entry in the Control so the user can search for, and load their own file from Form1? Cheers @@VBToolbox

So sorry for the way late reply. For some reason I didn't get notified. I'm fairly certain I tested this years ago and it worked, but is probably best implemented within your stored procedure. Unfortunately, I don't have any examples as I haven't tested this for years.

I'm very sorry for the super late reply. I didn't receive a notification about your question. By now, you have likely already figured out how to do this, but the DBControl as is will handle table joins within your query string. It is, however, preferred that this be done within your Stored Procedure instead of within the query string.

Hi, Derrick! Sorry, I just noticed that the download link on the video is for Part 4. I didn't add a download for this video. Unfortunately, my internet is down and I'm awaiting replacement parts. Are you having trouble with any part in particular?

@@VBToolbox I think that I figured it out :-). I would like some help using the New Connection string, however. I can't seem to figure that part out. BTW, a donate button would be cool because you're helped me greatly and I wouldn't mind donating to your continued success.

Hah! Then you're in good company. I refuse to grow up!