ADO.NET :: Retrieving A Single Value With A Procedure?

Feb 25, 2011

I have a stored procedure with two input parameters which calculates the distance between two points. When I call it from aspx.cs I get an error.

Here is the code:

CreateDataSet();
float raz;
String str = "";
float min = 3.4F;
String clo = "";

[Code]....

and the error I get is:

Exception Details: System.Data.SqlClient.SqlException: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.

Source Error:

[Code]....

When I test the procedure in SQL Server Management Studio everything is OK and I get a value 539.551855770807 for the certain input parameters.

View 2 Replies


Similar Messages:

SQL Server :: Retrieving The Single Record With The Most Recent Datetime?

Oct 18, 2010

In the stord procedure below. I am retreiving all the records for that 1 deal. What I want is to retrieve the most recent record hence the one with the most recent in the AddedDate field.

How can I accomplish this?

(
@DealID int)
AS
SET NOCOUNT ON
SELECT deals_Comments.CommentID, deals_Comments.AddedDate, deals_Comments.UserID, deals_Comments.AddedByEmail, deals_Comments.AddedByIP, deals_Comments.DealID, deals_Comments.Body, deals_Comments.SBody,
ROW_NUMBER() OVER (ORDER BY deals_Comments.AddedDate DESC) AS RowNum
FROM deals_Comments
WHERE deals_Comments.DealID = @DealID

View 6 Replies

Web Forms :: Stored Procedure - Inserting And Retrieving Data From Database

Jul 4, 2012

I have used in line queries for inserting and retrieving data from database. How should i use stored proceduress

Insertion code

string strSQL1 = "select * from cust_details";
DataSet ds = new DataSet();
SqlConnection m_conn;
SqlDataAdapter m_dataAdapter;
m_conn = new SqlConnection(conn);

[Code] ....

Retrieval code

