|
Hi,
I am Using VB.NEt 2003 and MS Access 2003 for my Project. In My Access database there are 7 tables and capacity 400kb. But when i am executeing program the database capacity is increasing significantly. My initial database capacity is 400kb. But After executing 50 times it increased to 4.5 MB. Sometimes after executing 100 times it increased up to 123MB. In my database, only 2 tables are updated while executing the program. When executing the program, 60 and 30 data records are inserted to the above 2 tables. But every inserting time, previous data record sets are deleted.
Please can anybody help me?
Dimuthu
|
|
|
|
|
The answer is simple - you need to compact the database.
Whenever records are deleted from an Access database the space those records take up is not freed up.
So if you keep adding and deleting records your database will keep growing until you compact it.
The only way to retrieve free space from the database is by compacting it.
You always pass failure on the way to success.
|
|
|
|
|
Helo every one'
please guide me how to install third party software with my project like the setup first install the third party software wait till installation complete then start installing my project. vs 2005
I will be highly thankful,
Julian
|
|
|
|
|
You will have to write a setup bootstrapper, or Google for ".net setup bootstrap" to use an existing one.
The problem you're going to run into is that you can only have one .MSI based installation running on a machine system-wide. An .MSI installation cannot launch a second .MSI installation and wait for it to complete. Each install must be checked for and launched by an .EXE-based installer.
|
|
|
|
|
Helo every one.
I want to access default media player of my machine from my app instead windows media player included in the studio.
Please give me some guidelines. I am using vs2005
I will be thankful
Julian
|
|
|
|
|
Define what you mean by "access". What do you want to do with it, whatever "it" is...??
|
|
|
|
|
I generated a list of media files in listbox. files are located on the server. first i include the wmp on the form which perform good. but did not play all types of media. need codecs. now i want that when client click on the list box the file should be opened on the client's computer on his default media player whatever he prefered to installed. like vlc, power dvd player etc etc rather than windows media player.
sir i am working on local area network and this part of the project is depends on ftp server.
I will be grateful for your kind support
Julian
|
|
|
|
|
The files being on an FTP server will pose a bit of a problem. Since you can't add a COM component to your form, since you won't know which plyers are installed, you have to shell launch each file using a command line, just like double-clicking the file in Explorer. The problem is that this approach does not work with FTP files because the command line you have to use will quite possibly launch a clients FTP client instead. The commandline would have to be:
ftp:
In order for this approach to work, you'd have to download the file to the client machine first, then launch the command line for the newly downloaded file. The new commandline that would launch the default player would be something like:
C:\Windows\Temp\content.mpg
The only way the first URI would work is if you could pass the path as a parameter to the media player when you launch it, or if it is added to your form as an object out of the toolbox.
wmplayer ftp:
but, you don't know what players are installed, or what file extensions will successfully play in each player.
It would seem you have a choice to make...
|
|
|
|
|
 Hi all ,Presently i am working on a task i.e.,i am having a toolstrip , i added textbox,RB,Label,Checkbox,etc , when i select a control on toolstrip,a run time control has to generate and paste on panel ,But i am not able to drag & drop the control to any place on the panel and make a new selection . And the other thing is when i click a new generated textbox ,it has to show the Textbox edges like in vs toolbox and after that i have to set properties for that runtime generated textbox or radiobutton .Actually, it has to work like VS.Net 2005 Toolbox with some controls on it -- this is actual idea
Waiting for help Urgently---
D.V.Sriram
|
|
|
|
|
I'm not sure I got the whole question right but for the drag and drop problem look at the property allowdrop.
to set the properties at runtime you'll need to create a properties form where you can do this
also look at user controls it might be easier to create a usercontrol then to use the standerd controls.
If my help was helpfull let me know, if not let me know why.
The only way we learn is by making mistaks.
|
|
|
|
|
Thanks For Replying Immediately ,
:-Olets see,i created a dynamically textbox when i click a button on toolstrip in vs2005 .a new label is generated and i am able to drag n drop on any place thats all.like that i created checkbox,RB,Label .For these control , now, when i click on label it has to highlight( i dont know how to highlight the control) like in vs2005 and set the properties .and i have to move that control at any place where i want, when i moving every controls are moving like that happening .. so for that looking for help
DVSriram
|
|
|
|
|
for the highlighting (box around the control) I think you'll have to write eighter a custom control with it in it or draw that box I don't think its possible with the standerd control.
for the moving part: without more detailed discription and/or code I can't tell you much except that if you want it done according to certain specifications its best to write it yourself in once again a user control
conclusion:
write a usercontrol that inherits label/textbox/radiobutton/... and add custom actions
If my help was helpfull let me know, if not let me know why.
The only way we learn is by making mistaks.
|
|
|
|
|
 Thanks For Replying ,
