please I need help with basic ado.net save, basic syntax needed

[Newbee Adam]

I am having some problems with getting squgglie lines under stringbuilder and
ConfigurationSettings

what am I doing wrong, is this even close to working? help.
------------------------------------------------------------------------------------
Imports System
Imports System.Data
Imports System.Data.SqlClient
Imports Microsoft.VisualBasic

Public Class Locations
Inherits System.Windows.Forms.Form

#Region " Windows Form Designer generated code "
Private Sub Save_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles Save.Click
Dim mySQLConnection As New
SqlConnection(ConfigurationSettings.AppSettings("D SN"))
Dim strSQLCommand As New StringBuilder, mySQLCommand As SqlCommand
strSQLCommand = New StringBuilder
With strSQLCommand
.Append("INSERT INTO Locations (Loc_Name, Address, ContactName,
Phone) ")
.Append("VALUES ('" & txtName.Text & "', '" & txtAddress.Text &
"', '" & txtContactName.Text & "', '" & txtPhone.Text & "');")
End With
mySQLConnection.Open()
mySQLCommand = New SqlCommand(strSQLCommand.ToString, mySQLConnection)
mySQLCommand.ExecuteNonQuery()
mySQLConnection.Close()

End Sub
End Class
--
thanks!!! Adam S

[Jay Pondy]

At the top of your source file:

Imports System.Text
Imports System.Configuration.ConfigurationSettings

On Mon, 27 Jun 2005 08:05:06 -0700, "Newbee Adam"
<Ne********@discussions.microsoft.com> wrote:

I am having some problems with getting squgglie lines under stringbuilder and
ConfigurationSettings

what am I doing wrong, is this even close to working? help.
------------------------------------------------------------------------------------
Imports System
Imports System.Data
Imports System.Data.SqlClient
Imports Microsoft.VisualBasic

Public Class Locations
Inherits System.Windows.Forms.Form

#Region " Windows Form Designer generated code "
Private Sub Save_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles Save.Click
Dim mySQLConnection As New
SqlConnection(ConfigurationSettings.AppSettings(" DSN"))
Dim strSQLCommand As New StringBuilder, mySQLCommand As SqlCommand
strSQLCommand = New StringBuilder
With strSQLCommand
.Append("INSERT INTO Locations (Loc_Name, Address, ContactName,
Phone) ")
.Append("VALUES ('" & txtName.Text & "', '" & txtAddress.Text &
"', '" & txtContactName.Text & "', '" & txtPhone.Text & "');")
End With
mySQLConnection.Open()
mySQLCommand = New SqlCommand(strSQLCommand.ToString, mySQLConnection)
mySQLCommand.ExecuteNonQuery()
mySQLConnection.Close()

End Sub
End Class

[Newbee Adam]

thanks!!!
is this the basics I need to do a save, that is al i m trying to do is learn
how to do 1 succesful ado.net save
--
Adam S
"Jay Pondy" wrote:

At the top of your source file:

Imports System.Text
Imports System.Configuration.ConfigurationSettings

On Mon, 27 Jun 2005 08:05:06 -0700, "Newbee Adam"
<Ne********@discussions.microsoft.com> wrote:

I am having some problems with getting squgglie lines under stringbuilder and
ConfigurationSettings

what am I doing wrong, is this even close to working? help.
------------------------------------------------------------------------------------
Imports System
Imports System.Data
Imports System.Data.SqlClient
Imports Microsoft.VisualBasic

Public Class Locations
Inherits System.Windows.Forms.Form

#Region " Windows Form Designer generated code "
Private Sub Save_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles Save.Click
Dim mySQLConnection As New
SqlConnection(ConfigurationSettings.AppSettings(" DSN"))
Dim strSQLCommand As New StringBuilder, mySQLCommand As SqlCommand
strSQLCommand = New StringBuilder
With strSQLCommand
.Append("INSERT INTO Locations (Loc_Name, Address, ContactName,
Phone) ")
.Append("VALUES ('" & txtName.Text & "', '" & txtAddress.Text &
"', '" & txtContactName.Text & "', '" & txtPhone.Text & "');")
End With
mySQLConnection.Open()
mySQLCommand = New SqlCommand(strSQLCommand.ToString, mySQLConnection)
mySQLCommand.ExecuteNonQuery()
mySQLConnection.Close()

