How-Do-I Videos for Visual Basic on MSDN

Comments

# Chuck Williams said on June 30, 2007 2:04 AM:

These are great videos, where can i find addtional videos, that would cover addtional topics on stored procedures.

# Dustin Townsend said on June 30, 2007 1:22 PM:

Beth,

I like to use Public Properties to store database data and functions to connection to the data source and filter a data view based on an id or other field in the table and populate the public properties that I need.

I am curious what your take on using Public Properties is?  I haven't watched your latest videos on advance data binding, but if you haven't touch on this...could you show us how you would do that in a new video?

Again thanks for the videos...they are really put together well.

# Beth Massi said on June 30, 2007 1:46 PM:

Hi Chuck,

Check out these videos on SQL Server Express: http://msdn2.microsoft.com/en-us/asp.net/bb498194.aspx#sql, #12 talks about stored procedures.

Cheers,

-B

# Beth Massi said on June 30, 2007 1:50 PM:

Hi Dustin,

Have you looked at the Object Binding Series videos I created? http://msdn2.microsoft.com/en-us/vbasic/bb466226.aspx#objectbinding

Basically those show you how to create the business classes manually for data-binding and shows filtering, sorting and searching. It doesn't specifically show how to connect these to a database because that is up to you how you want to do that. You can create them from datasets or by connecting directly to the database and filling them manually.

HTH,

-B

# Mahesh Kshirsagar said on July 2, 2007 3:34 AM:

Hi Beth,

Many thanks first of all for the initiatives by MS team and especially you for the video series!!

I have been using VB for quite some time now and never before I have experienced such a wonderful learning.

As a suggestion,moving ahead I would like see the "theory" of software development like architecture, usability, SOA, etc being featured in the video series.

Once again, keep up the excellent work you are doing!!

/Mahesh.

# el.wahyu.candra@gmail.com said on July 3, 2007 5:53 AM:

First of all, thanks for sharing VB '05, especially for the beginner like me.  I Started using VB 6 a year ago, but I preferred using VB.Net 2003 than it. Creating Database App by dragging control or using wizard like on your video seem faster and easier, but in some detailed or complex things, it's too difficult and too bored. For Example, first, The Use of binding Navigator as a must in all forms is boring (in vb.net 2003 I use separated button control). Second, I got no result as I want while I try to write code to add a row in a column named "ID" by increment style without  use integer type in  the control of addbindingnavigator(idtextbox.text= dataset.table.row.count + 1) and many more in detailed things.

Perhaps you are willing to make other videos in Database App in code in other  time.

My last comment for you:

You're the only maker of VB Tutorial Video who are give not only basic example(too easy) but more complex thing and you does not promote yourself

SALUTE TO YOU!!!

# Ian Pettman said on July 4, 2007 11:43 AM:

Hi Beth

I've just viewed your interop videos - very enjoyable. Is possible for you to do (or is there already) a video on set up projects (msi)? Things like:

distibuting a service

, adding desktop icons

, branching so we can have a server and a client install from the same setup

, running (SQL) scripts  to attach a database or create a SQL database

and determining prerequites for 3rd party (or vb6run) libraries if not auto detected.

many thanks

Ian

# Arman said on July 9, 2007 4:20 AM:

Hai beth ,

I wanna ask something dealing with your video on “one to many filtering”

If table “orderdetail” doesn’t have “price” column and I move that “price” column in “product” table, how to display the data of “total” in “orderdetail” table.

In other words, I wanna to display the “total” directly from “Quantity “column.

Therefore, if the “quantity” changes, the total do too.

Thanks.

# Thierry said on July 10, 2007 10:50 AM:

Hi Beth,

Very useful videos. Good job.

Cheers,

-TT

# Beth Massi said on July 13, 2007 6:56 PM:

Hi Arman,

Take a look at this sample application built on the Northwind database: http://blogs.msdn.com/bethmassi/attachment/3820257.ashx

It's an application I built for this post: http://blogs.msdn.com/bethmassi/archive/2007/07/11/tableadapters-and-transactions.aspx

But it demonstrates how to create expression-based columns in your dataset so you can use them to calculate totals across related tables. Just open up the Dataset and Take a look at the LineTotal and OrderTotal fields.

HTH,

-B

# Beth Massi said on July 13, 2007 7:03 PM:

Hi Ian,

I created a video on using MSI setup and deployment projects in the context of deploying Interop forms and VB6 applications, it's #3 of the Interop series. http://msdn2.microsoft.com/en-us/vbasic/bb643845

