Call SQL Function With Multiple Parameters From C# Web Page?

Mar 30, 2010

I have an MS SQL function that is called with the following syntax: SELECT Field1, COUNT(*) AS RecordCount FROM GetDecileTable('WHERE ClientID = 7 AND LocationName = ''Default'' ', 10) The first parameter passes a specific WHERE clause that is used by the function for one of the internal queries. When I call this function in the front-end C# page, I need to send parameter values for the individual fields inside of the WHERE clause (in this example, both the ClientID & LocationName fields) The current C# code looks like this:

String SQLText = "SELECT Field1, COUNT(*) AS RecordCount FROM GetDecileTable('WHERE
ClientID = @ClientID AND LocationName = @LocationName ',10)";
SqlCommand Cmd = new SqlCommand(SQLText, SqlConnection);
Cmd.Parameters.Add("@ClientID", SqlDbType.Int).Value = 7; // Insert real ClientID
Cmd.Parameters.Add("@LocationName", SqlDbType.NVarChar(20)).Value = "Default";
// Real code uses Location Name from user input
SqlDataReader reader = Cmd.ExecuteReader();

When I do this, I get the following code from SQL profiler:

exec sp_executesql N'SELECT Field1, COUNT(*) as RecordCount FROM GetDecileTable
(''WHERE ClientID = @ClientID AND LocationName = @LocationName '',10)',
N'@ClientID int,@LocationID nvarchar(20)',
@ClientID=7,@LocationName=N'Default'

When this executes, SQL throws an error that it cannot parse past the first mention of @ClientID stating that the Scalar Variable @ClientID must be defined. If I modify the code to declare the variables first (see below), then I receive an error at the second mention of @ClientID that the variable already exists.

exec sp_executesql N'DECLARE @ClientID int; DECLARE @LocationName nvarchar(20);
SELECT Field1, COUNT(*) as RecordCount FROM GetDecileTable
(''WHERE ClientID = @ClientID AND LocationName = @LocationName '',10)',
N'@ClientID int,@LocationName nvarchar(20)',
@ClientID=7,@LocationName=N'Default'

I know that this method of adding parameters and calling SQL code from C# works well when I am selecting data from tables, but I am not sure how to embed parameters inside of the ' quote marks for the embedded WHERE clause being passed to the function.

View 1 Replies


Similar Messages:

How To Call A JavaScript Function Multiple Times In A Loop On Page Reload With C#

Oct 25, 2010

I'm using the local database functionality in Chrome and Safari and what I do when I want to save this to a remote database is to create a hidden textfield and then using JSON to stringify each row. In the code behind I then parse each JSON object and insert it into the list. What I want to do now is to delete these rows from the local database. I have a JavaScript function called deletePatient:

[code]....

View 1 Replies

Javascript - Ajax Call Pass Parameters To Function?

Feb 7, 2011

What is wrong with this code? I am trying to pass parameters to a WCF function. I couldn't get this to work. I am getting Ajax error.

$.ajax({
url: applicationPath + "/Test.svc/GetData",
type: "POST",
dataType: "json",
data: '{GId":' + sender.get_value() + '"GName":' + sender.get_text() + '"mId":' + testId + '}',
contentType: "application/json; charset=utf-8",
success: function(result)
{
//trying to fill combobox here
},
});

View 1 Replies

Web Forms :: Passing Multiple Parameters To VB.net Function

Jan 7, 2010

Im wonding what the correct syntax is to pass 2 parameters from a Ascx control into a Vb.net function? Heres what I currently have:

<asp:Literal
ID="CommentFooterLiteral1"
Visible='<%# Eval("Approved") Or IsModerator() %>'
Text='<%# FormatFooter(Eval("Anonymous"), Eval("DisplayName"), Eval("CreatedDate")) &#43; "
" &#43; GetModeratorStatus(Eval("UserId")) %>'
runat="server"
/>

The Function "FormatFooter", needs to pass in Anonymous and DisplayName parameters. Anyone know the correct syntax for doing this?

View 2 Replies

Javascript - Multiple DropDownLists - Call Single Function With ID?

Aug 25, 2010

I have the following code which toggles the visibility of one of a pair of DropDownLists based on the selected radio button. This code works but my problem is that I have several sets of controls just like this on a single form. How can I use a single JavaScript Toggle() function, irrespective of the ID of the RadioButtonList that triggered it?

function Toggle()
{
var list = document.getElementById("produceDDL");
var inputs = list.getElementsByTagName("input");
var selected;
for (var i = 0; i < inputs.length; i++)
{
if (inputs[i].checked)
{
selected = inputs[i];
break;
}
}
if (selected.value == 'Vegetables')
{
div1.style.display = 'none';
div2.style.display = 'block';
}
else
{
div1.style.display = 'block';
div2.style.display = 'none';
}
}
<asp:radiobuttonlist ID="produceDDL" OnClick="javascript:Toggle();"
RepeatDirection="Horizontal" runat="server">
<asp:ListItem Selected="True">Fruit</asp:ListItem>
<asp:ListItem>Vegetables</asp:ListItem>
</asp:radiobuttonlist>
<div id="div1">
<asp:DropDownList ID="fruitDDL" Width="120" runat="server">
<asp:ListItem>Select</asp:ListItem>
<asp:ListItem>Apples</asp:ListItem>
<asp:ListItem>Oranges</asp:ListItem>
</asp:DropDownList>
</div>
<div id="div2" style="display:none;">
<asp:DropDownList ID="vegDDL" Width="120" runat="server">
<asp:ListItem>Select</asp:ListItem>
<asp:ListItem>Onions</asp:ListItem>
<asp:ListItem>Potatoes</asp:ListItem>
</asp:DropDownList>
</div>

