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.
i am using a gridview in my web page,i used to bind the database records to the gridview..my columns are name,empid,company name,pl leave,sl leave,total leave taken here total leave taken is not a database fields,in the page i want to fill the records once loaded pl leave and sl leave is added and display in the total leave taken column..it working properly when all pl ans sl columns fill with numbers,if some pl and sl leave having blank values.it showing an error like input sting was not in correct format..this is my code
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 will have a gridview with checkboxes and some amount fields. I would like to display the sum of the amount in gridview footer depending on the checked items by the user.
I have a gridview that calls a stored procedure that allows the user to search a parts list. In the gridview, I added a textox for Quantity and a button to Add to Quote. The idea here is that the user searches for parts, enters a quantity for a selected part, part is added to quote and user searches again for more parts. Here's my gridview code:
[Code]....
I've also created QuoteParts.aspx as follows:
[Code]....
Questions:
1. How do I display the gridview values including textbox Quantity in my listbox?
2. How do I ensure that parts remain in the listbox after another search is performed? If it's viewstate, can you provide an example of how to go about doing this?
3. The values in the listbox will ultimately be written to the database on an insert record when customer creates a quote. Is there a way to streamline this process so that the insert is started when gridview textbox quanity is entered? I'm thinking about using a wizard control with first step being a display of selected parts, culiminating in an insert statement.
[URL] .... In this I have a select option gridview property enable selection. i want when i click the select butoon the data of this come to the text box ... like if gridview row contain item --unit --cost
item comes to textbox1,unit comes to textbox 2 and cost comes to textbox 3Â
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.
I have a gridview in my aspx form. I have used template column & in that created a table. In the table of the Item template , I am displaying some fields. My requirement is that when I click on any row, the correspoding data should be placed in proper text boxes. Each row in itemtemplate has a unique id called UserId.
how to load Gridview HeaderText values from resource (.resx) files.I want to display headertext values for Gridview based on two different application dynamically.
I have a Gridview,when i select item from 1st grid it should load in the 2nd grid, here i have done for selecting from checkbox,but when i uncheck it is loading properly, Â <%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="Controls_Default" %>
<html xmlns="http://www.w3.org/1999/xhtml"> <head id="Head1" runat="server"> <script type="text/javascript"> // Select/Deselect checkboxes based on header checkbox function SelectheaderCheckboxes(headerchk) { debugger
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....
i want to show selected row of gridview into textbox then we can change these value  then we click update button then these value add into selected row., this row show the update value not previous using jquery . following my code.
<script type="text/javascript" src="~/Scripts/jquery-1.10.2.js"></script> <script type="text/javascript"> $(document).ready(function () { // function Edit() { var par = $(this).parent().parent(); var id = par.children("td:nth-child(1)"); var name = par.children("td:nth-child(2)");
Protected Sub gridview1_OnSelectedIndexChanged(sender As Object, e As EventArgs) Handles gridview1.SelectedIndexChanged Dim row As GridViewRow = gridview1.SelectedRow Textbox1.Text = row.Cells(1).Text Textbox1.Text = TryCast(row.FindControl("lblName"), Label).Text
[code]...
When I click "select" Link Button will fill in textbox1, but I am getting this following error:Conversion from string "Sears Club" to type 'Integer' is not valid.
In a gridview there is 4 columns i.e. application no,name,couse,more.. (linkbutton). When we will click more.. button of any application no, then in a popup window all information of that particular application number will show.
I have a gridview and in which there is a select button .. when I clicked the button .. then the data in gridview with indexes that have been, can move to the details view ..I use rowcommand event for the select button in gridview..
I use viewstate in details view..
How to passing data from gridview to details view?