shahrzad2
پنج شنبه 24 خرداد 1386, 20:01 عصر
من یک تابع random نوشتم تا به صورت random رکورد هارا از sql بخوانه ولی اجرا نمی شه لطفا کمکم کنید
int q,i=0;
Random r = new Random();
do
{
do
{
q = r.Next(200);
} while (q >= 100);
SqlConnection objConnection = new SqlConnection("Data Source=localhost;Initial Catalog=prjtype;Integrated Security=True");
SqlCommand objcommand = new SqlCommand();
string a = "select tbltype.word from tbltype where tbltype.code=@q";
SqlCommand objCommand = new SqlCommand(a, objConnection);
objConnection.Open();
SqlDataReader objdatareader = objCommand.ExecuteReader();
objdatareader.Read();
textBox1.Text = objdatareader["word"].ToString()+textBox1.Text;
objdatareader.Close();
i++;
} while (i <= 50);
int q,i=0;
Random r = new Random();
do
{
do
{
q = r.Next(200);
} while (q >= 100);
SqlConnection objConnection = new SqlConnection("Data Source=localhost;Initial Catalog=prjtype;Integrated Security=True");
SqlCommand objcommand = new SqlCommand();
string a = "select tbltype.word from tbltype where tbltype.code=@q";
SqlCommand objCommand = new SqlCommand(a, objConnection);
objConnection.Open();
SqlDataReader objdatareader = objCommand.ExecuteReader();
objdatareader.Read();
textBox1.Text = objdatareader["word"].ToString()+textBox1.Text;
objdatareader.Close();
i++;
} while (i <= 50);