Re: Stored procedure - ASP.NET Discussion Boards

tek 200918-May-10 22:35

tek 2009

18-May-10 22:35

thank you for those links, but despite that, I could not do this action, display a vertical menu by clicking on a horizontal menu, please help me

User Control

MWRivera18-May-10 4:54

MWRivera

18-May-10 4:54

Hi All,

I'm user VS 2005 and wanted to know if it's possible to create a user control that can be used in both a Windows Application and a WebSite?

I'm coding in C# with ASP.NET.

I'm wanting to create a control like the DateTimePicker, which is available when creating Windows Applications, but it doesn't seem to be available when creating WebSites. Please tell me if I'm wrong, this way I can build upon the existing control. Thanks.

If you know of any websites that might be useful, I would be very geratful if you shared them.

Thanks in advance.
Mel

Re: User Control

Not Active18-May-10 5:55

Not Active

18-May-10 5:55

MWRivera wrote:
a user control that can be used in both a Windows Application and a WebSite?

Not possible, they are two separate environments.

I know the language. I've read a book. - _Madmatt

Re: User Control

Dhyanga18-May-10 6:00

Dhyanga

18-May-10 6:00

I think we can create control like dateTimePicker for websites. Well you can create it using javascripts for that.

http://www.javascript-examples.com/javascript-calendars[^]

http://www.kelvinluck.com/assets/jquery/datePicker/v2/demo/datePickerDefaultToday.html[^]

well there are so many in the google if you search. But just try this one...

suchita

Re: User Control

Sandeep Mewara18-May-10 6:50

Sandeep Mewara

18-May-10 6:50

You are right but... he wanted to develop only 1 control for both Web & windows... which is not feasible as they both are totally different.

He only can develop something similar look wise and they way the works but they have to be two different controls!

Re: User Control

MWRivera19-May-10 4:30

MWRivera

19-May-10 4:30

Thanks for the replies guys. I guess I was hoping for a long shot.

Yes you're right Sandeep I was asking if I it was possible to create a single control taht could be used in both enviroments.

Does anyone know any alternative was of create a control that can be used within both enviroments. Or is there no avoiding two seperate controls?

Thanks,
Mel

Stored procedure

Morgs Morgan18-May-10 4:39

Morgs Morgan

18-May-10 4:39

Hi guys,
I am executing a stored procedure from my webservices, i would like this store procedure to check is a userid exist and if it does then i would like to return a value saying so.
Here is a quick proc...i don't know how to carry on from here.

USE [reportserver]
GO

--Create the Procedure
CREATE PROCEDURE FindCurrentUser(@userid VARCHAR(10), @RowCount VARCHAR(10) output)
AS
BEGIN
	IF EXISTS(SELECT * FROM [UserProfile] WHERE [userid] = @userid)
	BEGIN
		RETURN @RowCount = 'Exists'
	END
	ELSE
	BEGIN
		RETURN @RowCount = 'NotExists'
	END
END

but it gives me an error:
'Incorrect syntax near '='
Any help please??

Thanks,
Morg

Re: Stored procedure

R. Giskard Reventlov18-May-10 4:55

R. Giskard Reventlov

18-May-10 4:55

Here's one way:

USE [reportserver]
GO

--Create the Procedure
CREATE PROCEDURE FindCurrentUser(@userid VARCHAR(10))
AS
BEGIN
	declare @RowCount varchar(10)

	IF EXISTS(SELECT * FROM [UserProfile] WHERE [userid] = @userid)
	BEGIN
		set @RowCount = 'Exists'
	END
	ELSE
	BEGIN
		set @RowCount = 'NotExists'
	END

	select @RowCount as Counter
END

me, me, me

"The dinosaurs became extinct because they didn't have a space program. And if we become extinct because we don't have a space program, it'll serve us right!"
Larry Niven

Re: Stored procedure

Morgs Morgan18-May-10 5:53

Morgs Morgan

18-May-10 5:53

Thanks man,
that was great help

Re: Stored procedure

T M Gray18-May-10 7:50

T M Gray

18-May-10 7:50

I wouldn't use rowCount since it is a reserved word. Also I think you are making it more difficult on yourself by requiring hard coded strings. Hard coded strings for program control flow are bad. All you need is this:

select count([userid]) from [userprofile] where [userid]=@userID

Then in your C# you can just check for > 0.

scheduling in ASP.Net

Amit Patel198518-May-10 4:14

Amit Patel1985

18-May-10 4:14

Hi All ,

I want to run schedule task in every 1 min in background in asp.net but it should not interfere the other operation of application.

I tried with the following option

<a href="http://www.codeproject.com/KB/aspnet/ASPNETService.aspx"></a>

and it seems it is not working.can u guys provide me any solution or any sample.

