Asp.net - Return Two Tables From A Stored Procedure From LINQ To SQL?

Aug 4, 2011

I have written a stored procedure like this:

CREATE PROCEDURE [dbo].[TestProcedure]
AS
BEGIN
SELECT TOP 1 CampaignID FROM Campaigns
SELECT TOP 1 ServiceID FROM Services ORDER BY ServiceID desc
END

In my .NET Project, I have a LINQ to SQL file (.dbml) and I have drag-and-dropped this procedure to create a new class TestProcedureResult:

Partial Public Class TestProcedureResult
Private _CampaignID As Integer
Public Sub New()

[Code]....

So it is not returning ServiceID. How can I retreive ServiceID using LINQ to SQL? I know we can customize stored procedure calls, but how can I customize in this particular scenario?

View 1 Replies


ADVERTISEMENT

SQL Stored Procedure Return Multiple Tables?

Jun 9, 2010

Like the title says I want to create a SQL (2005) stored procedure where I say:

Select a, b, c from A
Select b, c, d from B
Select c, d, e from C

[code].....

View 2 Replies

LINQ Stored Procedure Return Value To A String Array?

Mar 24, 2011

I have a stored procedure in DBML and I try to pass the result to "sqlQryArray" as an array(1 dimensional array). But the bottom code causes error like below message. What else should be done?

Error 1 Value of type '1-dimensional array of aaaDatabase.stp_GetSomethingResult' cannot be converted to '1-dimensional array of String' because 'aaaDatabase.stp_GetSomethingResult' is not derived from 'String'.

The return result from stored procedure is a just list of first names of students(only one column)

Dim sqlQry = aaaLINQ.stp_GetSomething(bbb,ccc,ddd)
Dim sqlQryArray As String() = sqlQry.ToArray()

View 2 Replies

Performance Gain In LINQ Query Vs LINQ Stored Procedure?

Aug 6, 2009

if there is that much of a performance gain in running a LINQ stored procedure versus a LINQ query?

View 1 Replies

CanNOT Get The Return Value From Own Stored Procedure?

Jan 22, 2011

Why I can NOT get the return value (Scope_Identity) by executing my own Stored procedure (SQL Server 2008) via this below code written in VB.NET 2008? The SP inserts the new record into Table1 but I have 0 as the return value!What's wrong with it?here is my vb.net code and my SP:

Public Function Insert(ByVal Obj As entity, connectionString As String) As Integer
Dim ScopeIdentity As Integer
Dim Connection As New SqlConnection(connectionString)

[code]....

View 2 Replies

Get A Return Value From A Stored Procedure?

Sep 6, 2010

I have a stored procedure in SQL Server for generating transaction numbers.how to call the Stored Procedure from VB.NET and how will i get the value that is returned from the procedure into the front end.

View 3 Replies

Get Return Value Stored Procedure?

May 27, 2007

I use an adapter to execute the SP

Dim x As New TDataSetTableAdapters.QueriesTableAdapter
x.SP_BulkPayOut(BeginDate, EndDate)
The SP has a return value
How do I capture this

What do I have to change about my approach

View 6 Replies

Return Value From Stored Procedure?

Aug 23, 2009

I am having problems getting the return value from a stored procedure.As I said the last time, while I am an old programmer, I am new to visual languages.The code is as follows:

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim strServerName As String
Dim intServerID As Integer[code]....

From what I have read this should work. I think I have declared the parameters correctly.When I run the stored procedure from SQL it returns the correct value so I know the problem is in VB.It is a simple stored procedure, however, I am trying to remain consistent and use stored procedures as much as possible.

View 6 Replies

Updating 3 Tables In One Query Without Using Stored Procedure?

Jul 1, 2010

i have 3 tables t1,t2,t3..if i update t1,t2 and t3 must also be updated.i have just been tried

UPDATE t1,t2,t3 SET t1.f1='sample',t2.f1='sample',t3.f1='sample' WHERE t1.f1='test' and t2.f1='test' and t1.f1='test'

using this,update fails if t2 and t3 could not find 'test' in their fields,if i use OR all records will be..i have also tried JOINS

Update tbl_maincat AS m LEFT JOIN tbl_maincat AS m2 ON m.cTitle = m2.cTitle,
tbl_main AS c LEFT JOIN tbl_main AS c2 ON c.MainCat = c2.Maincat,
tbl_subcat AS s LEFT JOIN tbl_subcat AS s2 ON s.csCat = s2.csCat