End Sub
End Class

[Newbee Adam]

i get error , connection string has not been initialized? what is wrong. I am
sure the answer is simple since I am a newbie!!!!
also, this code i just put on a form , do I need to drag the table on form
and make data set and sql adapter and all that, r should this code work
alone? do I have to bind the text boxes in properties window. be kind, I am
new
--
Adam S
"Newbee Adam" wrote:

thanks!!!
is this the basics I need to do a save, that is al i m trying to do is learn
how to do 1 succesful ado.net save
--
Adam S
"Jay Pondy" wrote:

At the top of your source file:

Imports System.Text
Imports System.Configuration.ConfigurationSettings

On Mon, 27 Jun 2005 08:05:06 -0700, "Newbee Adam"
<Ne********@discussions.microsoft.com> wrote:

I am having some problems with getting squgglie lines under stringbuilder and
ConfigurationSettings

what am I doing wrong, is this even close to working? help.
------------------------------------------------------------------------------------
Imports System
Imports System.Data
Imports System.Data.SqlClient
Imports Microsoft.VisualBasic

Public Class Locations
Inherits System.Windows.Forms.Form

#Region " Windows Form Designer generated code "
Private Sub Save_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles Save.Click
Dim mySQLConnection As New
SqlConnection(ConfigurationSettings.AppSettings(" DSN"))
Dim strSQLCommand As New StringBuilder, mySQLCommand As SqlCommand
strSQLCommand = New StringBuilder
With strSQLCommand
.Append("INSERT INTO Locations (Loc_Name, Address, ContactName,
Phone) ")
.Append("VALUES ('" & txtName.Text & "', '" & txtAddress.Text &
"', '" & txtContactName.Text & "', '" & txtPhone.Text & "');")
End With
mySQLConnection.Open()
mySQLCommand = New SqlCommand(strSQLCommand.ToString, mySQLConnection)
mySQLCommand.ExecuteNonQuery()
mySQLConnection.Close()

End Sub
End Class

[Jay Pondy]

You are getting your connection string from AppSettings("DSN") .

Do you have an application configuration file in your project?

If you do - what is the value of the key "DSN" that you are calling
for?

If you don't - check out the System.Configuration stuff in the Docs.

The code you have will work - you do not need to drag a table or
anything else on the form.
On Mon, 27 Jun 2005 10:46:08 -0700, "Newbee Adam"
<Ne********@discussions.microsoft.com> wrote:

i get error , connection string has not been initialized? what is wrong. I am
sure the answer is simple since I am a newbie!!!!
also, this code i just put on a form , do I need to drag the table on form
and make data set and sql adapter and all that, r should this code work
alone? do I have to bind the text boxes in properties window. be kind, I am
new

[Newbee Adam]

I am not sure about the application config file. how would I now, what would
it be called. is there easir way to make connection string. it is simply sql
server db on local machine
--
Adam S
"Jay Pondy" wrote:

You are getting your connection string from AppSettings("DSN") .

Do you have an application configuration file in your project?

If you do - what is the value of the key "DSN" that you are calling
for?

If you don't - check out the System.Configuration stuff in the Docs.

The code you have will work - you do not need to drag a table or
anything else on the form.
On Mon, 27 Jun 2005 10:46:08 -0700, "Newbee Adam"
<Ne********@discussions.microsoft.com> wrote:

i get error , connection string has not been initialized? what is wrong. I am
sure the answer is simple since I am a newbie!!!!
also, this code i just put on a form , do I need to drag the table on form
and make data set and sql adapter and all that, r should this code work
alone? do I have to bind the text boxes in properties window. be kind, I am
new