ASP.NET

how to write a stored procedure to check the users sending parameter value

11-Dec-07 1:31

myCommandObject.Parameters["@ParamName"].Value = DBNull.Value

jagan12311-Dec-07 0:00

jagan123

11-Dec-07 0:00

in front end there are two text boxes one for reference no and other for employee id now the user can enter any of the value my query is how to write a stored procedure to check if the user enters refno then select statement is called for refno or if the user enter id then id select statemet has to call how it is possible to hceck which he entered in the
stored procedure

Re: how to write a stored procedure to check the users sending parameter value

J4amieC11-Dec-07 1:36

how to make a queue of jobs for moderators of a web-site

11-Dec-07 1:36

CREATE PROC FindEmployee
   @RefNo VARCHAR(100) = NULL,
   @EmpId INT = NULL
AS

IF @RefNo IS NOT NULL
   SELECT * FROM Employees WHEERE RefNo = @RefNo
ELSE
   SELECT * FROM Employees WHEERE EmpId = @EmpId

EXEC FindEmployee @RefNo = 'ABC123'<br />
EXEC FindEmployee @EmpId = 999

By specifying a default for each param in the SP (the = NULL bit) you do not have to pass that parameter to the stored procedure. Therefore by checking the default ( IS NOT NULL bit) you can determine which param was passed in. It should be obvious from the code above that if both are passed in it still uses @RefNo - this could be switched around to favour EmpId.

hurrem10-Dec-07 23:47

hurrem

10-Dec-07 23:47

Hi, this might be a stupid question, but I don't know how to do it, and I need help...

I need to find out how to make one web-site controlled by more than one moderators.
I mean, for example, when one moderator is on-line and working on some profile to approve it (for example how moderator of forum work), another moderator should work on another profile. So, I don't know how to distribute the moderators job. And the number of moderators is growing.

thanks..

Re: how to make a queue of jobs for moderators of a web-site

RichardGrimmer11-Dec-07 5:20

RichardGrimmer

11-Dec-07 5:20

For something like this i'd probably use a local message queue on the server. This then sits there, allowing things to be popped off it, and new stuff added to the other end....

Do a goole for MSMQ (Microsoft Message Queueing)....

C# has already designed away most of the tedium of C++.

Dynamic loading of Webusercontrol.....

zareee10-Dec-07 23:24

zareee

10-Dec-07 23:24

Hi,

I have created a Webusercontrol named sample.ascx.

I Have to dynamically load the usercontrol in my Webform.

The usercontrol has textbox control named Usernametxt,label control named UsernameLbl and a button control named Loginbtn

The following is the code i used in the pageload of my Webform,

protected void Page_Load(object sender, EventArgs e)
{
WebUserControl c;
c = LoadControl("WebUserControl.ascx") as WebUserControl;
if (c != null)
{
Controls.Add(c);
}
}

I get the following error:

Control 'ctl02_Usernametxt' of type 'TextBox' must be placed inside a form tag with runat=server.

Can ne body help me fixing the bug

zari

Re: Dynamic loading of Webusercontrol.....

ltom10-Dec-07 23:59

ltom

10-Dec-07 23:59

Hi zari,

the textbox (and all other input controls) must be embedded into a form. Only a form can post the user input to the server. You need something like that.

<form id="form1" runat="server"><br />
   <!-- place your controls here --><br />
</form>

I think, that you already have this form-Tag in your page. Just change the line "Controls.Add(c);" to
"Form.Controls.Add(c);".

Tom

Problem with UpdatePanel and PlaceHolder

amin_behzadi10-Dec-07 23:15

amin_behzadi

10-Dec-07 23:15

Hi my dears,

I have several UpdatePanels in my page . and in one of them I used a PalceHolder to add some controls to it in run time . everything is good and when my page loads controls will be added to PlaceHolder but when I click any other controls in other UpdatePanels in my page the PlaceHolder loses its controls.
pls help me know what to do ?
Thx a lot,

www.behzadi.net

how to populate a DropDownList from a self joined table?

Rocky#10-Dec-07 23:01

Rocky#

10-Dec-07 23:01

Hello everyone,

well I'm trying to populate a DropDownList from a Selfjoined table. At first I was using a treeView but now they say the want a dropDownlist for that. I'm having touble in showing the tree like structure in the combo box
Can you plz give some guidlines or code samples for that

Thanks in advance

