DataSource Controls :: Can Pass A Non-key Values To A Stored Procedure
Jan 11, 2010
I've changed the definition on one of my tables by removing a field from my data key. However, I still want to pass this field to my stored procedure that inserts fields into this table from another table. The field in question is called ignum. I was using the code
basically 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.
Ive tried a few ways of doing this without success and got together a simplified example so hopefully I can get an answer. When I try to INSERT using a stored procedure InsertTest (normal SQL works OK) I cannot. I need to know how to pass the @Model parameter to the Stored procedure
Have a Stored procedure which can be executed and after entering string for @Model through wizard a new record is created
My asp:SqlDataSource includes InsertCommand="InsertTest" InsertCommandType="StoredProcedure" Also my <InsertParameters includes the asp:Parameter Name="Model" Type="String"/>
My drop down (and I think this is where the problem is ). Record is Inserted after choosing Model and pressing enter
Do I have to set one of the properties in the drop down to tell the Stored procedure the parameter being passed is the parameter Model ??
I have a form that I need to add a new multiple selection criteria. I added a List Box and I populate it on Load. After user selected his choices I need to pass the values to SQL Select stored procedure. I use C# and SQL. I am not sure how to pass the values and write SQL statment that would select records with the selected values. I also have RAD Teleric list box but again the values need to be passed to sql.
i have a listview control with two textboxes in each row. i am to fill those and save their values in one/more than one database tables using a stored procedure.
i currently create a comma-separated string (using a string builder) of all the values, and then pass it as a parameter to the SP.
in the SP i extract the values, and put them into my tables.
any stored proceudre in which incrementing of integers, floating point nums alphabets and alpha numeric value incrmenting take place based on the datatype entered.
Is it possible to return multiple values from a stored procedure? Basically, if I execute the stored proc on the C# side, then on the SQL side I do multiple calculations. Let's say I have 5 int values I need returned to the C# side.
This table receives data from my web application via a stored procedure, snippet pasted below:
[Code]....
In my quote.aspx page, I have a wizard control that collects numerous data points. In one of the wizard steps, I have 20 textbox controls for PartNumbers and 20 textbox controls for respective Quantity.
Question:How do I write a for..each loop that checks for values in my Part Number and Quantity fields and inserts them via my SQLDataSource?
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?
This code returns MdaID and StateID, I want to assign them in this manner:
MdaIDLabel.Text = MdaID and StateIDLabel.Text = StateID, but I am not sure how to separate the two values and then to assign them as I have indicated above. Since my function has a "void" return -
MdaIDLabel.Text = GetMdaState({0}, 64114);
StateIDLabel.Text = GetMdaState({1}, 64114); - will not satisfy the requirement.
I am working with VS 2008 VWD, .NET 3.5 SP1, C#, SQL Server 2008 Express
I am using 3 web controls ,two are cascading dropdownlists used to filter gridview control bound to a datasource.
My question is , How to define multiple queries in stored procedure that takes parameter values from the controls declared using sqldatasource.Also, return all data when i set default control value to say 'null'.
NB: one paramaterised query for cascading dropdownlists and another for other control.
The database I am using has a schema called EQB and as such, my stored procedures are named as EQB.usp_SelectFunds, EQB.usp_SelectAccount, etc.
On the select tab of the Configure Data Source screen, I choose to use a stored procedure. The dropdown shows my stored procedures, however, the schema name does not show up in front of the stored procedures in the drop down. I see only usp_SelectFunds, usp_SelectAccount, etc.
I select one of the stored procedures and when I click TEST, I get the message that the stored procedure is not found. If I instead choose to use a SQL statement instead on the configuration screen and enter EXEC EQB.usp_SelectFunds and click TEST, it works fine.
Why are my stored procedures not showing up correctly in the stored procedure drop down and how can I fix this?
I have a page, let's called that Parameter page, displaying data from a database table using GridView. (The database is a SQL database.) I allow editing of data in GridView. The GridView uses stored procedure to retrieve data and to update data. In my project, users need to log in before using my asp.net project. So at every page, I know who the current user is by using HttpContext.Current.User.Identity.Name. Now as requirement changes, I need to record who has changed what (row) in the Parameter page. The information is to be written to a new table - audit log. Therefore I do not expect to change the Parameter table structure.
I have modified the stored procedure retrieving data. It returns one more column - an empty column with name currentUser. So GridView will create one more column. After data bound, I have the GridView_DataBound() to popluate that column using HttpContext.Current.User.Identity.Name.
I debug it in Visual Studio and am able to see the name of current log in user as the last column in GridView. I change the update stored procedure to take in one more parameter. That parameter, currentUser, takes default value. The default value is an empty string. So if UI part fails to send in the current user name to stored procedure, it just write the empty string as the user name. I change the <asp:SqlDataSource>. I add a <asp:Parameter> for currentUser.
[Code]....
I debug in Visual Studio. However when I save the change, the SQL profiler shows UI sends in @currentUser as NULL. Why?