|
Use a .CSV file. Its easy to read and write to, it will give you your one table with several columns, you can use excel, or notepad to edit it if necessary and no other program it required to be installed in order to run your program.
|
|
|
|
|
this sounds great, do you know of any resources, tutorials, on how to create a .CSV file and integrate it into my App???
Sorry, I am a newbie
|
|
|
|
|
also is there any way to convert my sql database to a .csv file??
My program is already written for SQL server but i dont need SQL, all i have is one table. I am just going to rewrite the app using this csv file even tho i know nothing about it, is this a mistake?
|
|
|
|
|
I wouldn't trust VistaDB. They ran an ad in the lounge, and when people called them on it, they offered us a free version, which never came. That makes me think they are good at talk, and not good at action. I'd not trust them for any sort of support.
VistaDB is also for apps where Access is not enough. If you don't want to use Access ( and it seems a good fit to me ), then an XML document seems the best alternative, as it's easy to modify in memory and save out again.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
I think i am just going to use this MSDE redistpackage since my app is already setup to run on SQL. I think i will just leave VistaDB alone.
|
|
|
|
|
hi everyone,
m stuck with this prob. the prob is that the windows of my application is vertically divided into two halves. In left half, I have controls like buttons, textboxes etc. The application runs fine at 96 dpi. But once I change the resolution to 121 dpi, the controls enlarge and become inaccessible. Any clues???
smith
|
|
|
|
|
First of all developemnt of windows based application should be done in the resolution same as clients screen. But you can try out working with various combinations of anchor and dock property of control, but it is for placment and not for size. also there must be some api's available to track that but for that you have to step out of the managed environment.
Het Waghela
 Be Humble in Victory and Strong in Defeat.