[code]....

View 1 Replies

ASP.NET A SQL Server Stored Procedure With Return

Jan 8, 2012

So I want to erase the guid @value from the database and retrieve the return value from my stored procedure [code]object name 'value' not valid..Net SqlClient Data Provider0.

View 4 Replies

C# - Stored Procedure Return Varchar Value

Jul 1, 2010

I am trying to create stored procedure that gone return varchar value, and that value I need to display in textbox. This is the code for stored procedure:

[Code]...

View 3 Replies

Return Values Of Stored Procedure?

Jun 11, 2011

the stored procedure is within a transaction. I want to get the inserted values after calling the stored procedure. My problem is, I don't know if that is possible because the transaction is not yet commited.

View 1 Replies

Sql Server - Return Value From Stored Procedure?

Oct 11, 2010

I am using vs 2008 doing a winforms app in vb.net. I have a database with a single table, that has two columns, in it and a stored procedure. The stored procedure is supposed to take an input value, match that value against one column in the table and then return the corresponding value from the other column; except it doesnt.It returns 1 or 0

ALTER PROCEDURE dbo.getgamenumber(@outputnumber bigint OUTPUT,
@inputnumber bigint)
AS

SELECT @outputnumber = ggnumber[code]......

but I still dont get the value I expect.

View 4 Replies

Ms Sql Stored Procedure Return Data Without Output?

Mar 16, 2012

i am trying to find examples of getting data back from a stored procedure that has no parameters sent to it nor has any returned output parameter. Though it does display data.How can i get that from my code im using below?

Dim myCommandSQL As New SqlCommand
Dim myReaderSQL As SqlDataReader = Nothing
Dim intX As Integer = 0[code]....

The @return_value i just put there to see what would happen but i got nothing returned.

View 2 Replies

Asp.net - Execute Stored Procedure Using Sqldatasource And Get Return Value?

Sep 15, 2010

How can I execute a stored procedure using sqldatasource and get the return value in vb.net.

View 2 Replies

Tell If A Stored Procedure Does Not Return Results When Using Linqtosql?

Aug 19, 2010

I have a linqtosql dbml where I dropped a stored procedure into the designer interface.

Stored procedure name:
GetUser(@userid int)
Select * from users_tbl where userid=@userid

[code].....

View 1 Replies

VS 2008 Reading Data From Two Tables Returned By SQL Stored Procedure?

Nov 12, 2009

Can any one provide me the link or give me an idea how to read all the tables returned by SQL Stored Procedure?

My Stored procedure returns two tables:

ID Name
-----------
1 Jeff
2 Joe

ID Pages
----------
1 2

i want to read data from both of these tables. I tried using SQLDataReader and then populating into datatables but then i can only read the values of 1st table. I want to read both the table values. How do i do it? please let me know if you guys have any ideas how to deal with this.

View 1 Replies

How To Call Stored Procedure And Retrieve Single Return Value

Jul 22, 2010

I'm new to LINQ and am having a problem getting proper results from a simple (working) stored procedure that takes no parameters and returns a single Integer. When calling this sproc with LINQ its returnvalue is always 0. When run using tableadapter or directly on the sql server it works, returning 6 digit values like 120123.

Here is my LINQ code:

Dim MeetingManager As New MeetingManagerDataContext
Dim MeetingID As Integer = MeetingManager.NewMeetingID().ReturnValue Here is the NewMeetingID procedure:
ALTER PROCEDURE [dbo].[NewMeetingID]
AS
SET NOCOUNT ON
BEGIN

[Code]...

View 1 Replies

Method To Execute Stored Procedure And Return Datatable In C#?

Jan 21, 2012

I have some VB code like

