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/2...-examples.html

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

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