SQL Server :: Return ID Value Into BLL Function?

Mar 12, 2011

I have written an insert stored procedure which is called by my business logic layer, I want to return the new ID to the function once it has executed but i'm not sure how.

My SP uses RETURN SCOPE and when I have tested this it works but how I get that into a variable in the BLL function I don't know.

View 15 Replies


Similar Messages:

Does A Return Statement In Function Stop The Function

Jun 8, 2010

Given the function

[code]....

When 'return false' is fired, I'm assuming that the function is stopped at that point and there's no need for exit fors and things like that?

View 1 Replies

Return A Value In C# Function?

Jan 6, 2011

I have a function in .CS file. i want to return many values fetched in the function to .aspx.cs file(both files in the same project)

How to return a values from the below function(.CS file code is as follows):

using System;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;

[Code]....

I want to pass advocates,jjj,tyear,year,petitioner1,resp1,sb etc... How can i do it??

View 3 Replies

SQL Server :: DAL Doesn't Return The Return Value Of Stored Procedure?

Nov 8, 2010

I have an update function in my data layer which is defined as:

public int UpdateRBTable(parameters ...) This calls a SQL Server Stored Procedure to perform an update function on the database.

The process does its job for updating the table. However, the stored procedure has a return value (which indicates how many rows were updated), but this return value is not returned to the application. The application always shows that a zero was returned from the stored procedure.

View 3 Replies

Return Parameters From Function

Mar 28, 2011

