Forms Data Controls :: Maintaining Selected Values In DropDownList While Paging In GridView
Jan 8, 2011
I have a problem with keeping the selected values in DropDownLists in rows in GridView while paging. I have this code behind:
private void RememberOldValues()
{
ArrayList LinijaIDList = new ArrayList();
int index = -1;
foreach (GridViewRow row in GridView1.Rows)
{
index = (int)GridView1.DataKeys[row.RowIndex].Value;
if (Session["equal_ITEMS"] != null)
LinijaIDList = (ArrayList)Session["equal_ITEMS"];
if (row.Cells[0].Text == lineTextBox.Text)
{
if (!LinijaIDList.Contains(index))
LinijaIDList.Add(index);
}
else
LinijaIDList.Remove(index);
}
if (LinijaIDList != null && LinijaIDList.Count > 0)
Session["equal_ITEMS"] = LinijaIDList;
}
protected void Button1_Click(object sender, EventArgs e)
{
//Session["equal_ITEMS"] = null;
RememberOldValues();
GridView1.AllowPaging = false;
BindGrid();
//RePopulateValues();
DataTable dt = new DataTable();
dt.Columns.Add(new DataColumn("LinijaID", typeof(int)));
dt.Columns.Add(new DataColumn("Ime", typeof(string)));
ArrayList LinijaIDList = (ArrayList)Session["equal_ITEMS"];
//if (LinijaIDList!=null)
//{
foreach (int LinijaID in LinijaIDList)
{
foreach (GridViewRow row in GridView1.Rows)
{
DropDownList Ime = GridView1.FooterRow.FindControl("ImeDropDownList") as DropDownList;
int rowID = (int)GridView1.DataKeys[row.RowIndex].Value;
//string Name = row.Cells[1].Text;
string Name = Ime.SelectedValue;
if (rowID == LinijaID)
{
DataRow dr = dt.NewRow();
dr["LinijaID"] = LinijaID;
dr["Ime"] = Name;
dt.Rows.Add(dr);
}
}
}
GridView1.AllowPaging = true;
Session["equal1"] = dt;
Response.Redirect("CheckedRowsPage1.aspx");
}
// else
//{
// GridView1.AllowPaging = true;
// Session["equal1"]=null;
// }
}
When I insert a value in the TextBox2 and want to select only the rows from the GridView from different pages which have value in the first column the same as the value in the TextBox2, after clicking on Button1 I get this error:
Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.
Source Error:
[Code]....
View 3 Replies
Similar Messages:
Aug 12, 2010
I have Grid view control in the page. Enable paging option is true.
Columns in the Grid view are ID, Name, Checked and Email
Whenever user selects the check box then I am showing txtEmail in the Email columns so that I can enter email id in the textbox.
Like this I am selecting checkboxes and entering values in the txtEmail when I go to next page and comes back. Then these entered values are cleared.
How to keep the textboxes values and checkboxes selected during paging?
I have been doing R&D for 1 day. Tried to implement.
View 17 Replies
Jul 17, 2015
How do i change the name column text the current row when the selected index of drop down is changed? ex:first row is mudassar khan and belgium, when i change belgium i want mudassar to be replaced to a name which i fetch from database....
View 1 Replies
Jun 19, 2010
I have a page with several dynamically generated DropDownLists. The DDs load and display the correct values on page load. However, when I try to retrieve the values at post back, the DDs all seem to be maintaining the values they had at page load.
All are created in Page_Load;
No test for IsPostBack;
Processing is handled in code below:
[Code]....
View 4 Replies
Dec 31, 2010
I have a problam in Gridview paging.
I create a gridview with 2 boundfield and check box in tamplet field. and allow paging True.
I maintaing a Chekcbos status while page index change. Its fine But
I have a button outside gridview to store a data in DB.
Now i want that on button clicking all selected Chekbox rows to stored in DB.
Means Gridview loop like
Each page each row if find checkbox selected pick this row store in DB .
View 4 Replies
Mar 10, 2010
i have a gridview with paging[index 10] enabled on my webpage, now i want a simple dropdownlist in footer or below gridview to have list of no 20,30,40.so that when user selects 20 from it the gridview shows 20 records on same page,when 30 is selected the gridview should show 30 records.i cant figure it out that how to do it, whether it requires coding at database(MYSql) or can be done at the page itself.
View 2 Replies
Mar 29, 2010
I got a list of customers That I'm gone show in the gridview. I have added a checkbox infront of every customer so i can select what customers gone be used and passed to the next method. With a little bit of strugle I almost got everything working now except for this thing with keeping the values of checked customers when I page to the next page (2,3,4,5 ect).
View 1 Replies
Apr 2, 2014
I have one gridview with page size 5. I have paging inside. I have radio buttuns on the gridview. If i select row in 1 first page indexwith radio button and back to second page index and when i come to first page index, my radio button selection has been lost.
View 1 Replies
Sep 20, 2015
I have days valus in asp.net page ,
How to get values from aspx page to .cs and how to insert sql server .
(Ex: Â Monday,Sunday,....)
View 1 Replies
Jun 29, 2010
i want to get the selected value from the dropdown from the gridview
how do i do this i have tried a lot but fail :(
View 17 Replies
Jan 19, 2010
I have a Grid on my page.When the page is loaded for the first time ther is a list of records displayed in the grid.When I edit the record by edit link button,the ddl saves the change value .
The same thing if I do when searching for a particular record and then editing and changeing the dropdownlist value,the page postbacks and the new value gets replaced with the old value that was present earlier.
View 15 Replies
Jan 11, 2011
I have the following gridview...
[Code]....
And inside that gridview you can see I have a dropdownlist called dpdTrueFalse. That dropdown has two values which I am loading from code behind like this...
[Code]....
I have a submit button outside that gridview that checks each row and the selected value in the dropdown. But for some reason, even if you select another item in the dropdown, it always selects the first item in the dropdown when I click the submit button. I reckon its because of the postback.
View 5 Replies
Apr 28, 2010
I want to display a GridView using the the selected DataValueField from the DropdownList.
I've set the Selectparameters for the GridView DataSource.
Here is my question: on clicking "BtnSelect" - How do I assign this parameter (@Id) to selected value (DataValueField) from the DropDownList and re-display the grid view accordingly?
Here is what I got so far:
[Code]....
View 5 Replies
Apr 20, 2010
here is my problem:
Admission no: 1212
Feetyep :College fee
Fee term : annual
above values should be appear in Grid view.
how to display the selected values in Grid view.
View 3 Replies
Sep 23, 2010
How Get particular selected cell value from gridview . my grid so many cell available..i'm created dynamic row and cell ...
View 2 Replies
Oct 9, 2012
Using dropdown in gridview and bind the values in dropdown then based on dropdown display the value in another column.
View 1 Replies
May 17, 2010
How to display the selected value of a dropdownlist in header taemplate of a gridview? As i change the dropdownlist's value, it should also change in the gridview. i have taken a label in the gridview's header template named "lbl_mnth" my dropdownlist's id is "ddl_mnth".
View 1 Replies
Apr 27, 2016
I am going to use this article but I don't know how to add the Search which is the dropdownlist and textbox
The data in dropdownlist is ContactName and CompanyName
[URL]
Also I would like to know how to sort the gridview in Header
View 1 Replies
Aug 4, 2010
I got a gridview -CompGrid, having 3 columns - Dept, Employees, Status.
The 'Status' tab need to be edited. So that I put a Dropdownlist as an Itemtemplate and connected the 'DataValueField' as 'Status'.
Now I can edit each row by row only. Some times it needs to update all the employees status in one department.
So that I placed 2 more dropdownlists in outside of gridview.
1. Department List, 2. Status List.
My requirement is this, When I select one department and corresponding status, it should update all the records of that department in the grid.
View 3 Replies
Dec 9, 2010
Girdview has dropdownlist TemplateField called ddlSate, how to bind state field value in sql table to selected value of ddlState dropdownlist control? For example the sql table has AL value for state field, (Note by default ddlState lists all states options with sqldatasource), how AL is selected in ddlState when binding to ddlState?
Secondly, when user selects different state like GA, how below update stored precedure works? that means how to find ddl selected value in update procedure as shown below question mark line:
Here is part code:
<asp:GridView ID="gvOrder" runat="server" DataSourceID="ods1" AutoGenerateColumns="False"
style="margin-top: 11px" CssClass="pnlOrdercss" ScrollBars="Both"
BorderColor="Black" BorderWidth="1px">
<Columns>
[Code]....
View 2 Replies
Feb 2, 2010
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)
View 5 Replies
Nov 4, 2010
while using gridview whenever I go to edit an item it increases the row size - but this is because I have a multiline textbox as one of the edititemtemplates. It also increases the size of every row to the same size as the one that is being edited. Is there any way to keep the rest of the rows the same initial height and have an increased size just for the row being edited?
View 5 Replies
Nov 27, 2010
I have a List box that displays my Vendors, and then I have a Gridview that shows payments made to those vendors. Is there any way of making the gridview always show 12 rows, regardless if 4 payments were made or even 0 payments have been made ?
View 2 Replies
Jan 31, 2010
My database has 4 colums;
TraditionalID-------------TraditionalName------------Singles-----------Suppers
Singles and suppers are money fields for the price of same item. A bit like the price of a Small, Medium or Large item. What I would like to do is display the 'Singles' price and 'Suppers' price in seperate listitems so the user can choose 1 of them.
GridView:
Traditional Name__________Size
Chicken-------------------[DROPDOWNLIST]
DropDownList:
Price of Single is: £1.50
Price of Supper is: £2.50
My page loads up with the correct items in TraditionalName colum but the DropDownList is completely empty. I'm aware I don't have anything in for DataValueField and DataTextField but I have tried putting things in these attributes, like Suppers and Singles, but nothing works, so I have taken them out below.
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="TraditionalID" DataSourceID="SqlDataSource1">
<Columns>
<asp:BoundField DataField="TraditionalID" HeaderText="TraditionalID" InsertVisible="False" ReadOnly="True" SortExpression="TraditionalID" Visible="False" />
<asp:BoundField DataField="TraditionalName" HeaderText="Meal" SortExpression="TraditionalName" />
<asp:templateField HeaderText="Size">
<ItemTemplate>
<asp:DropDownList ID="DropDownList1" runat="server" DataSourceID="SqlDataSource2">
</asp:DropDownList>
<asp:HiddenField ID="RowTraditionalName" runat="server" Visible="false" Value='<%# Eval("TraditionalName") %>' />
<asp:SqlDataSource ID="SqlDataSource2" runat="server"
ConnectionString="<%$ ConnectionStrings:The CodfatherConnectionString %>"
SelectCommand="SELECT Suppers AS Suppers, Singles AS Singles FROM [Traditional] WHERE TraditionalName = @TraditionalName">
<SelectParameters>
ControlParameter Name="TraditionalName" Type="String" ControlID="RowTraditionalName" PropertyName="Value" />
</SelectParameters>
</asp:SqlDataSource>
</ItemTemplate>
</asp:templateField>
</Columns>
</asp:GridView>
View 1 Replies
Mar 25, 2010
i have a gridview which consists of databounds and dropdownlist control. When I press the Add Grid Row Button, it will insert a row. Now my question is, if the user selected an item in dropdownList in the firstrow and the user click the AddGridRowBtn Again which will generate the 2nd row, how would i maintain the selectedItem in the dropdownlist after postback?
Source For Gridview:
[Code]....
Add Row Code
[Code]....
[Code]....
And For Grid Row Created Event
[Code]....
View 5 Replies