Comments by Member 12490691 (Top 40 by date)

I just want to know how do I read the data coming from the keypad. The transmission is made through serial port

My job is just read things from the electronic system and then write it on the database.

Get some information

You are completely right for sure. I know what you are saying, why should try to force and develop big and complex projects if I don't know how to make a single program to calculate simple things. Start from scratch it's very important and we could apply it to our life's, because we can't build a house from top to bottom.

Nowadays we don't need no courses or pay to learn because as you said Google is a good help. This forum is an example of it, we have a lot of material and improving our skill is the most exciting and important thing.

I think I am thinking right. I just need to focus on a programming language and mastering it.

Yes. Thanks.

Thank you for your explanation.

Ok. Why you're saying that?

I can see what you mean. Basically with C# I can develop a little bit of everything right?

I develop something in my spare time.

I know about that website concept but they do not work with vb.net. So should I upgrade to another language or??

I don't know I just wanna do it :D

Int SomeValue = Int32.Parse(txtBox1.Text) - Int32.Parse(TextBox2.Text). Can you explain me better that line of code?

To add values, I have a textbox where i insert values and it will add using that query. Then, I have a textbox where I insert values too and instead of adding a query to subtract the values

This is the query to SUM - SELECT CAST(SUM(amountTransacao ) AS DECIMAL(10,2)) FROM Transacoes what should be the query to SUBTRACT?

Because I want to subtract values

Already edited the question

I've just edited it. Sorry

What I have in my query is actually working but instead of using that 'NULL AS 'TOTAL(KB)' I would like to use a SELECT to query me what I want in that column.

This is the Select that I want to include in my query
SELECT Filetype, SUM(Filesize) AS 'Total(KB)'
FROM infofile
GROUP BY Filetype

-Filetype - nvarchar - contain extensions files
-Filesize - int

Hey. Thank you for your solution. Your query does not apply with the query that I am trying to build.

I improved the question with an possible example. By the way every data type is nvarchar

What you clearly want?

How can I post a print here?

Thank you for your help, but what I was trying to find is about VB.NET.

Have a great day

Hey. Unfortunately I couldn't get any help about what I really want by far. My goal with this piece of code is to get the info from a column of my database and give me the percentage of every different extensions(.exe, etc...) you know what I mean. This is useful if I display it on a Pie Chart.

Thank you for your help.

Ok. Thanks man I will try to do that

There is another option instead of using Access database?

I don't like Access so after I install it I should use which option?
-Microsoft ODBC Data Source?

This local server will be just used by a single user(Me). What you're saying is that it's better if I create a Microsoft SQL Server Compact and change my code to allow it?

It is local.

I am making a data collection from every computer of the company that I'm working for. I want to get this data just for me you know what I mean?

But if I create the database file on Microsoft Visual Studio it's easier right?