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]...
What is the correct way (or best) way to implement Comet, HTTP Push, or Reverse AJAX?What .NET implementations would you recommend?
View 1 RepliesI have a class Trans with various properties, including a boolean named Deleted.I have a generic list of Trans that are loaded from the database. I want to use linq to set all the Trans in this list to Deleted. Can I use linq to do this?
[Code]....
Generic List to DataTable
View 1 RepliesSplit off from [URL]
Getting records From DataBase using DataTale which contain 1000 Rows, then binding to GridView using Generic List. Like above Example
GridView1.DataSource= GetData();
GridView1.Binding();
Now i want to do search, sorting & Paging in the GridView with out Postback of the Page & with out hitting the DataBase when do Paging or searching in GridView.
U are caching a list of items, then Add or update or delete method called. Approach 1)
A- Do the data change at the database. If success do B, C
B- Remove the entire list from the Cache.
C- Re-Cache the list on first read.
Approach 2)
A- Do the data change at the database, If success do B
B- Do the same change at the cached items, and save more time.
Approach(2) probably will cause nasty difficult to spot bugs, because the data come from BLL and placed directly into cache, One can't assume no bugs will happen at the sproc, I am not worry about database runtime errors, runtime errors will show up, but I am worry about invalid data, or miss calculation. Can I proceed with approach (2) with caution? Is there a "best practice" principle which suggest not doing approach(2)?
I have a problem i just cant get around...I'm trying to sort the contents of a gridview that gets filled from a List<T>.
(working in DAL, BLL & Presentation layers).
The Gridview's source code:
[code]....
What i cant figure out is how to implement the sort method to the gridview when fetching data from a generic list... I have been Googling my a** of trying to solve this.
I have a generic list of a custom type. The custom type has a string and double.I'm binding the list to a gridview and it outputs everything fine.I'm trying to format the double column into a currency format. It is in a template field as I'm calculating a running total. I pass the value to a function that returns a double and adds the current value to a running total which I will show in the footer.
The format is not changing to currency as expected when using String.Format("{0:c}", GetTotal(Convert.ToDouble(Eval("Amount"))))
I need to "massage" the data a little during OnRowDataBound. When I used DataTable as my data source for my GridView, I could do the following:
[Code]....
How do I grab the row data if I'm getting it from List<Product>?
I have a ListView which is filled by generic list of type MyClass. I can easily bind data from this list into ListView. But I have problems with reading data in opposite direction. This is my class:
[Code]....
I have also generic list of type MyClass:
[Code]....
Finally I bind data to ListView this way:
[Code]....
My ListView template:
[Code]....
How can I read data from ListView into my List list?
The operation of reading ListView data into List generic list should begin after clicking the button "GetData".
I saw the following advice:
[Code]....
but it does not work - the DataItem property of each Item of ListView has null value. The point is that I have generic list with data. I am binding this data into ListView which can be edited by user. After that after click Save or GetData data from ListView is read into generic list of MyClass type.
I get this error when run the page
DataBinding: 'System.Int32' does not contain a property with the name 'item'.
protected void Page_Load(object sender, EventArgs e)
{
List<int> item = new List<int>();
{
item.Add(25);
item.Add(50);
item.Add(520);
item.Add(543);
item.Add(543);
item.Add(55);
};
GridView1.DataSource = item;
GridView1.DataBind();
}
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false" ShowFooter="true">
<Columns>
<asp:TemplateField HeaderText="Sub total">
<ItemTemplate>
<asp:Label ID="subTotalLabel" runat="server" Text='<%#Eval("item")%>' />
</ItemTemplate>
<FooterTemplate>
<asp:Label ID="grandTotalLabel" runat="server" />
</FooterTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
Following is my case in detail.I have a class against which I will configure an objectDatasource(I have a datatable in the class which the data will be initially loaded from the database.)A gridview which has provisions to add/update/delete records will be bound to the objectdatasource
My methods i.e. insert/update/delete will be manipulating the datatable and NOT the database directly(I DONT WANT TO CONNECT TO THE DATABASE IN THESE STEPS. THE REASON IS THAT THE INSERTS/UPDATES/DELETES WILL BE PERSISTED ONLY WHEN THE USER CLICKS A SAVE BUTTON(MAY BE PLACED OUTSIDE THE GRID) . My class to which the objectDatasource points to will have anadditional AcceptChanges method which will be called on clicking the save button. This method is the one which connects to the database and where the adapter.update will be called.The query here is that how do I call the AcceptChanges method of my class instance which is bound to the grid? Also I would like to get some websites where I can see the real world implementations of gridview(with insert/update/delete options) so that I can improve my implementation.
How to bind generic list of DataRow to gridView...
I am using MVC arch , in classDAO m fetching data from table and in bussiness layer ,storing datatable into list<DataRow> and finally in controller , i want to bind in gridview..how can i read each datarow value and bind to gridview..
I am displaying data with in textboxes in gridview here user will change the values my problam is how to get the gridview data and assign it to List?
View 1 Repliesim just testing out signalr and i am having too much fun and got a little bit far from my usual skill now my question is can i pass a list to the client here is my code actually i learned this from you mr aspsinnipets
Public Sub Send(message As String, id As String)
Dim tomessage = OnlineUser.userObj.Where(Function(users) users.userId = id).[Select](Function(users) users.connectionId).SingleOrDefault()
Dim customers As New List(Of locationslist)
customers.Add(New locationslist)
customers((customers.Count - 1)).CITE_NR = message
[code]....
i want to check my collection so i can add a new customer as long as the username does not exist in the collection i do not want 2 customers to be able to have the same username.
i have been trying many different things to try to get this to work but i am not exactly sure what i should be doing I have a aspforum and collection C# class of the list.
here is some things that i have tried
CustomerExists() i also have a collection of List<Customers>
//HERE IS MY EXISTS METHOD
public static Boolean IfCustomerExists(string login) {
List<Customer> theGuy = Collections.Customers;
bool exist = false;
foreach (Customer customer in theGuy)
[Code]....
how would i do my Gridview delete command like a update command?
im using a datasource... and my delete command is like my update command... so i can change the status into "INACTIVE"...
DeleteCommand="UPDATE ACCOUNT_MAINTENANCE SET am_status = 'INACTIVE' WHERE (accmain_no = @accmain_no)"
UpdateCommand="UPDATE [ACCOUNT_MAINTENANCE] SET [account_type] = UPPER(@account_type), [min_deposit] = @min_deposit, [min_capital] = @min_capital WHERE [accmain_no] = @accmain_no"
when i press my delete command at gridview... the status changed into "INACTIVE" but when i refresh or press f5... it automatically update the status into "INACTIVE" also...
How can I show data of a table into a page by using Data controls and add insert, update, and delete buttons?
View 2 RepliesI just drag a listview to my web page. When I config the data source, click the advanced button.I found that the item "Generate INSERT, UPDATE, and DELETE statements blah blah" is grayed out. Therefore I can'tmodify the records at runtime.I am using VWD 2008 Express,
View 1 RepliesUnable to add update and delete functionality to any data control using MS Visual Web developer Express and SQL server 2008. The advanced options in the data connection wizard remain disabled. I can display data OK.
I am however able to connect to an Access 2007 DB through the same page and get this functionality to work.
I have to delete record from the database and I am using the data list control to display the data. I have to delete the data from two table, that means I have to pass an id to a stored procedure which will delete the data from the database.
I am confused how can I do this? As I am not using the generic functionaliteis of the DataList Control and I don't want to use them. I have alos another choice to create a new page and pass the id through query string using hyperlink. But I don't want to do that?
I've got my data in the gridview via:
[Code]....
Now I need to make all the data editable (add, update, delete). Why isn't the Gridview the same as DataGridView? With the DGV, the data showed EXACTLY as it did in the database and one could add a record, edit a record, or delete a record.
I have two databases. When I am using MS Visual Web Developer, I can drag the table onto the webpage and it gives me check boxes to Insert, Update, Delete,...When I do the exact thing using the other database, it only has check boxes forpaging, sorting and selection. What is the difference? I seem to have all teh same permissions in both databases.
View 2 RepliesI have a page that is using the value from a textbox on a previous page to populate a formview. When I generate the Insert, Update and Delete Statements in Web Developer the edit brings up a blank page and the insert and delete don't work. It works if I just create the formview on a page and hardcode the value in the select statement then the Edit/Delete and Insert works.
View 3 RepliesIm a newbie, hoping any experts can lend a hand. I have a gridview table connected to an SQL database. I have auto generated the update and delete methods to allow me to edit the gridview.
However, I would like the editable data in the gridview to be replaced by a selectable drop-down box. The drop down box is referencing an sql table for selection.
