How to generate a number between 1 to 10 and insert into database

shreyas adikumar

Hi I am trying to generate a number between 1 to 10 and insert it into a database can anybody please help me with that.thank you so much in advanace

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sachin Singh5y ago
Accepted answer
just pass the textbox values to random object as shown below, i am considering webform as you have not mentioned which stack you are using.
   Random rnd = new Random();
int firstNum= Convert.ToInt32(TextBox1.Text);
int SecondNum= Convert.ToInt32(TextBox2.Text);
   int num= rnd.Next(firstNum, SecondNum);

now you can save this to database using ADO.net or EF, carefully copy paste

   using(SqlConnection con=new SqlConnection(cs))
   {
   SqlCommand cmd=new SqlCommand("Insert into TableName values(@Num)",con);
   cmd.CommandType=CommandType.StoreProcedure;
   con.Open();
   cmd.Parameters.AddWithValue("@Num",num);
   cmd.ExecuteNonQuery();
   }
shreyas adikumar5y ago
hi sachin your solution worked but how to do it using the text box

exampe if one txt box is given as one and another text box is given as 10 then how to genrate between this number
a.txt(1)
b.txt(2)
Sachin Singh5y ago
generate random number like
Random rnd = new Random();
int num= rnd.Next(1, 10);
now you can save this to database using ADO.net or EF, carefully copy paste
using(SqlConnection con=new SqlConnection(cs))
{
SqlCommand cmd=new SqlCommand("Insert into TableName values(@Num)",con);
cmd.CommandType=CommandType.StoreProcedure;
con.Open();
cmd.Parameters.AddWithValue("@Num",num);
cmd.ExecuteNonQuery();
}
Mageshwaran R5y ago
Auto-increment allows a unique number to be generated automatically when a new record is inserted into a table.
Often this is the primary key field that we would like to be created automatically every time a new record is inserted.
CREATE TABLE Persons (
    Personid int IDENTITY(1,1) PRIMARY KEY,
    LastName varchar(255) NOT NULL,
    FirstName varchar(255),
    Age int
);

INSERT INTO Persons (FirstName,LastName)
VALUES ('Lars','Monsen');