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

Question

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

Sachin Singh · 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 adikumar · Answer

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)

Mageshwaran R · Answer

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' );

Sachin Singh · Answer

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(); }