I also created a video on clickonce deployment and local databases, it's here: http://msdn2.microsoft.com/en-us/vbasic/bb643824

I'll add to the list on how to update services and databases for a future video :-)

Cheers,

-B

# Arman said on July 18, 2007 6:15 AM:

Hai Beth,

Thanks for responding on my answers. However, I still didn’t understand (I’ve downloaded app you’ve made and seen the expression properties of “lineTotal” and “OrderTotal” columns in “orders” dataset).

What I mean that the “unitPrice” column doesn’t exist in “orderdetail” table and I move that “unitPrice" to “Product” table. So, how I can calculate, for example the “total” column, if it’s in “orderedetail” datatable. In this case, no need “orders” datatable, just “orderdetail” and “product” datatable.

Lastly, since I’m new in VB 2005, please don’t be bored to me (lovetoask@plasa.com).

Thanks.

# Randy said on July 18, 2007 8:26 PM:

Hi Beth,

Just discovered the videos and your blog last week.  Both are great resources!  I am still doing a lot of VFP work but working on more and more .NET projects. Your blog and videos are some of the most useful resources I've found.  For instance, I had no idea how to create reports in .NET (or VS2005).  Now I at least know how to start!  Also, doing some local data stuff with SQLExpress so your local data deployment and using local data videos were just what I needed!

Keep up the the great work!

# shadi said on July 23, 2007 3:12 AM:

Hi

The videos where greate!

They were really useful for me!

Thanks

# AK said on August 25, 2007 8:16 AM:

Hi,

Thanks for your valuable vs2005 videos.

I have a some doubts on vb interop form.

1. How to create interop method in wrapper class

2. How to invoke interop method in vb6.

Thanks.

AK

# Beth Massi said on September 7, 2007 8:41 PM:

Hi AK,

If you use the Interop forms toolkit it will expose any public method on your control for you automatically. However if you want to do it without the toolkit you can have a read of this article wich explains the details: http://msdn2.microsoft.com/en-us/library/Aa719105(VS.71).aspx

Cheers,

-B

# suhk ran singh said on September 15, 2007 8:11 AM:

NICE TO SEE THE VIDEO.

I'M INTERESTED IN THE VALIDATION VIDEO SECTION . BUT I NEED TO KNOW HOW TO VALIDATE THE CHANGING OF DATASET.

FOR EXAMPLE I MAKE,  DATA ENTRY APP. I HAVE MADE THE DATA UPDATED BUT I FORGOT TO SAVE IT AND DIRECTLY CLICK CLOSE BUTTON.

SO HOW TO MAKE A MASSAGE DIALOG TO PUSH ME TO SAVE OR IGNORE THE CHANGING OF DATA.

I HAVE TRIED THE EVENT FORMCLOSING  BUT ALWAYS FAIL: THE MESSAGE DIALOG ALWAYS DISPLAYS EVEN I DON'T MADE CHANGING WHEN I CLOSE THE FORM.

I USED:  

DATASET. GETCHANGE AND DATASET.REJECT CHANGE ---TO SAVE THE CHANGING AND IGNORE  

THE CHANGING OF DATASET.

# AK said on September 17, 2007 2:33 AM:

Hi Beth,

Thanks for your explanation. Actually there was a confusion over invoking the interop method since the name of the method was 'Print'.

Thanks again,

AK

# Beth Massi said on September 25, 2007 1:56 PM:

Hi suhk,

I'd watch the videos on understanding data and saving related tables here: http://msdn2.microsoft.com/en-us/vbasic/bb466226.aspx?wt.slv=topsectionimg#formsoverdata

To check for changes you can use DataSet.HasChanges property.

HTH,

-B

# suhk said on September 27, 2007 10:26 PM:

thanks for the response. I know the property haschanges property or getchanges dealing with dataset.

however I don't know how to code with them in warning the changing of dataset without saving and directly closing the form.

thanks

# Beth Massi said on October 15, 2007 3:05 PM:

Hi Suhk,

You'll want to take a look at the FormClosing event. You can cancel this event if the dataset has changes and the user wants to save first.

http://msdn2.microsoft.com/en-us/library/system.windows.forms.form.formclosing.aspx

HTH,

-B

Leave a Comment

Name (required) 

Your URL (optional)

Comments (required) 

  

Enter Code Here: Required

Remember Me?

About Beth Massi