internal static void GetUserData(int userId, out string userName,
out string userEmail, out string userPassword)
{
using (SqlConnection con = Util.GetConnection())
{
con.Open();
using (SqlCommand cmd = new SqlCommand("usp_UD_SelectById", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@UD_ID", SqlDbType.Int).Value = userId;
cmd.Parameters.Add("@UD_UserName", SqlDbType.NVarChar, 100).Direction = ParameterDirection.Output;
cmd.Parameters.Add("@UD_Password", SqlDbType.NVarChar, 100).Direction = ParameterDirection.Output;
cmd.Parameters.Add("@UD_Email", SqlDbType.NVarChar, 100).Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
userName = Convert.ToString(cmd.Parameters["@UD_UserName"].Value);
userEmail = Convert.ToString(cmd.Parameters["@UD_Email"].Value);
userPassword = Convert.ToString(cmd.Parameters["@UD_Password"].Value);
}
}
}

and the call

string userEmail;
string userName;
string userPassword;
MemberHelper.GetUserData(userId, out userName, out userEmail, out userPassword);

Sometimes I need to get just one parameter from the out parameters, how can I call the function when I want to get just one:

string userPassword;
MemberHelper.GetUserData(userId,"","",out userPassword);

View 1 Replies

ADO.NET :: Return Value From Delete Function?

Feb 8, 2011

[Code]....

This method always returns '-1' (Fail) while it is expected the method return '0' (Success).

View 2 Replies

Get Return Value Of Javascript Function From Aspx.vb?

May 8, 2010

How to get return value of java script function from aspx.vb..

View 1 Replies

Perform Action After Return In Function

Feb 24, 2011

Without giving away specifics: basically, I have a bunch of users adding content to my site. What happens now is ajax sends the text to a web service which does its thing, sends the info to the DB, Sends the user an e-mail, and then returns a response to the browser to do something.

What I would like to do is change that order. I want to return a response to the browser so the user is not waiting on the e-mail to send before they get their response. Basically, I'm trying to gain every milisecond I can to quicken the response, and there's no reason for the user to wait for the server to send their e-mail before it tells them that everything worked ok. If the info went to the DB, that's all the user needs to know, they'll know the e-mail sent when it shows up in their inbox. I notice this is an issue on my local machine which has no SMTP server and can actually hang the page response up for a few extra seconds because it's throwing errors trying to send something with no SMTP server.

So, I know in my function when I say

[Code]....

it WORKS, but I want to send the e-mail after the return. Is there ANY way to get this to happen?

View 5 Replies

Web Forms :: Return Value From Javascript Function To C#?

Jan 20, 2010

I call the javascript function in cs using button.attributes.add("onclick","function();");

how can i return a val to cs's string variable from js?

View 2 Replies

Looking For A C# Function To Return Portion Of Html?

Feb 21, 2011

I am looking for a c# function to return a portion of the html. Say I have pages that render html of about 60 k in length, I want to email to users showing only the first 2k and add a link to the original page.

Sure there is a Substring function with String, but it will give me a lot of unclosed html tags.

View 4 Replies

.net - Function Return System.IO.MemoryStream?

Jan 8, 2010

I trying to display image in picture box. The application have two part.First part is windows application, and second part is web service (asmx).This is the code for windows application:

Public Sub PrikazSlike()
Dim p As localhost.Service1 = New localhost.Service1()
PictureBox1.Image = Image.FromStream(p.PictureShow()) [code]....

The problem is that function in web service does not return System.IO.MemoryStream data type so I getting error message can not convert:

Error 1 Value of type 'WindowsApplication1.localhost.MemoryStream' cannot be converted to 'System.IO.Stream'.

View 4 Replies

Web Forms :: How To Write A Function To Return A CSS Class Name

Jan 24, 2010

I'm new to C# and ASP and can't seem to figure out how to write a function to return a CSS Class name.

Here's what I have so far:

In "MyWeb.master" I have a line that reads:

<asp:HyperLink ID="HyperLink1" text="xxxxx"
cssClass='<%# MyCssStyle("ddd") %>'
NavigateUrl="http://www.RDRR.com/Catalog.aspx?TribeID=1"
runat="server" />

And in "MyWeb.master.cs" I have a routine within the partial class that reads:

public string MyCssStyle(string myInput)
{
myInput = "NavigationBarUnselected";
return myInput;
}

This code does not throw an error, but neither does it return a value. What have I missed?

View 8 Replies

Web Forms :: Return Value From Javascript Function To C# Code Behind

Sep 28, 2010

I want to send value from text on text keypress event in C# Code Behind Function. or get value from server side script function which called on textbox keypress event to C# Code Behind Function. How i do that

View 2 Replies

C# - Edmx To Have A Function That Calls That SP And Return A Type?

Jan 28, 2011

I have create a table and create edmx file, and I create a Stored Procedure that return a single row (select by primary key), and I want the edmx to have a function that calls that SP and return a type.

View 1 Replies

Web Forms :: Java Function Needs To Return Only Two Places?

Sep 3, 2010

I have this java function that works great, but I need it to only return two decimal places like 333.33. Currently it returns 333.3333333333. What can I do to modify this?

plannedpmt = (pledgedamt / numberpayments)

View 1 Replies

Web Forms :: Get Function That Return Maximum And Minimum?

Jan 11, 2011

how can i get function that return Max and Min of string in sample way

View 2 Replies

Generic Function To Return String Or Xdocument?

Nov 11, 2010

I want to write a generic function which return either string or Xdocument

[Code]....

In default.aspx

XDocument doc = api.CreateJob<XDocument>("xyz");
threws the exception "Invalid cast from 'System.String' to 'System.Xml.Linq.XDocument'."

How can i do this

View 6 Replies

DataSource Controls :: Return String Value From The Function?

Mar 7, 2010

i try to return string value from the function i wrote for getting string value from the table for that i havecommon stored procedure

public string getdata(string str)
{
string datanew;

[code]...

View 2 Replies

Return Generic.List<Anonymoustype> From A Function In C#?

Dec 10, 2010

ASP.NET 3.5 C# I am joining two tables using Linq. Table names are MapAssets and ExitPoint. In Database they are related with 'has a relationship'

I am writing a function in my BLL to return the joined table

public List<ExitPoints> GetExitPointDetailsByProjectID(int iProjectID)
{
ctx = new CoreDBDataContext();
var exitPointDetails = from ma in ctx.MapAssets
join ep in ctx.ExitPoints
on ma.MapAssetID equals ep.MapAssetID
where ma.ProjectID == iProjectID
select new
{
//would like to have data from both tables here
ctx.MapAssets,
ctx.ExitPoints
};
return exitPointDetails.ToList();
}

This obviuosly doesn't work. And I dont know what to return at all. All constraint I have for the return is to be able to be bound to a gridview. is this the correct way? Or else whats the correct way?

View 6 Replies

How To Call A Codebehind Function And Return Data To The Client

Nov 5, 2010

When I click on the following div:

<div id="Result">Click here for the time.</div>

I need the following codebehind function to run:

<WebMethod()> _
Public Shared Function GetDate() As String
Return DateTime.Now.ToString()
End Function

I need this to populate the inside of the div with the string returned by the GetDate() function. I think this should use code similar to this:

[Code]....

I've pulled this example from this site: [Code]....

However, I simply cannot get it to work. Nothing happens. This is just a regular asp.net web project. I haven't done any sort of Ajax-enabling business other than including script tags in my markup to reference jquery.

Here's what the firebug console tells me when I click on the div:

POST http://admin/Default.aspx GetDate 404 Not Found -18ms

Edit: Note: test.aspx/GetDate must match your aspx page name and function name!

View 1 Replies

JQuery :: Simple Return Value From WebMethod From Ajax Function

Sep 22, 2010

I have an Ajax function called from JQuery that goes to a webservice to return a value. I need a SIMPLE example on how I can do this. I've been going nuts with serializing and every other aspect of this topic. I need to return either an ArrayList with ONE string field or a DataTable of some kind. Either way, I'm populating it into a DropDownList. I'm willing to consider alternatives to this idea. (Background info - I get a value from a textbox and I need to run it through a DB to get an associated value or set of values). I'm being really general so that someone can show a simple example.

View 15 Replies

Web Forms :: Get Return Value From A Javascript Function Before The Page Is Loaded?

Mar 24, 2011

I have web page that will call the macromedia detection tool kit. But I cannot get the hasReqestedVersion value before the page is loaded. I tried to use RegisterClientScriptBlock or RegisterStartupScript inside of the Page_load function.

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head runat="server">
<script type="text/javascript" src="AC_OETags.js" language="javascript"></script>
<script language="JavaScript" type="text/javascript">.......

View 2 Replies

Declare Return Type Of The Function When There Are Two Possible Returned Types?

Jan 25, 2010

I have the following statement, I want to turn it into a Public Shared Function :

If isEmployee Then
Dim employeeInstance As New Employee
employeeInstance = GetEmployeeInstanceByUserId(userId)
Return employeeInstance
Else
Dim studentInstance As New Student
studentInstance = GetStudentInstanceByUserId(userId)
Return studentInstance
End If

Public Shared Function GetWorkerInstance(Byval isEmployee as Boolean) As ...(not sure what to write here)...

There two possible return Type. I'm not sure what I should declare for the function return type.

View 2 Replies

C# - How To Return False In Javascript Function From JQuery Calling [web Method]

Mar 3, 2011

So in default.aspx I have the code

<script type="text/javascript">
function validateForm()
{ [Code]....

When I call test() from javascript i want it to return false but cant seem to geta value from test.

View 4 Replies

Passing JQuery Object And WebMethod Return Value To OnSuccess Function

Mar 31, 2010

I am calling a WebMethod from this code:

if($(this).attr("checked")) {
..
MyWebMethod(variable1, variable2, onSuccessFunction);
}

The MyWebMethod returns an integer, and I want to set $(this).attr("id") of the jQuery object above to the returned integer. Basically, I'm trying to do the equivalent of an MVC Ajax.ActionLink...AjaxOptions {UpdateTargetID =...} However, I can't figure out how to get both a reference to $(this) as well as the returned value. For example, if I do:

MyWebMethod(variable1, variable2, onSuccessFunction($(this)));

I can succesfully manipulate the jQuery object, but obviously it doesn't have the return value from the MyWebMethod. Alternatively, the first code block with a method signature of onSuccessFunction(returnValue) has the correct return value from MyWebMethod, but no concept of the jQuery object I'm looking for. Am I going about this all wrong?

View 1 Replies







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