I have two GridViews, the first works fine as I defined the datasource when I dropped it onto the asp page via visual studio and I specified the table to use.
The other GridView (dgvParams below) has just been dropped onto the asp page and I want to use it at run time:
[Code]....
When I step through the code I can see row and column counts are as expected and call "dgvParams.DataSource = table".
I think I am missing another step somewhere so that I can physically see the data on the GridView?
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 would like to ask a question on the visual basic codes to loop the gridview to retrieve the values and based on the values, it will be provided as parameters to update to the database table using stored procedure.
Firstly, I have a gridview named grvProduct. The page (ui) will be loaded with data from the database with the use of stored procedures. And only certain values can be edited through the use of template in gridview. So based on those edited values, I'm supposed to pass these values as parameters to the stored procedure which will then update a database table.
Let say, I have 3 records retrieved from the database and displayed in the gridview. And I would like to edit a values in the 3 records, how do I do batch update and pass those parameters to the stored procedure? I went to debug and step through the visual basic codes and realised there were too many arguments specified because I actually loop the gridview.
Below is my visual basic codes:
[Code]....
Below is my Stored Procedure code: [Code]....
I believe it is the error in the looping of the gridview which results that I could not batch update the data/values.
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?
I'm pretty new at web programming but a lot of years as a client-server dev.
I'm populating a gridview from a stored procedure, but I don't want to actually execute the populate till I have all the values filled in the page. (some are static textboxes, a calendar (date) value and some drop-downs that are populated earlier) I see there's nothing like gridview1.show() like there is in c# windows form programming. I tried
I have a stored procedure that returns a dataset with a different number of columns and different column names depending on user input. How can I use this with a GridView? Normally I define the columns beforehand in a static fashion, but, have never done a dynamic dataset like this.
Im loading some results from a SQL Stored procedure into a Grid View. From my stored procedure I simply get 2 columns returned, Details and Savings, the savings are being returned in the format 30.50123 I want to limit this to 2 decimal places and put a euro sign in front of it like so €30.50, I have managed to do this however its adding a new "savings"column to my Grid view which I obviously don't want. So I now have a savings column with the correct format of €30.50 and my 2 columns from my stored procedure
I have an app where i have a GridView connected to a DropdownList....The selectedIndexChange determines what the gridview shows. Then have coded in the row editing event the ability to change the information in the row. MY ISSUE- cant take the new information changed in the row and update it in the database. I have a row updating event that im trying to figure out how to attach it to my stored proc and the newly edited row
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.
I am using two SQL Data Adapters to initially populate a gridview and then repopulate from search results. The Search SQL Data Source uses a stored procedure to retrieve the results but I cannot get the updated gridview to display.Here is my aspx code:
[Code]....
Here is my CS code:
[Code]....
I cannot get the gridview to display after I click the Search button.
update mytable set column1 = @column1, column2 = @column2 where id_table = @id_table
The stored procedure works perfect when I try to execute it in the SQLServer query analizer, but my problem is when I call the sqldatasource update command.
When I do that, it seem that there are problems whith the parameter's names...
I'm doing that whit updateparameters.Add(parameter) and parameter is created whit the same name, tipe and the value that Is shown in the gridView.
I'm looking for in the msdn but everything I founded was about doing that through an update query but I need the stored procedure.
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.
I have a form that has a textbox, a button and a datagridview. The textbox is a parameter of @subschedule. I'm needing to pass the value of the text box to my sql stored procedure and then fill my datagridview with the results of that query.
When i bind gridview to stored procedure what i found it only shows data after enabling Autogeneratecolumns and it also doesnot show any column in boundedfield. Due to which i am unable to apply formating to individual column according to my requirement. One possible reason may be table is created in stored procedure due to which it generate fields at run time.
Is it possible to use dynamic query filters with a gridview using a stored procedure as a data source? What I'm thinking of is a search page where there are multiple controls to enter in a search string and a radio button for the AND/OR query filters between the various controls. If not, what would be the best way to allow a user to select an AND / OR with a group of different query controls?
Here is the page I have created thus far using a view and no AND/OR option. I but I can't get it to work with my SP, also listed below:
I am migrating a application and using asp.net 3.5 and in a page i want to display some data in grid where coulmn heading comes from one stored procedure, another procedure for Row heading and another procedure for row data.
Can we do like this in Grid view? or I need to go for HTML Table to display the data. Previously it was done in Vb6.0 using Flexigrid.
I have a gridview in aspx page bound to a stored procedure, and data is loaded from the database. I have 2 problems which I am banging my head against. 1. Stored Proc has default values of NULL ( which is a DateTime db type) and I don't get how to give them as default values and once I have valid date time ( from textbox on form) , I need stored proc to take this value . ( I have done this from server side code but if this is able to acheive from client side that would be great.
2. As shown below my gird view is present ( no columns are bound and since the data is loading from server side ) I am unable to do sorting on the gridview without a sort expression. Does any one know how to do this?? This is my biggest concern. I have checekd all the articles I could find on google
