How do you Update a List(of Product) object with Gridview. i wish to either increase/decrease the item field named Quantity.
GridView3.DataSource = Product
GridView3.DataBind()
I'm having a gridview in my aspx page with checkbox, User can select one or more than one record(s) at a time and clicks on delete button, Then i'm constructing an object of my DTO and adding all the checked row's Primary Key (DataKeyNames - GUID's in my case) to a serializable class and generating an XML and sending it as parameter to the Stored Procedure.
My Doubt is, can i bulk delete all the rows from database table those are present in my XML document??
If it works, I can do bulk update with XML only, i already did bulk insertion by generating an XML..
My Another Question is, Will it affect the performance? Each time when i construct an DTO object and adding it to the Generic List?
Which one is better, I mean ObjectDataSource or SQLDataSource or my XML method?
[code]....
I have a gridview,when i do it is giving me null object reference error.
I am posting my code for your reference -
[Code]....
My gridview code is -
[Code]....
Using C# and sql server. I have a gridview which is populated using a sql query. I have 5 columns in the gridview ( projectid,project name,description,date,status). I'm using the Edit/update option that is available in the gridview to edit/update a user selected row. When I use this Text boxes appear. I want to have a drop down list for status instead of a text box with values Started,Inprocess,Complete, Inhold.
View 3 RepliesI am working in asp.net 3.5 with c# and sqlserver 2005 as database. I my project i have to select some of the checkbox of a gridview and update the database according to that. I want to store all the selected box in a arraylist and update the database according to the selected list . But i am not getting how to proceed.
View 3 Replies[Code]....
I am getting error of in Foreach loop
[Code]....
How to resolve this situation or any other alternative to cum out of this problem.
I have a text box placed inside a gridview(template) . I need to update its value by a dropdown list event (Selected Item Changed event) placed in the same gridVew. But The problem is that , I need to update the text box of the same row the dropdown list (whose textChange Event haas been fired)
[code]....
This is My Method, How to get Checkbox Value from Gridview and adde that value inti list?
private List<ActivityList> PopulateData() {
string ActivityCode = string.Empty;
string ActivityName = string.Empty;
List<ActivityList> list = (List<ActivityList>)Session["ActivityToStudent"];
List<ActivityList> listObj = (List<ActivityList>)Session["ActivityToStudent"];
for (int j = 0; j < listObj.Count; j++)
[Code] ....
I am trying to get the value of the id field in my gridview but I keep coming up with this error when i do selectedValue or selecteIndex
Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.
How do I get that id? What I am trying to do is when the user select that link it will delete that information from the database. Here's my code:
[Code]....
[Code]....
I would like to enable/disable the field BagNo in my gridview, depending on the value of another field in the gridview called ScriptNo, when I click the edit button I get this message "Object reference not set to an instance of an object".
here is the code
Protected Sub GridView1_RowEditing(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewEditEventArgs) Handles GridView1.RowEditing
Dim row As GridViewRow = GridView1.Rows(e.NewEditIndex)
If DirectCast(row.FindControl("ScriptType"), TextBox).Text = "TTA" Then
[Code]....
I am trying to get an idea on the best way to do the following:
[1]I have a list of object type (my_object_type), one of the my_object_type members is called SortOrder, which corresponds to the location within the list.
example of List<my_object_type>
SortOrder=1 | item2="something" | item3="something"
SortOrder=2 | item2="something" | item3="something"
SortOrder=3 | item2="something" | item3="something"
SortOrder=4 | item2="something" | item3="something"
SortOrder=5 | item2="something" | item3="something"
SortOrder=6 | item2="something" | item3="something"
[2]I bind this List<my_object_type> to a GridView, that looks something like the following when displayed:
[1]|[something]|[something]|MOVE TO [DropDownList 1-6]|[Move Button]
[2]|[something]|[something]|MOVE TO [DropDownList 1-6]|[Move Button]
[3]|[something]|[something]|MOVE TO [DropDownList 1-6]|[Move Button]
[4]|[something]|[something]|MOVE TO [DropDownList 1-6]|[Move Button]
[5]|[something]|[something]|MOVE TO [DropDownList 1-6]|[Move Button]
[6]|[something]|[something]|MOVE TO [DropDownList 1-6]|[Move Button]
[3]When I select a drop down list item from column 4 of the GridView and then select the MOVE BUTTON, I would like to be able to move an object to a specific NEW location - basically reorder the List<my_object_type> and then BIND the new List Order back to the GridView.... (example: current list item #3 -> select #5 from drop down list -> press Move Button ||| then BIND changes back to the GridView)
Question: any recommendations about the best way of doing this within the gridview, etc...?
i wanted to retrieve things from the data base and perform mathmatical operations on it then post it to the user, so i was told to use the bullited list and bind it to the object dataSource
how to perform such thing??
I'm using a DetailsView object to present a record from a database in table format. I'm actually using and ObjectSource object as the data source for the details view. In the object I am using as the source for the ObjectSource, I have paired properties that hold decimals. This is, I have a property called Year1 and another property called Year1Change. This for years 1 to six. The values from the Year1 properties are in a cell, whereas the change values are bound to texboxes. The code for the frontend is the following:
[Code]....
Now, as you can see in the tbYr2RtCh textbox, I have an OnTextChanged property to call an event handler. This is because I want to do two things when the text changes. The first one is to make the font in the textbox bold if the value it holds is different from the Year2 property. The second one is to change the text on tbYr2RevCh to adjust the revenue for the percentage increase in the rate. The problem I have is that I cannot access the object that is the source for the data and make those changes directly in the object, instead of having to update the database. I don't want to update the database until the client says so, but the changes should be calculated immediately. I thought about creating an method in the object that I could specify in the ObjectDataSource as the update method, but I'm still not sure how to go about it.
i have a sortedlist who values contain a Product objects. i wish to set the Quantity property of a selected Product object ( from gridview) when the Quantity field changes?
how do i compare whether the product row Quantity field in the gridview is the same as the Product Quantity property in the sortedlist and update accordingly?
note. i have converted to a list(of product) to bind to gridview. then update the sortedlist values
on page load I fill a repeater with checkboxes. I use a separate tablelist (subcatID & userID) to check if chkbox is checked or not.
On pageload and works fine (according boxes are checked):
[Code]....
When submitting the adapt button .. nothing happens and I can't figure out why ..
[Code]....
I want to update multiple rows of gridview (only price field. for that i have added textbox) on click of update button which is outside of gridview.I have done following way
<asp:LinkButton ID="lnkUpdate" CssClass="BlueButton" runat="server" OnClick="lnkUpdate_Click">Update</asp:LinkButton>
[Code]....
Up to this its working fine but when no textbox updated then no need to go in for loop so i am looking for confiramtion before updating rows please help me how to do that becausei am less aware with javascript. another problem is textbox value disappear when page index changed how i can retain that values.
[Code]....
When i try to update a row using the update functionality of Gridview it updates all the rows rather then updating that specific row which is in edit mode.
[Code]....
I want to add a drop down list so that on update a user has to select something from a list rather then free text
ive googled and come across loads of info on this but i cant get anything to work
this is my aspx code so far, its the Description column i want to set as a drop down list
[code]....
i'm beginning with a little question. So i have this scenario
[Code]....
So i have a Linq object named TCategory. When the user wants to edit this object he will have 2 fields id and categoryName and when he press update the UpdateCategory function will receive an already made object of TCategory type storing the data user has typed. The problem is that i also want to let the client to change the id of the object so i need to pass to the function the actual Id and the TCategory object. How can i do this?
[Code]....
I have a repeater which contains dropdown list in it.
The items in the dropdown list are all the same at fist.
But if i select a item in one dropdown, then the selected item will be deleted in the other dropdown list.
For example A, B, C, D,E are the five items in dropdown list, and repeater has three lines.
If A is selected in the dropdown list in the first line of repeater, then the dropdown list in the other lines will only have four items to select, they are B, C, D, E.
If then D is selected in the dropdown list in the third line of repeater, then the dropdown list in the second line will only have B, C, E to choose.
I can do this in csharp code, how can i do it in .aspx page?
I have a following generic list method that contains some data for a gridview. I need to supply edit and delete functionality for it.
List<students> List(string id)
{
List<students> st = new List<students>();
[code]...
I am trying to implement the code URL...I have a database table with Integer type.Here is the running code line: Code in GridView:
<asp:TemplateField HeaderText="RegionNavn">
<ItemTemplate>
<%# Eval("RegionNavn")%>
</ItemTemplate>
<EditItemTemplate>
<asp:Label ID="lblRegionNavn" runat="server" Text='<%# Eval("RegionNavn")%>' Visible = "false"></asp:Label>
[code]...
On Edit Click, the DropDownList in the GridView brings the previously selected value.On Update Click, the error is: "System.FormatException: Input string was not in a correct format."
dCmd.Parameters.Add("@KystverketRegionID", SqlDbType.Int).Value = int.Parse(ddKystverketRegionID.SelectedValue);
When I use the following code:
ddlRegionNavn.DataTextField = "RegionNavn";
ddlRegionNavn.DataValueField = "RegionID"; // from RegionNavn to RegionID
On Edit Click, the DropDownList values in the GridView is not firing and the following error shows.Object reference not set to an instance of an object. How to implement the code when having a value of type Int ?
I have this part in the Gridview.
<asp:TemplateField HeaderText="Student">
<ItemTemplate>
<asp:DropDownList ID="ddl" OnSelectedIndexChanged="ddl_IndexChanged" runat="server">
</asp:DropDownList>
[Code]....
After the change, when it is to bind data, I get this Exception message. Why?Object reference not set to an instance of an object.
When I am executing the below code on Visual Studio 2008, then it is executing properly with out any error. But when i am executing it on Visual Studio 2012, then it showing me following error (System.NullReferenceException: Object reference not set to an instance of an object) at line 64
Why is it so?
.vb Code is below :
Imports System.Data.SqlClient
Imports System.Data
Partial Class grid
Inherits System.Web.UI.Page
Function constr() As String
Dim i As New IO.StreamReader(Server.MapPath("constr.config"))
[Code] ...
HTML code:
<asp:GridView ID="GridView1" runat="server" CellPadding="4" EmptyDataText="no record found" ForeColor="#333333" GridLines="None" AllowPaging="True" HorizontalAlign="Center" Width="303px" AutoGenerateColumns="False">
<AlternatingRowStyle BackColor="White" ForeColor="#284775" />
<EditRowStyle BackColor="#999999" HorizontalAlign="Center" VerticalAlign="Middle" />
<FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
<HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
[Code] ....
