is it so tedious to update a record

[ad]

I found an example in Starter kit.
Is it so tedious to update a record.
----------------------------------------------------------------------------
-------------
SqlConnection myConnection = new
SqlConnection(C onfigurationSet tings.AppSettin gs["connectionStri ng"]);
SqlCommand myCommand = new SqlCommand("Por tal_UpdateConta ct",
myConnection);

// Mark the Command as a SPROC
myCommand.Comma ndType = CommandType.Sto redProcedure;

// Add Parameters to SPROC
SqlParameter parameterItemID = new SqlParameter("@ ItemID",
SqlDbType.Int, 4);
parameterItemID .Value = itemId;
myCommand.Param eters.Add(param eterItemID);

SqlParameter parameterUserNa me = new SqlParameter("@ UserName",
SqlDbType.NVarC har, 100);
parameterUserNa me.Value = userName;
myCommand.Param eters.Add(param eterUserName);

SqlParameter parameterName = new SqlParameter("@ Name",
SqlDbType.NVarC har, 100);
parameterName.V alue = name;
myCommand.Param eters.Add(param eterName);

SqlParameter parameterRole = new SqlParameter("@ Role",
SqlDbType.NVarC har, 100);
parameterRole.V alue = role;
myCommand.Param eters.Add(param eterRole);

SqlParameter parameterEmail = new SqlParameter("@ Email",
SqlDbType.NVarC har, 100);
parameterEmail. Value = email;
myCommand.Param eters.Add(param eterEmail);

SqlParameter parameterContac t1 = new SqlParameter("@ Contact1",
SqlDbType.NVarC har, 100);
parameterContac t1.Value = contact1;
myCommand.Param eters.Add(param eterContact1);

SqlParameter parameterContac t2 = new SqlParameter("@ Contact2",
SqlDbType.NVarC har, 100);
parameterContac t2.Value = contact2;
myCommand.Param eters.Add(param eterContact2);

myConnection.Op en();
myCommand.Execu teNonQuery();
myConnection.Cl ose();

[Kevin Spencer]

> Is it so tedious to update a record.

Compared to what?

There are all kinds of database apps. There are all kinds of database
operations. There are all kinds of ways of getting it done. Your example
shows one approach to doing a database update in a specific set of
circumstances. It is not an example of the only way to update a database
under any circumstances.

An example is just that: an example. It is usually for the purpose of
demonstrating one or a few aspects of a programming technology. It is not
meant as a template for everything you do with databases.

As for tedious, well, that's subjective. I occasionally run into some jobs
that I consider tedious. However, I couldn't tell you whether those jobs
would be considered tedious by everyone. In my case, tedious is something
I've done many times before. However, in your case, tedious is apparently
something entirely different.

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
What You Seek Is What You Get.

"ad" <[e-mail] u.tw> wrote in message
news:ud******** ******@TK2MSFTN GP10.phx.gbl...

I found an example in Starter kit.
Is it so tedious to update a record.
----------------------------------------------------------------------------
-------------
SqlConnection myConnection = new
SqlConnection(C onfigurationSet tings.AppSettin gs["connectionStri ng"]);
SqlCommand myCommand = new SqlCommand("Por tal_UpdateConta ct",
myConnection);

// Mark the Command as a SPROC
myCommand.Comma ndType = CommandType.Sto redProcedure;

// Add Parameters to SPROC
SqlParameter parameterItemID = new SqlParameter("@ ItemID",
SqlDbType.Int, 4);
parameterItemID .Value = itemId;
myCommand.Param eters.Add(param eterItemID);

SqlParameter parameterUserNa me = new SqlParameter("@ UserName",
SqlDbType.NVarC har, 100);
parameterUserNa me.Value = userName;
myCommand.Param eters.Add(param eterUserName);

SqlParameter parameterName = new SqlParameter("@ Name",
SqlDbType.NVarC har, 100);
parameterName.V alue = name;
myCommand.Param eters.Add(param eterName);

SqlParameter parameterRole = new SqlParameter("@ Role",
SqlDbType.NVarC har, 100);
parameterRole.V alue = role;
myCommand.Param eters.Add(param eterRole);

