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:
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
Jan 28, 2010
How to pass parameters from one page to another pages using a href.
<a href="#">
View 3 Replies
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
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
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
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
Jul 16, 2010
in asp.net how to fill a dropdown using stored procedure,the sp has one input parameter.
View 4 Replies
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(" +Eval("Order_No") + " );" %>'
View 15 Replies
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
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