View 1 Replies

Web Forms :: Call Server Side Function Of Parent Page From Popup Page?

Mar 24, 2011

I open a pop up page(child page) by using jquery(jquery.colorbox.js) in asp.net application. now when I click on search button I want to close the pop up page(child page) and refresh the UpdatePanel1 by using search parameters. for above I need to execute server side function in parent page. code to close pop up:

child.aspx:
<script>
function closePopup() {
[Code]....

View 3 Replies

Web Forms :: How To Call A Javascript Function On A Master Page From A Content Page Control

Jan 24, 2011

I have a javascript function on my Master page, how do I access it with a dropdownlist of a content page. Not from codebehind, I can do that, but from the control itself such as the onSelectedIndexChanged event.

View 11 Replies

User Controls :: Call Function In Master Page From UserControl In Content Page

Jan 25, 2014

On MasterPage i have function below, how call this function on test.ascx  form on button click.

public void HideBtnLogin() { string session = Session["userCode"] as string; if (String.IsNullOrEmpty(session)) {
lbtnSignInTop.Visible = true; lbtnSignUp.Visible = true;
}
else { lbtnSignInTop.Visible = false; lbtnSignUp.Visible = false; } }

View 1 Replies

Web Forms :: How To Redirect To Another Page And Call Its Function From Source Page

Mar 13, 2011

I have 2 aspx page:

1>companyMaster(CM) 2>CompanyBranchMaster(CBM)

In CompanyMaster ihave a gridview (listing all companyBranches) with select,Update,Delete button on it.On clicking select of anyone row in gridview ,it should redirect to CompanyBranchMaster page and there is a funciton in it dbSelectGrid to show the details of that Branch in form.

CompanyBranchMaster page contains a form with all the required fields and gridview and its funcitons.

My Question is if user clicks on grid of CM then it can be redirected to CBM with Response.Redirect.But how to call the function dbSelectGrid of CBMs page.

View 5 Replies

Call A Method Or Function From Another Page

Jul 12, 2012

How can I call a method from another page. I have the following code to add row dynamically in grid view: 

<asp:GridView ID="dg2" runat="server" ShowFooter="true"
AutoGenerateColumns="False" BackColor="White" ForeColor="#0099FF"
HeaderStyle-BackColor="#0099FF" HeaderStyle-ForeColor="White" PageSize="2">
<Columns> <asp:TemplateField HeaderText="Item Code"> <ItemTemplate>

[Code] ....

In code behind

public void IntializeRow() { DataTable dt = new DataTable(); DataRow dr = null;
dt.Columns.Add(new DataColumn("itemcode", typeof(string)));
dt.Columns.Add(new DataColumn("itemname", typeof(string)));
dt.Columns.Add(new DataColumn("quantity", typeof(string)));
dt.Columns.Add(new DataColumn("mrng", typeof(string)));

[Code] ....

Some methods for initialize grid view row and set previous row record. There any possible to call this methods from another page? Or any possible to use the same grid view to use different page....

View 1 Replies

Can Content Page Call A Function In Its Master Page

Jan 29, 2010

I have a site with a master page, Site.master. Many of Site.master's content pages have the same button that functions the same way on each page:

<asp:ImageButton ID="btn" runat="server" OnClick="btn_Click" />

Is it possible to write btn_Click once in Site.master's CodeFile and have it called in the OnClick attribute of each content page's button? I'm trying to avoid adding the same function (or anything at all) to each content page's CodeFile.

View 5 Replies

Web Forms :: Call Function When Page Close?

Mar 27, 2011

I want to call a function (VB, server side function) when the page is close.

View 4 Replies

Web Forms :: How To Call A Function In The Masterpage From Its Content Page

Feb 25, 2011

How can I call a function in the masterpage from its content page I have a function in my master page to populate a tree view in the master page. After entering some database values from the contentpage I want to call the master page function to show the entered value in the treeview.

View 4 Replies

Web Forms :: How To Call A JavaScript Function After Page Loads

Apr 19, 2010

I don't need to run the function every time the page loads!!

But, I would like to have the control when the function is to be called.

The only way I thought of is calling my function with OnLoad in the body tag and having a hidden field to be checked and then run the script accordingly.

e.g:

<body onload="ScrollToView();">

Is there a better way? For example, running the function from Page_InitComplete handler?

View 15 Replies

Call C# Method From Another Page In Javascript Function With JQuery

Mar 3, 2011

In GridViewData.aspx.cs I have a method I want to call inside a javacsript function.

[Code]....

Now hears the kicker, I am mostly using jqUery as UpdateInsertData() is a jquery Call and works fine. How do I use ValidateNameUpdateable to call jQuery to return the value from the c# method. . I believe this issue is with my jQuery Call as its just posting and I need to do a $.get or something?

function ValidateNameUpdateable()
{
$(document).ready(function ()
{
$.post("GridViewData.aspx")
});
}

View 4 Replies

Web Forms :: Call Master Page Function From User Control?

Jul 22, 2010

I have a Masterpage and a UserControl inside the MasterPage itself.

I have a public method named PerformDragAndDrop inside the MasterPage and I want to call this method from the userControls's code behind.

View 9 Replies

Web Forms :: Using Site.master To Call Js Function When The Page Loads

May 27, 2010

I have a VS 2010 and have created some aspx content pages associated with a master page. I want to call a javascript function right when the page loads but am not able to find an onload client side event for these pages which are using asp:content as there only controls. I know that I can put content in them and I have but how do I call the client side onload event from the main content control?

View 4 Replies

Web Forms :: Call Javascript Function From Code Behind From Page.aspx.vb

Nov 24, 2010

how can i call javascript function from code behind from my Page.aspx.vb. in my Page i have a button i want to add this function to my button onclick="refreshParent();"

View 8 Replies

Web Forms :: How To Call A Function Of User Control From The Parent Page

Nov 21, 2010

how to call a function of user control from the parent page?

I have a user control inside of default.aspx page, And I have a function in the code behind of user control. I need to call that function from a code behind of default.aspx

View 5 Replies

VS 2013 - Call Web Service Function Within (Code Behind) Using AJAX On Page

Dec 4, 2014

I am trying to call a web service function within my own ASP.net (code behind) using AJAX on the page.

Once i push the button to execute the JS/AJAX/codebehind - I got an error.

POST http://************/admin/Admin.aspx/getDBInformation 500 (Internal Server Error)

This is my code below that I am currently using:

Code:
<WebMethod> _
Public Shared Function getDBInformation() As String
loadDBData()
Return JsonConvert.SerializeObject(dbInfo, System.Xml.Formatting.Indented)
End Function
End Class

The code behind looks like this:

Code:
Imports System.DirectoryServices
Imports System.Security.Principal
Imports System.Net
Imports System.Drawing
Imports System.IO
Imports System.Data.SqlClient
Imports System.Web.Services
Imports Newtonsoft.Json

[Code] ......

How can I correct this issue so that I am able to call **loadDBData()** without that 500 error?

View 2 Replies

Web Forms :: How To Call A Javascript Function From CodeBehind On Page Load Event

Jan 20, 2011

How would you call a Javascript Function from CodeBehind on Page Load event without : Ajax (ScriptManager), Response.Write ?

View 2 Replies

Javascript - How To Call The Jquery Function In .aspx Page To Usercontrols Controls

Jan 27, 2011

i have the following function in default.aspx.....i have webusercontrol which have 10 checkboxes and 1 button .... i want when i click on button1 of user control then it can access the function of default.aspx ...page ...if i dragged the usercontrol to default.aspx

Normally if i use 10 checkboxes and 1 button in default.aspx then it works fine ... if i use 10checkboxes and 1button in usercontrol then drag that usercontrol in default.aspx then it will not work ..

[Code]....

View 3 Replies

User Controls :: Call A Method Or Function Inside UserControl From Web Page

Aug 1, 2012

I am having a Calculate() function in user control which is inherited in a page.

I need to call this method in the button click event in the page.

View 1 Replies

SQL Server :: What If Multiple Output Parameters And Input Parameters And Also Want A Select Table

Feb 16, 2011

[Code]....

When I want to get the output values its okay but I also want returning a table as a result data.But Datareader has no rows.is it possible if I want a returning query result and multiple output values togather ?I wrote a test above.I can get output values as sqlparameters. But Datareader attached to a Gridview is empty.can you detect whats wrong here and it doesnt return a query result.So stored procedure is not standart or ı am doing something wrong.this doesnt raise any exception.but not returning any data.

[code]....

View 8 Replies

Web Forms :: How To Call JavaScript Function After UpdatePanel Update And Page Fully Load

Jul 27, 2012

My javascript that scroll down the page.

function SetScrollEvent() { window.scrollTo(0, document.body.scrollHeight);}

I update update panel from server side like below.

protected void rptList_ItemCommand(object source, RepeaterCommandEventArgs e){
//HiddenField hiddenId = e.Item.FindControl("hiddenId") as HiddenField;Label lb1 = e.Item.FindControl("Label2") as Label;
//Button bt = e.Item.FindControl("Button2") as Button;if (e.CommandName == "myclickevent"){
// your codes here...SqlConnection conn = new SqlConnection(constr);SqlCommand

[CODE] .....

I use repeater and repeater have button on button click i update the update panel. now where i have to call the javascript function so that it execute after update panel fully loaded. I want to call javascript function after page fully loaded.

View 1 Replies







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