Het Waghela, Blog|Het Waghela DotNet Questions Link|More Links
|
|
|
|
|
Anchor and dock properties did help...my application is such that it needs to be opened in different resoultions...still there are forms whose controls enlarge so much that some of them become inaccessible...also, no scroll bar comes by itself after that
|
|
|
|
|
I have drawn lines as per in paint. Now i want to erase that as like in Microsoft paint, means on any button. I would want to do like wherever cursor moves, it clear the line which have drawn on picturebox.
For drawing i am using following
Code:
Private Sub picboard_Paint(ByVal sender As Object, ByVal e As System.Windows.Forms.PaintEventArgs) Handles picboard.Paint
Try ' error trapping
If undo = True Then
For i As Integer = 0 To 13
path(i) = New GraphicsPath
path(i).Reset()
Next i
'Dim g As Graphics = picboard.CreateGraphics()
'g.Clear(Color.White)
'e.Graphics.Clear(System.Drawing.Color.White)
'g.Dispose()
ElseIf SetEraser = True Then
myAlpha = 100
picboard.Cursor = New System.Windows.Forms.Cursor("C:\icons\8.ico")
'picboard.Cursor = New System.Windows.Forms.Cursor(Application.StartupPath & "\8.ico")
'Dim CurrentPen = New Pen(Color.FromArgb(myAlpha, System.Drawing.Color.White), 5) 'Set up the pen
'e.Graphics.DrawPath(pen1, mousePath) 'draw the path!
For index As Integer = 0 To 13
'Dim CurrentPen = New Pen(Color.FromArgb(myAlpha, myUserColor(index)), myPenWidth(index)) 'Set up the pen
Dim CurrentPen = New Pen(Color.FromArgb(myAlpha, myUserColor(index)), myPenWidth(index)) 'Set up the pen
'Dim CurrentPen = New Pen(Color.White) 'Set up the pen
e.Graphics.DrawPath(CurrentPen, path(index)) 'draw the path!
'e.Graphics.DrawPath(currentpen, mousePath)
'If (picboard.Image Is Nothing) Then picboard.Image = New Bitmap(picboard.Width, picboard.Height)
'Dim g As Graphics = Graphics.FromImage(picboard.Image)
'g.DrawPath(CurrentPen, path(index))
Next index
Else
picboard.Cursor = New System.Windows.Forms.Cursor("C:\icons\pen.ico")
'myAlpha = 100 ' This will give the color a Alpha effect, you can set this to 255 if you want a full color
'*********************** NOTE ***********************************************
'The line below set the pen up with the ability to add user selected Alpha, Color and Penwidth
' A simpler, but less flexible solution would be to replace the line with the following code:
'Dim CurrentPen = New Pen(System.Drawing.Color.Black, myPenWidth)
'************ End Note ***************************
' Paint all the GraphicsPath one color at a time
'''whitescreen = False
'''blackscreen = False
For index As Integer = 0 To 13
Dim CurrentPen = New Pen(Color.FromArgb(myAlpha, myUserColor(index)), myPenWidth(index)) 'Set up the pen
'Dim CurrentPen = New Pen(Color.FromArgb(myAlpha, myUserColor(index))) 'Set up the pen
e.Graphics.DrawPath(CurrentPen, path(index)) 'draw the path!
'If (picboard.Image Is Nothing) Then picboard.Image = New Bitmap(picboard.Width, picboard.Height)
'Dim g As Graphics = Graphics.FromImage(picboard.Image)
'g.DrawPath(CurrentPen, path(index))
Next index
End If
Catch
'MsgBox("Not happening!")
End Try
' End If
End Sub
Thanks!!!
|
|
|
|
|
Hello
I need multi-Column combo box user control (derived from combo box class)
I have downloaded some cource codes from artilces available on the group but i am not able to use them perfect. Plz guide me in this regard . if some one using this then plz give me that perfect control
|
|
|
|
|
I have the multi-column Combo box downloaded from any site which I dont remember.. So if you need the source send me the email with subject Multicolumn Combo required... at rbashir@gmail.com
cheers....
|
|
|
|
|
hi all, i only want to get my scrollbars working. what i have done is paste 1 horizontal and 1 vertical bar on my form, put a button in the form but its out of view of the user(outside the form) and when i run the program i want it to be able to scroll to the place where i have placed my button. however it doesnt work, cause the button nv shows up. do i need to do any coding for this? thanks!!
|
|
|
|
|
|
Wait holdup I dont think so. If you are using vb .net standard winform one of the properties for the form is AutoScroll which by default is set to false if you set it to true it will Automatically put Scroll Bars on a form when they are necassary.
1. Out of clutter, find simplicity.
2. From discord, find harmony.
3. In the middle of difficulty lies opportunity.
Albert Einstein
three rules of work
|
|
|
|
|
Hi,
How can i add the "Right-to-Left" property to the ToolTip control? i've done this before for the ListView control by creating a new control that inherits from the original & adding the required parameters. The problem is that ToolTip control is marked "NonInheritable". Is there any way to support this feature??
thanx
|
|
|
|
|
if you have a text starting from right to left then it will automatically show you the right thing. As I have build one software with Arabic Support and it gives text from right to left. So what exactly is your problem.... ???
the control is visible false at runtime so what do you mean by right to left ?
|
|
|
|
|
Anonymous wrote:
if you have a text starting from right to left then it will automatically show you the right thing.
This is my problem!! i'm writing a SW with Arabic support, i have a tooltip text in arabic, but when the mouse hovers over the control, the tooltip text is shown from left to right is there a property i forgot to set or something???
|
|
|
|
|
Arabic Support means the tooltip is in Arabic and will come from right to left. Second thing is if this is coming from left to right then be sure that Arabic is Enabled on your or client machine. Go to Regional settings in control panel and add the right to left languages..
cheers...
|
|
|
|
|
I am using IDisposable interface and trying to dispose my class but that not working. Class variables still hold references to old values. How can i actually dispose off the class. I was of the view that by disposing off a class all the managed memory is freed up.
Public Overloads Sub Dispose() Implements System.IDisposable.Dispose
Dispose(True)
GC.SuppressFinalize(Me)
End Sub
|
|
|
|
|
|
This is the way i am using the references
Public Class Class3
Private strH3 As String
Public Sub dispose()
GC.Collect()
End Sub
Public Property H3() As String
Get
Return strH3
End Get
Set(ByVal Value As String)
strH3 = Value
End Set
End Property
End Class
Public Class Class1
Dim c3 As Class3 = New Class3
Public Sub H3()
c3.H3 = "Class3 => Class1"
MsgBox(c3.H3)
c3.dispose()
End Sub
Public Sub dispose()
GC.Collect()
End Sub
End Class
Form_Load event of the application
Dim a As Class1 = New Class1
a.H3()
a.dispose()
GC.Collect()
a.H3()
Now when i call the c3.dispose in class1 then the reference to tclass3 should be removed and later when i call a3.dispose reference to a class1 will be destroyed. Second call to a.h3 works fine as well.
I have tried the finalize method as well but the result is same
now when i set a=nothing then it works fine but we know that nothing sets it to the default value. so if i have a constructor with some default values it will set it to that.
If i am wrong do correct it.
|
|
|
|
|
First, you should not be calling GC.Collect() - the garbage collector is optimised already so don't undo that optimisation by forcing a collect.
You don't appear to have any UNmanaged resources so the dispose method is pointless - it is for disposing of unmanged (non-.NET) resources. If you don't directly have any unmanaged resources in your class, but it is made up of object that have dispose methods, then your dispose method should call dispose on these objects. So, there are only 2 valid reasons for having a Dispose method. (1) Clear up unmanaged resources, (2) calling dispose on objects in the class.
nitin_ten wrote:
Now when i call the c3.dispose in class1 then the reference to tclass3 should be removed
No, as I've said already, that is not how it works. Dispose is only for clearing up unmanaged resources. It does NOT remove references.
nitin_ten wrote:
now when i set a=nothing then it works fine but we know that nothing sets it to the default value
No, that is not correct. If you set a reference to Nothing the reference does not point to anything. It does not create a default instance of the class; it does not initialise any values.
Does this help?
My: Blog | Photos | Next SQL Presentation
WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and More
|
|
|
|
|
thanks for this, but my problem is still the same how do i destroy the object completely. Nothing won't work and dispose as u said won't work either and even though gc.collect should work but i want to refrain myself from using it and .net doesn't have 'deterministic finalization'. so what is the solution.
|
|
|
|
|
When you set all references to the object to Nothing it is effectively destroyed. While it does still reside in memory for a while, until the garbage collector gets it, it is no longer accessible because nothing refernces it.
If you have a reference to an object then the garbage collector cannot collect it because something is referencing it. If something is referencing it then it is not safe to remove it.
What you might consider looking into is the WeakReference[^] class. This allows you to hold a reference to an object that the garbage collector effectively ignores. So, if you remove all strong references (i.e. a normal reference) then the garbage collector will remove it when it gets round to it. The weak reference will then return Nothing.
Does this help?
My: Blog | Photos | Next SQL Presentation
WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and More
|
|
|
|
|
Thanx Colin. I first set all the reference of class3 in class1 to nothing and then set the reference of class1 to nothing and then called
GC.GetTotalMemory(True)
GC.Collect()
GC.GetTotalMemory(True)
the memory is freed up and the object is destroyed. The problem i found out in the application is that i am using collections and even though when i set the object of the class to nothing collection should also freeup the memory allocation. But that is what is not happening. I found out that on the click event of the button when i create a new object of the class, all the variable except the collection are re initialized to their default value. In case of collection they already have old values and are adding new values along with the old one. What is the problem.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
