I have a row in datagrid with a ID field and some other fields
When i'm updating i want to also insert a record to a different table with the old values of the row
How can i read the row values in the RowUpdated event?
i have contineous data stream and saving in database. database size is growing. as per out data retention policy we have to archieve data and only keep last 6 month data on server.
if archieve data is required in future in current/live database so how do i bring it back.
I was working on an asp.net 3.5 website and used ajaxtoolkit in it and when I use it in my page it was registered as below
<%@ Register assembly="AjaxControlToolkit" namespace="AjaxControlToolkit" tagprefix="cc1" %>
and it was working well even After I upgraded my wevbsite to .net version 4 but when I started a new website from scratch in vs2010 using .net4 when I use ajax toolkit in this new site it is registered as folowing
<%@ Register assembly="AjaxControlToolkit" namespace="AjaxControlToolkit" tagprefix="asp" %>
and when I run the page I get the error The Controls collection cannot be modified because the control contains code blocks (i.e. <% ... %>) I don't Know what is the reason for this. I noticed another thing. in my old website I was using thckbox script by using the files common.js, jquery-1.3.2.js,jquery.thickbox.js and puting them in a Javascript folder ad then registering them in Script manager as following
<asp:ScriptManager ID="ScriptManager1" runat="server">
<Scripts>
<asp:ScriptReference Path="~/Javascript/jquery-1.3.2.js" />
<asp:ScriptReference Path="~/Javascript/jquery.thickbox.js" />
<asp:ScriptReference Path="~/Javascript/common.js" />
</Scripts>
</asp:ScriptManager>
this was working well also but in my new site the jquery file version was jquery-1.4.1.js but also I added the old version f the javascripts files in the built in Scripts folder that is created by default b the new site and followed the same way in registering them in the script managerchange the JavaScript folder to the built in folder Scripts
<asp:ScriptManager ID="ScriptManager1" runat="server">
<Scripts>
<asp:ScriptReference Path="~/Scripts/jquery-1.3.2.js" />
<asp:ScriptReference Path="~/Scripts/jquery.thickbox.js" />
<asp:ScriptReference Path="~/Scripts/common.js" />
</Scripts>
</asp:ScriptManager>
but this doesn't work also in the new site I think that there is something diffirent in the 2 case which leads to this change in performance I wish your support and advice about how to solve this matter
I have 5 user controls in a web form. Data is being loaded into the user controls at the user control page load event. I have a single save button for the entire web form(the the top of the page). Each user control has update panel and consists of many web controls like textbox, dropdown,gridview and many other.
after the page has been rendered successfully to the user.
Considered that he has changed text in one user control ( in few textboxes,dropdowns , grid) and clicked on save button.
Now I should save only the changes user has made ( in 1 user control) instead of saving all the 5 user controls.
how can i achieve this?
i am populating a grid view from one table, if any changes made in the particular table the particular modified cell should be highlighted... how can i do this.. ?
View 3 RepliesI'm using a Gridview in VS2008 framework 2.0 to edit a field with standard edit/save/cancel buttons on each row. I have a textbox named TextBox1 in an EditItemTemplate tag, it's value is binded to my field with '<%#Bind("LOGIN_NM")%>'. This is a simple form a took from an old project. My problem is when I try to read the textbox in the GridView1_RowUpdating event, it keeps returning the original value and not the modified value. I spent some time figuring the cells, controls and all so I'm sure I'm reading the right textbox, I have only one. I also tried using:
CType(row.FindControl("TextBox1"), TextBox).Text but I can't get the modified text to store in the database. The exact same thing works in the old project.
I've been looking all afternoon, but the best I've been able to do when the user selects a row is to get at the item with each field in Text format.I would like, ideally, to be able to get at the row in its original MyDataType that I bound. I'm using an ObjectDataSource, and the grid (a RadGrid in this case, but its much the same deal as gridview) know the type not only of the rows by also of each and every column.I'm stymied that I'm stuck in the days of error-prone referencing columns by their name. Instead of:
grid.Items[grid.selectedIndexes[0]].item["myColumnName"]
I'd much rather be doing something like
grid.Items[grid.selectedIndexes[0]].item.myColumn
But for the life of me I can't figure out if its even possible. The grid is retaining viewstate, so it still has all of the data.
[code]....
Above is my select query result. "Select Groupname from table". Now i want to add dynamit row in table which display like follows.
[code]....
so that i can display the combobox with default value '-Select-'. I tried combobox.item.insert(0.'"Select") but it gives error.
"Items collection cannot be modified when the DataSource property is set."
so I am trying to add dynamically into table.
I got 2 listboxes in a window form, one on left and one on right. The 1st listbox have some items while the 2nd listbox is empty. Also there are 2 buttons between the 2 listboxes which used to move item from/to the 1st and 2nd listbox.My problem here is that after I bind the data to the 1st listbox (from a dataTable, using DisplayMember and ValueMember) , and I try to move 1 of the item from this 1st listbox to the 2nd listbox and I want that the selected item is also removed from the 1st listbox by:
lbMembers2.Items. Add(lbMembers1. Text);
lbMembers1.Items. Remove(lbMembers 1.Text);
But the selected item is not removed from the 1st listbox.Also on deselect button when i move item from 2nd listbox to 1st listbox,it displays error message "Items collection cannot be modified when the DataSource property is set."
The following utility works great on my machine but not on a partner's machine. The container and strChild values come through but the second line throws an error.
[Code]....
I have a gridview that I have bound to a sqldatasource. However I have the gridview changing data shown per a drop down list and textbox so I can choose how I am searching.
My code includes changing the select command of the data source and rebinding the gridview.
My issue is that if I implement the edit button and click edit the grid view seems to resort back to the original select command that was entered when I created the datasource.
Is there any way to get the gridview to do what I want it to?
I have EntityDataSource for DetailsView which is in Edit mode by default (showin Update, Cancel link buttons).
This datasource also has foreign key called PecID. If I change the value in textbox bound to PecID, it works fine.
Entering IDs is not very user friendly, so I add dropdownlist and new datasource.
When I select new value from dropDownList and press update the DropDownList's selection is restored to original (previous) value.
Other values in textboxes are saved as expected.
After few hours of trying to figure out what is going on, I got lucky. I figure out that it is important the order of TextBox and DropDownList in field template.
This is the working order (textbox before DropDownList)
[Code]....
This one doesn't work [Code]....
The code Export data from GridView to Excel is working fine but in our office network all machines have MS Office2007 so when user click to export data and save the file it is always saving in the old format and when user wants to open that excel file then a popup asks the compatibility of version to open yes or no. So to open the file user everytime click Yes.
I just want to export data from GridView to Excel in MS Office 2007 version, so that when user click to open then it directly open the file without asking any question.
Following is the code which I used in my projects's web pages:
Therefore I cannot try any other code. I just want minor ammendment's in this code to accomplish this task.
[Code]....
I have changed the look and feel of the grid by modifying the cols, rows in the gridview. I need to save this in the gridview viewsate, so that it load the modified look and feel next time it loads from the viewsate.
View 3 RepliesEdit and Delete functionality works flawlessly in Gridview if all data is pulled ONLY FROM ONE TABLE. But pulling data from one table give you ID's instead of actual values that are stored in other tables.
After creating a usable Select statement that would pull all the correct values, my Edit and Delete functionality no longer work.
Here is code.
[Code]....
I'm fairly new to web service development, and I am really confused about how ASP.Net Development Server synchronizes with code during debug mode. When I make changes to my service, I cannot figure out how to propigate those changes so that my client can "see" them (I've been able to synchronize through a stumbling series of publishing the service, viewing the service in browser, etc... but I have a feeling there's a more reliable system than my random ritual). Here are the symptoms I'm seeing: After I've made a change to the code behind my service (Service1.svc.cs), started the application through the debugger and attached the debugger to the WebDev.WebServer.exe process as well, my latest changes are not executed, and my breakpoints are not hit (they have the message that "The source code is different from the original version." What really baffles me, though, is that when the ASP.Net Development Server notification pops up in my system tray, its physical path points to my project folder, so I don't understand how it could be looking at anything but my current code files.
View 1 RepliesI can see the issue here but can't get my head around a dv and dv.Table unless I'm looking too deep into this.Essentially, I can't get AsEnumerable.Sum() on dv but on dv.Table but I need it on the filtered view (ie. dv).This is the framework the entire application is built on so I can't pass these parameters to the stored procedure! Well I could but cannot be bothered re-writing and testing eveyrthing!
[Code]....
Updates to the edited item are not passing the new / updated values but rather the original values. And I can't for the life of me figure out why when I change the original value in an edit textbox and post the update the new value is not being passed. I get the original value. Perhaps fresh eyes can spot the problem. This should be super basic but apparently I'm missing something.
Here's the code for the Item and Edit templates. The code behind is below this.
[Code]....
Code behind begins here....
[Code]....
When I Drag and Drop the gridview row record then update preference will be enable the Button(update preference). Otherwise it will be disable..
Please refer this link: [URL] ....
In my application I've allowed users to upload Excel 2003 .xls files, and import them into a Gridview. This has been working fine using the following connection string:
[Code]....
Now my users are using Excel 2003, 2007 or 2010, I need to allow the newer file extensions (.XLSX) to be accessible too.
Therefore, within the connection string above I presume I could change the Excel version from 8.0 to 9.0 or 10.0 respectively, but is there much difference between Excel 2007 and Excel 2010 files?
If so, is it possible to 'detect' the Excel file version so that I can use the appropriate connection string to read the data from the files?
I am modified CreateUserWizard Template to accept additional user information such as address, city, state and zip. I wanna store this additional data into a table i create call UserInformation. The table has UserId as it's primary key and it's also a foregin key to apsnet_Users. The tables also has an Address, city, state and zip column/field. I have an event that is called after a new User is Created and it is at this point where i wanna write the Address, City, State and Zip to the the database. What is the best way to write the data to the database..
[Code]....
I have an ASP.Net ListBox that I'm trying to populate via jQuery, using the following snippet:
$("#MyList_btnAddAll").click(function(e) {
e.preventDefault();
$('#MyList_lstAll option').appendTo('#MyList_lstSelected');
});
The code has two ListBoxes in fact, one a "source" and the other a "destination". As you can tell above the ListBoxes are MyList_lstAll and MyList_lstSelected. These are rendered in the browser as <select> elements, as you'd expect.
The jQuery is working great, the items are moving from one ListBox to the other, the DOM is updated but when I submit this form (not using jQuery), the ListBoxes don't reflect this change on postback.
I realize my modifications via jQuery aren't available in ViewState but I thought since the DOM was updated these changes would be part of the postback data? But in the codebehind after postback the ListBox contents haven't changed. Does anyone know what might be going on and what I can do about it?
Two websites that are being developed by me is online in my office network. Our IT department has updated Internet Explorer and the view my websites is completely disturbed. Now we have Internet Explorer 8.0.6001.18702 In most of my pages the setting is that from top to bottom, in top there is a panel holding dropdown, textboxes and just under this panel there is another panel with gridview. When the pages load the first panel with the search controls are ok.
When i supplied search parameters then gridview resulted overlaping the above panel and it scrolls behind the above panel. When there is one record populates to gridview the whole gridview would not be seen but the count label shows one record.
I've databound some data to a datagrid and I'm wanting to be able to get the original data back.
I've databound the data as follows in one section of my code.
IEnumerable<MyClass> myClasses = GetMyClassesFromDatabase();
DataGridForMyClass.DataSource = myClasses;
DataGridForMyClass.DataBind();
When I've clicked a button, I want to be able to do stuff with the items in the datagrid.
How do I, given the DataGridForMyClass, retrieve the original list of MyClass?
i have a grid as
<asp:GridView ID="dgv_passengerdetails" runat="server" AutoGenerateColumns="False"
CssClass="pasdetailsgrid" BorderStyle="None">
<Columns>
<asp:BoundField HeaderText="Seat No" DataField="seatno">
<ItemStyle HorizontalAlign="Center" />
</asp:BoundField>
[code]...
the string gs=null, if i click the button again then gs takes the value from textbox.