DataSource Controls :: Stored Procedure Does Not Indicate Table Returned In Dataset?

Apr 23, 2010

This may not be the correct place to put this as it is both a stored procedure AND Visual Studio 2008 problem.

I have the following stored procedure:

[Code]....

I have been mokeying around with it because of what is happening. I have a dataset, call it dataset1. I drag this stored procedure onto the dataset. I EXPECT a datatable to appear, instead the data set adds this store procedure to the queries table adapter and sets the exec mode to 'NonQuery' which unless I am very mistaken, means "don't expect a dataset back from this' when in fact you DO expect a dataset back from this.

The SQL server is a Windows 2000 Server running SQL 2000. It has never caused us a moments grief since we set it up oh-so-many years ago.

If I connect to a different database and drag a query into the same dataset I get a datatable as I expect. I cannot see where / how this procedure could be wrong. The query when executed returns exactly the data I expect, in the format I expect (looks like a table, acts like a table in the Query analyzer).

View 3 Replies


Similar Messages:

DataSource Controls :: Run A Sql Stored Procedure And Access The Returned Value?

Mar 30, 2010

I have a stored procedure 'RoomIfExists' on my sql server (it does work). It takes a string variable for the Room_No and returns either '1' or '2' depending on the result of the query.

[Code]....

I need to know how to run the sp in c#, passing the variable Room_No and then pull the result from it.I am using a data reader.

View 2 Replies

C# - Get Column Names From Table Returned From Stored Procedure?

Feb 10, 2011

I have a stored procedure which returns a table. The stored proc is called via a linq datacontext.

It works fine and I get the table back however I really want to also get the title relating to each particular cell returned.

The stored procedure call is like:

var table = DataContext.GetTable().ToList();

So I get a List<GetTable>. The data is fine I just want the column names as well.

View 2 Replies

DataSource Controls :: Filtering DataSet Using Stored Procedure

Mar 24, 2010

I'm working on an application that allows our Office Services people to schedule employee location moves. The page I'm currently working on allows for modification of scheduled moves. When the user attempts to save changes in this page, the app runs a stored proc to see if there are any conflicts, e.g., someone already sitting in the new location, someone scheduled to move into the employee's location before the employee is scheduled to move, etc. These conflicts, if any, are then displayed for the user and he/she has to make changes to one or more moves to resolve the conflict. This all works just fine. My problem comes when the user has resolved all the conflicts (or thinks he or she has). I need to check again to make sure that there are not still conflicts somewhere before allowing the data to be saved back to the database. So, I've got data for at least two scheduled moves, but this data does not necessarily match what's in the database.

I want to run the same stored procedure that I initially used on this dataset. The stored proc uses three database tables, plus the proposed move information to check for conflicts. What I'm trying to do (but please tell me if there's a totally different approach that would be better) is I've created 3 DataTables, using the 3 tables that my stored proc uses. The tables are Employee, Location and Moves. I've then put all these tables into a DataSet. I've updated my Moves DataTable with the proposed new move information. Now I want to run my stored proc on this dataset to see if I get any rows (i.e., if there are still any conflicts). But I can't just run the stored proc; it references the tables in the database. I want to run my stored proc on this DataSet. The stored proc is very long and takes 5 parameters which are referenced all through it, so I don't want to just create a DataViewManager using the SQL.

View 10 Replies

DataSource Controls :: Dataset Sorted By Temporary Column Created By Stored Procedure?

Mar 27, 2010

I have a stored procedure in my database that sorts a dataset by distance from the specific address input by the user. The distance is created among each individual users query and the sorting of distance occurs within my stored procedure, the distance is not returned in the output. Is there a way I can create a temporary column that returns the distance so that I can give the user an option to sort by distance?

View 9 Replies

DataSource Controls :: Using Table Variable In Stored Procedure?

Feb 18, 2010

I've written a stored procedure which uses a table variable. The stored procedure is shown below:

[Code]....

