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:
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
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
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")) + "
" + 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
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
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
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
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
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
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
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
Mar 27, 2011
I want to call a function (VB, server side function) when the page is close.
View 4 Replies
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
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
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
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
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
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
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
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
Jan 20, 2011
How would you call a Javascript Function from CodeBehind on Page Load event without : Ajax (ScriptManager), Response.Write ?
View 2 Replies
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
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
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
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