MVC :: Execute Stored Procedure And Pass Result To View
Jun 19, 2010I created a stored procedure in my MVC project. I need to execute it and pass result to view form. How can I do this?
View 1 Replies
Similar Messages:
C# - Adding Parameter To Sqldatasource - Pass Them To Execute Stored Procedure
Mar 2, 2010I am using a gridview where i am calling a stored procedure which has 4 input parameters. Out of these 4 parameters, values are to be given such that DomainId = This has to be the row which is to be deleted. This is a primary key Domain = This field has to be passed to SP as NULL. Description= This field has to be passed as NULL. OperationType= This field has to be passed by programmer as some static value say 4 How to i need to specify these here... More details of the Question are here.
<DeleteParameters>
<asp:ControlParameter ControlID="GridView1" Name="DomainId"
PropertyName="SelectedValue" Size="4" Type="Int32" />
<asp:Parameter DefaultValue="" Name="Domain" Size="16" Type="String" />
<asp:Parameter DefaultValue="" Name="Description" Type="String" />
<asp:Parameter DefaultValue="4" Name="OperationType" Type="Byte" />
</DeleteParameters>
On running my code using this. I gets an error
Procedure or Function 'spOnlineTest_Domain' expects parameter '@Domain', which was not supplied
DataSource Controls :: How To Pass Multiple Values And Execute Query In Stored Procedure
Jun 2, 2010basically i have two dropdown boxes to filter data and textbox with stored procedure bound to gridview.i want to be able to query data depending on the selected value passed,either using one or more parameter values.
i would like seperate sqlcommands to chose from depending on which controls i select to pass parameters.
i have included a parameter Select(control id) as this is declared by the wizard for stored procedure.
but i am not sure how it is defined on the page and passed to procedure.
[Code]....
SQL Server :: Have A Stored Procedure Execute Another Stored Procedure During Time Period?
Jan 28, 2011I could probably figure this out if I tried to, but I have been working so long on code, I'm a little fried
I have a stored procedure, and I want to execute another stored procedure during a time period of lets say 1/1/2011 to 12/31/2011
How Would I accomplish this?
Multiple Single-result Sql Server Stored Procedures Or Single Multple-result Stored Procedure?
Aug 9, 2010Background: I use stored procedures exclusively for an ASP.NET application. I am using a DataReader to load a dataset object.
View 4 RepliesDataSource Controls :: Execute A Stored Procedure Within A Stored Procedure?
Jan 18, 2010Does anybody if it is possible that a stored procedure returns rows which is the result of the execution of another sp? Something like..
[Code]....
SQL Server :: Stored Procedure - EXECUTE And EXECUTE Sp_executesql
Mar 10, 2011I am looking through a sql stored procedure which I might need to update in the near future. Basically the stored procedure is about 20 lines long. The stored procedure first builds a query
and stores it in a variable named "@Sql". And then for the last two lines of the stored procedure it appears that the big sql statement stored in "@Sql" is executed by using the "EXEC" command. See below. What is confusing though is that the query appears to be exectuted twice? Why was the query written in this way. Don't both lines do the same thing? Why is it being done twice? Could this possibly be a mistake on the
part of the person who wrote the query. Below are the two lines I am talking about?
EXEC sp_executesql @sql
EXEC (@sql)
ADO.NET :: Trying To Execute A Stored Procedure In LINQ?
Feb 25, 2011I am trying to execute a stored procedure in LINQ. When run in SQL Server it returns several fields, mostly integer and float fields. But when I call the stored procedure in LINQ, all it returns is 0. Here is how I am calling the stored procedure :
[Code]....
And here is the stored procedure :
[Code]....
ADO.NET :: Execute 2 Stored Procedure In 1 Page
Feb 11, 2011Can I execute 2 store procedures in one asp page? I copied my code here, it doesn't give me an error but the second store procedure is not executing.
using (SqlConnection connection = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]))
{
SqlCommand cmd = new SqlCommand("Sp_createOrder", connection);
cmd.CommandType = CommandType.StoredProcedure;
connection.Open();
//input parameters for the 1st stored procedure
cmd.Parameters.AddWithValue("@in_order_class", "WEB");
cmd.Parameters.AddWithValue("@in_owner_code", "OP");
cmd.Parameters.AddWithValue("@in_sales_campaign_code", "DEF");
cmd.Parameters.AddWithValue("@in_cus_key", null);
cmd.Parameters.AddWithValue("@in_lab_key", null);
cmd.Parameters.AddWithValue("@in_invoice_number", null);
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
SqlDataReader rdr = null;
rdr = cmd.ExecuteReader();
int ChargeFine=0;
//this write the return value on the screen
while (rdr.Read())
{
Label5.Text="<strong>Order Key:</strong> ";
Label1.Text = rdr["ord_key"].ToString();
ChargeFine = Convert.ToInt32(rdr["ord_key"].ToString());
Label6.Text="<strong> Order Invoice Number:</strong>";
Label2.Text = rdr["ord_invoice_number"].ToString();
Label7.Text="<strong> Via Ship Via Code:</strong>";
Label3.Text = rdr["via_ship_via_code"].ToString();
Label8.Text=" <strong> Order Ship After Date:</strong>";
Label4.Text = rdr["ord_ship_after_date"].ToString();
}
//executing the second stored procedure
SqlCommand cmd2 = new SqlCommand("Sp_createitem", connection);
cmd2.CommandType = CommandType.StoredProcedure;
//input parameters
cmd2.Parameters.AddWithValue("@in_ord_key", ChargeFine);
cmd2.Parameters.AddWithValue("@in_long_item_number", "AC00107");
cmd2.Parameters.AddWithValue("@in_quantity_requested", 1);
cmd2.Parameters.AddWithValue("@in_price_override", null);
cmd2.Parameters.AddWithValue("@in_shipment_type", null);
cmd2.Parameters.AddWithValue("@in_size", null);
cmd2.Parameters.AddWithValue("@in_color", null);
cmd2.Parameters.AddWithValue("@in_subscription_issues", null);
cmd2.Parameters.AddWithValue("@in_sub_start_date", "");
cmd2.Parameters.AddWithValue("@in_sub_to_renew", "");
cmd2.Parameters.AddWithValue("@in_lab_key", "");
cmd2.Parameters.AddWithValue("@in_ship_via", "");
cmd2.Parameters.AddWithValue("@in_ship_after_date", "");
cmd2.Parameters.AddWithValue("@in_edi_sku_ID", "");
cmd2.Parameters.AddWithValue("@in_edi_style_ID", "");
cmd2.Parameters.AddWithValue("@in_edi_size_ID", "");
cmd2.Parameters.AddWithValue("@in_edi_color_ID", "");
cmd2.Parameters.AddWithValue("@in_check_item_for_duplicates", "");
connection.Close();
Access :: Trying To Execute The Stored Procedure?
Jun 9, 2010I have a stored procedure in SQL server 2000. It is a simple select query and returns a list of account names. However, when I try to execute the stored procedure, it automatically declare @return_value as int and return this int as shown below:
DECLARE @return_value int
EXEC @return_value = [dbo].[p_getAccountNameListByPrefix]
@prefixText = N'br',
@count = 40
SELECT 'Return Value' = @return_value
How can I make the stored procedure return the list of account names as expected?
SQL Server :: How To Open And Execute Stored Procedure
Aug 10, 2010 how to lock a stored procedure..
if its lock how to open and execute that stored procedure..
Execute Stored Procedure Using Sqldatasource And Get Return Value In Vb.net?
Sep 15, 2010How can I execute a stored procedure using sqldatasource and get the return value in vb.net.
View 2 RepliesAccess :: Execute Stored Procedure More Than One Time Each With A Different Value?
May 14, 2010I am building a website that mostly uses Stored Procedures, but now I am facing a problem such that I want to execute the Stored Procedure more than one time each with a different value .
such that when I am calling it from the .vb page I could not execute it more than one time
this is my sql SP code:
ALTER PROCEDURE dbo.plnCs
SQL Server :: Can Execute Different Queries In A Stored Procedure Same Time
Jan 11, 2011In my stored procedure there are 8 queries for 8 tables.Each query has joins and sub queries. I am passing parameters & stored procedure name from front end(designed in asp.net 3.5) can we execute that 8 queries at the same time i.e. parallel execution so that I can minimize stored procedure execution time?
View 6 RepliesC# - How To Convert The Result Of A Stored Procedure In A Dbml File
May 6, 2010I have a MVC project that has a Linq to SQL dbml class. It is a table called Clients that houses client information. I can easily get the information to display in a View using the code I followed in Nerd Dinner but I have added a stored procedure to the dbml and it's result set is of IQueryable, not IQueryable. I need to convert IQueryable to IQueryable so I can display it in the same View. The reason for the sproc is so I can pass a search string tothe sproc and return the same information as a full list but filtered on the search. I know I can use Linq to filter the whole list but I don't want the whole list so I am using the sproc.
Here is the code in my ClientRepository with a comment where I need to convert. What code goes in the commented spot.
public IQueryable<Client> SelectClientsBySearch(String search)
{
IQueryable<SelectClientsBySearchResult> spClientList = (from p in db.SelectClientsBySearch(search) select p).AsQueryable();
//what is the code to convert IQueryable<SelectClientsBySearchResult> to IQueryable<Client>
return clientList;
}
SQL Server :: Cannot Find Execute Any Query, Stored Procedure Not Found Even If It Is There?
Nov 3, 2010I am getting frustrated with this problem, I dont know what i did, but now I cannot execute any stored procedured when I could last time.When I use my asp.net application to run the query, it finds the stored procedure but when I execute it is sql management studio it says it cannot find the stored procedure even though it is there.I tried to execute other procedures and the samething happens. Even when I try a simple query it says it cannot find the tableI could execute the query if i placed Use [databasename] in front, but even with this, I cannot execute stored procedures.
View 12 RepliesSQL Server :: How To Write Stored Procedure For Insert Data & Execute It In MS SQL
Oct 13, 2010How to write Stored Procedure for Insert Data & Execute it in MS SQL?
Some websites:
[URL]
SQL Server :: Script To Execute Stored Procedure And Send Email?
Nov 12, 2010Has anyone ever wroye a script that will execute a stored procedure and a function with the .Net Framework that sends email?
View 6 RepliesDataSource Controls :: Execute Stored Procedure Using A String Variable
Jun 22, 2010Is it possible to save execute stored proc command in a string variable and then execute string variable?
Does this logic fits into LINQ2SQL? Why I want to do this - INstead of passing user control references to server, I want to save user control values to string in client side java script and then pass string to server to do actual stored proc execution. Hopefully this will improve performance.
DataSource Controls :: Execute A Stored Procedure From An Aspx Page
Jan 8, 2010I need to run a stored procedure from an aspx page but because it takes a long time to complete, it times out at MyDataAdapter.Fill. This sp doesn't return any recordset but the number of records affected would be nice.
Protected Sub BtnProcessDT_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles BtnProcessDT.Click
Dim DS As DataSet
Dim MyConnection As SqlConnection
Dim MyDataAdapter As SqlDataAdapter
MyConnection = New Global.System.Data.SqlClient.SqlConnection
MyConnection.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings("RevConnectionString").ConnectionString
MyDataAdapter = New SqlDataAdapter("uspINSERTDT", MyConnection)
MyDataAdapter.SelectCommand.CommandType = CommandType.StoredProcedure
MyDataAdapter.SelectCommand.Parameters.Add(New SqlParameter("@RowCount", SqlDbType.Int, 4))
MyDataAdapter.SelectCommand.Parameters("@RowCount").Direction = ParameterDirection.Output
DS = New DataSet() 'Create a new DataSet to hold the records.
MyDataAdapter.Fill(DS, "RowCount") 'Fill the DataSet with the rows returned.
Basic syntax of the stored procedure.
It SELECTS a single record (at a time) from a table, processes the data and UPDATES four other tables.
ALTER PROCEDURE [dbo_DHT].[uspINSERTDT] (@RowCount INT OUTPUT)
AS
BEGIN
select @RowCount=@@ROWCOUNT
END
Do I need to create a DataSet if all I want to do is capture the number of records? How do I increase the timeout? This is strictly an intranet web application used by one person so performance isn't a big priority. Editing the sp to reduce the amount of time to process isn't practical due to the amount of processing that occurs.
VS2005 Version 8.0.50727.42 (RTM.050727-4200)
.NET framework version 2.0.50727.3603
SQLExpress 2005 9.00.3042.00
DataSource Controls :: Execute Stored Procedure From Button Click?
Jan 18, 2010I've searched and searched for this all day, but can't seem to find the answer. I'm looking to execute a stored procedure by clicking a button. I've set this up in a code behind manner, rather than using a datasource.
The stored procedure doesn't return any rows. All I need to do is pass a variable through it. I think I have it set up correctly, however it keeps saying the stored procedure expected the @pin variable. Here's my code:
[Code]....
I've tried changing sp1 to pin and @pin, thinking that was the problem. Am I missing something?
DataSource Controls :: Execute Stored Procedure On Linked Server?
Apr 22, 2010i need to execute stored procedure on linked server (create procedure on linked server). i had try with this:
[Code]....
SQL code is looking like this
[Code]....
UDBV68 is linked server... Now, when i execute procedure from asp.net i got error 'Incorrect syntax near 'GO'.', but sql server doesn't report error...
Dbcall has value = "EXECUTE ('Create Procedure SelectOne as Select * From FixitOnline.Os_node ',952) AT UDBV54; GO"
DataSource Controls :: How To Execute Delete Stored Procedure Programmatically (C#)
Oct 7, 2010I need to execute a stored procedure which is a simple delete (record) query. Programmaticaly, I want to pass in a parameter "ID1".
Assume I will pass in the ID1 parameter on a delete link click event froma GridView control. What would the code be to execute the existing stored procedure?
ID1 - the parameter and primary key of the source database for the record to be deleted
GridView1 - the GridView control
spDeleteRecord - the stored procedure needing the parameter ID1 and to be executed from C# code
DeleteTableAdapter - an existing TableAdapter for the existing
Here's my start:
[code].....
C# - Can Execute A Stored Procedure Using Linq In A Background/alternate Thread
Feb 4, 2011In my app I am using the open xml sdk to generate a word document and write the file to the response.output stream for the user to download.
At the time that the letter is generated I also need to call a SP via linq data context to update a row in my db.
I think that I need to execute this SP in a seperate thread so that I can simultaneouly write the file to the output. my method looks like this...
protected void btnPrint_Click(object sender, EventArge e)
{
//call sp to update
//create letter and send to client
}
Is this feasible or should I avoid seperate threads?
C# - Accessing The Result Set Of A Stored Procedure, Executed Using SqlDataSource.Select?
Jul 21, 2010I'm programming a webpage in ASP.NET which displays a list of students not listed as participants in something, and upon clicking a student name shows you a brief summary of their details, so the user can ensure they're selecting the right person.
My code currently correctly obtains their ID, adds it as a parameter to my stored procedure and executes the procedure;
[code]....
However, when I try to access the results I get the following error:
System.NullReferenceException: Object reference not set to an instance of an object.
Upon debugging, there don't seem to be any results returned... but when running just the stored procedure in SQL Server with the same data, it does return a single row, as expected.
How do I access this result so I can bind it to my fields?
(I am working in ASP.NET 3.5 in Visual Studio 2008, with SQL Server 2008.)