ASP.NET

How Is Possible Check Row Affected

15-Nov-06 0:20

use javascript, search google for javascript timer and when time passed just submit form back to server

Pilo

marconi Flangepants14-Nov-06 4:38

14-Nov-06 4:38

Hows it is possible to tell when rows in SQL database have been updated by the update command?

My page does need to know if the row is now renewed with the data, and how many rows was updated.

Your help is needs must.

http://msdn2.microsoft.com/en-us/library/system.data.sqlclient.sqldataadapter.rowupdated.aspx[^]

indianet14-Nov-06 5:47

indianet

14-Nov-06 5:47

marconi Flangepants14-Nov-06 7:29

14-Nov-06 7:29

I read this but it does not make clear to me.

Not Active14-Nov-06 6:38

Not Active

14-Nov-06 6:38

If you are using 2.0 look at SqlDependency or SqlCacheDependency

only two letters away from being an asset

marconi Flangepants14-Nov-06 7:34

14-Nov-06 7:34

Perhaps i not make myself clear.

I code the SqlConnection with Update command manually and update the record. Inot use any DataSet or others. When i run Update it update the informations.

This is good.

But how do i see how many rows records have been updated?

Please your help for i read the dependencies infos but not mean anything to me. This is not right for my problem i think.

Thank

Not Active14-Nov-06 8:31

Not Active

14-Nov-06 8:31

ExecuteNonQuery

"For UPDATE, INSERT, and DELETE statements, the return value is the number of rows affected by the command. For all other types of statements, the return value is -1."

only two letters away from being an asset

marconi Flangepants14-Nov-06 8:38

14-Nov-06 8:38

Many Thank For Answer.

My question is how do i find this information to make us of please?

I know not how i get this return value from Insert statement.

Not Active14-Nov-06 8:52

Not Active

14-Nov-06 8:52

marconi Flangepants wrote:
how do i find this information

Microsoft is very clever, they keep this stuff hidden very securely on a public site called MSDN[^]. Perhaps you've heard it mentioned a few million times in these forums.

only two letters away from being an asset

marconi Flangepants14-Nov-06 10:01

14-Nov-06 10:01

Is my question make angry?

Sorry that my brain does not knows these things yet.

l0kke15-Nov-06 0:25

15-Nov-06 0:25

I don't see a problem... I suppose you use SqlCommand to run your UPDATE statement, right? And SqlCommand.ExecuteNonQuery method returns you number of affected rows...

Or do I not understand what you mean?

Pilo

marconi Flangepants15-Nov-06 23:50

15-Nov-06 23:50

Yes,

I do like this

<code>SqlConnection6.ConnectionString = "connstring goes here";
string sql = "update string goes here";
SqlCommand cmd = new SqlCommand(sql, SqlConnection6);

SqlConnection6.Open();
cmd.ExecuteNonQuery();
SqlConnection6.Close();</code>

So how from this must i get number of rows please?

l0kke16-Nov-06 0:40

Best way to localized applications in .NET 2.0?

16-Nov-06 0:40

int rowsAffected = cmd.ExecuteNonQuery();

we call it return value Smile | :)

Pilo

wojti14-Nov-06 4:05

wojti

14-Nov-06 4:05

Hi,

I would like to ask you what is the best way to localize applications in .NET 2.0 and
how Microsoft do it in Vista?

Wojtek

Re: Best way to localized applications in .NET 2.0?

l0kke15-Nov-06 6:47