ASP.NET

Christian Graus5-Oct-07 23:38

5-Oct-07 23:38

stops IIS and starts it again.

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

rockyl6-Oct-07 0:31

rockyl

6-Oct-07 0:31

Hi,

I can clearly see in the command prompt that the IIS gets stop and then started when I run the command IISRESET. What I was looking is that what happens internally in the IIS, which fixes lot of issues raised in the webapplications.

How it is a single solution for many problems?

Thanks,
Rakesh

Rakesh

Christian Graus6-Oct-07 0:33

6-Oct-07 0:33

It will cause your web app to restart, thus solving, for example, issues where your use of session state gets tied in knots.

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

Abhijit Jana6-Oct-07 0:39

Abhijit Jana

6-Oct-07 0:39

It's Strat and Stop the IIS..

WE are deploying our web application to IIS, and it has a link with Framework version also.

Instated of Run command u can reset ur IIS programitacally also accordign to ur requirment !!!! Cool | :cool:

Good luck !!!

Happy Programming
-----
Abhijit

asp.net intraction with database

Urs Enzler6-Oct-07 3:35

Urs Enzler

6-Oct-07 3:35

type iisreset /h into a command prompt and you'll see all possible commands with (short) explanations.

-^-^-^-^-^-
no risk no funk ................... please vote ------>

radio button

venky4565-Oct-07 23:17

venky456

5-Oct-07 23:17

Hi i am using two radio buttons in my application.
here one button set as default at page load.the second button selection code results write in javascript.if i select second button and run the code then results display,the checking of second button go to default.because page loaded,i want to checking second button still display results also.plz send answer
regards

venkat

Sonia Gupta5-Oct-07 23:03

5-Oct-07 23:03

i know the cursors and triggers . but can u tell me the real life situation when i can implement these things in asp.net. I mean so far i implemented tables , views , stored procedure , functions in languages

Soniagupta1@yahoo.co.in
Yahoo Messenger Id = soniagupta1

John-ph5-Oct-07 23:19

John-ph

5-Oct-07 23:19

Sonia Gupta wrote:
i know the cursors and triggers . but can u tell me the real life situation when i can implement these things in asp.net. I mean so far i implemented tables , views , stored procedure , functions in languages

It can't be Implemented in asp.net...

Regards
J O H N

"Even eagles need a push." David McNally

Sonia Gupta5-Oct-07 23:33

5-Oct-07 23:33

well cool answers.... Thanks.
if u change the point of view to some technical aspects (I mean cursors and triggers interaction with languages)

Soniagupta1@yahoo.co.in
Yahoo Messenger Id = soniagupta1

Christian Graus5-Oct-07 23:42

5-Oct-07 23:42

Sonia Gupta wrote:
but can u tell me the real life situation when i can implement these things in asp.net.

Never. cursors, triggers, tables, views and stored procs have nothing to do with ASP.NET, they relate to SQL.

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

reference parameters in user defined functions

Abhijit Jana6-Oct-07 0:59

Abhijit Jana

6-Oct-07 0:59

Hi Sonia,

I think This will work for you Smile | :)

http://dotnetjunkies.com/Article/9AE62C44-3841-4687-B906-2F6D4A5A4622.dcik[^]

Thanks in advance !!!

Happy Programming
-----
Abhijit

Sonia Gupta5-Oct-07 22:39

Re: reference parameters in user defined functions

5-Oct-07 22:39

can i use the reference parameteres in the sql user defined functions.
actuallty i wanted to retrieve two values from the function.

Soniagupta1@yahoo.co.in
Yahoo Messenger Id = soniagupta1

Christian Graus5-Oct-07 23:40

AppSettings vs. ConnectionStrings in .NET 2.0 [modified]

5-Oct-07 23:40

This is a SQL question, you should ask it in the SQL forum.

Did you buy that book yet ?

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

alfakappasigma5-Oct-07 22:29

alfakappasigma

5-Oct-07 22:29

I have the following code (works fine in .NET 1.x) which I believe expects to get the connectionstring from the key-value pair within <appSettings>...</appSettings> block in my web.config file. But I'm using .NET 2.0 now and all of my connection strings are within <connectionstrings>...</connectionstrings> block. How can I convert this line:
string strConnexn = SecureConnection.GetCnxString("cnxNWSecure");

to read my connectionstring from <connectionstrings>...</connectionstrings> block and not from <appsettings>...</appsettings>.

I'm familiar with the following in .NET 2.0 which doesn't involve string encryption & decryption:

string strConnexn = ConfigurationManager.ConnectionStrings["cnxNonSecure"].ToString()

What I'm looking for is something that works for secure connection.

Here's a chunk of code from a function for your review:
...
try
{
// Grab the encrypted connection string and decrypt it
string strConnexn = SecureConnection.GetCnxString("cnxNWSecure");

// Establish DB connection
using(SqlConnection cnxString = new SqlConnection(strConnexn))
{
cnxString.Open();
// Perform operation
...
}
...

Thank you in advance for your advice and support.

Anjani K Shiwakoti

Computer programs and social cultures are the same.

-- modified at 4:48 Saturday 6th October, 2007

stored procedures in asp.net

Sonia Gupta5-Oct-07 21:42

5-Oct-07 21:42

i was using stored procedures in the asp.net and in the stored procedure i am using functions there in the stored procedure i wrote the following line to call he function

@itemid int,
@subitemid int,
@SSubItemId int,
@typeMasterid int,
@subtypeMasterid int

declare @lifeid int
set @lifeid = 0
@lifeid = FLifeId(@itemid,@subitemid,@SSubItemId,@typeMasterid,@subtypeMasterid)

and error occured
incorrect systax near @lifeid

Soniagupta1@yahoo.co.in
Yahoo Messenger Id = soniagupta1

Imran Khan Pathan5-Oct-07 21:44

Imran Khan Pathan

5-Oct-07 21:44

Sonia Gupta wrote:
set @lifeid = 0
@lifeid = FLifeId(@itemid,@subitemid,@SSubItemId,@typeMasterid,@subtypeMasterid)

set @lifeid = FLifeId(@itemid,@subitemid,@SSubItemId,@typeMasterid,@subtypeMasterid)

bEST rEGARD

pATHAN

please don't forget to vote on the post that helped you.

Sonia Gupta5-Oct-07 21:55

5-Oct-07 21:55

now the error is flifeid is not the recognized function name , but it exist in the database, i created a user defined function name

Soniagupta1@yahoo.co.in
Yahoo Messenger Id = soniagupta1

Sonia Gupta5-Oct-07 23:31

5-Oct-07 23:31

it was dbo which was needed to be appended with ehe table name.
well Thanks , the problem is solved.

Soniagupta1@yahoo.co.in
Yahoo Messenger Id = soniagupta1

Christian Graus5-Oct-07 23:42

5-Oct-07 23:42

It depresses me how few people who use these forums have any idea what ASP.NET is, and is not.

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )