DataSource Controls :: Editable Gridview With Multiple Select Commands
May 14, 2010
I am trying to write an app that has one gridview, but I change the select on my sql data source to show different information on the same grid. For example I start showing units, but when price is selected I reassign my select command from Select sales.[sales1] to Select (sales.[price] * sales.[sales1]) as sales1.
However, this is causing a problem that I cannot understand with the built-in edit functionality of gridview. Whenever I click on edit, all the data in my gridview reverts back to the original select and displays only units. Am I missing something? When I change my select command the only things I am changing are my gridview.datakeynames, sqlsource.selectcommand, and sqlsource.updatecommand. What do I need to add to make my gridview edit using the current selectcommand?
View 3 Replies
Similar Messages:
Feb 13, 2010
I plan on having multiple Gridviews on one page populated completely in code behind. The only difference between them will be the Stored Procedure. In an effort to save having to write the following for each gridview, can I reuse the commands for each of them. Below is a sample of one of the commands that I would like to use, as well as the bind sub that I am using.
I realize that it will not be at all difficult to cut and paste each of these lines, and making the minor edits for each one. I just would like to keep my code behind file thin, as well as only limiting the chance for mistakes by using multiple commands.
[Code]....
View 7 Replies
Nov 15, 2010
How to select a row in editable gridview, if we write like
[Code]....
its selecting the row in gridview but it unable to select dropdown and image in gridview after selecting a row in gridview
My requirement is selecting a row in gridview and when the user selects a row in gridview, it has to perform postback to show the data in other controls related to this gridview row and able to select dropdownlist and imagebuttons in gridview.
Note: I have used checkbox in gridview to select rows and delete selected rows, but i want postback has to be happen show the data of gridview rows in other controls.
View 1 Replies
Mar 16, 2012
In a gridview, how does one create/add more than one button where each does something different?
I need 3 buttons for each row in a gridview.
Each will open a different target page/url when clicked on. I've done this in classic asp but how does one do it in asp.net using gridview? Or should I be doing something else? Maybe a repeater or some other control? I would need sorting and paging too.
I am trying to duplicate the functionality of this classic asp application I created years ago:
[URL]
Search for street name="oaK"
The results of the search is what I need to duplicate in asp.net.
I have the basics done but can't figure out how to make additional buttons in the gridview of the results do different things in this asp.net application:
[URL]
View 3 Replies
May 20, 2010
So far i've populated my grid view with my roomID. however using data reader I don't seem to be able to get more than one column to auto generate even though i'm now looking for three values : SELECT tt_roomEquip.roomID, tt_room.roomCapacity, tt_equip.equipTitle is my select bit of the sql, though it's only putting roomID into my grid view.
View 1 Replies
Aug 19, 2010
I've got this page where I display a 3 level nested gridview. First gridview displays data, 2nd one displays data based on the 1st one's row and 3rd one displays data based on the 2nd gridview. All of this works perfectly, including the edit mode for the 3rd gridview.
The issue comes when I make each gridview collapsible, again, it works fine but when I click on "Edit" on the 3rd gridview all the grids collapse, I can then re-open them and the "edit mode" is still present and I can still save my updated data. But that collapsing thing is quite annoying. I based a lot of my code from this page: [URL] And I understand how I can fix my issue on a 2 level nested gridview, by simply adding the C# code:
[Code]....
This makes allows me to save the index and prevent it from collapsing when I'm editing. Unfortunately, because I'm actually editing the 3rd gridview, if I code:
[Code]....
That simply doesn't work because I get the error "GridView2 does not exist in the current context". I also tried adding it to the .designer.cs page, but that doesn't change anything and still doesn't work. I'm not at work atm, and hence cannot paste the entire code, however, would anyone still have any idea as to how I can fix that issue?
View 11 Replies
Dec 1, 2010
im explaining this base on a test page that i have hosted as i was trying to track down my problem, i have a hosted page which i have hosted on the internet on a hosting service provider. the page has a normal gridview that is linked to a SqlDataSource. and theSqlDataSource has sql statements for selecting data, updating and deleting. They all work fine locally and even if i host them locally through IIS. but on the hosting service they down work. only the select work, which means i can view my data on the gridview but i cant manipulate it, delete and updating dont wanna work, they dont do anything. and the worse part is that im not even getting an error from them, on the grid i have enabled the autogenerate edit button and the delete, how can i make the update and delete work, or what is it that makes them not to work. the code for my test page is below
[Code]....
View 2 Replies
Jan 14, 2011
I have an inventory page with a gridview that shows 1 item per record, each item starts with a checkbox in the gridview. Currently users can select multiple records and hit the order button and everything has worked well. Now I have multiple pages in my gridview, and if a user selects a few records from the first page, and then goes to the second page, all the records (checked checkboxes) disappear from the first page.
[Code]....
View 8 Replies
Jun 1, 2010
the best way to achieve the following:A products table linked to an images table where 1 product can have many images.Simple scenario is to select a product and its images using
select * from products where id=5
select * from images where pid =5
So far so good, its easily mapped to an object once the query has executed with ado.net.
what if i want to select all products and their related images and map them to a Product object, the result is as follows
SELECT * FROM PRODUCTS JOIN IMAGES ON ID=PID
Now the table I get is:
ID PRODUCTNAME IMAGEURL
1 COMPUTER IMAGE1.JPG
2 COMPUTER IMAGE2.JPG
3 COMPUTER IMAGE3.JPG
I would need to do some work in c# to keep track of id and get images until the id changes, if you get what I mean.
I want a way that I can execute a single query like the one above, or modifed version and make it easier to map the result to my objects.
Something like,loop products,map products to product object,loop images map images to products.images
View 8 Replies
May 18, 2010
How do I select multiple columns into IQueryable<Employee>?
View 2 Replies
Feb 25, 2010
if I have three Dropdownlist A, B, C, how can I write a select statement to get data from sql server based on the dropdownlist selected.e.g. if user select dropdownlist A, select * from table where A = dropdownlist A but if user select dropdownlist A and C, then select statment is "select * from table where A = dropdownlist A and B = dropdownlist B or if selected A, B, C.......how can I settle so many choice.
View 2 Replies
Mar 15, 2010
I need to write a select query where it will be doing "like" on one column with multiple strings.
Eg : Select * from tblCity where city like '%ABC%' and city like '%XYZ%'
I have set of strings.
View 5 Replies
May 19, 2010
I'm using ASP.NET MVC to create a small web apllication.
Here is my database And here is my class
[Code]....
View 2 Replies
Nov 16, 2010
I want to be able to show the record that was just inserted after add_button_click event. I run the insert from mycommand and then set mycommand2 to run the read to populate a details view. I have a feeling I am going about this the wrong way. The insert fires correctly but the details view does not populate.
[Code]....
View 3 Replies
Jan 2, 2010
there are multiple rows with same SubContact_No and with same value of some columns. for a single column I am firing query like
Select distinct (Financial_Status) from mtblSub_Contract where SubContract_No=@SubContract_No";
it's working fine.... (it's ok with a Single column)
But Now I need multiple columns value so how to query for this.
Select distinct (Financial_Status, colums2, column3) from mtblSub_Contract where SubContract_No=@SubContract_No"; is not working
So how to do that.
View 5 Replies
Jan 5, 2010
[Code]....
I have a select statement that is supposed to be filling grid with information from an income table. It's only supposed to pull if the income is from the current fiscal year or is less than 1 year old. Currently, what it does is pull multiples of rows and also rows from past income years but only if there is a mixture. For instance, if a person has income from 2005 and 2010 what it will show is this
Income 2005
Income 2005
Income 2010
Income 2010
Income 2010
Does anyone know what I've done wrong? BTW, those results are exact, old income is shown twice, current is shown 3X
View 16 Replies
May 14, 2010
This question is for wrapping up work on a database driven AJAX AutoComplete Control that I am using to provide keyword hints to user on search pages. Each record has 6 columns for keywords where each column is for an advertiser to add a keyword. These are used in meta keywords tags, but I also want to use them for AutoComplete. The problem is that I don't know how to write a SELECT statement in Visual Studio that treats all 6 keyword columns as if they were all one column. I am looking for something like
SELECT (keyword1 + keyword2 + keyword3) AS Keywords
FROM (Merchandise)
WHERE Keywords LIKE @term
The only other thing I can think of the gain this level of functionality would be to combine them into a new table.
View 7 Replies
Feb 4, 2010
Is it possible to add multiple select statements in a single stored procedure. The select statements are getting data from different tables. If yes, could anybody provide an example in adding multiple select statements, which retrieve data from different tables in a stored procedure.
View 3 Replies
Feb 9, 2011
I stripped this example to make it simple. I have a gridview with a template field. The template field contains two buttons and a label (They must be in the same template field). I want the first button to set the label text to "Win", and the other button to set the label text to "fail". The onrowcommand doesnt seem to be triggered by buttons in a template field. How can I accomplish this?
My gridview code is below:
<asp:GridView ID="GridView1" runat="server" EnableModelValidation="True" AutoGenerateColumns="False"
OnRowCommand="Gridview1_RowCommand">
<Columns>
<asp:TemplateField ShowHeader="False">
[Code]....
View 2 Replies
Jun 30, 2010
Note: Code is taken from this tutorial [URL] I currently have an editable gridview with only some columns editable by the user. In the background I want to record the time/date they have saved the data to the grid. This column 'Time' is not bound to the grid. Is there anyway I can still include this update when rebinding the newly edited data?
I'm also having a problem saving the updated data of my column ActivityTotal. I've been debugging that and following the variable, and it holds the correct value, but just doesnt seem to update. I am providing the codes below for both my gridview and the cs behind and would be grateful if someone could take a look, I assume it's a sort of minor sql issue on my part.
code
protected void UpdateButton_Click(object sender, EventArgs e) { originalDataTable = (DataTable)ViewState["originalValuesDataTable"]; foreach (GridViewRow r in GridView_ABC.Rows) if (IsRowModified(r)) { GridView_ABC.UpdateRow(r.RowIndex, false); } // Rebind the Grid to repopulate the original values table. tableCopied = false; GridView_ABC.DataBind(); }
View 4 Replies
Oct 13, 2010
my have requirement is to select multiple records from Grid. by checking check box..
Actually i have 10 records in my Gridview i checked only 3 records by using check box . then i click NEXT button i need to show those 3 records only in another Gridview.
below is my code...
<asp:GridView ID="grvStores" runat="server" BackColor="White"
BorderColor="#CCCCCC" BorderStyle="None" BorderWidth="1px" CellPadding="3">
<FooterStyle BackColor="White" ForeColor="#000066" />
<RowStyle ForeColor="#000066" />
[Code]....
View 2 Replies
Feb 19, 2010
how do i edit and delete in gridview without sqldatasource commands?
View 2 Replies
Nov 6, 2010
i'm using the code below to select multiple rows in a gridview using a checkbox, how do I modify the code in a "select all" button click event to select all the rows by checking the checkboxes in all the rows? How do I also clear all the checkboxes using sa "Clear" button click event?
[code]....
View 1 Replies
Nov 12, 2010
I have a GridView with an extra checkbox column to select rows.
To select multiple rows, the user now has to click each separate checkbox, but I would like to offer the possibility to select multiple rows at once using Shift+click.
Thus the user would explicitly select the first row with a single click and the select the last row using Shift+click. And the checkboxes of the rows in between would then automatically be checked as well.
View 3 Replies
Mar 15, 2011
I would like to let user to select multiple records from a gridview and then click a print button to print a report (*.rdlc).
In the report, there will be a table to list the selected records row by row.
(there is no insert/update/delete for selected records, just selected to print report.)
how to select multiple records to print on a report ?
View 4 Replies
