Forms Data Controls :: Trying To Add The Checked Rows Into The Database By Looping Through
May 9, 2010
I am trying to add the checked rows into the database by looping through but im getting this error:
Object reference not set to an instance of an object.
Description:
An unhandled exception occurred during the execution of the current web request. review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.
I have a Gridview that has Paging enabled, and I need to loop through all the rows of the data. Therefore, I assume I need to loop through the datasource instead of through the Gridview.
I change the datasource of my gridview at various times when running.
How can I get a DataView of the GridView's current DataSource, so that I can loop through it?
Something like:
Dim dv as DataView = DirectCast(GridView1.DataSource, DataView)
except that this comes back as Nothing, probably because a Datasource isn't a dataview.
I am having a problem with this code, i had a post on this however this code is slightly different to that so i thought i would post a spearate thread.
Anyway, what i am trying to do is display job vacancies by the result of a DropDownList value. Now each job name has a description. The problem i am having is i need to display the results in this logic:
Job nameJob descriptionJob location. But what is happening is the job description (body) is repeating the more vacancies there are. This is the page:
If you select Deputy Nursery Manager from the DropDown and hit the Search button you will see the results. After listing the first two locations the description is repeated and then the 3rd location is shown after this. This is my code:
i need to design an application in asp.net using gridview custom control. the gridview will show hundreds of records using paging with checkboxes in every row.
if the user checks 3 rows in first page of gridview which is showing 9 rows, those 3 rows should appear on top in the next gridview page and the page should display only 6 new records. ie 6+3=9
similarly if user checks 2 more rows, the next page should show 3+2 rows(from first 2 pages) on top and only 4 new rows ( 3+2+4=9)
I am new here,I have a grid with some checked & unchecked check boxes,& on click button of asp.net i want to add the checked rows to database,so which method will be best ?
i need to show 3 gridviews in a tab container (ajax).. which should refresh at same time.. what is the optimal way to get data from database for that can some one show a solution for this .
i need to design an application in asp.net using gridview custom control. the gridview will show hundreds of records using paging with checkboxes in every row. if the user checks 3 rows in first page of gridview which is showing 9 rows, those 3 rows should appear on top in the next gridview page and the page should display only 6 new records. ie 6+3=9 similarly if user checks 2 more rows, the next page should show 3+2 rows(from first 2 pages) on top and only 4 new rows ( 3+2+4=9)software developer
I am using 2 Form First Page is used to Get data from user a dropdownlist and a GridView with CheckBox. Second Page is used to Display the Data entered in the dropdownlist and gridview. values are displayed in a gridview. Each value has a Edit and Deleted command. if edit Button is Selected.. i must redirect to page 1 along with the details which i Selected must bedisplayed in the dropdownlist and the CheckBox selected Value should be checked.
in my project i have a gridview gv with 5 rows with check boxes(templatefield).. and 1 label.. my problem is when i check 1st row the row value display in label, if i select 1st row & 2nd row checked the two values display in same label with comma seperation, if i uncheck 2nd row, the row value remove from label and only 1st row will be display..if i select all rows all values are display in label with comma seperation.
I want to transfer gridview record to another gridview. Actually I have placed a checkbox column in 1st gridview. Now what I want that when i select the checkbox of any row the related row transfer to 2nd gridview and when I deselect it that row it returns to its previous position in 1st gridview. All these things I want to do using Javascript.
I have a grid view with two columns A and B. Column A has Checkboxes and Column B has numeric values(int). When user checked checkboxes the checked checkboxes column B have to added and displayed in a Label.
I am having gridview and i have check box for each row. There are 2 buttons ,accept and reject outside the gridview. If I click accept button, all the checked rows fields value should change to accept and if i click reject button all the checked rows column value should change to reject. There are 3 columns only one column will change.
Now I am passing selectedUserTypeIDs along with other details to my Stored Procedure and adding those UserTypes for newly Added menu. It works fine for me. Now I want to show checked CheckBox in Edit Mode.
i have code to update multiple rows in a gridview. What I want is that if the row value is = 1 in the database then the row is checked otherwise it's not. I've put some pseudo code in below to illustrate what I want to achieve.
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 have as script that runs a stored procedure to fetch a comment along with it's id. There are multiple comments and I want to display them but I am having problem with display all the records. Here is my code:
Using con Using sda As New SqlDataAdapter() Try cmd.Connection = con Catch ex As Exception Response.Write("Error" & ex.Message)
[code]...
How do I make it so that the returned results will be like this:
I am transferring selected rows from 1st gridview to 2nd gridview and removing rows from second gridview when I deselect row from 1st gridview using Javascript and it is working fine. But when I am deselecting the same row 2nd time it is not removing from 2nd gridview. html and javascript
<head runat="server"> <title></title> <script type="text/javascript" language="javascript"> function AddRow(lnk) { var rw = lnk.parentNode.parentNode;
I'm developing an ASP webshop website (in VB). I've attached an sql database and put a gridview on the form which pulls up the product details from the database. I can turn on Edit and Delete in the gridview so it is easy to modify the products but how can I add new rows?
Using a class component, an Object data source and a formview I am successfully pulliing data from a SQL database. In some cases the rows contain one or more Null values and I would like them to be ignored completely. My simple code follows:-
I've a gridview with 6 coloums. First col is dropdown list and rest are text boxes.aspx page looks like this
[Code]....
I've a created a class and bounded to grid view in my Business LayerThe dropdown list was bounded to another table by using gvExpense_RowDataBound eventNo.of rows in gridview depends on no. of rows in expensetype table
check the VB behind code for any syntax errors.Unable to add new rows of data to a database using the DataGrid control.Compilation Error message is located at http://cforedu.com:View snap shot images of each line error at http://cforedu.com/snap.pdfThe VB code behind reads (revision 1.3):
