ASP.NET

12-Nov-09 20:16

You don't need a reader at all. Just do a count and if count is greater than 0, you have the user. Work with ExecuteScalar(). Something like

select count(*) from table where user = @user

Best wishes,
Navaneeth

Re: Data base

Amit Patel198512-Nov-09 20:25

Amit Patel1985

12-Nov-09 20:25

Hi,

Thanks for ur suggestion.

Thanks,

Amit PAtel

regarding unit testing

Amit Spadez12-Nov-09 19:06

Amit Spadez

12-Nov-09 19:06

In the visual studio 2008, there is tool "test" in the menu bar.
what's the use of this tool . can anyone give one example as I'm a beginner in this

N a v a n e e t h12-Nov-09 19:38

12-Nov-09 19:38

It allows you to manage with automated tests. You can write the tests and execute it inside VS itself.

Best wishes,
Navaneeth

Amit Spadez12-Nov-09 19:45

Amit Spadez

12-Nov-09 19:45

yes..but could u give some example so that I could understood well???

N a v a n e e t h12-Nov-09 19:59

12-Nov-09 19:59

Well, I hope you are aware about the automated test tools like NUnit.

Before VS2008, to execute a test, you need to write it and use the assembly with tools like NUnit. These tools uses reflection to read the test methods from the assembly and execute it. Since Vs2008, MS provided a test framework inside visual studio so that you don't have to use other applications like NUnit.

But in reality, VS test framework is used very rarely. Most of the people (including me) still uses NUnit or a better alternative.

Best wishes,
Navaneeth

sashidhar12-Nov-09 19:42

sashidhar

12-Nov-09 19:42

Refer this link it may be helpful
http://anants-blog.blogspot.com/2008/01/unit-testing-starter-vsnet-2008.html[^]

LatestArticle :Log4Net
Why Do Some People Forget To Mark as Answer .If It Helps.

session timeout

Dot-Net-Dev12-Nov-09 18:00

Dot-Net-Dev

12-Nov-09 18:00

Hi,

I am working on ASP.NET C# application.
Everything is working fine on the local machine but on the server my application's session timeout after two minutes.
I haven't set the session timeout in web.config. Please tell me the reason of this. Also tell me what is the unit of session timeout minute, second or millisecond.

Thanks
Sonia

Aman Bhullar12-Nov-09 19:30

Aman Bhullar

12-Nov-09 19:30

Sonia Shahid wrote:
I haven't set the session timeout in web.config

Set Session timeout as

<sessionState mode="InProc"
            stateConnectionString="tcpip=127.0.0.1:42424"
            sqlConnectionString="data source=127.0.0.1;Trusted_Connection=yes"
            cookieless="false" 
            timeout="50" />

Sonia Shahid wrote:
Also tell me what is the unit of session timeout minute, second or millisecond

Minutes

Regards
Aman Bhullar
www.arlivesupport.com[^]

N a v a n e e t h12-Nov-09 19:43

12-Nov-09 19:43

Sonia Shahid wrote:
but on the server my application's session timeout after two minutes.

Session will end when ASP.NET worker process recycles. You need to make sure your code is not doing something like updating web.config at the run-time that will recycle the worker process.

Sonia Shahid wrote:
Also tell me what is the unit of session timeout minute, second or millisecond.

It is in minutes.

Best wishes,
Navaneeth

Paulo Zemek13-Nov-09 7:31

Paulo Zemek

13-Nov-09 7:31

Try setting the timeout in the Web.config. If you don't set it, I think it could still not be the default value if the Machine.config has a different value for it.

Also, any page can reset the time-out.

Mail sending error-Partial Class Mailreceiver

Gamzun13-Nov-09 9:17

Gamzun

13-Nov-09 9:17

Yes, you're right. That's the root config applies if nothing is configured at lower level. Define your session timeout and it will work as charm.

Please don't forget to mark 'Good Answer', if you find it really a good one!

Kashif

Interop Excel

mithun narayanan12-Nov-09 17:40

mithun narayanan

12-Nov-09 17:40

Hi all,

i am using Interop for excel.

i need to set border style as solid and border color for particular cells.
am using the following code, which is not working....
Please correct it...

<code>
oRange = (Excel.Range)oSheet.Cells[i, j+1];
oRange.Borders.Weight = BorderStyle.Solid;
oRange.Cells.Borders.ColorIndex = 11;

</code>

Thanks and regards

Member 426027012-Nov-09 16:57

12-Nov-09 16:57

Hi all,

I am using one function to send mail.I have written 4 different functions in a single page(Mailreceiver.aspx),and call according to the hosting server.I am using these mail facilities successfully in my other sites.But I run this in one project I got the error that

'Server Error in '/' Application'

Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately.

Compiler Error Message: ASPNET: Make sure that the class defined in this code file matches the 'inherits' attribute, and that it extends the correct base class (e.g. Page or UserControl).

and show the error in the line with a red color

Partial Class Mailreceiver

So anyone know about this.Pls help me

Thanks
Denny

N a v a n e e t h12-Nov-09 17:41

12-Nov-09 17:41

As the error says, you need to look into the inherits attribute in the ASPX page.

Best wishes,
Navaneeth

Member 426027012-Nov-09 19:49

12-Nov-09 19:49

I have checked there,but I didn't find anything

N a v a n e e t h12-Nov-09 20:00

12-Nov-09 20:00

Member 4260270 wrote:
but I didn't find anything

You didn't find the inherits attribute at all?

Best wishes,
Navaneeth

Member 426027012-Nov-09 20:09

12-Nov-09 20:09

I saw it but i didn't understand the problem.

<%@ Page Language="VB" autoeventwireup="false" inherits="Mailreceiver" CodeFile="Mailreceiver.aspx.vb" %>

Is there any problem?

N a v a n e e t h12-Nov-09 20:17

12-Nov-09 20:17

Go to Mailreceiver.aspx.vb and see from which class it inherits.

Best wishes,
Navaneeth

Member 426027012-Nov-09 20:26