The table variable @CaseNumbers is declared, and is a bunch of values are inserted using a table-valued function called SplitStringIntoInts. At this point I can select from @CaseNumbers and this works fine.But when I try to join onto @CaseNumbers, the name '@CaseNumbers' in the ON clause is highlighted with the error 'Must declare scalar variable @CaseNumbers'. What?! It's not scalar, I declared it ages ago and I have used it since!

View 3 Replies

DataSource Controls :: How To Join Table In Stored Procedure Sql Server Db

Jun 9, 2010

my stored procedure is always extract some data into temp table such as"select name,address,content into #TEMP1 from table1,table2,table3"
finally, select another table together with #TEMP1 to extract all desire data from one queryselect T.name,T.address,T.content,C.other from #TEMP1 T, otherTable C
where T.ID=C.IDI would like to ask if i want to join one more table T2 into final query with "otherTable left C outer join on C.ID=T2.ID"

View 1 Replies

DataSource Controls :: When Use ##Temp Table In Stored Procedure, It Gives An Error?

Jun 15, 2010

i m using ##Temp Table in stored procedure..it gives this error There is already an object named '##people' in the database.in two codition1.in case of multisession2. if transaction drop in between even i drop Table in Last in stored procedure..what can i use in place of temp table to hold data for a time being

View 1 Replies

DataSource Controls :: Insert ID Field Into SQL Table Programatically From Stored Procedure?

Oct 6, 2010

I have a table in SQL where I insert data (CatCodes) using C# code but I want to insert ID code (DealerID) with it as well. Following is my Stored Procedure and C# code:

[Code]....

C#:

[Code]....

As you can see, I am insering CatCode values in Categories table using string cbspecialities.

How can I insert DealerID the same way? DealerID is automatically generated in tblDealers table when "InsertExternalInfo" asp.SqlDataSource control runs "InfoInsert" SP.

[Code]....

View 2 Replies

DataSource Controls :: Eliminate Returning Of Empty Table From Stored Procedure

Jul 12, 2010

I have a Procedure which should return only 1 Record on selecting record according to Priority.

BEGIN
DECLARE @Accounts nvarchar(MAX)
SELECT @Accounts = ISNULL([map_user_modules].[Accounts], '') FROM [map_user_modules]
WHERE [map_user_modules].[id_user] = 231 AND [map_user_modules].[id_module] = 5
IF ((@Accounts = '') OR (@Accounts = 'All'))
SELECT @Accounts = null

BEGIN
Select @@ROWCOUNT as Priority2
END
IF @@ROWCOUNT = 1
BEGIN
Return
END

BEGIN
Select @@ROWCOUNT as Priority3
END
IF @@ROWCOUNT = 1
BEGIN
Return
END

BEGIN
Select @@ROWCOUNT as Priority4
END
IF @@ROWCOUNT = 1
BEGIN
Return
END

In the above statement Suppose we take a scenario where Select @@ROWCOUNT as Priority3 is executed, I get two tables returned, One is the Table returned by Select @@ROWCOUNT as Priority3 and the other is the Table returned by Select @@ROWCOUNT as Priority2 which has no Records. How can I eliminate the Empty table that returns no records.

View 1 Replies

DataSource Controls :: Get The @@Identity From A Table By Using A Stored Procedure Called By Website

Jul 10, 2010

I am trying to get the @@Identity from a table by using a stored procedure called by my asp.net website. I am using a datareader to do this but get an error as it tells me it cannot convert the returned value to getint. Here is my code. What should I be using instead of getint?

Dim myReader = cmd.ExecuteReader()
While (myReader.Read())
intID = myReader.GetInt32(0)
End While
myReader.Close()

View 3 Replies

DataSource Controls :: Create A Stored Procedure That Displays Data From A Table?

Mar 22, 2010

More specifically, i'm trying to create a stored procedure that displays data from a table if the date column in the table matches a specific day of the week. (IE. Monday, Tuesday, ect...)

The date in my table is stored as MM/DD/YYYY.

View 5 Replies

DataSource Controls :: Stored Procedure For Delete Records From Parent And Child Table

Jan 16, 2010

