[2005] How to save input?

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

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...

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

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

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.

Quote:

---

Originally Posted by 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

---

Did you considered post # 3?

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.

Quote:

---

Originally Posted by 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.

---

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.

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

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.

Hi Deepak,

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

If not what datasource should I use?

Wkr,

sparrow1

Would a binary file work?

Use open file as binary, fileput, fileget.

Quote:

---

Originally Posted by sparrow1

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

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