asp.net - Random numbers in Gridview -
i want on need create gridview (40 rows 10 columns) on asp.net using vb.net , generate , display random numbers between 1 50 in gridview should refresh every 2 seconds. need button turn on , off refresh timer. can 1 or put me right direction?
this stored procedure shed light , lead path move forward. using mssql 2014 express, hope can consider moving mssql access.
create procedure [dbo].[procgetrandoms] -- procedure name begin drop table randoms create table randoms --your columns ( 1 varchar(20), 2 varchar(20), 3 varchar(20), 4 varchar(20), 5 varchar(20), 6 varchar(20), 7 varchar(20), 8 varchar(20), 9 varchar(20), ten varchar(20), ) declare @row int = 0 while @row < 40 begin -- desired rows set @row = @row + 1 insert [dbo].[randoms] ([one] ,[two] ,[three] ,[four] ,[five] ,[six] ,[seven] ,[eight] ,[nine] ,[ten]) values (--using newid() function first 3 rows abs(checksum(newid()) % 50) , abs(checksum(newid()) % 50) , abs(checksum(newid()) % 50) --random integer between 0 , 50 using rand() rest of rows ,convert(int, (50+1)*rand()) ,convert(int, (50+1)*rand()) ,convert(int, (50+1)*rand()) ,convert(int, (50+1)*rand()) ,convert(int, (50+1)*rand()) ,convert(int, (50+1)*rand()) ,convert(int, (50+1)*rand()) ) end -- output attached gridview select * randoms end go -- on code behind timer ('handles timer1.tick)
dim sqlcomrandoms new sqlcommand sqlcomrandoms .commandtype = commandtype.storedprocedure .connection = constring .commandtext = "procgetrandoms" end ' create data adapter (using stored procedure command created earlier) dim datadptrandoms new sqldataadapter(sqlcomrandoms) dim datablerandoms new datatable datadptrandoms.fill(datablerandoms) 'data adapter data table 'bind datagridview using data table intead of dataset datagridview1.datasource = datablerandoms with concept, hope adapt ms access , implement solution. works can refined better time.
Comments
Post a Comment