Thanks and regards,

Amit Patel

Re: scheduling in ASP.Net

John Bhajan18-May-10 4:41

John Bhajan

18-May-10 4:41

Search about thread or timer and you will get something in google and start it in Application_Start method
Smile | :)

Re: scheduling in ASP.Net

Sandeep Mewara18-May-10 6:55

Sandeep Mewara

18-May-10 6:55

Dont know why it was downvoted... direction is fine! gave a 5 to balance out..

Prevent querystring from changing when using Response.Redirect or Server.Transfer

Adam Brown 318-May-10 4:10

Adam Brown 3

18-May-10 4:10

I am using Server.Transfer to navigate between my ASP.Net 3.5 pages. The URL changes each time I go to a new page. How do I prevent the querystring from changing no matter what? In other words, I want the URL to always display the default.aspx page no matter what page I am on.

Thanks.

Adam

Re: Prevent querystring from changing when using Response.Redirect or Server.Transfer

Sandeep Mewara18-May-10 6:59

Sandeep Mewara

18-May-10 6:59

Thats called URL Rewriting.
Read about HTTPModules and HTTPHandlers... of how to do it...
Here you go: MSDN: URL Rewriting in ASP.NET[^]

How Can I Add MasterPage My Existing Projet

nevzatagan18-May-10 3:37

nevzatagan

18-May-10 3:37

Hi I want to add masterpage to my existing project It Has 200 forms..

please Help.

Re: How Can I Add MasterPage My Existing Projet

Not Active18-May-10 3:52

Not Active

18-May-10 3:52

Ok, so add it. What difficulties or questions do you have?

I know the language. I've read a book. - _Madmatt

Re: How Can I Add MasterPage My Existing Projet

Sandeep Mewara18-May-10 7:12

Sandeep Mewara

18-May-10 7:12

You have to do that manually for all of them.

First you have add the following code as follows:
1. Mention the Master Page File path in the Page Directory

<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="Default1.aspx.cs" Inherits="Default1" Title="Untitled Page" %>

2. Then add the content place holder code next to the page declarative code.

<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server"> 
<!-- ContentPlaceHolderID Should match master pages's ContentPlaceHolder's IDRest of your html markups, including Server Controls goes here. -->
<asp:Content>

3. Then remove HTML tags from up to tag

P.S.: Be sure that you do not have a runat=server in form tag anymore. (because master page form tag contain the runat=server attribute.)

This way you can make the existing page to the master paged one.

website got hacked

Rohit16db18-May-10 2:10

Rohit16db

18-May-10 2:10

Dear all,

I have a dedicated server where I used to publish the project developed in asp.net.

Somebody deletes all source code from server. I cound not find any information of them either in IIS log or FTP log.

Any body can help me please how I can detect who is doing this hell.
I am very disappointed with such activity.

Thanks
Rohit

Re: website got hacked

R. Giskard Reventlov18-May-10 2:29

R. Giskard Reventlov

18-May-10 2:29

Who manages the server? Did you ask them? (if it wasn't you!)

Try changing the password/s that allow access to the web source.

I'd start there (assuming you've checked for trojans, key loggers, etc, etc).

me, me, me

"The dinosaurs became extinct because they didn't have a space program. And if we become extinct because we don't have a space program, it'll serve us right!"
Larry Niven

Re: website got hacked

Rohit16db18-May-10 3:01

Rohit16db

18-May-10 3:01

Thanks dear for your suggestion. I did all thing even I bought a new server even though same thing is happening there. One thing I would like to ask is it possible to delete all project related files from server via http injection as I found some suspecious request in IIS log file like /cgi-bin/env.pl, /fastenv etc.

Hoping some answer from you

Re: website got hacked

Ankur^\m/18-May-10 3:33

Ankur^\m/

18-May-10 3:33

Rohit16db wrote:
I bought a new server

If you can buy a new server for this, I guess you should hire a professional for maintaining your servers.

..Go Green..

Re: website got hacked

Sandeep Mewara18-May-10 9:43

Sandeep Mewara

18-May-10 9:43

Yes, Http Injections can do it!

Problem in form view empty data template in c#.net [modified]

sudheera p18-May-10 0:52

sudheera p

18-May-10 0:52

Hi...
In my asp.net form ,if form view is not binding no records ,it should show empty datatemplate ,i am not getting the empty data template ..
can any one send me the sample code...

-- Modified Tuesday, May 18, 2010 7:00 AM

Re: Problem in form view empty data template in c#.net

Sandeep Mewara18-May-10 9:55

Sandeep Mewara

18-May-10 9:55

Best would be when no records fetched to bind, then add a dummy blank row to show the template with header.

Check the rowcount before binding, if it's zero then add the above logic.

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.