try {
SqlConnection conn3 = new SqlConnection(conn);
String q1;
//string ddl = DropDownList1.SelectedItem.ToString();
q1 = "select * from Product where ID ='" + DropDownList1.SelectedItem.ToString() + "'";
SqlCommand cmd = new SqlCommand(q1, conn3);

[Code] .....

View 1 Replies

Multiple Single-result Sql Server Stored Procedures Or Single Multple-result Stored Procedure?

Aug 9, 2010

Background: I use stored procedures exclusively for an ASP.NET application. I am using a DataReader to load a dataset object.

View 4 Replies

Retrieving Auto-incremented Column Value From MySQL Table WITHOUT Using Stored Procedure?

Jan 21, 2010

I a function that used a mySQL Data Adapter and inserts a new row.

I want the function to return the value of the auto-incremented column of the updated row.

Public Function addRow(ByVal colA as String, ByVal colB as String) As Integer
Dim dbConnection As New MySqlConnection("server=xxx; user id=xxx; password=xxx; database=xxx; pooling=false;")
Dim dbDataAdapter As New MySqlDataAdapter("SELECT * FROM table", dbConnection)

[Code].....

The "Return..." line doesn't work and don't know what the correct code would be.

View 3 Replies

ADO.NET :: Different Stored Procedure Data Into Single DataSet

Aug 6, 2010

I have a small query can we store three different stored procedure data into single dataset (in multiple tables). I am asking this because I have three stored procedure and when I run them simultaneously it takes less time to execute and when I run them separately it takes more time and I want to use all three stored procedure in page load.
Environment - SQL Server 2005, ASP.net 2.0

View 7 Replies

ADO.NET :: Converting The Single Value Returned With Stored Procedure?

Mar 6, 2011

I get a single value from a stroed procedure of type float. Even if I change it into Int or decimal in the procedure when I call it from my asp.net appliction with ExecuteScalar I get this error:

Exception Details: System.InvalidCastException: Object must implement IConvertible.

Source Error:

[Code]....

I tried with

Int32 pomalor=(int32)distpostSqlCommand1.ExecuteScalar();
= Convert.ToString(...);
= (String).....

but I always get the same error.

View 7 Replies

ADO.NET :: Update Two Tables From Single Gridview Using Stored Procedure?

Oct 12, 2010

I want to update two tables using stored procedures but my data not updating to data base

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace INV_DN
{
public partial class Form1 : Form
{
SqlConnection con;
SqlDataAdapter da1;
SqlCommand cmd;
// SqlCommandBuilder cb;
DataSet ds;
public Form1()

[Code].....

View 2 Replies

DataSource Controls :: Returning Single String Value Using Linq And Stored Procedure

Jun 21, 2010

I can return single integer values when using stored procedures with Linq but I cant get single string values returned.

View 2 Replies

DataSource Controls :: How To Get A Single Value Out Of A Stored Procedure Recordset And Store It In A Variable

May 19, 2010

Here's a stored procedure I created that uses another stored procedure inside it to return a value:

[Code]....

Note the 'exec dirinfo.dbo.d_searchempbyname @TicketSubName' part. That stored procedure will return a single record. What I need is to get a single column from that recordset (in this case, the email address of the employee), and store that value in a variable.

View 3 Replies

SQL Server :: Make A Stored Procedure That Use Two Select Statements In A Single Table?

Mar 10, 2011

I tried nested ListViews but can get the display wanted.In my database I have a Category Table and a Product table.They share the CG_ID value.I want to make a stored procedure that will use two select statements to produce a single table.that can be used as a ListView DataSource.

[code]...

View 18 Replies

Forms Data Controls :: Returning Single String Result Through Stored Procedure

Jun 22, 2010

I am trying to return single string result through a stored procedure and Linq. This works fine when I test the stored procedure but it is not returning the value to the page. The value returned is always 0 which is the return value. This is the stored procedure:

ALTER PROCEDURE Login
@CustomerName nvarchar(50),
@Password nvarchar(50) output
As
Select @Password=Password
From Customers
Where Customers.CustomerName=@CustomerName

This is the vb
ALTER PROCEDURE Login
@CustomerName nvarchar(50),
@Password nvarchar(50) output
As
Select @Password=Password
From Customers
Where Customers.CustomerName=@CustomerName is the code created by the designer

This is the designer function
<FunctionAttribute(Name:="dbo.Login")> _
Public Function Login(<Parameter(Name:="CustomerName", DbType:="NVarChar(50)")> ByVal customerName

As String, <Parameter(Name:="Password", DbType:="NVarChar(50)")> ByRef password As String) As IntegerDim result
As IExecuteResult = Me.ExecuteMethodCall(Me, CType(MethodInfo.GetCurrentMethod,MethodInfo), customerName, password)
password = CType(result.GetParameterValue(1),String)
End Function

View 4 Replies

SQL Server :: Stored Procedure - Looping Into Multiple SELECT Statements To Return Single Value?

Jan 3, 2011

When can I use Stored Procedure? Is this useful for looping into multiple SELECT statements to return single value? How? Can anyone post some sample codes? I have text query and notice that my web application is slow and want to find ways to speed it up. Is there any possible ways aside from Stored Procedures?

View 4 Replies

Data Access Strategy For Single Stored Procedure Retuning Multiple Recordsets In Webpage?

Sep 18, 2010

what is the recommended data access strategy for the following environment: single stored procedure, many parameters, asp.net 4.0, sql server 2008, and the stored proc returns 11 different recordsets, all of which get displayed in various different elements too complex and specific to be handled by server controls.

View 1 Replies

Web Forms :: Using Single Stored Procedure For Select Insert Update Edit Delete In Linq

Feb 25, 2016

I have a table and i want to use this table in asp.net page

how i will call the stored procedure on the basis

of Stored procedure's Action .
 
CREATE TABLE Std_Enquiry(
StdID int IDENTITY(1,1) PRIMARY KEY CLUSTERED ,
FirstName varchar(50) ,
LastName varchar(50) ,

[Code].....

View 1 Replies

Forms Data Controls :: Using Multiple Tables Within A Single DataSet And Single SqlDataSource?

May 19, 2010

I have a stored procedure that returns 3 tables within the single recordset it returns. If I set a SqlDataSource to get data from this procedure, it works, but it only returns the first table. I want to have a GridView display the data from the 2nd or 3rd table using a SqlDataSource, but I can't figure out how to specify a particular table.

While there are some posts discussing this out there, I can't get a definitive answer about whether or not this is even possible (?). In a worst-case scenario, I can create another SP that only returns the 3rd table - but that creates a little maintenance headache that I would prefer to avoid.

View 4 Replies

DataSource Controls :: Using LINQ To Pull Out A Single Value From A Single Result Row Of A Join Query?

May 25, 2010

For context: First of all, I am new to LINQ, as I have been using SubSonic for quite some time now.

I have two tables, Users, and Affiliates. They both have a very typical schema. The FK that joins them is the UserId field, which is in the Affiliates table. I want to create a LINQ query that pulls the Username from the Users table using the AffiliateId value. The AffiliateId is a primary key of the Affiliates table.

I have tried to accomplish this using many variations of the following code:

[Code]....

In the above query, I expect to get a single row result set. However, I instead receive the entire table of results.

How can I make this work? I have yet to see an example or article out there to do what I am trying to do.

View 9 Replies

Open A Single Worksheet (single Tab) From A Huge Excel File On A Web Browser Using C#

Feb 27, 2010

I have huge excel files that I have to open from web browser. It takes several minutes to load huge file. Is it possible to open a single worksheet (single tab) at a time from excel file that contains many worksheets? I have to do this using C# / asp.net MVC

View 5 Replies

Web Forms :: Disable A Single Intem In Dropdownlist Or Stop The Ddl Change Event For A Single Item?

Sep 20, 2010

I am trying something apart of my boundries, is there any way to disable a single intem in dropdownlist or stop the ddl change event for a single item.

View 2 Replies

Forms Data Controls :: Working Procedure With Varbinary From Existing Stored Procedure?

Feb 22, 2010

[Code]....

i have a stored procedure with this values and i need just to make a button that will send something to "Equip" column,how to do it? write the values on my webpage and make a button to exec the procedu

View 1 Replies

How To Create Stored Procedure In Sql Server And Call That Procedure From C# Code

Sep 1, 2010

I am trying to create the following stored procedure in sql server Lat and Lng are the parameters being passed from c# code behind .But I am not able to create this stored procedureit indicates with error saying undefined column name Lat,Lng

CREATE FUNCTION spherical_distance(@a float, @b float, @c float)
RETURNS float
AS
BEGIN
RETURN ( 6371 * ACOS( COS( (@a/@b) ) * COS( (Lat/@b) ) * COS( ( Lng/@b ) - (@c/@b) ) + SIN( @a/@b ) * SIN( Lat/@b ) ) )
END
sqlda.SelectCommand.CommandText = "select *, spherical_distance( Lat, 57.2958, Lng) as distance
from business
[code]...

View 1 Replies

DataSource Controls :: Call One Stored Procedure In Another Procedure For Search?

May 1, 2010

I want to apply other stored procedure select query on result of first stored procedure.

View 1 Replies

SQL Server :: Alter A Procedure From Another One Procedure?

Oct 9, 2010

How can I Alter a Procedure from another one procedure?

View 2 Replies

DataSource Controls :: How To Convert The Oracle Stored Procedure To Sqlserver 2005 Stored Procedure

Apr 2, 2010

This is surareddy. i nead some small clarification in the "Stored Procedure"

how to convert the oracle Stored Procedure to sqlserver2005/2008 Stored Procedure.

right now i am enhancing the project that project already developed the oracle Stored Procedure. now our company is using sqlserver 2005/2008.

how to convert the Oracle Stored Procedure to sqlserver 2005 Stored Procedure

View 4 Replies

DataSource Controls :: Do Not Use Or Call Any Stored Procedure But It Says "Could Not Find Stored Procedure 'xxxxx'?

Dec 9, 2010

Initially, I have tried to use stored procedure. But I changed my mind and preferred to call sql query in codebase with command text. However, it stills tries to find initially-called stored procedure (which is neither called or exists).I think that it is related caching. But I tried it with different browsers it did not work.What might be the reason?

View 4 Replies







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