SqlParameter parameterEmail = new SqlParameter("@ Email",
SqlDbType.NVarC har, 100);
parameterEmail. Value = email;
myCommand.Param eters.Add(param eterEmail);

SqlParameter parameterContac t1 = new SqlParameter("@ Contact1",
SqlDbType.NVarC har, 100);
parameterContac t1.Value = contact1;
myCommand.Param eters.Add(param eterContact1);

SqlParameter parameterContac t2 = new SqlParameter("@ Contact2",
SqlDbType.NVarC har, 100);
parameterContac t2.Value = contact2;
myCommand.Param eters.Add(param eterContact2);

myConnection.Op en();
myCommand.Execu teNonQuery();
myConnection.Cl ose();

[Scott Allen]

As Kevin says - there are many ways to accomplish the same task. If
you think the code is tedious to write, let some tools autogenerate
the code for you:

http://blog.hundhausen.com/PermaLink...5-a582fde8a0fc

--
Scott
http://www.OdeToCode.com/blogs/scott/
On Tue, 29 Mar 2005 20:34:10 +0800, "ad" <[e-mail] u.tw> wrote:

I found an example in Starter kit.
Is it so tedious to update a record.
----------------------------------------------------------------------------
-------------
SqlConnection myConnection = new
SqlConnection( ConfigurationSe ttings.AppSetti ngs["connectionStri ng"]);
SqlCommand myCommand = new SqlCommand("Por tal_UpdateConta ct",
myConnection );

// Mark the Command as a SPROC
myCommand.Comma ndType = CommandType.Sto redProcedure;

// Add Parameters to SPROC
SqlParameter parameterItemID = new SqlParameter("@ ItemID",
SqlDbType.In t, 4);
parameterItemID .Value = itemId;
myCommand.Param eters.Add(param eterItemID);

SqlParameter parameterUserNa me = new SqlParameter("@ UserName",
SqlDbType.NVar Char, 100);
parameterUserNa me.Value = userName;
myCommand.Param eters.Add(param eterUserName);

SqlParameter parameterName = new SqlParameter("@ Name",
SqlDbType.NVar Char, 100);
parameterName.V alue = name;
myCommand.Param eters.Add(param eterName);

SqlParameter parameterRole = new SqlParameter("@ Role",
SqlDbType.NVar Char, 100);
parameterRole.V alue = role;
myCommand.Param eters.Add(param eterRole);

SqlParameter parameterEmail = new SqlParameter("@ Email",
SqlDbType.NVar Char, 100);
parameterEmail. Value = email;
myCommand.Param eters.Add(param eterEmail);

SqlParameter parameterContac t1 = new SqlParameter("@ Contact1",
SqlDbType.NVar Char, 100);
parameterContac t1.Value = contact1;
myCommand.Param eters.Add(param eterContact1);

SqlParameter parameterContac t2 = new SqlParameter("@ Contact2",
SqlDbType.NVar Char, 100);
parameterContac t2.Value = contact2;
myCommand.Param eters.Add(param eterContact2);

myConnection.Op en();
myCommand.Execu teNonQuery();
myConnection.Cl ose();

[Ken Dopierala Jr.]

Hi,

You can rewrite this :

SqlParameter parameterItemID = new SqlParameter("@ ItemID", SqlDbType.Int,
4);
parameterItemID .Value = itemId;
myCommand.Param eters.Add(param eterItemID);

Like this :

myCommand.Param eters.Add("@Ite mID", SqlDbType.Int). Value = itemId;

This will cut the number of lines of code you are typing to 1/3. Other than
that you'll need to use a 3rd party tool that autogenerates SP calls. I've
never used one so I don't have one to recommend. Good luck! Ken.

--
Ken Dopierala Jr.
For great ASP.Net web hosting try:
http://www.webhost4life.com/default.asp?refid=Spinlight
If you sign up under me and need help, email me.

"ad" <[e-mail] u.tw> wrote in message
news:ud******** ******@TK2MSFTN GP10.phx.gbl...

I found an example in Starter kit.
Is it so tedious to update a record.
-------------------------------------------------------------------------- -- -------------
SqlConnection myConnection = new
SqlConnection(C onfigurationSet tings.AppSettin gs["connectionStri ng"]);
SqlCommand myCommand = new SqlCommand("Por tal_UpdateConta ct",
myConnection);

