Edit SQL table

[Daniel]

Hi all,

If I want to add rows to an SQL table, can I only do it like this:

Dim commd As SqlCommand = New SqlCommand("insert into table etc....")

Or is there a better way?
Additionally, is there a best pratice method for connecting to SQL and
editing tables? When I google there are just soooo many different ways
of doing it!

--

Daniel
MCSE, MCP+I, MCP in Windows 2000/NT

--------------------------------------
remove the 2nd madrid from my mail address to contact me.

[Lucas Tam]

Daniel <da****@madridmadridsoleado.com> wrote in news:uQkYTKndFHA.3712
@TK2MSFTNGP09.phx.gbl:

Hi all,

If I want to add rows to an SQL table, can I only do it like this:

Dim commd As SqlCommand = New SqlCommand("insert into table etc....")

Or is there a better way?

Take a look at SQL Parameters - they help protect code and simplify your
SQl statements.

Another thing - take a look at Microsoft's Data Application Block (v2 or
v3), it'll help simplify your SQL code.
--
Lucas Tam (RE********@rogers.com)
Please delete "REMOVE" from the e-mail address when replying.
http://members.ebay.com/aboutme/coolspot18/

[Cor Ligthert]

Daniel,

What do you mean with "better". In my opinion are those thousands methods
not made for nothing.

If you need a table with only one row, than I surely advise you the method
you are using now and have absolute no better option.

Cor

[Lucas Tam]

Daniel <da****@madridmadridsoleado.com> wrote in news:uQkYTKndFHA.3712
@TK2MSFTNGP09.phx.gbl:

Hi all,

If I want to add rows to an SQL table, can I only do it like this:

Dim commd As SqlCommand = New SqlCommand("insert into table etc....")

Or is there a better way?

Take a look at SQL Parameters - they help protect code and simplify your
SQl statements.

Another thing - take a look at Microsoft's Data Application Block (v2 or
v3), it'll help simplify your SQL code.
--
Lucas Tam (RE********@rogers.com)
Please delete "REMOVE" from the e-mail address when replying.
http://members.ebay.com/aboutme/coolspot18/

[Cor Ligthert]

Daniel,

What do you mean with "better". In my opinion are those thousands methods
not made for nothing.

If you need a table with only one row, than I surely advise you the method
you are using now and have absolute no better option.

Cor

[Daniel]

Cor Ligthert wrote:

Daniel,

What do you mean with "better". In my opinion are those thousands methods
not made for nothing.

If you need a table with only one row, than I surely advise you the method
you are using now and have absolute no better option.

Cor

Thanks, I have a table and i might be adding 50,000 rows. The app runs
as a service so this is all done in memory rather than a user using a
datagrid. so is my method still OK for this or is there a much faster
one? (like maybe create the entire table in memory and the send it all
at once to the server perhaps?????)

--

Daniel
MCSE, MCP+I, MCP in Windows 2000/NT

--------------------------------------
remove the 2nd madrid from my mail address to contact me.

[Daniel]

Cor Ligthert wrote:

Daniel,

What do you mean with "better". In my opinion are those thousands methods
not made for nothing.

If you need a table with only one row, than I surely advise you the method
you are using now and have absolute no better option.

Cor

Thanks, I have a table and i might be adding 50,000 rows. The app runs
as a service so this is all done in memory rather than a user using a
datagrid. so is my method still OK for this or is there a much faster
one? (like maybe create the entire table in memory and the send it all
at once to the server perhaps?????)

--

Daniel
MCSE, MCP+I, MCP in Windows 2000/NT

--------------------------------------
remove the 2nd madrid from my mail address to contact me.

[Cor Ligthert]

Daniel,

I would absolute for what you tell use the one you are using now.

Assuming it is everytime inserting physical at the end and no updates or
what ever.

I hope this helps,

Cor

[Daniel]

Cor Ligthert wrote:

Daniel,

I would absolute for what you tell use the one you are using now.

Assuming it is everytime inserting physical at the end and no updates or
what ever.

I hope this helps,

Cor

Great, then i'll stick with the existing code. And if I wanted to
update an existing record would I still use this method...?

--

Daniel
MCSE, MCP+I, MCP in Windows 2000/NT

--------------------------------------
remove the 2nd madrid from my mail address to contact me.

[Cor Ligthert]

Daniel,

I would absolute for what you tell use the one you are using now.

Assuming it is everytime inserting physical at the end and no updates or
what ever.

I hope this helps,

Cor

[Daniel]

Cor Ligthert wrote:

Daniel,

I would absolute for what you tell use the one you are using now.

Assuming it is everytime inserting physical at the end and no updates or
what ever.

I hope this helps,

Cor

Great, then i'll stick with the existing code. And if I wanted to
update an existing record would I still use this method...?

--

Daniel
MCSE, MCP+I, MCP in Windows 2000/NT

--------------------------------------
remove the 2nd madrid from my mail address to contact me.

[Cor Ligthert]

Daniel,

Probably yes, are you sure that this program is the only one who does add
and update, otherwise you have to catch the concurrency errors.

And than of course an update command and not an Insert.

Cor

[Daniel]

Cor Ligthert wrote:

Daniel,

Probably yes, are you sure that this program is the only one who does add
and update, otherwise you have to catch the concurrency errors.

And than of course an update command and not an Insert.

Cor

OK thanks.
--

Daniel
MCSE, MCP+I, MCP in Windows 2000/NT

--------------------------------------
remove the 2nd madrid from my mail address to contact me.