Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Beginning .Net : Insert data into SQL Server Database with C# Examples and VB.Net Examples

30 views
Skip to first unread message

Jayesh Sorathia

unread,
Jul 26, 2012, 3:27:42 AM7/26/12
to
You can insert data or records in to SQL Server Database tables using SqlCommand Class.
You can use "ExecuteNonQuery" method of SqlCommand Class.
This article is very useful for .Net Beginners.

Click here to view full article. Click Here... http://jayeshsorathia.blogspot.com/2012/07/beginning-net-insert-data-into-sql-server-database-with-c-cxamples-and-vb-net-examples.html

Arne Vajhøj

unread,
Jul 26, 2012, 10:12:04 AM7/26/12
to
On 7/26/2012 3:27 AM, Jayesh Sorathia wrote:
> You can insert data or records in to SQL Server Database tables using SqlCommand Class.
> You can use "ExecuteNonQuery" method of SqlCommand Class.
> This article is very useful for .Net Beginners.

Hmmm.

If the goal is code that runs, then maybe.

But:
- not utilizing the using statement for guaranteed disposal
- access via SQLServer security instead of integrated security
- variable names with sort of Hungarian notation
- parameter definition and value assignment in single operation
makes the example somewhat mediocre and not so well suited as
learning material.

Arne

Peter Duniho

unread,
Jul 26, 2012, 10:41:33 AM7/26/12
to
On Thu, 26 Jul 2012 10:12:04 -0400, Arne Vajhøj wrote:

> On 7/26/2012 3:27 AM, Jayesh Sorathia wrote:
>> You can insert data or records in to SQL Server Database tables using SqlCommand Class.
>> You can use "ExecuteNonQuery" method of SqlCommand Class.
>> This article is very useful for .Net Beginners.
>
> Hmmm.
>
> If the goal is code that runs, then maybe.
>
> But: [...]

If you're going to start reviewing Jayesh's blog for reasonableness,
efficiency, and practicality, you've got your work cut out for you.

There's a reason he's spamming this newsgroup, and it isn't because he
knows what he's talking about.

If you're ready to call out each and every erroneous suggestion he makes,
more power to you. I think it's great for someone to do that...but it's
like to be a monumental task. I hope you've opened up some room in your
schedule. :)

Pete

Arne Vajhøj

unread,
Jul 26, 2012, 10:52:59 AM7/26/12
to
On 7/26/2012 10:41 AM, Peter Duniho wrote:
> On Thu, 26 Jul 2012 10:12:04 -0400, Arne Vajhøj wrote:
>
>> On 7/26/2012 3:27 AM, Jayesh Sorathia wrote:
>>> You can insert data or records in to SQL Server Database tables using SqlCommand Class.
>>> You can use "ExecuteNonQuery" method of SqlCommand Class.
>>> This article is very useful for .Net Beginners.
>>
>> Hmmm.
>>
>> If the goal is code that runs, then maybe.
>>
>> But: [...]
>
> If you're going to start reviewing Jayesh's blog for reasonableness,
> efficiency, and practicality, you've got your work cut out for you.
>
> There's a reason he's spamming this newsgroup, and it isn't because he
> knows what he's talking about.

He seems to read what is being written here and improve based on it.

So maybe he is more like a C# Roedy than a traditional plagiarizing
blog spammer.

Arne

Peter Duniho

unread,
Jul 27, 2012, 1:53:25 AM7/27/12
to
On Thu, 26 Jul 2012 10:52:59 -0400, Arne Vajhøj wrote:

> He seems to read what is being written here and improve based on it.

Not everything. Like, suggestions that he comply with community standards.

> So maybe he is more like a C# Roedy than a traditional plagiarizing
> blog spammer.

Faint praise indeed. :)

But you're a good man for giving him the benefit of the doubt.
0 new messages