hi ...Help me please

[standard]

i found on goggle this cool sites...

i have problem on my project on vb.net I'm using visual studio 2008


may i know how to do to show all my sales everyday..


i have sale almost 5 items every day i want to have list for this.. what should i use?

thanks for you guys Sorry I'm new on vB.net.. hoping for your some advice..

[Ash.Burlaczenko]

You need to give us more information. What do you want you program to do? Where does the information about sales come from?

[cicatrix]

First of all you should store the information about your sales somewhere. Where is it?

[standard]

thanks for reply ...


I'm on repair section on mobile i have different repair every

REPAIR TODAY

on textbox.

Model: nokia
Problem: signal
solution :change ic
Price: $10

REPAIR NEXT DAY

Model: Blackberry
Problem: hang
solution :flash
Price: $20

TOTAL IN 2 DAYS = $30

my question is how can i show all my repair during past days till next day with total price ?

[cicatrix]

You need a database. You create a database with a table called 'Repairs' and create the following fields (columns) in it:

ID (int) - Unique record id.
Model (VarChar) - either simple text or an ID of a known model (taken from another table called 'Models') - this id is called Foreign Key (FK) that identifies a unique record in the Models table.
Problem (VarChar) - either simple text or an ID of a known problem (taken from another table called 'Problems')
Solution (VarChar) - the same - either text or a FK to another table.
Price (money)

Also you will probably want to add the 'Client' field to identify your customers.

This is only an example. You can add as many columns as you want and design your database differently.

You can use any of the most popular database engines (.Net works best with SQLServer or SQLServer Compact Edition, but it also supports nearly all other db engines: MS Access, Oracle, etc). If you decide to use MySQL then you'd need to download a connector from MySQL site.

By querying your db you can collect any kind of statistical information. To query the database you will need to use SQL (Structured Query Language)

[standard]

thanks man how about the computation... of total price daily week monthly ...what can i use

[cicatrix]

It's resolved by using SQL

For example, if you have fields Date and Price in your db table (called Sales) then the query that returns the total sales is:

SELECT Sum(Price) As Total FROM Sales WHERE Date =2010-07-30;

etc.
SQL is a wery powerful tool that can do many things. Yet, it's intuitive to understand and well-documented.

[standard]

what data base can i use for this..


i have only visual studio 2008

where can i download

[cicatrix]

You can create a database using visual studio (for example SQLServer Compact Edition) or create a database in MS Access. Also, you can download MySQL database server from www.mysql.org.

[standard]

i used Microsoft access but it seems auto sum doesn't appear in my GUI .tell me what to do...please..

[cicatrix]

For you it can be no difference but for someone else it will be all the difference in the world. MS Access is more suitable for individual use (not very many users, rather poor protection and performance, but requires substantially less resources). Still, it's a good solution if your database is not for a large-scale enterprise.

Here is more detailed comparison.
http://www.mssqlcity.com/Articles/Co..._vs_access.htm

If your experience with databases is rather poor then I suggest you start with MS Access.

Here is comparison between MS-SQL and MySQL
http://swik.net/MySQL/MySQL+vs+MS+SQL+Server

A great advantage of MySQL is that it's completely free.

[jmcilhinney]

I would tend not to recommend Access to anyone these days. SQL Server CE and SQL Server Express can both be installed along with VS or separately and are both free. SQL Server Express does have some limitations but they won't affect new developers and it offers almost all of the power of SQL Server. They both integrate well with VS and can be very easily deployed. SQL Server Express requires a server to be installed but that can be done with essentially no effort, or you can use SQL Server CE without a server install.

[cicatrix]

I would tend not to recommend Access to anyone these days. SQL Server CE and SQL Server Express can both be installed along with VS or separately and are both free. SQL Server Express does have some limitations but they won't affect new developers and it offers almost all of the power of SQL Server. They both integrate well with VS and can be very easily deployed. SQL Server Express requires a server to be installed but that can be done with essentially no effort, or you can use SQL Server CE without a server install.

Deploying and maintaining of an SQL server for simple solutions is not always practical while CE version may lack certain key features. I agree that MS Access has its drawbacks but still may be a more practical solution in certain situations. For simple projects it would be more correct to compare SQLServerCE and Access. While I would prefer SQLServerCE some people may find the fact that Access is very widespread due to MS Office popularity and the fact that it has its own independent IDE to maintain the database an additional advantage.

[standard]

i cannot understand what can i download now please help

1. Sql server Ce?
2. Sql server?

3. where to download... please...

[cicatrix]

What version of Visual Studio you have? I don't know whether it is present in Express edition, SQL Server is included in the package so it's already there - no need to download. MS Access is a part of MS Office, I'm sure you know it, and MySQL can be downloaded from www.mysql.com (free).

If you don't plan to deploy a SQL server (full version) on your machine (or on some other) or if you don't have an already running SQL server I suggest you use SQL Server CE.

Read this tutorial: http://www.homeandlearn.co.uk/csharp/csharp_s12p1.html
(it's split in topics so don't forget to click the next topic link at the bottom of the page)

It's a bit outdated but it covers the principles.

[standard]

i have VISUAL STUDIO 2008 and Sql server 2005

i want to learn but i do not know how to use it sir...when i open this will appear .. i cannot find SQL SERVER MANAGEMENT.. ? when i open it just configuration manager...please help...

[IMG][/IMG]

[cicatrix]

Did you follow the instructions from here: http://www.homeandlearn.co.uk/csharp/csharp_s12p1.html

All you need is to 'Add new Item'/Database to your project.

[standard]

sir I'm using vb.net

[Joacim Andersson]

It doesn't matter, the tutorial cicatrix linked to works the same in VB.

[standard]

test successfuly but when i try to click ok this error appear..

[IMG][/IMG]

[Joacim Andersson]

Do you have Visual Studio SP1 installed?

[standard]

yes i have... problem on my software. .. already fixed..


my problem now is how to connect form1 to form2=database.

[fanlx1122]

Hi Standard, I have the same error message. How did you fixed it? Thank you.