Now i am able to move the runtime controls on the form and place any where , no problem with that .Now i am in doing the things like these::
1) Setting the properties of those runtime controls
2) When i mouse down on that particular runtime control it has to display rectangles on edges of the control and able to resize the control.
I am searching the net . i got some answers ,But Trying if u have any resource links Give to me please ..
Regards
D.V.Sriram
|
|
|
|
|
for the properties of the controls you'll need to make a form or something where they can be set.
If you want to save them (most likly you will) you'll need to save them to a db or use serialisation (do some research on this since its not easy).
for the resising you'll need to use the mousedown event then check where the mouse is on the control, if its on the edge of the control then draw the rectangles, change the mouse to the appropriate arrows and put a boolean on true (this boolean indecates that the mousebutton is down also save the mouseposition since you'll need it to calculate how much the user is resising,in the mouseup event you put it to false) then in the mousemove event compare the current with the saved position and resise you'r control. I have some code that does this somewhere, when I have 10min of time I'll look for it.
If my help was helpfull let me know, if not let me know why.
The only way we learn is by making mistaks.
|
|
|
|
|
Thanks For Replying ..
Now i have done the things for properties of runtime controls .I used PropertyGrid control which is in vs2005 to get the selected control in runtime .
1) DO u know how to set the properties one by one like in vs2005 properties toolbar ( Example the comboxbox shows all the items present in the form in windows )Presently i am concentrating on this .And have to work on resizing .
2) In the future , I have to save all these controls properties in to an XML file and i have to retrieve the same ,and align and look like before saving the file .
If u have any ideas of these things , Kindly reply me
D.V.Sriram
|
|
|
|
|
haven't used propertygrid before so don't really know about 1)
for 2) you'll need serialisation or write it all you'r self (to xml) if I have time I'll make a small example for serialistion
If my help was helpfull let me know, if not let me know why.
The only way we learn is by making mistaks.
|
|
|
|
|
 i created the controls at runtime on panel using toolstrip in vs2005 using vb.net , so if add this it is working on the panel, toolstrip that' all . i am not able to access the runtime control like label1 ,checkbox1,RB1 ,TB1 like that . if i am able to access the control like label1 it is showing the squares but not able to resize the runtime controls , --- using Pickbox from codeproject
DVSriram
|
|
|
|
|
in order for you to be able to access the control you'll need to give at a unique name (when created at runtime) also you should add a addhandler to it (with the click event) then in the code of you'r addhandler you can cast the sender object to label and access it like that
so something like this
on creation
dim l as new label
l.name = 'label1'
addhandler l.click, addressof label_click
the handler
private sub label_click(sender as object,e as system.eventargs)
if sender.gettype.equals(gettype(label) then
dim l as label = sender
l.doyourdrawingofthesquareshere
end if
end sub
hope this helps
If my help was helpfull let me know, if not let me know why.
The only way we learn is by making mistaks.
|
|
|
|
|
Presently i worked on resizing the controls , it works for dynamic controls also .
Thanks
|
|
|
|
|
hi,
say for example,
i have created one database application in vc, and i access the MS access database through that.
so first i create a DSN from control panel\odbc datasources.
obviously i have to access that database through the dsn from vc++.
now if i want to install it on my clients machine, i have to copy the files first, then map the DSN and then run the application.
now what i want is, is there any method to automate the creation of DSN, such that, just by a single click on my application, this DSN gets created.
thanks.
|
|
|
|
|
Do NOT post the same question in multiple forums. This is called "spamming" is just plain rude.
|
|
|
|
|
Hi
Can anyone help!
I want tot develop a weather reporting software and an Economic tutor. I'm a bit
confused how to get about them. Thanks
|
|
|
|
|
First step is to use a language that is still alive. VB6 is totally unsupported, move to VB.NET. Then, you need to either have a better starting point than 'I have no idea how to write XXX', or you need to pay someone to write it for you.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
sir,
please tell me how i can make application in which server have database and client can make search through this database in vb.net
|
|
|
|
|
this is simply a matter of using the correct connectionstring just point the data source part to the server: servername\sqlserverinstancename
example:
Data Source=server1\server1_DEV;Initial Catalog=DB;User ID=sa
then you can write you app like any other
If you'r question was how to write the app then you'r asking at the wrong place. Nobody here will write it for you, when you have a specific problem then you can ask for help here
If my help was helpfull let me know, if not let me know why.
The only way we learn is by making mistaks.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