I have two tables dept and employees those table have parent and child relation ship link column is deptno i want to delte department even this departmetn contains employees i want to write storedprocedure for first delte employees and after department if i wrtie these two querys in storedprocedure will i get any problems

Begin
Delete from tbl_employees where Department_Id=@Department_Id
Delete from tbl_Department where Department_Id=@Department_Id
RETURN
END

View 5 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

Forms Data Controls :: How To Replace Values In GridView Returned From A Stored Procedure

Sep 10, 2010

I am working on creating a stored procedure that will output a pivot table. In the pivot table will be either the string NULL or a number. How can I reformat this in ASP.NET so the NULL value becomes a blank cell in the gridview and the number (whatever it is) becomes an 'X' ?

View 3 Replies

DataSource Controls :: Execute A Stored Procedure Within A Stored Procedure?

Jan 18, 2010

Does anybody if it is possible that a stored procedure returns rows which is the result of the execution of another sp? Something like..

[Code]....

View 11 Replies

DataSource Controls :: How To Call A Stored Procedure In Another Stored Procedure

May 13, 2010

i want to return output parameter from 1 storeprocedure. into another stored procedure.

View 7 Replies

DataSource Controls :: Getting A Single Value From A Returned Dataset?

Feb 18, 2010

I've managed to connect to the database and return a record based upon a login name. I can itterate through the rows printing out the password but I know there's only 1 row (or can test for that) so how do I get the value of the password for the one row without the loop?

Dim supervisorAdapter As New SupervisorTableAdapters.SupervisorTableAdapter
Dim supervisors As Supervisor.SupervisorDataTable
supervisors = supervisorAdapter.GetSupervisorByLogin(login)
For Each count As Supervisor.SupervisorRow In supervisors
Response.Write(count.password)
Next

View 3 Replies

SQL Reporting :: How To Add Stored Procedure Result Set Columns To Typed Dataset And Dataset To RDLC File

Jan 9, 2011

Till now I used to design RDLC file before and assigned typed dataset table columns.Report processing mode is local. But now my stored procedure returns different columns based on condition i.e columns are not fixed every time. Now I need to add that columns to typed dataset and dataset is assigned to RDLC file. So dataset and RDLC files are create dynamically based on stored procedure result set columns.

View 1 Replies

DataSource Controls :: How Do Access The DataSet Returned By A SqlDataSource

Feb 17, 2011

I want to run a SUM on a particular against the DataSet returned by a SqlDataSource. How can I access the DataSet stored in memory that is returned by the SqlDataSource to run this calculation?

View 2 Replies

DataSource Controls :: Access Data Returned In Dataset?

Feb 26, 2010

I am having some difficulties with a particular task. I am creating a support desk intranet application and I am trying to write a method within a class within a namespace which will form a generic database connection which can be called from any of the aspx pages so that I have the dbconnection logic in one place; you know, going along with the 'DRY' (Don't Repeat Yourself) mantra.

The Namespace:

SUPPORTDESK.SQL.dbconnection.pullData()

Objective of the method:

To provide any aspx code behind file with an SQL Server 2005 Express Connection and if possible return the data from an SQL Query. This is where I need advice do I create the method such that it simply forms the connection and returns a DataSet or that it returns an SQLConnection object? If i've got things back to front and upside down don't worry I'm a beginner with ASP.NET. The Method so far:

[Code]....

If I'm on the right track how do I access the data returned in the DataSet?

View 3 Replies

DataSource Controls :: What Is Better: Connecting To DB With One Stored Procedure To Get Two Table At Once OR Connecting...

May 20, 2010

While working with LINQ to ENTITIES I see that there is only a way to use stored procedure that is returning one entity only, or a view that is a join of two entities.

But what if I need in ASPX page to get two tables that there is NO connection between them, no join can be done between them at all.

I have one Stored Procedure that return the two tables, but entities don't support this right now.

I can split them to two Stored Procedure and call each of them separately.

View 2 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

DataSource Controls :: Inside Procedure, Sql Returned Records Or Not?

May 11, 2010

inside procedure, how to know a sql returned records or not?

View 7 Replies







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