[2005] How to save input?

[sparrow1]

Hi All,

I have an application with several textboxes.
When the user write some data into these textboxes it has to be saved.

An access database and textfile is no option to save the data.

What sould I use to save, remove, open and change this data?

Thanks in advance,

sparrow1

[chris128]

why cant you save it to a text file or database? If you dont want to save it anywhere then how on earth can it be saved :S
The only other option I can think of is to save it in the My.Settings class but that would only save it per-user so you wouldnt be able to have more than one PC with your app on and have them both work from the same saved data...

[Deepak Sakpal]

If need to save data of only several text boxes then you can think of Registry.

[sparrow1]

Hi,

I know it's strange that it can't be a Textfile or an access database.
Otherwise I didn't asked this question.

So, The application will be installed on the companyserver and will be used by several companyPC's. (That's the reason not to use Textfiles or accessdatabases)

Is there another way to do it?

Thanks,

Sparrow1

[chris128]

an SQL database would be ideal for this purpose then. The SQL database would run on a server (you can install SQL Express on the server for free if you dont already have an SQL Server anywhere on your network) and then all the PCs can communicate with this.

[Deepak Sakpal]

Hi,

I know it's strange that it can't be a Textfile or an access database.
Otherwise I didn't asked this question.

So, The application will be installed on the companyserver and will be used by several companyPC's. (That's the reason not to use Textfiles or accessdatabases)

Is there another way to do it?

Thanks,

Sparrow1

Did you considered post # 3?

[chris128]

Deepak, I dont think saving to the registry would be suitable when more than one machine needs to access the same data... SQL Server was designed specifically for this purpose.

[Deepak Sakpal]

Deepak, I dont think saving to the registry would be suitable when more than one machine needs to access the same data... SQL Server was designed specifically for this purpose.

If don't want to save anything on the client machine then SQL server is definitely a better choice as everything will be saved on server.

[sparrow1]

Hi Deepak and Chris,

If you says that's the best way to save anything, then I'll go for it.

The only thing is, I've never used a SQL server before can you put me in the right direction with an example or a tutorial.
And I can use it with VB 2005.

Thanks,

Sparrow1

[Deepak Sakpal]

http://www.homeandlearn.co.uk/NET/vbNet.html

See the 'VB .NET Thirteen - VB .NET and Databases' section at above link. It will give an idea about that.

[sparrow1]

Hi Deepak,

Thanks for the link, but isn't that for an Accessdatabase!

If not what datasource should I use?

Wkr,

sparrow1

[sytto]

Would a binary file work?

Use open file as binary, fileput, fileget.

[nmadd]

Hi Deepak,

Thanks for the link, but isn't that for an Accessdatabase!

If not what datasource should I use?

Wkr,

sparrow1

I've found this set of tutorials helpful: http://msdn.microsoft.com/en-us/library/ms172560.aspx

[eker676]

Here is a video tutorial that helped me
http://msdn.microsoft.com/en-us/beginner/bb308825.aspx