i have a gridview and the delete option.
when i press delete button i want to run my stored procedure which requires an input variable. how can i do this?
how to pass the in out parameters in stored procedures
and how to execute it??
I was reviewing my old post about this issue with a accessdatasource and that was simple since the Select, Update and Delete were all written within the datasource.
But this page im having issues with is using SQLDataSource and pointing to Store procedures. My issue is that i have created the sqldatasource with Insert(storeprocedure), Select(actual select statement), Update(storeprocedure) and was trying to take advantage of gridviews capabilities for editing when connected to a datasource that has all those elements setup.
Here is my datasource and gridview code: The gridview row goes into edit mode, but the changes never take affect on the database.
[Code]....
I have several VB.NET functions which pass and receive values from executed stored procedures using parameters. However, the latest method I am using seems to be a little too specific on the datatype and data length of the parameters for my liking (i.e.
LogActivityCommand.Parameters.Add("@strErrSource", SqlDbType.NVarChar, 300).Value = strErrSource). For example:
[code]....
If I end up changing the datatype and data length properties of the variables in my SQL stored procedures in the future, I am going to have to re-visit my VB code too and alter the parameter settings here as well.
I have built a web app and want the user to be able to select, update, delete, add data as well as execute stored procedures, I thought that I would get this from the db_datareader and db_datawriter roles but I get an error when trying to select data etcFor instance I get an error when trying to run the stored procedure ups_AddCustomer when the user has the assigned roles db_datareader & db_datawriter but it works fine when the db_dbowner but i would rather not have the page user having full access to the database.
View 1 RepliesI open a sqlconnection and sqlcommand. I execute a stored procedure and get the scope_identity from that procedure to be used within another procedure that needs to be fired. Unfortuntley if the second procedure fails forwhatever reason the data change for the first procedure commits anyway. I kind of want to do a began transaction end transaction on the c#.net side. Also I need to execute a stored procedure multiple times....
View 2 RepliesI created a ListView and attempted to delete a record using the delete button and native procedures. It failed and threw an error.Pass in a valid dictionary for delete or change your mode to OverwriteChangesIn researching this issue, it appeared there is a problem with the list view when deleteing and
ConflictDetection is set to
[Code]....
[Code]....
[Code]....
[Code]....
[Code]....
[Code]....
[Code]....
[Code]....
[Code]....
I have never used stored proc ouput parameters i want to know what is the use of using output parameters?If possible provide me some code.
View 10 RepliesI have a stored procedure with the following structure:
[Code]....
I try to pass two parameters to code behind
Into gridview
Visible='<%# Show(DataBinder.Eval(Container, "DataItem.Id").ToString()) %> + <%# MostrarBotonBorrar(DataBinder.Eval(Container, "DataItem.Rol").ToString()) %>'
in codeBehind:
public bool Show(string value,string value2)
{
if(value == LbluserInvisible.Text)
{
return true;
}
else
{
return false;
}
}
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 ??
[Code]....
I need to be able to delete records from a gridview using a stored procedure. My data comes from two sources so the standard delete won't work. I have come up with the code below which deletes a record, but the wrong one. How can I iterate through the rows to delete the row I actually want to delete.
[Code]....
I want to have a dropdownlist in the footer row of a gridview. The dropdownlist must be populated with an stored procedure that receives a parameter and has a select. Is that posible?? I think yes but I having problems with the parameters.
[Code]....
The exception says incorrect sintax... but I've changed the procedure for something very simple to solve the problem like select 'hello' or select 1, 'hello' and I'm getting the same problem...
ringht now i am working with one web page, in that page i have 3 sections of data [or 3 set of data] in 1 set 4 to 5 fields actions to be taken when we click on save button 1st it should save the 1st fields data in one of my sp and it should get the table level id it should loop that table level id into another set of records & insert into to the another sp
View 4 RepliesI have a situation where in a legacy app (VB6) I have a grid which is populated by any one of a large number of (100+) stored procedures. Each of the procedures returns one or more rows with an identical list of columns (including column names, column data types, column order). I am basically looking at the (best) options to keep things reasonably light weight. Each procedure has its own set of parameters, each of which would result in different query plans etc. I have tried using each query to exec select into a (temp) table which is encapsulated into a "master" query which then returns a single results set, but it breaks SQL, the query optimiser returns an infinite number of rows - this is a MS documented issue. Looking for possible ways forward: generics, model view etc
View 3 RepliesHow do I pass the ID and SelectedDate values in to the stored procedure as parameters??
[Code]....
I have a grid view that populates and displays data at btn click event from the following sql statement in one of the SP:
SELECT
reg_code, pc_serial, act_code
FROM user_reg
WHERE reg_code=@reg_code
I want to pass parameters to the other Stored procedure when the edit button is clicked in order to update the 2 columns in the specific row at the time. I now how to pass parameters in a regular btn click event or function, but in the case of edit btn in grid view I don't know how to capture data from specific row and then pass it to the SP. Here is Stored Procedure to update the columns (every user always has the same reg code, but may have more than one serial number and activation code, I want to let the user update serial number and then based on the serial number generate new activation code in the SP.):
[Code]....
This is my stored procedures with 3 selects statements
[Code]....
Now I have to fill two dropdown from the forst 2 select statements and need to fill some label through the 3 statement for this I did this
[Code]....
Its working fine my
[Code]....
Now I want to bind others controls. But I am not getting that how dataset differentiate which data need to bind to which control. How I can do this.
I have been reading this forum post: http://forums.asp.net/t/1320074.aspx.I have found that I have to have the column which contains the image path showing in the gridview, in order to reference it using e.values("columnhere"). Is there a way I can do this without the column showing? I have tried setting the visible property to'false' but it still doesn't like it.
View 1 RepliesI 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?
I got DDL1: 10 miles
20 miles
TextBox1 : 'AAA20'
Button:
When user selects 10 miles from dropdownlist DDL1 and types AAA20 in textbox1 which is of type text, on button click it has to pull all the columns from database and show results in gridview using sqldatasource store procedure. I'm stuck in server side code..how to pull the data..in store procedure I'm passing two parameters val1 and val2. val1 gets data from DDL1 and val2 gets data when user types in textbox1 and it has to validate the text...see the code below mentioned and tell me how to pass the params and get the data in gridview...
[code]....
I am using Visual Studio 2008 and SQL Server 2008 and have added a SQL datasource to my form.
When I configure the datasource, I choose my connection string which looks like this in my webconfig:
<connectionStrings>
<add
name="PSFSPRD_ConnectionString"
connectionString="Data
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?
In one of the web page say "Default1.aspx" I have a Gridview.I am using 2 DataKeyNames in Gridview. i.e., DataKeyNames="G_Name, Param_ID" Also, I have one Hyperlink inside Gridview, upon clicking, page navigates to other page say "Default2.aspx"
code of "Default1" page:
<asp:GridView ID="GridView1" runat="server" DataKeyNames="G_Name, Param_ID" AutoGenerateColumns="False" Width="100%" PageSize="8" AllowPaging="True" OnPageIndexChanging="GridView1_PageIndexChanging">
<Columns>
<asp:BoundField HeaderText="Goal Name" DataField="G_Name" Visible="false"/>
[Code]....
code of "Default2" page:
protected void Page_Load(object sender, EventArgs e) {
if (!Page.IsPostBack) {
string name = Request.QueryString[0].ToString();
string id = Request.QueryString[1].ToString();
}
}
I want to pass multiple parameters in querystring. I wrote above code.
Problem is: I am unable to write the correct syntax for Hyperlink NavigationUrlTherefore, it is giving me below error:
DataBinding: 'System.Data.DataRowView' does not contain a property with the name 'GF_Name, Param_ID'.
at Line:
<asp:HyperLink ID="HyperLink1" runat="server" NavigateUrl='<%# Eval("GF_Name, Param_ID","~/Default2.aspx?Name={0}&Id={1}") %>'
Text='<%# Eval("GF_Name") %>'></asp:HyperLink>
how to resolve it.
Instead of dynamically building an sql to update data based on certain fields that are filled in, I would like to try and do it via a stored procedure I have three fields passing potentially passing to a stored procedure
myCommand.Parameters.AddWithValue("@Field1",
Field1.Text)
myCommand.Parameters.AddWithValue("@Field2",
Field2.Text)
myCommand.Parameters.AddWithValue("@Field3",
Field3.Text)
Stored Procedure accepts 3 parameters
@field1 nvarchar(20), @field2 nvarchar(20), @field3 nvarchar(20)
I want to be able to pass parameters in a variety of ways
field1, field2, field3
or
field1, field3
or
field2, field3
When I attempt thsi, it provides an error of a missing parameter when I do not supply all three. Is there any way to pass exclude parameters at times. The most important thing is that I do not want to update the field to a null when a parameter is not passed, I want it to exclude updating that field altogether
I have 2 store procedures and I need to populate DataList using the two stored procedures
GO
ALTER procedure [dbo].[ViewSreg]
@Mobile nvarchar(30)
as
begin
select *
from S_register
[Code] ....