How to count in vb.net and direct it to the database(SQLserver)

Question

3.00/5 (2 votes)

See more:

, +

Hi guys! hi programmers and dvelopers.

I would like to ask about my project.

in my project i have two textbox such as text1 and text2

now the user will input a integer that will range the count

example the user inputted 1 in text1 and 5 for text2

therefore

it will go like this

1
2
3
4
5

maybe if i can display it with a label but more important is to make the numbers insert to the database.

to summarize when i input the range the system will count and the numbers will automatically be in the database.

thanks guys.

i really need some help here. please.

more power! have a great day! looking forward for your help. ;)

Posted 4-Dec-11 12:13pm

Ariel Riyo

Updated 4-Dec-11 17:35pm

v3

Add a Solution

Comments

D K N T H 4-Dec-11 20:59pm

is this an assignment?

Ariel Riyo 4-Dec-11 21:17pm

a project sir. thats one of the function

Manoj K Bhoir 4-Dec-11 23:39pm

You want to insert 1,2,3,4,5 in same column or different columns?

Ariel Riyo 5-Dec-11 2:49am

same columns sir but different rows.

3 solutions

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)

Wendelius · Answer 1 · 2011-12-18T11:29:00

An efficient way would be to create a stored procedure for this. Something like

SQL

CREATE PROCEDURE InsertNumbers @start int, @end int
AS
BEGIN
   DECLARE @counter int = @start;

   WHILE (@counter <= @end) BEGIN
      INSERT INTO YourTable (ColumnName) VALUES (@counter);
      SET @counter = @counter + 1;
   END;
END;
GO

And you can call it from client side using ExecuteNonQuery[^]

codennr · Answer 2 · 2011-12-05T00:17:00

Solution 1

--Execute below script on your SQL

SQL

DECLARE @Start BIGINT 
Declare @END BIGINT 
SET @Start = 1
SET @END = 50
BEGIN

WITH mycte AS
(
SELECT @Start as id
UNION ALL
SELECT id + 1
FROM    mycte
WHERE  id + 1 < = @END
)
SELECT id
FROM mycte
OPTION (MAXRECURSION 0)
END

Posted 5-Dec-11 0:17am

codennr

Updated 6-Dec-11 20:14pm

v2

**Manoj K Bhoir** · Answer 3 · 2011-12-05T02:14:00

You can use For Loop and write insert query in that.It may help you.
I hope you know basics of Ado.Net i.e how to connect with DataBase and all.

VB

Dim StartValue As Int32 = Val(TextBox1.Text)
Dim EndValue As Int32 = Val(TextBox2.Text)

For i As Int32 = StartValue To EndValue
Dim objCommand As OleDbCommand = New OleDbCommand 'Command Object
objCommand.Connection = Con     'Con is connection Object
objCommand.CommandText = "Insert into TableName (FieldName) Values(@FieldName)"
objCommand.SelectCommand.Parameters.AddWithValue("@FieldName", i)
   Try
       'Open your Connection before executiong the Query.
       objCommand.ExecuteNonQuery()
   Catch ex As Exception
       MessageBox.Show(ex.Message) 'Error Message if any
   End Try
objCommand = Nothing
Next

I hope it will help you. :)

How to count in vb.net and direct it to the database(SQLserver)

3 solutions

Solution 3

Solution 1

Solution 2

Add your solution here

Preview 0