// Mark the Command as a SPROC
myCommand.Comma ndType = CommandType.Sto redProcedure;

// Add Parameters to SPROC
SqlParameter parameterItemID = new SqlParameter("@ ItemID",
SqlDbType.Int, 4);
parameterItemID .Value = itemId;
myCommand.Param eters.Add(param eterItemID);

SqlParameter parameterUserNa me = new SqlParameter("@ UserName",
SqlDbType.NVarC har, 100);
parameterUserNa me.Value = userName;
myCommand.Param eters.Add(param eterUserName);

SqlParameter parameterName = new SqlParameter("@ Name",
SqlDbType.NVarC har, 100);
parameterName.V alue = name;
myCommand.Param eters.Add(param eterName);

SqlParameter parameterRole = new SqlParameter("@ Role",
SqlDbType.NVarC har, 100);
parameterRole.V alue = role;
myCommand.Param eters.Add(param eterRole);

SqlParameter parameterEmail = new SqlParameter("@ Email",
SqlDbType.NVarC har, 100);
parameterEmail. Value = email;
myCommand.Param eters.Add(param eterEmail);

SqlParameter parameterContac t1 = new SqlParameter("@ Contact1",
SqlDbType.NVarC har, 100);
parameterContac t1.Value = contact1;
myCommand.Param eters.Add(param eterContact1);

SqlParameter parameterContac t2 = new SqlParameter("@ Contact2",
SqlDbType.NVarC har, 100);
parameterContac t2.Value = contact2;
myCommand.Param eters.Add(param eterContact2);

myConnection.Op en();
myCommand.Execu teNonQuery();
myConnection.Cl ose();

[Steve C. Orr [MVP, MCSD]]

Data Access code such as this can be dramatically simplified by using
Microsoft's free Data Application Block.
Here's more info:
http://aspnet.4guysfromrolla.com/articles/070203-1.aspx

--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://SteveOrr.net
"ad" <[e-mail] u.tw> wrote in message
news:ud******** ******@TK2MSFTN GP10.phx.gbl...

I found an example in Starter kit.
Is it so tedious to update a record.
----------------------------------------------------------------------------
-------------
SqlConnection myConnection = new
SqlConnection(C onfigurationSet tings.AppSettin gs["connectionStri ng"]);
SqlCommand myCommand = new SqlCommand("Por tal_UpdateConta ct",
myConnection);

// Mark the Command as a SPROC
myCommand.Comma ndType = CommandType.Sto redProcedure;

// Add Parameters to SPROC
SqlParameter parameterItemID = new SqlParameter("@ ItemID",
SqlDbType.Int, 4);
parameterItemID .Value = itemId;
myCommand.Param eters.Add(param eterItemID);

SqlParameter parameterUserNa me = new SqlParameter("@ UserName",
SqlDbType.NVarC har, 100);
parameterUserNa me.Value = userName;
myCommand.Param eters.Add(param eterUserName);

SqlParameter parameterName = new SqlParameter("@ Name",
SqlDbType.NVarC har, 100);
parameterName.V alue = name;
myCommand.Param eters.Add(param eterName);

SqlParameter parameterRole = new SqlParameter("@ Role",
SqlDbType.NVarC har, 100);
parameterRole.V alue = role;
myCommand.Param eters.Add(param eterRole);

SqlParameter parameterEmail = new SqlParameter("@ Email",
SqlDbType.NVarC har, 100);
parameterEmail. Value = email;
myCommand.Param eters.Add(param eterEmail);

SqlParameter parameterContac t1 = new SqlParameter("@ Contact1",
SqlDbType.NVarC har, 100);
parameterContac t1.Value = contact1;
myCommand.Param eters.Add(param eterContact1);

SqlParameter parameterContac t2 = new SqlParameter("@ Contact2",
SqlDbType.NVarC har, 100);
parameterContac t2.Value = contact2;
myCommand.Param eters.Add(param eterContact2);

myConnection.Op en();
myCommand.Execu teNonQuery();
myConnection.Cl ose();