Dim data As DataTable = DataAccess.ExecuteDataSet("AuthenticateWebServiceClient" _
, New SqlParameter("@ClientID", ClientId) _
, New SqlParameter("@Password", Password) _[code]....

Except PrepareSPCommand isn't recognized by VS. Does anyone know the correct way to convert this function to C#.

View 2 Replies

Linq Stored Procedure - Convert C# Code ?

Feb 3, 2010

Can convert this c# code to vb.net code.

DataClassesDataContext dc =
new DataClassesDataContext();

//proc_GetExistProductDetails is a Stored procedure method from my DataContext class.

[CODE]...

View 6 Replies

Pass Stored Procedure Name Dynamically To Linq-to-SQL?

Jul 11, 2011

How can I pass stored procedure name dynamically to Linq-to-SQL, vb.net and get the result into a datatable.

View 2 Replies

Return The SCOPE Identity Of The Inserted Record In Stored Procedure @temp_id?

Jul 10, 2010

I'm trying to return the SCOPE Identity of the inserted record in my stored procedure @temp_id, but how can I bind it to a label e.g

<asp:ControlParameter ControlID="ASPxLabel_RequestTemp" Name="temp" PropertyName="Text" Type="Int32" />

View 1 Replies

Call A Stored Procedure In SQL Using LINQ To Fill A Combobox

May 14, 2012

I have a combobox named cbEmpState, I need to call a stored procedure named 'spStateList' and have it fill the combobox. I'm having a hard time finding examples of this online. The stored procedure is in my dbml file.

Here's the stored procedure


ALTER PROC spStateList
AS
SELECT * FROM states ORDER BY StateName ASC

View 1 Replies

Invoke A Stored Procedure With LINQ Results In Error?

Apr 2, 2010

My application produces this error System.Data.SqlClient.SqlException: Login failed for user..This started after I added a stored proc in my dbml file. It works fine in my local enviroment, but throws that error when deploy to staging sever. the user it displays is foreign to me?

View 1 Replies

String Variable For Use With LINQ To SQL Class Stored Procedure Call Has Weird Message?

Feb 4, 2010

In my project I am using a LINQ to SQL class that contains a stored procedure which includes a string value as an output parameter.So to capture that, I created a string variable as follows in the procedure:Dim spOutput As String? However, when I do this I get the following message "Type 'String' must be a value type or a type argument constrained to 'Structure' in order to be used with 'Nullable' or nullable modifier '?'"

View 2 Replies

Call A Stored Procedure From Sql Server Which Work With A Stored Procedure

Sep 11, 2009

The store procedure which give me the information I need is:

USE [UCSMIS]
GO
SET ANSI_NULLS ON

[Code].....

When I try to add it to my report it gives an error, is it because of the temp table and how should I go about it?

View 2 Replies

Sql - Getting Parameter For A Stored Procedure Inside Another Stored Procedure

Aug 29, 2011

I have a stored procedure to update a table, but needs a couple of values from another table.

the first two selects get the value from the table and then are used in the update statement.

The select statments:

Select @iStatusDropDownValueID = iDropDownValueID
From DropDownValue
Inner Join DropDownValueType On DropDownValue.iDropDownValueTypeID =

[Code].....

First, the values that are retrieved by the first two select statements are always the same. So they could be passed in by the code itself. I don't know that this will speed things up at all, just make the entire stored procedure better and easier to read.

Second, if the "Value Name" should change this store procedure will break (which is possible, but not often).

I am looking for any insight into the Best Practices for this situation.

View 2 Replies

Return Value From Stored Procedure Is "nothing"

Apr 17, 2012

I have a stored procedure running in SQL Server 2000 which returns a value

when I run it in SQL Server Management Studio 2008 (SMS). I have also tested

it in SQL Server 2000 Query Analyzer with the same result. However, when I

run it with VB.Net 2010 I get "nothing" as the value of the return parameter:

cmd.Parameters("@ReturnCount").Value.

How do I get a value back? The parameter I am testing on is @ReturnCount.

I will need it to work for the return code also - @ReturnCode.

I have searched the web and found quite a few examples and tried them, but

they do not work with this code.

(I have simplified the procedure for testing. I am using dynamic SQL

because the SELECT in the actual procedure uses a parameter on the FROM

clause. I use sp_executesql in order to get a return value from the

dynamic SQL.)
<code>
/*

[Code].....

View 6 Replies

.net - Using A Stored Procedure

Sep 7, 2009

I want use a stored procedure in my project but I have no idea about it. Please could you tell me a little bit about how to use I can use one in my vb.net application ?

View 2 Replies

How Stored Procedure Run

Dec 22, 2011

I have noticed the following but unable to understand why.Whenever a procedure is called in .net it takes more time than when it is called subsequently.Even if a procedure is called after some interval it takes more time than it takes if it is called quite frequently. i am not asking about sql query or sql command. any user definded function or user defined method takes much more time to finish when it is called occasionaly. but when the same procedure is called quite often it finishes a lot faster. why?

View 1 Replies







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