ASP.NET

5-Sep-07 20:01

There is no direct method available it seems. You could use a flag column and change the value when a user starts editing record. Before editing check this flag value.

My Website | Ask smart questions

Re: Lock record

Malcolm Smart5-Sep-07 20:59

Malcolm Smart

5-Sep-07 20:59

If you use this method, make sure you have the ability to reset the column on error. (try /catch / finally). If your code crashes after setting this column for edit, and before resetting it, nobody else will be able to edit.

In C++ I would generally use RAII for something like this, but C# destructors are non deterministic, so RAII has to be implemented via 'using'.

"More functions should disregard input values and just return 12. It would make life easier." - comment posted on WTF

"I haven't spoken to my wife now for 48 hours. I don't like to interrupt her.

Re: Lock record

N a v a n e e t h5-Sep-07 22:36

error when deploy asp.net website

5-Sep-07 22:36

Malcolm Smart wrote:
f you use this method, make sure you have the ability to reset the column on error. (try /catch / finally). If your

Yes that's correct. No will be able to edit it. Good point

My Website | Ask smart questions

ABBASI_RA5-Sep-07 19:50

ABBASI_RA

5-Sep-07 19:50

i create an asp.net website using membership and ..
it works fine on local but when i deploy it to internet this error occures:
--------------------------
An error has occurred while establishing a connection to the server.
When connecting to SQL Server 2005, this failure may be caused by the
fact that under the default settings SQL Server does not allow remote
connections. (provider: SQL Network Interfaces, error: 26 - Error
Locating Server/Instance Specified)
---------------------------
My web config contains this:

<connectionStrings>

<remove name="LocalSqlServer"/>

<add name="LocalSqlServer" connectionString="Data Source=.
\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|
aspnetdb.mdf;User Instance=true" providerName="System.Data.SqlClient" />
</connectionStrings>

any one can help me ..???
thanks

Re: error when deploy asp.net website

Michael Sync5-Sep-07 19:58

Michael Sync

5-Sep-07 19:58

ABBASI_RA wrote:
<add name="LocalSqlServer" connectionstring="Data Source=.
\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|
aspnetdb.mdf;User Instance=true" providername="System.Data.SqlClient">

I think you can't probably use "." in hosting. You should ask your hosting service about how to connect to your SQL database. We can't say about that for sure since the connectionstring might differ from host to host...

Re: error when deploy asp.net website

ABBASI_RA5-Sep-07 21:36

ABBASI_RA

5-Sep-07 21:36

thanks
i ask it and they dont support sqlexpress
i found its way...
thanks again

Validation for all controls in ASP.Net

Priya_20075-Sep-07 19:43

5-Sep-07 19:43

Iam using ASP.Net2.0 with VB.Net.
Iam having a code for validation to the controls which can be called on KEYpress Event i.e. checking for each keypress event related to that control where I have written this code in vbscript.How that function can be called in application or to a control
Can anybody give me the exact syntax to this or help in writing easiest way fro validation of all the controls.

Priya

Michael Sync5-Sep-07 19:55

Michael Sync

5-Sep-07 19:55

txtName.Attribute.Add("onkeypress","yourvbscriptfunction")?

N a v a n e e t h5-Sep-07 19:59

5-Sep-07 19:59

Priya_2007 wrote:
How that function can be called in application or to a control

You have to add attributes to all the controls. Assume you have a textbox with name Text1, then you could add Text1.Attributes.Add("onkeypress","function()"). You should change the event name and calling methods according to VBScript syntax.

Priya_2007 wrote:
I have written this code in vbscript.

Why ? Better use javascript. VBScript is supported only in Internet Explorer.

My Website | Ask smart questions

Priya_20075-Sep-07 20:40

5-Sep-07 20:40

In which event I have to write the text1.attributes.add("onkeypress","function()")
Parameters of the Function will be valuetype,keyascii of pressed key,text present in the control
How this can be specified

Priya

N a v a n e e t h5-Sep-07 20:53

5-Sep-07 20:53

Priya_2007 wrote:
In which event I have to write the text1.attributes.add("onkeypress","function()")

felicitous place would be Page_Load().

Priya_2007 wrote:
Parameters of the Function will be valuetype,keyascii of pressed key,text present in the control

What is valuetype ? I am not well-known in VBScript. In javascript it can be written like

Text1.Attributes.Add("OnKeyPress","Function(valuetype,event);");

event contains the keyCode which is used to find what is the key pressed.

My Website | Ask smart questions

Priya_20075-Sep-07 21:26

5-Sep-07 21:26

Where I have to write the VBScript function either in the Source file or COde File.

Or else can u please suggest where to VBscript file outside and importing of that vbscript file into the project

Priya

Imran Khan Pathan5-Sep-07 21:53

Imran Khan Pathan

5-Sep-07 21:53

U can use vbscript file in Source

<Script language="VB">
code here
</Script>

Best Regard
Patha

---------------------------------------------------

Priya_20075-Sep-07 23:05

5-Sep-07 23:05

code here

THis can be written in the Source file where I have to call the Function present in the Script into code file which may not move to the function present in the Source file.

Priya

N a v a n e e t h5-Sep-07 22:39