Random rand = new Random(); for (int i = 0; i < 10; i++) { int num = rand.Next(1, 100); //插入操作 }
private void button1_Click(object sender, EventArgs e) { ArrayList list = new ArrayList(); Random rd = new Random(); while (list.Count < 11) { int numb = rd.Next(1, 10); list.Add(numb); } foreach (int i in list) { listBox1.Items.Add(i.ToString());//这里面你可以写你要插入的sql语句 } }
select top 10 left(newid(),20) INTO YOURTABLE from syscolumns
for (int i = 0; i < 10; i++)
{
int num = rand.Next(1, 100);
//插入操作
}
{
ArrayList list = new ArrayList();
Random rd = new Random();
while (list.Count < 11)
{
int numb = rd.Next(1, 10);
list.Add(numb);
}
foreach (int i in list)
{
listBox1.Items.Add(i.ToString());//这里面你可以写你要插入的sql语句
}
}