Easy Visual C# Insert Record Tip?

[gregarican]

I have a simple VC# form that validates its text boxes' contents and I
want to insert these text box contents into an SQL Server 2005 Express
DB. I have added the DB as a data source but right off the bat most of
what I see in terms of visual controls are data grids for displaying
row data and whatnot. What's an easy way to insert my record? In other
words if I start to manually code the insert SQL method how do I refer
to the data source I have added on the visual end?

 

[gregarican]

I have a simple VC# form that validates its text boxes' contents and I
want to insert these text box contents into an SQL Server 2005 Express
DB. I have added the DB as a data source but right off the bat most of
what I see in terms of visual controls are data grids for displaying
row data and whatnot. What's an easy way to insert my record? In other
words if I start to manually code the insert SQL method how do I refer
to the data source I have added on the visual end?

Please disregard. I failed to RTFM and realize that I was looking at
the DataSet and DataTable, but needed to invoke the Insert() method
provided by the TableAdapter.

 

[Kevin Spencer]

Actually, all you need is a SqlConnection and a SqlCommand, unless you want
to bind to a DataSet or DataTable.

--
HTH,

Kevin Spencer
Microsoft MVP
Software Composer
http://unclechutney.blogspot.com

I had the same problem once. Fixed it using the same solution.

 

[gregarican]

Actually, all you need is a SqlConnection and a SqlCommand, unless you want
to bind to a DataSet or DataTable.

--
HTH,

Kevin Spencer
Microsoft MVP
Software Composerhttp://unclechutney.blogspot.com

I had the same problem once. Fixed it using the same solution.







- Show quoted text -

True. I've programmatically used the SqlConnection and SqlCommand
methods when writing ASP code. I just wanted to grasp the IDE way of
achieving something similar using Visual Studio 2005. Now I think I've
gotten my head around the DataSet, DataTable, TableAdapter, etc.
concepts newly introduced with the newer .NET releases. I come from a
background of using other languages like Ruby, Python, and Smalltak.
The middleman idea of the SQL adapter reminds me of some Smalltalk
variations that use presenters and containers to separate the GUI and
underlying logic. MVP/MVC and whatnot...

 

[Kevin Spencer]

Well, you're adding a lot of overhead if all you want to do is an insert. If
you want to be able to edit and update, that's another story.

--
HTH,

Kevin Spencer
Microsoft MVP
Software Composer
http://unclechutney.blogspot.com

I had the same problem once. Fixed it using the same solution.

 

[gregarican]

Well, you're adding a lot of overhead if all you want to do is an insert. If
you want to be able to edit and update, that's another story.

--
HTH,

Kevin Spencer
Microsoft MVP
Software Composerhttp://unclechutney.blogspot.com

I had the same problem once. Fixed it using the same solution.

Good point. This was more just an exercise of getting to know the new
tools at my disposal. Yeah I could've just as easily thrown in a
couple lines of code to accomplish the same things without all of the
extra file baggage