ID | NAME | PARENTID
1 A 0
2 B 0
3 A.1 1
4 A.2 1
5 A.1.1 3
6 B.1 2
7 B.1.1 6
8 B.1.1.1 7
View Complete Post
I am building an association model , if my nested table records is more than 1 lac, model is failing.
Even same while applying the model also. Server's RAM size is 16GB.
Please can you suggest the maximum number of records that can be handled?
Thanks in Advance
How could I get the total number of records present in a database table through asp.net in VB? I know about setting up and opening a connection. I wanted to loop through records, so wanted to know the number of records present. How could that be done?
Also, I used statements like 'Update' and 'Insert Into' to to change the data in my data source. Like I updated a certain field like this:
ds.Tables("tblUsers").Rows(2)(3) = "xyzzzz"
and then I executed an sql statement on the same field like this:
objCmd.UpdateCommand = new OleDbCommand
objCmd.UpdateCommand.CommandText = "Update tblUsers " & _
"SET City='xyzzzz' WHERE UserID=3"
objCmd.UpdateCommand.Connection = Conn
(where objcmd is an instance of oledbdataadapter object)
What should I do to delete a record or a field in a data source through asp.net?
I get records from the table by using "Select top(5) itemCode,ItemName,Price from Item"
Now I wan't to take next 5 records. How can I create query to that one.
After that I wan't to take the previous 5 records also.
I'am using dnamic entity with EF4. On a list page of a table, I would like to display a column containing information from a child table of the current element. Sample :
Order List :
Order Data | Required Date | Shipped Date | etc... | ... | Customer Name (foreign key with tostring() method override) | Customer Postal Code (Column that I want to add) |
I don't known how to do that. Is it possible ? Maybe I have to to create my own Metadata proxy that will add dynamicly a column on the MetaColumn list of the table.
Does someone have an easier or better idea ?
Thank you for any help.
I have a textbox and a gridview which is bound to a table
what I want to achieve is a solution where lets say there are two records - e.g. "1. Book and 2. Red", i want a user to type in those words and the gridview shows the results as followed;
I have set up the sql data source and everything and my like operator is this...
LIKE '%' + @record + '%'
how can I solve this problem?
In a project, I have two lists that are linked together with a lookup column (it's not the actual scenario, but I simplify it) :
* a parent list, that defines some fields and especially a state field that will follow the life of the object (created, open and archived)
* a children list, that also defines some fields including a lookup field to the parent list and a similar state field for its own lifecycle (created, open and archived)
the life cycle of both kind of objects are linked together. For example, when the parent is opened, all children must be opened too (looks like easy because it's a workflow action from parent, and finding children is simply an activity of the workflow).
Another requirement is to archive the parent when all children are archived.
What is the best approach ?
In the parent life cycle workflow, can I monitor children events (I don't think so :() ?
I can cheat a bit by adding an hidden field "all children archived" in the parent, and set this to true from a child workflow or event. I'm not at ease with this solution as it's not a proper way. Anything else I may dive ?
Any idea, advice, tip, encouragement?
I'm trying to link an InfoPath form to an Access database, I want to connect the InfoPath form to 3 tables in the Access database but InfoPath will only recognise parent-child relationships in a series (e.g. the "Company" table is the parent to
the "Customer" table, which is again parent to the "Orders" table)
I need to have two parent tables and one child table, though (e.g. "Customer" is parent to "Orders", but "Inventory_Item" is also parent to "Orders"). Is there any way to establish this in InfoPath? I'm using Windows XP, InfoPath 2007 and Access 2007.