Library tutorials & articles
An Introduction to VB.NET and Database Programming
Finishing Up
Adding data is done by first clearing the fields and then using the BindingManager to add a new row. Then the user must fill out the text fields and click the update button. The code for the Add button and Update button is below:
Private Sub btnAdd_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnAdd.Click
txtTitle.Text = ""
DsRecipes1.Recipes.Clear()
RecipesBindingManager.AddNew()
bNewRow = True Me .SetEntryControls( True )
Me.SetMaintenanceButtons( False )
Me.SetComboBoxControls( False )
cboCategory.Enabled = True
txtCategory.Visible = True
lblCategoryText.Visible = True
txtTitle.Focus()
End Sub
Private Sub btnUpdate_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnUpdate.Click
If ValidData() Then
RecipesBindingManager.EndCurrentEdit()
Me.UpdateDatabase()
If bNewRow Then
cboRecipe.SelectedIndex = RecipesBindingManager.Count - 1
bNewRow = False
End If
Me.SetEntryControls( False )
Me.SetComboBoxControls( True )
btnUpdate.Enabled = False
Me.SetMaintenanceButtons( True )
EditMode = False
cboCategory.Focus()
End If
txtCategory.Visible = False
lblCategoryText.Visible = False
End Sub
That covers the basics of how to use your data connections, data adapters, and data sets to retrieve, navigate, add, delete and update data. I hope that these simple instructions have helped you gain a better understanding of how to manipulate a DataSet. Please feel free to write me or post your comments here about your experiences. There will be more of these beginner type articles as well as book reviews from a beginner's perspective to help guide those of us that are new to the world of Visual Basic.
Related articles
Related discussion
-
How to write the category attribut in a class dynamically
by converter2009 (1 replies)
-
VB.NET: Hide and show table using radio buttons
by converter2009 (1 replies)
-
VB.Net Button Problem
by pysdex (0 replies)
-
Unable to access AxInterop.AcoPdflib.dll on 64 bit OS
by Shaila14041981 (0 replies)
-
Very Urgent regarding deleting the images from a folder
by Nanosteps (6 replies)
Related podcasts
-
xpert to Expert: Inside Concurrent Basic (CB)
"Concurrent Basic extends Visual Basic with stylish asynchronous concurrency constructs derived from the join calculus. Our design advances earlier MSRC work on Polyphonic C#, Comega and the Joins Library. Unlike its C# based predecessors, CB adopts a simple event-like syntax familiar to VB progr...
Hi Chathura,
Good day to you. As you asked the question about the vb.net. And from your explanation you also said that you are little good in vb6. So once you are entering the .net framework area you should be aware of this area. Anyway you are a new user of this programming even u are good in vb6. The main matter in vb.net is that, its quit similar like java. Where in java, you write program in one platform but you can run the program from all other platform. But in vb.net you write the program in all platform but run the program from one platform. Mostly we use vb.net for database connectivity application. We choose this also for web applications. So its very usual that to make a program in vb.net we will be using SQL access, ado.net or asp.net etc. So its natural that if you download vb.net the other software also included with it. May I know what site you used to download vb.net? May be you are downloading fro, any wrong sites. Thank you.
Best regards
Imran
i want to how to have a data set of more than10 tables
Hi,
As a M.E. student of Computer Engineering i am serching for the VB.net Platfrom how 2 start with & find your para usefull. Thanks
Hi All
I'm a beginner to VB .NET but have quite good knowledge in VB 6. I'm currently in the process of switching to .net.
When I install visual studio 2005, there are SQL Server Mobile package and some other SQL server stuff. could you please tell me why they are there and what I can do with them?
Also, is there one called profile or something? As I heard, as a VB 6 project can hold many forms, in .Net there are profiles which can hold many projects. Could you please explain?
Appreciate your help
Best Regards,
Chathura
Hi,
I am having a problem in data binding in vb.net. I have to use MS-Access as database and win forms controls to design a application. Please guide me . Specially in adding the records into the table at run time. Like I just enter the data in the text boxes and clike on the ADD button. The data should automatically be added into the table.
Thank you.
a web site that I wrote works well under internet explorer, but when I run the site on mazilla the forms get changed.
The colors are deleted, and the sizes of the textbox's, change. When I examined the html code generated, there was a difference between the code for IE and Mazilla. How do I correct this
Hi,
I have a bit understanding of VB.net.
Currently I m using winXP Pro.
I Create an Installation, and I set
DetectNewerInstalledVersion to False
RemovePreviousVersions to True.
However, When I first install a fresh copy, it run fine. An entry was created on Add/Remove Program.
After I update something on the application and rebuild the installation file and change the product code and upgrade code; I re-run the installation again without uninstall the previous version.
Installation was success. But the problem is it create 2 entry in Add/Remove Program.
If i install 5 time, it will create 5 entry.
I'm not sure what's wrong with my installation scripts.
Like Winzip or Winrar. no matter how many time we run the installation, it only create one entry on Add/REmove program.
Is there any other way to fix this ?
Please help!
Hi,
The topic which you have explained in the article has been of much help to me,I have Joined an organisation as a programmer.As of now,i have not yet started woith programming.
But since i am new to this field,i would expect you to kindly post more articles which would make working with databases easy.
Regards,
Anu
Chas,
VB .NET is the Visual Basic language which you can purchase by its self. .NET Studio is the development Suite which can contain several different development languages, such as VB, C#, Visual J, etc. I think you can get VB .Net for like $150 and the .Net Suite is around $1000.
If you are a college student you can either of these at a greatly reduced rate for the academic version.
Chester
However, if you purchase VB.NET Professional, that will basically be Visual Studio with support for VB.NET (and not C#)
I wanted to ask you, what's the difference between Visual Basic.NET and Visual Studio.NET
I know a litlle about Visual Basic 6 but I just got a new job and want to learn more stuff so that
I can create a nice program for my company.
I will purchase the books you recommend for beginners. thanks
This thread is for discussions of An Introduction to VB.NET and Database Programming.