SQL Server :: Passing One Input Parameter To The SP?

Sep 7, 2010

im passing one input parameter to the SP, based on that parameter i have written the code like below create procedure SP1(@inpName varchar(10))

declare @where varchar(20);
if @inpName = 'ABCD'
@where = 'A';
else if @inpName = '1234'
@where = '1';
else if @inpName = 'AB12'
@where = 'A,B';

SELECT * FROM TABLE1 WHERE COLUMN1 IN(@where);

Now the above query was fine if its 'ABCD' or '1234', but if its 'AB12' then query failed.
How to resolve this issue.?

View 2 Replies


Similar Messages:

WCF / ASMX :: Exposing Data Contract Without Passing As Input Or Output Parameter For Any Operation Contract?

Sep 21, 2010

I have a method in wcf which returns stream of custom object. I need to deserialize this stream at client side, but my custom class which is exposed as data contract is not visible through client proxy. When I add a dummy operation contract which returns the custome object I am able to get this custom class. I dont want to write this dummy method as there are many such custom classes.

Is there any way to expose data contract without writing any operation contract that returns or accepts data contract type object?

View 1 Replies

Passing Special Character In Parameter To SQL Server Reporting

Jan 11, 2011

When i try to pass this string "- !@#$%^&*()_+|}{:"?><<>?/.,';[]`" as a parameter to SQL Server Reporting it crashes. Here is code sample

