Help required

  • Thread starter Thread starter Martin Racette
  • Start date Start date
M

Martin Racette

Hi,

I would like to create a program to keep track of all of DVD in my
collection, but I do no know how I can do such a thing. I use to use Access
to do this but Access 2007 refuse to use most of the forms that I need to
get to the information.

SO I thought that using VB Express 2008 I could do something that would do
what I need, but I have no clue where to start
 
I tried it already, and I was told that it is impossible to do, since 2007
remove some fonctionnality that were the in previous version

I am stuck at the point of how do I keep the information, because now the
only way is to keep it in memory, so as soon as I close the program I lose
everything (which defate the purpose)
 
Martin Racette said:
I tried it already, and I was told that it is impossible to do, since 2007
remove some fonctionnality that were the in previous version

I am stuck at the point of how do I keep the information, because now the
only way is to keep it in memory, so as soon as I close the program I lose
everything (which defate the purpose)



--
Thank You in Advance
Merci a l'avance

Martin
Click to expand...

MS has a bunch of "Starter Kits" which includes a Movie Collection
application. You could most likely take this as the starting point for your
app.

http://msdn2.microsoft.com/en-us/express/aa700734.aspx

LS
 
One major problem with these starter kit, they do not work because they
require SQL Express, and this does not work over her, it was always
requirying something call sp_instance or something like that and I can not
either create or use any SQL database from either VB Epress 2008 or C#
Express 2008
 
What I needed was to be able to choose and actor(ess) name and have the
whole listing from my collection, but this work only from the 1st name and
did not worked afterward, also there is noway to add picture anymore in the
database, all pictures do not show and only the name of the picture appears

SO that is why I would like to create my own application that will do this.

SQL databse are not an option, because there is something called sp_instance
or something like that that was telling me that either I could not create a
database nor use one from with either VB express 2008 or C# Express 2008

As for the Access, I can not search Google, since the website does no show
overhere
 
Lets forget about Access, it was for a while a good system but it no longer
up to speed

So any idea how I could do what I am looking for
 
I get an error that there is no programm that will let me integrate the
picture files
 
Hi,

I would like to create a program to keep track of all of DVD in my
collection, but I do no know how I can do such a thing. I use to use Access
to do this but Access 2007 refuse to use most of the forms that I need to
get to the information.

SO I thought that using VB Express 2008 I could do something that would do
what I need, but I have no clue where to start

--
Thank You in Advance
Merci a l'avance

Martin
Click to expand...

Martin,
If you're not sure how to use SQL for storing your DVD collections,
then i'd suggest a basic and really working way.

Store collection in a listbox or listview control, then save the
content in a text file.

A basic sample would work for you:

Dim ItemArray(Me.ListBox1.Items.Count - 1) As Object
Me.ListBox1.Items.CopyTo(ItemArray, 0)
Dim Data As String = Join(ItemArray, Environment.NewLine)
My.Computer.FileSystem.WriteAllText("c:\collection.txt", Data, False)

The parameters of WriteAllText method are up to you (append, data,
path...)

But remember that, your text file will get bigger and unresponsive due
to large amount of text lines over the time, then you may want to
create a new text file.

To get the content of textfile into your listbox:

Dim reader As String
reader = My.Computer.FileSystem.ReadAllText_
("c:\bookmarks.txt")
Dim strs() As String
strs = Split(reader, Environment.NewLine)

For Each s As String In strs
ListBox1.Items.Add(s)
Next

As i stated, you can use this way if your must-do is urgent and
collection is not huge.

Hope this works
 
Martin Racette said:
I get an error that there is no programm that will let me integrate the
picture files



--
Thank You in Advance
Merci a l'avance

Martin
Click to expand...
Martin,

I just installed VB Express 2008. Then downloaded the starter kit for
DVDs. Opened the project. Ran it. No problem. In the documentation for
the starter kit is example of adding a new field so I cannot see what your
problem can be. Try it and if it does not work out of the box let us know
what kind of error you get.

LS
 
On my computer, in either VB Express 2008 or C# 2008, I can not either
create nor use an SQL database, everytime that I tried I get an error about
something called "sp_user instance", nad it's the end of the use of SQL

THe only ones that I can create is COmpact 3.5, but then I can only create
the file, but not the relations between tables
 
It's not that I am not sure how to use SQL, the problem is that I can not
create an SQL database, everythime that I attempt to I get an error message
about somthing called "sp_instance" or something like that.

Hi,

I would like to create a program to keep track of all of DVD in my
collection, but I do no know how I can do such a thing. I use to use
Access
to do this but Access 2007 refuse to use most of the forms that I need to
get to the information.

SO I thought that using VB Express 2008 I could do something that would do
what I need, but I have no clue where to start

--
Thank You in Advance
Merci a l'avance

Martin
Click to expand...

Martin,
If you're not sure how to use SQL for storing your DVD collections,
then i'd suggest a basic and really working way.

Store collection in a listbox or listview control, then save the
content in a text file.

A basic sample would work for you:

Dim ItemArray(Me.ListBox1.Items.Count - 1) As Object
Me.ListBox1.Items.CopyTo(ItemArray, 0)
Dim Data As String = Join(ItemArray, Environment.NewLine)
My.Computer.FileSystem.WriteAllText("c:\collection.txt", Data, False)

The parameters of WriteAllText method are up to you (append, data,
path...)

But remember that, your text file will get bigger and unresponsive due
to large amount of text lines over the time, then you may want to
create a new text file.

To get the content of textfile into your listbox:

Dim reader As String
reader = My.Computer.FileSystem.ReadAllText_
("c:\bookmarks.txt")
Dim strs() As String
strs = Split(reader, Environment.NewLine)

For Each s As String In strs
ListBox1.Items.Add(s)
Next

As i stated, you can use this way if your must-do is urgent and
collection is not huge.

Hope this works
 
Everytime that I try to add an image I get an error about OLE

"THE OPEARTION ON THE OLE OBJECT FAILED, the OLE server may not be
registered, toregister the OLE Server, reinstall it"

I search the Office website for OLE Server, and there is nothing about it,
and that was something that was working out of the box with the previous
version of Access
 
Lloyd Sheen said:
Martin,

I just installed VB Express 2008. Then downloaded the starter kit for
DVDs. Opened the project. Ran it. No problem. In the documentation for
the starter kit is example of adding a new field so I cannot see what your
problem can be. Try it and if it does not work out of the box let us know
what kind of error you get.

LS
Click to expand...

One note. In the project the database file(s) are marked as Copy Always.
What that does is on each build it copies the blank database to the bin
folder. Took me a while to figure out why if I changed something in the GUI
all the info I had put into the database was gone. You will want to change
this to "Copy if newer" to get around this.

If you want to add fields to the database you will have to copy the database
files from the bin folder back into the project folder prior to making
changes. That way you will be able to change the table and the build will
then copy the new version of the database into the bin folder.

Also if you want to view the rows in the database using VS 2008 you open the
database from the bin folder not the project folder.

Try it out. The web service to amazon is great. Just imput your movie
title and search. The double click the item in the list to add it to your
database.

LS
 
Could be, it is great, but I can not make it work here, because I can not
access the damn SQl databse, when it trys I get an error about "sp_instance"
 
Martin Racette said:
Could be, it is great, but I can not make it work here, because I can not
access the damn SQl databse, when it trys I get an error about
"sp_instance"


--
Thank You in Advance
Merci a l'avance

Martin
Click to expand...

I can only suggest that you reinstall SQL Express. Take care in the install
and do it as a default install. Don't change anything.

What is the exact message you get?

LS
 
THe exact message I do not recall, and I can no longer find out because I
erased all traces of SQL Express 2005 from my computer, after being told
that I am too stupid to understand how to use it

From what I can understand this newsgroup seem to be mostly for PHD holder
nad not beginner that would like/need some help

BTW. the last comment is not direct to any of who are answering this line
of question that I have previously posted
 
I already given the exact error in an other seires of messages abour SQL
Server, and I was told (subtily) that I am too stupid to use it so I just
got rid of it and thus I can not use SQL Databases.

SQL Express was already installed, it was inatalled at the same time that I
installed VBExpress 2008, it tells me something about "SP_INSTANCE" when I
either try to create or use SQL database

I had similar problem when I use the Management Studio, 1) it was creating
databases where I can not get to them (PRGRAM FILES(x86)/SQL SERVER)
2) Once again when I tried to used the SQL Database in my project I got the
same error message about SP_INSTANCE

SO the sample that LLoyd was talking about, I was unable to use it because
when it tried to open there was a problem with the SQL database(same error
as above)

THe only kind of database that I can crete/use is something called compact
SQL, I can create table in there but I can not link them to make a relation

MY sincere apologies to Patrice, Lloyd, and kimiraikkonen, I was rude to you
and there was no reason for it, Once again my apologies
 
Back
Top