I 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 Replies
I am using asp.net 3.5 and in a page i want to make 3 coulmns editable. I don't want to add Edit button. I have Save Button, which i want to use save all the record.
[Code]....
When I am running the page coulmns are not editable. How can we make editable coulmn.
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(); }
I have a gridview and users would select some records and would click on the submit button and i will be saving those records into database using a stored proc.... now .... just below the gridview and above the submit button there are few checkboxes by default they wud be checked. How would i save the selected values and the checked boxes in database i wrote the stored proc for the gridview but how would i save the checked checkboxes into the same table.
For i As Integer = 0 To gvSelectScreen.Rows.Count - 1
Dim chkTemp As CheckBox = TryCast(gvSelectScreen.Rows(i).FindControl("cbStatus"), CheckBox)
If chkTemp.Checked Then
ContractNumber = gvSelectScreen.Rows(i).Cells(0).Text
ClientProgramNumber = gvSelectScreen.Rows(i).Cells(1).Text
ClientProgramName = gvSelectScreen.Rows(i).Cells(2).Text
StartDate = CType(gvSelectScreen.Rows(i).FindControl("txtStartDate"), TextBox).Text
EndDate = gvSelectScreen.Rows(i).Cells(5).Text
Dim connStr As String = ConfigurationManager.ConnectionStrings("MainConnectionString").ConnectionString
Dim myCon As New SqlConnection(connStr)
Dim cmd As New SqlCommand("usp_ParametersFromGrid")
Dim dt As New DataTable
cmd.CommandType = CommandType.StoredProcedure
cmd.Parameters.Add("@ContractNumber", SqlDbType.VarChar, 22).Value = ContractNumber.ToString()
cmd.Parameters.Add("@ClientProgramNumber", SqlDbType.VarChar, 22).Value = ClientProgramNumber.ToString()
cmd.Parameters.Add("@ClientProgramName", SqlDbType.VarChar, 100).Value = ClientProgramName.ToString()
cmd.Parameters.Add("@StartDate", SqlDbType.VarChar, 20).Value = StartDate.ToString()
cmd.Parameters.Add("@EndDate", SqlDbType.VarChar, 20).Value = EndDate.ToString()
cmd.Parameters.Add("@RequestID", SqlDbType.VarChar, 50).Value = RequestID.ToString()
cmd.Connection = myCon
myCon.Open()
cmd.ExecuteNonQuery()
myCon.Close()
End If
Now above the submit button as i said, there are few checkboxes and they are checked by default...how would i save the selected item (in the gridview and the checked checkbox values in the same row in the database(sql server)
I want to add the text box values to grid one by one and next i want to submit all grid values for insert.
View 1 RepliesViewState["Index"] = reader[0].ToString();
Using sqlDataAdapter, I wanna save one column to view state like this.
I'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 inside which there are 4-5 checkboxes. In that gridview, I have 10 rows too. So, Now what i want is.
IF I check, 2 checkboxes and don't check remaining checkboxes. how to save the value of the checked checkboxes value as Y and unchecked checkboxes value as N into the database.
Below is the HTML of the checkboxes here:-
<cc2:Grid ID="GrdRights" runat="server" FolderStyle="../Styles/Grid/style_12"
AllowSorting="False" AutoGenerateColumns="False" AllowColumnResizing="true" AllowAddingRecords="false"
AllowMultiRecordSelection="true" OnRowDataBound="GrdRights_RowDataBound" ViewStateMode="Enabled"
PageSize="100">
<ClientSideEvents OnClientSelect="FunMonthList" />
<ScrollingSettings ScrollHeight="400px" />
[Code] .....
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 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 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 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 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.
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'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.
In my project i am binding a gridview from session and i want to make it editable. i handled the rowediting,rowupdating and cancelediting event as suppose to and at run time i bound my data to the grid cells in the rowdatebound like this
if (e.Row.RowType == DataControlRowType.DataRow)
{ RequiredPaper paper = (RequiredPaper)e.Row.DataItem;
e.Row.Cells[0].Text = paper.PaperDesc;
}
and every time i click on the edit link in the grid view the cell never turns in the edit mode so i can not edit it!
i'am trying to validate a DateTimePicker inside a gridview ( it's actually an ItemEditTemplate) i'am trying to use a compareValidator Because i have two columns startDate and endDate this sounds to be easy but the validator cannot find the item startDate because it's in another column is there a way to do it whithout having it done on the client side using javascript .
View 3 RepliesI am working in a asp.net page, Where I have a button "Edit Grid". I would like to make all the row editable when user click this button.
View 4 RepliesI have a Gridview with 12 columns, Jan, Feb...Dec.
I have a textbox value that could be 1, 2,...12
I want if textbox value is 7, then column Aug-Dec in Gridview is editable when in update mode and the column in Jan-Jul is not updatable (eg make it label instead of textbox).
How can I do this ?
How to make gridview rows editable on the clilck event of a button.
View 3 Replies