ReportParameter[] ReportParams = new ReportParameter[1] { new ReportParameter("Name", HERE-COMES-SPECIALSTRING)

IS there any way to pass special character safely like in SP's we use @ sign for parameter name

View 2 Replies

SQL Server :: Passing Multivalue Parameter To Stored Procedure

Jul 28, 2010

I want to know, how do i send a multivalue parameter from C# to Stored Procedure which is used in WHERE CLAUSE in IN statement?

for eg:

CREATE PROCEDURE [dbo].[sp_GetPolicyDivOff1]
@Insid varchar(5000)=null
AS
SET NOCOUNT ON

SELECT MST_GroupCompany.GC_Name,MST_DivisionalOffice.DIV_Name FROM MST_DivisionalOffice INNER JOIN MST_GroupCompany ON

MST_DivisionalOffice.DIV_FK_GC_ID=MST_GroupCompany.GC_ID where GC_Name IN(@Insid)

View 10 Replies

Format Of Local Variable As Input Parameter In Stored Procedure In Sql Server

Jul 28, 2010

Stored procedure ALTER proc [dbo].[spSearchCombo](@searchBy nvarchar(50),@searchKey nvarchar(50)) as select * from CD_DETAILS where @searchBy like '%' +@searchKey+ '%' I'm using ASP.net2.0 with c# to extract rows basedon search key from a text box and searchBy for the column to be searched. When i use column name instead of @searchBy which comes from value selected from a ddropdownlist i get the desired result . There seems to be a problem with format of @searchBy and i get a blank page.

protected void btnSearch_Click(object sender, EventArgs e)
{
string constring = ConfigurationManager.AppSettings.Get("con").ToString();
SqlConnection conn = new SqlConnection(constring);
conn.Open();
SqlCommand cmdSP = new SqlCommand("spSearchCombo", conn);
cmdSP.CommandType=CommandType.StoredProcedure;
cmdSP.Parameters.Add(new SqlParameter("@searchBy",SqlDbType.NVarChar,50));
cmdSP.Parameters["@searchBy"].Value=ddlSearchBy.SelectedValue.ToString();
cmdSP.Parameters.Add(new SqlParameter("@searchKey", SqlDbType.NVarChar, 50));
cmdSP.Parameters["@searchKey"].Value=txtSearch.Text.Trim();
SqlDataAdapter da=new SqlDataAdapter(cmdSP);
DataSet ds=new DataSet();
da.Fill(ds);
this.dgv1.DataSource=ds.Tables[0].DefaultView;
dgv1.DataBind();
}

View 3 Replies

MVC :: Cannot Retrieve Input Parameter

May 1, 2010

I got this actionresult which I want to call with ajax:

[Code]....

and the call I do is:

[Code]....

but the input parameter id in the action is always emty. How come? I get into the action without a problem but the input parameter is emtpy. Please explain to me why and what a workaround is with $.get.

View 9 Replies

MVC :: Passing Id In Parameter?

Aug 26, 2010

I am using url in my mvc application like /product/edit/5, should change it because users can

change id parameter and access different product as this Id directly refer to Id in product table, I have validation there for user to access product.

should I continue with it or should I change it as application has many users

View 2 Replies

C# - Pass A Plus Sign In Input Parameter?

Sep 2, 2010

How do I pass an email address with a plus sign in my input parameter?

Username Value is "johnsmith+1@gmail.com"

http://domain.com/page1.aspx?username=johnsmith+1@gmail.com

View 5 Replies

Web Forms :: Value Cannot Be Null.Parameter Name Input Error

Mar 3, 2010

for some reason i get an error saying the following. i have tried to look it up on google but there seems to be nothing about this error.

View 2 Replies

C# - How To Handle Input And Parameter Validation Between Layers

Mar 5, 2010

If I have a 3 layer web forms application that takes user input, I know I can validate that input using validation controls in the presentation layer. Should I also validate in the business and data layers as well to protect against SQL injection and also issues? What validations should go in each layer?

Another example would be passing a ID to return a record. Should the data layer ensure that the id is valid or should that happen in BLL / UI?

View 6 Replies

Accepting SOAP Input As Parameter In Webservice

Nov 11, 2010

I have a webservice method which needs to accept SOAP as input parameter. I've worked webservices between .NET clients but I've never worked using raw SOAP so I don't know what to do. The format of the input like this:

<?xml version="1.0" encoding="utf-8"?>
<S:Envelope xmlns:S = "[URL]/">
<S:Body>
<ns2:RemoteService xmlns:ns2 = "some.ns.url">
<RemoteServiceInput>
<param1>123</param1>
<param2>Asd Qwe</param2>
<param3 xsi:nil = "true" xmlns:xsi = "[URL]"/>
</RemoteServiceInput>
</ns2:RemoteService >
</S:Body>
</S:Envelope>

How should my method input be to accept this SOAP as parameter?

View 1 Replies

DataSource Controls :: This Input Parameter Cannot Be Converted?

Jan 8, 2010

I am trying to test a SPROC from my ASP.net page by passing a date from my page or from visual studio server manager.

The date value is like so 2009-01-01.

I keep getting an error message this input parameter cannot be converted.

I tried all combinations like '2009-01-01', "2009-09-01" , 20091001.

Nothing seems to work.

But the SPROC works on the SQL side just fine.

View 1 Replies

Passing A Parameter To Stored Procedure In C#?

Mar 23, 2011

When I try the following:

[Code]....

I get an error saying No overload for Add method takes 2 arguments. HOw would i pass the PaycheckID in then as a paramter?

View 2 Replies

Passing Page Title Through Parameter

Aug 23, 2010

I am new to ASP.NET, and was wondering how to pass a Page title through a parameter. In classic ASP I could just use something like:

<title><%=Pagetitle%></title> but I cannot seem to get this to work in ASP.NET.

View 3 Replies

Passing A Parameter To Action Method?

Sep 8, 2010

public ActionResult RenderMyThing(IList<String> strings)
{
return View("RenderMyView");
}

How do I pass in strings?

routes.MapRoute("MyRoute", "RenderMyThing.aspx", new { controller = "My", action = "RenderMyThing" });

Is there a way I could pass in strings here?

Secondly, how does ASP.NET MVC know that action is my action, and controller is my controller. Like I saw this in samples, and it does work, but isn't it just an anonymous object with no type?

View 1 Replies

Web Forms :: Passing Parameter From One Page To Other

Mar 17, 2011

I am opening one page and sending parameter from one asppage to other using winodow.open method

var retVal = window.showModalDialog("PopupWindow.aspx?SQL=" + document.getElementById(SUCName.concat("txtRetVal")).value +
"&Curr_Date=" + d , null,"dialogLeft=" + XPos + ";dialogTop=" + YPos +
";center=no;status=no;dialogHeight:430px;dialogWidth:420px;resizable=no;help=no");
in my document.getElementById(SUCName.concat("txtRetVal")).value contains:
SELECT ResourceID, ResourceName FROM ResourceMaster WHERE AREA LIKE '%CALICUT%'

but when it access this on PopupWindow.aspx using Request.QueryString("SQL") then first 3 character in LIKE clause gets convert to some ascii character and my query becomes

SELECT ResourceID, ResourceName FROM ResourceMaster WHERE AREA LIKE '�LICUT%'

what is solution to this?

View 7 Replies

MVC :: Passing Parameter From One Page To Another Using Href

Jan 28, 2010

How to pass parameters from one page to another pages using a href.

<a href="#">

View 3 Replies

Web Forms :: Passing Parameter While Routing?

Feb 12, 2011

i am doign url routing and it is working fine with url like followwing:-when ever i click on HOME/SEARCH i get redirected to ~/SEARCH1.aspx page.

[Code]....

BUT IF I REPLACE THE ABOVE URL WITH "~/SEARCH1.ASPX?ID=2"I GOT FOLLOWING ERROR:'~/search1.aspx?id=2' is not a valid virtual path. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.Exception Details: System.Web.HttpException: '~/search1.aspx?id=2' is not a valid virtual path.i have to pass id to the search1.aspx page.what is the way out.

View 5 Replies

MVC :: Passing A List As A Parameter With BeginForm()?

Mar 2, 2011

I am using HTML.BeginForm to create a form on my page. I need to pass a list of classes I created as a parameter. It's done like this:

<%
using ( Html.BeginForm("DisplayCompanions", "CCDReviewController", new { CompanionList = Model.CompanionList} ) )
{ %>

When I click a "Continue" button (enclosed in the form tag), the "DisplayCompanions" method on my Controller ("CCDReviewController") should be called, as I've set a breakpoint on it. But it's not being called.

Note that Model.CompanionList is a generic list of classes that I created.

View 3 Replies

Web Forms :: Parameter Passing Between Web Pages?

Jan 20, 2011

Developing in C#.I have a home page and couple of other aspx pages.In the home page in a summary box I have names of projects. When the user clcks on a given project I will pass the projectID to the Project.aspx page.I then retrieve this ProjectID and display the project details in text boxes. Code is given below.

[Code]....

View 3 Replies

ADO.NET :: Pass Input Parameters To SP And Fetch Output Parameter?

Jan 18, 2011

i like to pass two i/p parameters to the SP and fetch 2 output parameters.This should done using simple ADO .NET code.

View 1 Replies

Forms Data Controls :: Filldropdown Using Sp One Input Parameter?

Jul 16, 2010

in asp.net how to fill a dropdown using stored procedure,the sp has one input parameter.

View 4 Replies

Web Forms :: Passing Eval() As Parameter In Javascript

Oct 22, 2010

I have got a drop down list in a gridview and would like to pass eval() as parameter to javascript..

<asp:DropDownList ID="ddl_grprowcutter" runat="server" onchange='<%# "fn_ddl(" &#43;Eval("Order_No") &#43; " );" %>'

View 15 Replies

Passing A String Parameter In A JavaScript Function On MVC

Jun 17, 2010

I tried to pass a string value into a JavaScript function like below: <%= "'" + prop.property_description + "'") %>) But it does not seems to be the best option, is there a better way to do the above without concatenate the string values with "'"?

View 2 Replies

Passing A Controller As A Parameter - Can't Get To RedirectToAction Method

Jun 15, 2010

My method looks like:

public static RedirectToResult(Controller controller, ...)
{
}

when I do:

controller.

I don't see RedirectToAction, how come?

I get RedirectToAction from within the controller's action, but not when I pass the controller as a parameter to another classes method.

View 3 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved