Solved like this
currentID = Convert.ToInt32(GridView_ABC.DataKeys[0].Values[0]);
activityName = Convert.ToString(GridView_ABC.DataKeys[1].Values[1]);
DataRow row =
originalDataTable.Select(String.Format("EmployeeID = {0} AND ActivityName = '{1}'", currentID, activityName))[0];
I am looking for a way in which to make a column in a GridView editable.
Currently i am looking into overriding the GridView so that the whole view is editable and then making all the column I do not want to be editable, read only.
I'm sure there is a better way, but I cant find it.
I've got my data in the gridview via:
[Code]....
Now I need to make all the data editable (add, update, delete). Why isn't the Gridview the same as DataGridView? With the DGV, the data showed EXACTLY as it did in the database and one could add a record, edit a record, or delete a record.
[Code]....
and im not getting the result i expected =
I want if the header of a particular column contains a word "S", the header and row turns red. I used following code to make header red and it works fine. How to make it such that the rows also turn red if condition is met ? I cannot hardcode in columns since the Gridview is autogenerate colums as data structure keeps changing.
Protected Sub GridView1_DataBound(ByVal sender
As
Object,
ByVal e
As System.EventArgs)Dim HeaderRow
As GridViewRow = GridView1.HeaderRowFor
Each c
As TableCell
In HeaderRow.CellsIf c.Text.EndsWith("S")
Then
c.BackColor = Drawing.Color.OrangeRed
End
If
Next
End
Sub
I was wondering if anyone could help me. I have a template field which has four itemtemplates that each hold a label in a gridview. These labels are always constant with the same strings. What I want to do is change the css formatting of these four labels depending on the value of a column. So the css formatting would have to be done for each row, not the whole column. I bind the gridview to a dataaccesslayer so there is no sqldatasource on the page. Does anyone have any idea how to do this and where it would be done. I will have the dataview with the data sorted in the correct order. The actual column that is used to alter the CSS will not be in the gridview although I could assign it to the datakeyname if that makes it easier as the data is not sensitive.
View 1 RepliesI want to do one thing that when i edit the gridview then it will not go back to main form for editing.it will remain there in the form for the row editable.
i-e when i edit any row then it will be editable on the gridview.
<asp:GridView ID="noticeDetails" runat="server" BorderWidth="1px" AutoGenerateColumns="false" PageSize="10" Width="10%" CellPadding="10"
AllowSorting="true" AllowPaging="true" AutoGenerateEditButton="true" onrowediting="noticeDetails_RowEditing"
onrowcancelingediting="noticeDetails_Rowcancelingediting"
[CODE] ...
I have a RadGrid which has a column like:
<telerik:GridTemplateColumn HeaderText="Car" >
<ItemTemplate>
<asp:Label ID="MakeLabel" runat="Server" Text='<%# Eval("Make") %> />
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="MakeTextBox" runat="Server" Text='<%# Bind("Make") %> />
</EditItemTemplate>
</telerik:GridTemplateColumn >
and I'm wanting to set it up so that this column will allow input when inserting new values but won't when updating values.
Any one know any open source user control that is similar to gridtreeview. Basically, I want to show a multi column treeview that when expanded, user can edit certain column values. The columns can have a text box or dropdown etc.
View 8 RepliesNote: 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(); }
Show/Hide Edit button depending on column value?
View 3 RepliesI have a gridview with an edit command button. When I press the edit button, it makes all the columns of the selected row editable. But I want it to make only few columns of the selected row to be editable...how can I do that?
View 3 RepliesI'm creating a gridview that should always have a row on the top of the gridview irrespective of whether there exists data to bind to or not. This row should have a column with a textbox to insert data.I tried creating a header template and setting showheader to true,but it won't display.
<asp:GridView ID="gvwMessages" runat="server" AutoGenerateColumns="false" ShowHeader="true"> <Columns>
<asp:TemplateField HeaderText="FileNote">
<ItemTemplate>
<asp:CheckBox ID="CheckBox2" runat="server" />
</ItemTemplate>
<HeaderTemplate>
<asp:CheckBox ID="CheckBox3" runat="server" />
</HeaderTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Date">
<ItemTemplate>
<asp:Label ID="Label7" runat="server" Text="Label"></asp:Label>
</ItemTemplate>
<HeaderTemplate>
<asp:Label ID="Label8" runat="server" Text="Label"></asp:Label>
</HeaderTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Created By">
<ItemTemplate> <asp:Label ID="Label9" runat="server" Text="Label"></asp:Label> </ItemTemplate>
<HeaderTemplate>
<asp:Label ID="Label10" runat="server" Text="Label"></asp:Label>
</HeaderTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Message Lines">
<ItemTemplate> <asp:TextBox ID="TextBox2" runat="server" TextMode="MultiLine" Enabled="false"></asp:TextBox> </ItemTemplate>
<HeaderTemplate>
<asp:TextBox ID="txtHeaderMessage" runat="server" TextMode="MultiLine"></asp:TextBox> </HeaderTemplate> </asp:TemplateField>
</Columns>
</asp:GridView>
</p>
I have a gridview which enables editing. The editing sequence works fine. When the user clicks the edit button, I want ONLY the row to be edited to be shown, and all others to be hidden.
This is the code that I have, but it isn't working. Can anyone tell me why and how I can fix it? I am using a dataset to bring text from an XML file.
[Code]....
I want to make an editable gridview with 4 boundfield. When a row is selected, I want to edit the value of the 2 boundfield. Can I use edit, update commandfield?. Because when I tested it, all the columns of the selected row becomes editable.
View 4 RepliesSorry if I suffering from morning-brain, but I can't find an answer to this, right now, but it seems such a beginner's question. Is there a way to make a gridview "fully editable"? By this, I mean that rather than the normal gridview edit method, where you have to click a row to edit it and then click to update the dataset, you can set certain columns (and also, only certain rows within those columns) to be editable all at once?
View 6 RepliesI need to display 144 records in some form of Grid/Spreadsheet view. Currently I have the records being displayed in a Gridview, however this means that if the user needs to make multiple changes to the data that is being displayed then they would have to hit the edit and then update for each row. What I would like to be able to do is have them Edit whatever rows and columns they need to and then have them click update once. Is this possible, if yes then how?
View 7 RepliesHow 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.
I have a gridview which displays rows and columns all linked to an sql statement... and all works as normal.
I want to include a new column, that displays an image depending on what the value of the column is. If the column has a value - it will display an image. If the column value is null no image whill be displayed.
My sql is something like:
SELECT c.call_id, title, a.call_id as b_attach
FROM calls c
LEFT JOIN attachments a ON c.call_id = a.call_id
GROUP BY c.call_id,title,description, a.call_id
What's returns from this sql is:
Call_id | title | b_attach
1235 | title goes here | 1235
1382 | another title |NULL
So if there's something in b_attach - diplay image in gridview column, else display nothing in gridview column
My Gridview:
[Code]....
I am using Gridview and on that data is binded conditionally.the problem is that at the time of editing whole row of the grid is in editable mode and i want only few of the columns editable. my code is as follows
[code]....
I have a gridview with bound fields and a templateField that receives data from a submit button which, depending upon the selected object, i.e. dropdown 1, 2, or 3, return a result set. The gridview also has a checkbox column which is used as a marker to determinie the rows to be added to and existing table. If a user selects multiple row, those rows are written to the database. Everything works.
Now, I need to add additional functionality to the gridview:
Upon selecting the checkbox, programmatically the accompanying row must become editable; for each row presented.
Deselected the checkbox, return the gridview row to a read-only state.
There are 14 columns, one of which is a dropdown which needs to maintain its default value.
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?
I have set up an editable GridView using the AutoGenerateEditButton property. When the Edit link generated is clicked I only get a small editable area, is there a way to customise this to show more text?
View 2 RepliesI have an editable gridview with blank cells. User enters some numeric data in cells and also user can clicks a button to add new row to gridview. My problem is that, as soon as button click event is fired, the page refreshes & the gridview becomes empty. Can anybody tell me, how can I save values in gridview until the user saves all changes to the server in the end
View 3 RepliesI have two pages; one page similar to a 'dashboard' displaying an incoming correspondence gridview and the other page 'incoming' displaying the same gridview of incoming correspondence. So my dashboard page is just a snap shot of what some pages have. So there are main pages that are being summarized in the dashboard. What I want to do with the Incoming gridview in the 'Dashboard' Page is once a user clicks a row in that gridview it obtains the correspondence id and redirects to the Incoming page and make that row in that gridview(same view or query as the gridview in the dashboard) editable.
What I have right now is I am obtaining the correspondence id for the row selected and redirecting to the Incoming page but have noo idea how to make that row editable in the gridview in the Incoming page.