Vb.net textbox to datagridview and add price existing value

Question

0.00/5 (No votes)

See more:

C#

Dim table As New DataTable
        da.Fill(table)
        table.Rows.Add(TextBox1.Text, TextBox2.Text, TextBox3.Text, TextBox5.Text)
        DataGridView1.DataSource = table

What I have tried:

How to add value in datagridview from textbox and I want to add same product price 10. If they are already added then cells total become 20.
How to achieve this functionality?

Posted 20-Oct-16 5:38am

CaptainChizni

Updated 20-Oct-16 21:24pm

Add a Solution

Comments

[no name] 20-Oct-16 11:50am

You convert the strings to numbers and add them.

CaptainChizni 20-Oct-16 11:56am

do you have a code for this? I'm really new to this

[no name] 20-Oct-16 12:03pm

Doing research, reading documentation, and attempting your work is how you learn. Could I write the code for you? Sure, but then you won't learn anything other than someone will do your work for you.

Ralf Meier 21-Oct-16 1:23am

I the reply of NotPoliticallyCorrect right ? Do you want to add the values of the 5 Textboxes and write the result of this Addition into a new cell of your DataTable ?
Or is your requirement different ?

CaptainChizni 21-Oct-16 1:43am

Yes i want to add the values of the 5 textboxes and write the result of this additon into a new cell of my datatable

Ralf Meier 21-Oct-16 3:20am

In this case you only should convert their value into single or double, then add it and after thsi convert it back to String and write it into your DataTable.
See my "Solution" to this ...

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Ralf Meier · Answer 1 · 2016-10-20T21:24:00

As I wrote in my Comment :

VB

Dim mySum as double = cdbl(TextBox1.Text) + cdbl(TextBox2.Text) + cdbl(TextBox3.Text) +cdbl(TextBox5.Text)
table.Rows.Add(mySum.toString)

But note :
Each Textbox-Value MUST be able to be converted. If it is possible that there is a non-decimal value in it you should handle it.
the Result mySum has no Formatting - but toString gives you the ability to do this - see MSDN-Help for this ...