|
I don't know Oracle FlashBack , but according to this article , Oracle support entity Framework : http://www.oracle.com/technetwork/issue-archive/2011/11-sep/o51odt-453447.html[^]
But anyway , what is different oracle from sql server according to my problem ?
I need to do this recovery process in Entity Framework level , ( so not directly to SQL server or Oracle ) because I must test first if the record being recovered can or cannot recover according to program tests and actual conditions.
|
|
|
|
|
Oracle supporting Entity Framework does not mean that Entity Framework supports Oracle Flashback.
|
|
|
|
|
I have two hash table
1) LogoCount
key Value
item1-> 123
item2-> 10
item3-> 45
2)LogoGroupCount
key Value
item1-> item2,item3,item1
item5-> item5,item1
item2-> item2
I want to join this two hashtabel using linq in vb.net and answer will be
1)Result:
key value
item1-> item1
item5-> item1
item2-> item2
because item1 has max count if that not exist in hashtable 1 than it will get default 0
so how can i do ?
|
|
|
|
|
Please don't cross-post the same question across this site - choose whether you want to keep this question here or use How Do I Join 2 Hash Table In Linq With Vb.Net ?[^] and then delete the other.
Either way - I've asked what you have tried - it might help to clarify what you are trying to do.
|
|
|
|
|
For Each logo In htLogoGroupCount
Dim Count(logo.Value.Count - 1) As Integer
For i As Integer = 0 To logo.Value.Count - 1
Dim sOptLogo() As String = logo.Value(i).Split(":")
Count(i) = sOptLogo(1)
Next
Dim MaxCount As Integer = Array.IndexOf(Count, Count.Max())
Dim sLogoValue As String = logo.Value(MaxCount).ToString
Dim sOptLogoName() As String = sLogoValue.Split(":")
alstOptimize.Add(sOptLogoName(0))
Next
I will assign value to count by adding ":" symbol in htLogoGroupCount in value from htLogoCount and then try above code but i will do it by Linq.
|
|
|
|
|
I don't want to copy entire row how do I do this ..
This is a copy of the macro I want to amend
Private Sub Workbook_Open()
Dim i, Lastrow
Lastrow = Sheets("Master").Range("A" & Rows.Count).End(xlUp).Row
Sheets("Personel").Range("A2:N10000").ClearContents
For i = 2 To Lastrow
If Sheets("Master").Cells(i, "B").Value = "Personel Abby" Then
Sheets("Master").Cells(i, "B").EntireRow.Copy Destination:=Sheets("Personel").Range("A" & Rows.Count).End(xlUp).Offset(1)
End If
Next i
|
|
|
|
|
Delete "EntireRow" or use it with the right Selector ...
|
|
|
|
|
I am designing a accounting system application prototype,and need some help on how to build Chart of Accounts using VB 2010
|
|
|
|
|
You should probably try defining what you mean by a chart of accounts and what you expect to be able to do with this wonderful creation.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Chart of Accounts is a list of hierarchical accounting system which is designed as per the generally accepted accounting principles
|
|
|
|
|
You need a database (or other storage system) to persist you data.
Account Table
Link table to form your hierarchical structure
You then need a user interface so the user can perform CRUD operations on the tables. Simples!!!
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Uhhhh no. We know what an account of charts is supposed to BE. The questions you need to answer to yourself is describing in detail exactly what data you need, how you're going to get it, and how your going to present that data to the user. Without that description you have no target to code for.
You haven't done that.
|
|
|
|
|
Hello !
I have working before on a vb.net application with MS Access Database. On my application I had a Function "Compact_And_repair" that is called every time the application is closed. This function will compact and repair the Ms Access database file.( After this function is called , the database size is decreased)
Now I'm creating an application that use a Sql server database. I'm asking if I can do similar action to a SQl server database .
If yes , which are the instruction to do this from inside my vb.net application ?
Thank you !
|
|
|
|
|
Since you post multiple questions, you are well aware of the general rules of asking questions and what many of the repsonses will be.
So, this should have been done already, but it is hasn't.
1. Search for a solution yourself
2. If you find a solution and have a SPECIFIC issue implementing it, ask for help.
3. Do not ask someone to give you the entire solution.
|
|
|
|
|
There is no such concept in SQL Server. It applies ONLY to Access databases.
|
|
|
|
|
"Don't" for server-databases; size is less of an issue than speed. It is also of no concern to the application using the database, it is a concern for the database-admin, the owner of the server.
Bastard Programmer from Hell 
If you can't read my code, try converting it here[^]
|
|
|
|
|
I have noticed , that my database size continue to increase , and even when I delete records the size is not decreased.
Is this a problem ? And if yes , what I can do from inside of my application ?
|
|
|
|
|
satc wrote: that my database size continue to increase , and even when I delete records the size is not decreased.
The size of the file is not affected, since it is not removing the record; it is merely marking it as free space. That is by design 
satc wrote: Is this a problem ?
Most database-servers will not release the space.
satc wrote: And if yes , what I can do from inside of my application ?
You could shrink the file if the space is that important, but that may piss of the DBA if it is done at an inconvenient time.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
Hi,
I am designing a Form using VB 2010, I am unable to completely design the form as they is not space to place more controls on the form.
Using the form properties, I can set the Maximum Width of Form to 1044, and Maximum Height is 788 only
I have gone through some solutions, which seems to be not clear to my question.
Kindly lemme know, if we can increase the height of the form to 1000 during design time
thanks & regards
Prem
|
|
|
|
|
..and how would that work during runtime? If the form is full, it might be better to introduce tabpages.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
Can you please send the procedure step by step using tab pages
|
|
|
|
|
Take a TabControl and put it on your Form.
Size it like you need.
Define the TabPages as you need (and perhaps give them a Name).
Put your Controls on the TabPages like on your Form before.
You could switch between the TabPages by clicking them ...
Try it ...
|
|
|
|
|
Thanks Ralf, for the time being i will use tabcontrol which allows me to fit all my controls in a form. But if i can increase the height of my form that will be great.
I donno, why this property has only 788 as the height, when we have a scrolling option.
regards,
Prem
|
|
|
|
|
Please read your Thread completly.
Here are the postings of Eddy and Dave which answers the question and delivers a (work-around) solution
|
|
|
|
|
Any WinForm tutorial using the TabControl would do. Alternatively, you could scroll the contents as explained here[^].
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
