The Following code is for a very simple insert command…
Dim sqlStr As String = "INSERT INTO [Table1] ([col1]) VALUES (@col1)"
Dim conn As New Data.SqlClient.SqlConnection
conn.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings("connStringInWebConfig").ToString
Dim cmd As New Data.SqlClient.SqlCommand(sqlStr, conn)
cmd.Parameters.Add("col1", Data.SqlDbType.VarChar).Value = tbCol1.Text
conn.Open()
cmd.ExecuteNonQuery()
conn.Close()
I’ve got my YooHoo and I’m feeling like I may stick to this. Most likely I will not. Yea, high expectations.
These are the Courses you would have to take to become an MCAD.NET – Microsoft Certified Application Developer for .NET. I really don’t want to spend the money for classe, so I am learning via books and the web. I have a membership to http://www.LearnVisualStudio.Net. I am already comfortable with Classic ASP and VBScript, but nobody is hiring for those skills. I even searched http://www.indeed.com. I also understand the basics of Object Oriented Programming (Classes, Methods, Constructors, and such)
The following is from Here.
Core Requirements:
Exam 70–305: Developing and Implementing Web Applications with Microsoft Visual Basic .NET and Microsoft Visual Studio .NET
Exam 70–310: Developing XML Web Services and Server Components with Microsoft Visual Basic .NET and the Microsoft .NET Framework
Elective Requirement:
Exam 70–229: Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition
