I have two textboxes on my webform txtOQty,txtShipQty and Status dropdown list having 3 options.Active,hold,Completed.When txtoqty=txtShipQty then status should changed to Completed.Can any one help me on this,thanks.
View 4 Repliesi have one gridview in which their is on linkbutton and one textbox
i want to enable or disable textbx on click event of linkbutton for particular row
.aspx code
[Code]....
.cs code
[Code]....
i am able to find textbox in gridview in RowDataBound event but how to perform action on click event on textbox for individual row
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 RepliesI was told to use a Repeater control in what I am doing which is a "Data Entry" screen with ASP.NET controls -a standard "address" like form. In cases, the fields on the form will repeated twice, once for the original values, one for the changed values. I have not used this control before but it seems like I have to bind to a database. Instead, I have an Entity object that has been obtained via a Repository. Can I bind to an object like this?
[DataContract()]
public class RON
{
[code]...
I have a db table MemberOccasion with two columns: memberID and occasionID where I keep members votes for occasions. A member can vote for several occasions. Every time a vote is inserted I need to check how many members have voted (and compare against the number of registered member in another table, but I do the comparison outside of this query). My question is this: Is it possible to do adjust the query below to accomplish this?
This is how I count all memberID in MemberOccasion:
[Code]....
with the result that the data in the table below would be counted as 8. Instead I need to count each memberID once. The result I want is that five members have voted.
memberID occasionID
1 28
1 30
2 30
3 29
4 30
5 28
5 29
5 30
I am developing a website with ASP.NET pages that uses an SQL Server database with LINQ to SQL. I am using Visual Studio's Web Developer along with SQL Server 2008 (Developer Edition) database tables on my personal PC to develop this software. When ready, I intend to transfer the compiled web pages to a web hosting service with an SQL server database that is identical to the database on my PC.
I now have a version of my website deployed on a web hosting service at: [URL] and all of my database tables duplicated at the remote SQL server. However, this version of my website does not work with the database yet. I realize that I can have the VS Server Explorer connect to both databases, but I do not know if the web pages on my PC can use both databases interactively.
I am asking how I can develop my website to use the local SQL Server database and then have the deployed pages use the remote SQL Server database with LINQ to SQL. Do I need to create one version that works with the local database and another deployable version that works with the remote database? What should I do?
I am using seperate buttons to control whether edit and delete row linkbuttons are enabled or not on the GV. When I click a buton to enable the edit linkbuttons on the GV and then click a linkbutton for a row that puts it in edit mode. Then if the Delete button is clicked I have code that disables the edit linkbutton and enables the Delete linkbuttons. But, if there is a row in edit mode and the delete button is clicked, the edit linkbuttons disappear and the delete buttons appear (as expected) but the row that was in edit mode does not have a delete linkbutton in it and the row is still in edit mode with no update/cancel buttons. When the delete button is clicked, if there is a row in edit mode, I need to cancel any edit modes in any row.
View 3 Repliesi am developed one simple single payment gateway in this customer can fill all the basic information and the amount afterwards i am redirected to moneybookers.com. everything is working fine but i dont no how to retrieve the moneybooker posted values in my status url
View 11 RepliesI have database status field Bit(0/1) this values binding to gridview column. i want to show record status instead of 0 and 1 display open or close
View 5 RepliesI have a project that uses the same form on 5 different dynamic pages. The form will be in an updatepanel (I have no problems with that). My question is how can I populate the form with data and process the data on a centralized class? This form has about 80 controls on it.
I work in VB.
I've given up on trying to programatically generating/injecting the updatepanel/table into the contentplaceholder. (I got it to work but I could not read ANY of the fields even using nested FindControls). So now I've backed up to 5 instances of the form in easy to use UpdatePanels. But I cannot justify writing 5 identical form processor code blocks in 5 different classes.
I have a gridview and a button-Start in aspx page.
In gridview 3 columns checkbox , Name and Status.
Select multiple columns and click on Start then Status column for selected rows should be changed to "Starting...", later it should be changed to "Started".
But it is showing directly "Started". In the mean time i should see "Starting..." also.
Here is my code
[Code]....
trying to restrict the "Administrator" from deleting the product when the product is still "Available" or "unsold".When a user buys the product the status will become "Sold", and when the product is not sold, the status will be "unsold". i want to do a validation where there will be a prompt when the administrator tries to delete the product that is "Available" or "unsold".
I've tried many ways by using OnItemDeleting to create the prompt, but it didn't seem to work together with OnItemDeleted. The record will remain in the database even when deleted or there the prompt is not working. Please tell me how do i go about doing the OnItemDeleting when the status changes. Or is my method wrong.
This is my code for the DetailsView
[Code]....
This is my code for the OnitemDeleted
[Code]....
I have tried to validate using OnitemDeleting together with OnItemDeleted(using the previous code above) to restrict the quantity before. But it didn't work.
[Code]....
I have a gridview which is populated from SQL. SQL table fields are ProjectName,Description and TaskDate.Gridview should have 3 columns ; ProjectName,Description and Status
I want to compare the TaskDate to the current system date and if TaskDate < System Date I need to have "Delayed " in the Status column and if TaskDate > System Date I need to have "On Schedule" in the status column.Also how should I defined the blank status column in the gridview?(gridview code without Status is as follows)
[Code]....
In this code, I have a multi View below the Loginview. The page works fine when it loads, but when I click on a button that changies which view to display, The page looses the fact that it is logged in and renders the Anonymous Template. The system knows the person is still logged in so when I go to another page like Signin, it displays the loggedin Template.
[Code]....
I have a gridview with column name:
Pending, Waiters, Opened
and in the rows under column there are figures like:
30, 50, 28
65, 0, 214 etc.
My program is working fine, when I am clicking 30, a new page opens and displays 30 rows, when I click 28 another page opens and displays 28 rows and so on.
In datatable there is a column named Stauts, actually Pending, Waiters,Opened are the status.
In dataset in table adapter I used thress queries one for "Pending", second for "Waiters" and third for "Opened".
To display data I created three pages with gridviews.
I used query like:
Select * from ..... Where status ='Pending'
Select * from ..... Where status ='Waiters'
Select * from ..... Where status ='Opened'
What is Required:
I want to make one query with status =@status and want to use header name in query or in vb.net coding and want to make only one page to display record.
To put my question as an idea/example I used three status but in real scenarion I have lot of status. If I have lot of status so I have to make lot of queries and have to create lot of aspx pages to display data in gridview that is not the correct logic.
On a page load, how do I check to see if data in a table has changed? And if any data has changed, populate Gridview1?
View 2 RepliesI have a few textboxes,dropdowns and one checkbox in a DataGrid. when the checkbox is checked/unchecked i need to save the record.How to raise a event when a checkbox is checked/unchecked in a grid.How to Identify the row which is checked.
View 3 RepliesI am creating a WebApp and got stuck on the "Save" process. I am gathering data from a SQL DB and using a DataReader to populate the DataList. The DataList hold employee data and there are quite a few. What is the best way to save the data to the database?
I had originally thought that once a Supervisor has verified the employee data, just click the "Update" button and save to the DB but how would I determine which fields in the DataList have been changed? I only want the changes saved.
use a Dataset to populate the DataList then build a second Dataset with the same structure and compare the two. Then save the changes to the DB. I had read before on the 4GuysFromRolla website that using Datasets in a web app wasn't the greatest ...
I probably should not bother writing these posts at this time of day. I have a gridview control on a web form page. Within the gridview I have
<asp:BoundField DataField="phone" HeaderText="Phone Number" />
<asp:CheckBoxField DataField="displayFrontPage" HeaderText="Display on Front Page?" />
From the documenteationI see, it seems to me that the checkbox I have here should be bound to the data field BIT on SQL Server. The gridview displays a checkbox. Lovely. But when I click the grid's edit, check the checkbox and click the grid's update, the value is not saved/changed.I thought this was straightforward asp control.
does anyone know if the gridview can tell you if a cell's contents have changed (during an edit) in order to determine if an update should be made against the database?
View 5 RepliesIn Gridview, Item Template i want to display Dropdown containing Order Status. On Dropdown selection I want to update Status corresponding to that Order. I just want to know how can I get OrderID value(which I had stored in Label in Item Template), in dropdown onselectedindex event. Grid view can't have Edit button.
View 3 RepliesI am currently trying to implement a small class attendance system, where the student names are taken from a database, stored in a List<Student>, and bound to a Repeater control. Each row of the Repeater contains two columns: The first is the student's name, and the remaining column contains a RadioButtonList with three ListItems (Present, Absent, Sick).Now, once the user presses "Submit", I want to be able to store their attendance status based on the user selection. However, after submission, the SelectedIndex is always 0, no matter what option is selected.
View 8 RepliesI have a dropdownlist as a template item in a gridview - it populates fine and with the right values. I have an SelectedIndexChanged on the dropdownlist, and has set it for postback. In the SelectedIndexChanged event, I would like to know where the control that fired this event is, - which row in the gridview is it in? How do I get this info? If the row was selected it would be easy, but the only thing that has happened in that row is that the dropdown has changed value and consequently the SelectedIndexChanged event has been fired - is that enough to know which row the event has been fired from?
View 1 RepliesI have a Gridview with about 6 templated columns hooked up to SQL, with a Save button below the grid.
When save is clicked, I loop through each row, and write each row back out to SQL.
Can you recommend a good way for me to tell whether the row has changed so I can avoid re-writing the row when nothing has changed?
This is not only for performance, but I also have a request to write out a "Last Modified Date" along with each record. So for that, I would need to know whether the row has changed.
I saw someone mentioned that the Gridview.RowState could be used for this, but I don't see how.
One alternative I see is to re-read each row from the database first, to see if anything changed. Another alternative might be to set a dirty-bit on each Textchanged, SelectedItemChanged, etc, for the row, but I'm not sure where to store that.
I wanted to create a dropdownlist that would trigger an asynchronous postback and update the Gridview inside the Updatepanel. However, no matter what I do, when the dropdownlist changes, nothing in the UpdatePanel will change, even the TestLabel....I've been banging my head against the walls for days on this -- why won't this work? When I remove the UpdatePanel code and triggers, all the code works, eg, you change the dropdownlist andthen gridview updates -- but it refreshes the page and this is why I wanted to put the Gridview inside an Updatepanel to make it look cleaner.[Code]....
View 9 Replies