I am tryting to reach controls in the gridview rows by RowCommand event. I can take values of controls which are binded to gridview source successfully . But for all other controls which is not binded to gridview returns NULL value. All controls run at server. Why is that?
View 7 Replies
I'm trying to retreive values entered by users in the textboxes in the footer of the gridview and insert these values into another sql table.My code is as follows :-
protected void GridView2_RowCommand(object sender, GridViewCommandEventArgs e)
{
if(e.CommandName.Equals("addnew"))
{
TextBox t1 = (TextBox)GridView2.FooterRow.FindControl("tfrm");
string frm = t1.Text;
TextBox t2 = (TextBox)GridView2.FooterRow.FindControl("tsub");
string sub = t2.Text;
string cmd = "insert into suggestions values('" + frm + "','" + sub + "','c','c')";
con.Open();
SqlCommand com = new SqlCommand(cmd,con);
int a = com.ExecuteNonQuery();
GridView2.DataBind();
con.Close();
}
}
But the strings 'frm' and 'sub' returns null values.
In a DetailsView Templatefield i have some binded Labels.
I need to show - hide Templatefield or the detailsView if Label1 is null - empty.
I have a gridview with daatsource from MembershipUserCollection. When my collection doesn't contain any records the gridview just disappears. I want to display the empty gridview indicating no records exist rather than the grid just become invisible.
How to make gridview always visible ?
i am working on a website,As i am new to coding i got a problem in it. It was,I hav a gridview in which i am adding the details about a college, and in that i had a buton ("btnReservation") on clicking it another grid will be appeared in which, i hav to enter the reservation details so, till this step it is working fine, but if i enter one college details and clicking on the btnReservetion the grid is being dispalyed and i am able to enter and save the data, But if i enter the details of another college and clicking on the btnReservation, the rows which i hav already entered in the Reservation grid for the previous record are not being Refreshed and are remaining the same,So now i hav to make the gridview datasource null.
[code]...
I am so stuck with a simple issue , but I cannot figure out what it is...I have a gridview and have some bound columns. I have a
<asp:ButtonField
ButtonType
="Button"
[code]...
I have a webpage with a select object and a GridView object. For testing my problem i've created asp button and html button.On pageLoad the GV is empty and select is being filled with names. (GV is not appearing)After choosing a name from the select options, the user should click a button and then the GV need to be filled with relevant info.I am having 2 "related" problems:
1. When clicking on the asp button and getting into the click function on the aspx.cs file, i can't find the select object and retrieve the selected option. How can i get this?
2. When clicking on the html button and getting into the button_click function on the aspx file (javascript), i can't find the GV object (getElementByID("GridView1") returns null). I guess that it's because the GV is not loaded initialy since it's empty.I've tried also using callback methods, but the although it seems like i am reaching the GV and performing DataBind(), the GV table won't show on the page.
I have a gridview. In the rowupdating event, the txtbox returns null. I have enabled viewstate for the gridview. But still it does not work. I have made this in Kentico.
<asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True"
AutoGenerateColumns="False" DataKeyNames="id" DataSourceID="SqlDataSource1" EnableModelValidation="True"
OnRowUpdating="GridView1_RowUpdating" >
<Columns>
<asp:CommandField ShowDeleteButton="True" CausesValidation="false" ShowEditButton="True"
ControlStyle-Width="100px" />
<asp:TemplateField HeaderStyle-HorizontalAlign="Left" HeaderText="Name" SortExpression="name">
<ItemTemplate>
<asp:Label ID="lblRegionName" runat="Server" Text='<%# Bind("name") %>' Width="200px"></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox runat="server" ID="EditRegionName" OnTextChanged="EditRegionName_Updated"
Text='<%# Bind("name") %>' Width="200px" />
</EditItemTemplate>
<FooterTemplate>
<asp:TextBox runat="server" ID="InsertRegionName" Text='' Width="200px" />
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderStyle-HorizontalAlign="Left" HeaderText="Archived" SortExpression="IsArchive">
<ItemTemplate>
<asp:CheckBox ID="lblArchive" Enabled="false" runat="Server" Checked='<%# DataBinder.Eval(Container.DataItem, "archived") %>'
Width="100px" />
</ItemTemplate>
<EditItemTemplate>
<asp:CheckBox runat="server" OnCheckedChanged="EditArchive_CheckedChanged" ID="EditArchive"
Width="100px" />
</EditItemTemplate>
<FooterTemplate>
<asp:CheckBox runat="server" ID="InsertArchive" Checked="false" Width="100px" />
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField ShowHeader="False">
<ItemTemplate>
<asp:LinkButton ID="btnHistory" runat="server" Text="History"></asp:LinkButton>
<ajaxToolkit:ModalPopupExtender OkControlID="OkButton" ID="ModalPopupExtender1" runat="server"
BackgroundCssClass="modalBackground" TargetControlID="btnHistory" PopupControlID="Panel1" />
<asp:Panel ID="Panel1" runat="server" CssClass="modalPopup" Style="display: none">
<div>
<iframe frameborder="0" src="/CMSWebParts/MSM/RoundTableAfrica/Beheer/History.aspx?id=<%# DataBinder.Eval(Container.DataItem, "id") %>"
width="500px" height="100%" scrolling="no"></iframe>
<br />
<asp:Button ID="OkButton" runat="server" Text="OK" CausesValidation="false" Width="50" />
</asp:Panel>
</div>
</ItemTemplate>
<EditItemTemplate>
</EditItemTemplate>
<FooterTemplate>
<asp:Button ID="btnInsert" runat="server" Text="Insert" OnClick="Insert_Click" />
</FooterTemplate>
</asp:TemplateField>
</Columns>
<EmptyDataTemplate>
Region Name:<asp:TextBox runat="server" ID="NoDataRegionName" />
Archived:<asp:CheckBox runat="server" ID="NoDataIsArchive" />
<asp:Button runat="server" ID="NoDataInsert" CssClass="contentButton" Text="Insert"
OnClick="Button1_Click" />
</EmptyDataTemplate>
</asp:GridView>
<asp:Button runat="server" ID="Add" Text="Add" OnClick="Add_Click" />
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:RTAConnectionString%>"
ProviderName="System.Data.SqlClient" SelectCommand="select * from [spiderwebs_region] order by name "
UpdateCommand="UpdateRegionWithHistory" UpdateCommandType="StoredProcedure"
DeleteCommand="DeleteRegionWithHistory" DeleteCommandType="StoredProcedure" OnInserting="Sqldatasource1_Inserting"
OnInserted="Sqldatasource1_Inserted" InsertCommand="InsertRegionWithHistory"
InsertCommandType="StoredProcedure">
<DeleteParameters>
<asp:Parameter Name="id" Type="Int32" />
</DeleteParameters>
<InsertParameters>
<asp:Parameter Name="action_time" Type="DateTime" />
</InsertParameters>
<UpdateParameters>
<asp:Parameter Name="content_type_id" Type="Int32" />
<asp:Parameter Name="object_repr" Type="String" />
<asp:Parameter Name="action_flag" Type="Int32" />
</UpdateParameters>
</asp:SqlDataSource>
Code Behind:
protected void Page_Load(object sender, EventArgs e)
{
GridView1.DataBind();
}
protected void GridView1_RowUpdating(Object sender, GridViewUpdateEventArgs e)
{
int index = e.RowIndex;
GridViewRow currentrow = ((GridView)sender).Rows[index];
TextBox txtbox = (TextBox)currentrow.FindControl("EditRegionName");
CheckBox isarchive = (CheckBox)currentrow.FindControl("EditArchive");
e.NewValues["name"] = txtbox.Text;
e.NewValues["archived"] = isarchive.Checked;
GridView1.EditIndex = -1;
GridView1.DataBind();
}
Since I am not using a DataSourceId at the markup I am having to create my own Sorting handler. I found a sample on MSDN but the variable 'dataTable' always returns null why?
[Code]....
and here is how I am feeding the DataGrid:
[Code]....
I have a treeView on my main page. While the page is postback the method TreeView.FindNode works fine. But when i return to main page from another, and loading ValuePath from session it returns null.
here is my treeView [Code]....
Code behind to save values in session on Page_Load:
[Code]....
Code behind to select TreeNode after return from other page on PageLoad
[Code]....
I have a auto binded grid view, in one of the column, I would like to create a hyperlink for it.
View 2 RepliesI have the columns pre-set and I set the Allow Sorting = True,
Now I don't know what code to put in my VB file under "GridView1_Sorting" event.
I am binding the gridview with the list like this
<ev_event> objev_event = new List<ev_event>();
GridView1.DataSource = objev_event.ToList();
GridView1.DataBind();
I want to enable paging for the Gridview. when I enable True for Enable paging property, The error throws.how to enable the paging for list binded GridView?
I have a auto column generated GridView in a page, I have a dynamically binded column in that gridview, when page loads then sorting option is available on all other columns except that dynamically created column.
[Code]....
I am getting error as Procedure 'storedproc2' expects parameter '@NewMessage', which was not supplied.Basically in this I am taking the text in one cell and add sometext to it and update in the next cell of the row.
My .aspx contains
<asp:SqlDataSource ID="mySource1" runat="server" ConnectionString="<%$ myConn %>"
SelectCommand="storedproc1" SelectCommandType="StoredProcedure"
UpdateCommand="storedproc2" UpdateCommandType="StoredProcedure">
<SelectParameters>
<asp:SessionParameter Name="AcctId" SessionField="AcctId" />
</SelectParameters>
<UpdateParameters>
<asp:SessionParameter Name="AcctId" SessionField="AcctId" />
<asp:SessionParameter Name="Id" SessionField="Id" />
[code]...
End Sub
asp:GridView ID="Departments" runat="server" AutoGenerateColumns="False" DataKeyNames="EntityID" DataSourceID="AccessDataSource1"
BorderColor="White" BorderWidth="0px" Height="79px" Width="232px">
<Columns>
<asp:BoundField DataField="EntityName" HeaderText="Department"
SortExpression="EntityName" />
<asp:TemplateField>
<ItemTemplate>
--->>> <asp:Button ID="btnJoin" runat="server" CommandArgument="<%# CType(Container,GridViewRow).RowIndex %>"
CommandName="Join" Text="Join" BackColor="#F2F0FF" Font-Bold="True" />
</ItemTemplate>
</asp:TemplateField>
I have several Gridviews that display data from the same table. They are separate for visual effect (Different characteristics). If I select on an item from any grid they can all execute the same code (Show Details).I'm using a row command GridViewCommandEventArgs.Is it possible/How can you get the gridview name from the row command so that I can use just one subroutine.
Sub GV_RowCommand(ByVal sender
As
Object, ByVal e
As GridViewCommandEventArgs)
If e.CommandName = "select" Then
Dim index As Integer = Convert.ToInt32(e.CommandArgument)
Dim row As GridViewRow = ????.Rows(index)
[Code]....
When "btnEdit" is clicked, "RowCommand" event is raised where I want to the catch row index of the row which was set to Edit mode.The Reason for doing this is ......I am using paging with page size = 4. When I click the fourth row (suppose), page is postedback and then the user has to scrolldown to get to the edit row
I have one button and gridview.
The button is located at the outside of gridview.
By clicking the button, I want to trigger the RowCommand event in that grid.
Obviously, I know that I can create same function to run it in that button to achieve samething in the RowCommand event.
However, I would like to know that techinically, I can simply trigger the RowCommand event from outside of GridView.
In my database table I have ID,FirstName,LastName,Address fields.I have bound the FirstName,LastName in Gridview with Eval Method.But have not bound the address coz I m not dispalying address.Now there are textboxes below the gridview which gets filled when I click the edit button in gridview with values in the gridvoew row.I am getting the FirstName and LastName (using find control in rowcommand) but not the address.How can I get the address
View 3 Repliesi am using gridview for data manipulation. in gridview i have added a Edit and a delete button as a template field like
<asp:TemplateField HeaderText="Edit">
I'm trying to fire the RowCommand event on a DataGrid control. I've previously done that, but not in this precise case.
Actually I'm working on someone else code so I can't really change the structure of his page excepted if it's really necessary.
The code of the page is heavy, so I've summarized the problem in a small project and the page behaves the same way too.
Basically I have a GridView which I bind to a DataSet. According to those data, I sometimes need to add, at the end of a row, a "Details" button (a LinkButton).
By pushing this button, I want to show a second GridView containing those details.
Let's add to this that the columns number of the first GridView is variable, those LinkButton need to be added dynamically.
The first GridView is generated without any problem and when my mouse is over one of the LinkButton, I can see that the link is something like "javascript:__doPostBack('dataGridView$ctl02$lnkDetail','')". When I click on this link and debug step by step : Page_Init, Page_Load, OnPrerender, RowDataBound but no RowCommand, and I don't know why!
In the exemple, I've explicitly set the EnableViewState to true from what I've read here and there, but nothing's changed.
[code]...
And the code of my .aspx :
[Code]....
I have gridview+sqldatasource. In gridview i have button DELETE. But i want on click this button for some rows execute DELETE command other rows UPDATE. I did:
[Code]....
@index - DeleteParametrs in sqldatasource.
But DELETE works and DELETEVIRTUAL doesn't. Then i insert sourceMain.Delete() in rowcommand after sourceMain.DeleteCommand ... But it's doesn't help me.
It has to do with the RowCommand 'Cancel'. When clicking on my Edit button for a row, the GridView puts the row into edit mode without a problem (I have no code for the Edit command, I let the control do everything).
Once in Edit mode, if I click the Cancel button (again, I have no code handline this RowCommand, I let the control handle it (like i do with many other GridViews)) I get the following exception:
"System.InvalidOperationException: Databinding methods such as Eval(), XPath(), and Bind() can only be used in the context of a databound control."
I'm having a hard time figuring this one out, i got a gridview with a sqldatasource that is loading its content, to custom columns a ButtonField and a Boundfield, both are loading in page load event,When i click the ButtonField its trigerring the rowcommand event but i can't figure out how to read the value of the cells wich i need to get for the next step of the program.Here what i got so far :- The aspx
[Code]....
- the aspx.vb
[Code]....
I'm getting the correct index and command name but i cant get the button value or bound field value either.