Rocky

You can't climb up a ladder with your hands in your pockets.

showing data in crystal report using dataset dynamically

pavankumarchakilam10-Dec-07 22:50

pavankumarchakilam

10-Dec-07 22:50

im getting error as

im trying to create crystal report where data is coming to dataset from query(select *from emp) and but when binding reportdocument to dataset it is giving error as below:
CrystalDecisions.CrystalReports.Engine.LoadSaveReportException: Invalid report file path.

Thanx is advance

List of controls

Mazdak10-Dec-07 22:36

Mazdak

10-Dec-07 22:36

I want to get list of asp.net controls and list them in a listbox. I know they are all in WebControl namespace but there so many extra class are also there. So anybody know some smooth solution?

Mazy

"This chancy chancy chancy world."

Re: List of controls

Karthic M11-Dec-07 0:42

Karthic M

11-Dec-07 0:42

which type of controls u want?
mention it clearly...

Re: List of controls

Mazdak11-Dec-07 1:08

Mazdak

11-Dec-07 1:08

Standard Controls, Data Controls, Validation Control, Login Controls

Mazy

"This chancy chancy chancy world."

showing of data in Crstal report

wasimsharp10-Dec-07 21:58

wasimsharp

10-Dec-07 21:58

Hi i m again i had made a Stored procedure which return a table of two Column in which there 700 record i want to show the record in the Crystal report int in 2 Four Column Like Half og the record should be shown in First two and remaining in last two Coulmn what i shell doo

wasim khan

Smallest Unit in .NET [modified]

.NET- India 10-Dec-07 21:48

10-Dec-07 21:48

What is the smallest unit of execution in .NET?

Is XML case-sensitive

modified on Tuesday, December 11, 2007 3:55:05 AM

Vasudevan Deepak Kumar10-Dec-07 21:56

Vasudevan Deepak Kumar

10-Dec-07 21:56

Assembly?

Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips

A pessimist sees only the dark side of the clouds, and mopes; a philosopher sees both sides, and shrugs; an optimist doesn't see the clouds at all - he's walking on them. --Leonard Louis Levinson

.NET- India 10-Dec-07 21:58

10-Dec-07 21:58

Hello Friend,

Assembly is the smallest unit in .NET to execute.
But can u explain it wht it is

Colin Angus Mackay10-Dec-07 22:55

Colin Angus Mackay

10-Dec-07 22:55

Vasudevan Deepak K wrote:
Assembly?

Define "assembly"

Did you mean a DLL or EXE? If so, isn't that the largest unit of execution?

Upcoming FREE developer events:
* Developer Day Scotland

My website | blog

Christian Graus10-Dec-07 22:08

Christian Graus

10-Dec-07 22:08

I guess the smallest unit of execution is a property, because they tend to be smaller than methods. Is this what you meant ?

Does Google say that XML is case sensitive ? Have your experiments with XML indicated that it's case sensitive ?

It is, but you shouldn't need to ask here to find that out.

Christian Graus - Microsoft MVP - C++

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

.NET- India 10-Dec-07 22:31

10-Dec-07 22:31

Sir r u sure smallest unit of execution is property not Assembly as i got in last reply

Colin Angus Mackay10-Dec-07 22:51

Colin Angus Mackay

10-Dec-07 22:51

The Knowledge wrote:
Sir r u sure smallest unit of execution is property not Assembly as i got in last reply

How do you know the previous reply was correct? What makes you doubt Christian?

Upcoming FREE developer events:
* Developer Day Scotland

My website | blog

Colin Angus Mackay10-Dec-07 22:50

Colin Angus Mackay

10-Dec-07 22:50

The Knowledge wrote:
What is the smallest unit of execution in .NET?

What do you mean by smallest unit of execution? .NET languages comile in to CIL (aka MSIL). Each CIL instruction could be considered the smallest unit of execution.

Upcoming FREE developer events:
* Developer Day Scotland

My website | blog

J4amieC10-Dec-07 23:15

10-Dec-07 23:15

Homework questions much?

Now that you've had 3 pretty good answers which one are you going to submit? Have you considered checking back in your course notes to see which one of these your teacher thinks is the right answer?

.NET- India 10-Dec-07 23:20

10-Dec-07 23:20

Now i'm very confused because i've 3 good answers

But still i don't know which i must go with.

J4amieC11-Dec-07 0:13