Visual Basic

Pavlex4 wrote:

I read that there is no anymore that option,now for conversion is using SQL Server Migration Assistant for Access.

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

string cs= @"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename= C:\Users\Pavle\Documents\Visual Studio 2015\Projects\Test slagalica\Test slagalica\Slagalica-DB.mdf;Integrated Security=True";
            string queryString = "SELECT * FROM table1 WHERE LEN(Reci) >=10 AND LEN(Reci) <=12 ";
            using (SqlConnection connection = new SqlConnection(cs))
            {
                SqlCommand mycommand = new SqlCommand(queryString, connection);
                try
                {
                    connection.Open();
                    SqlDataReader reader = mycommand.ExecuteReader();
                    label14.Text = Convert.ToString(mycommand);
                    reader.Close();
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message);
                } 
            }

Pavlex4 wrote:

When I run program with this commands it prints System.Data.SqlClient.SqlCommand!!!

Pavlex4 wrote:

Why it won't show random word from database???

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

using (SqlConnection connection = new SqlConnection(cs))
            {
                SqlCommand mycommand = new SqlCommand(queryString, connection);
                try
                {
                    connection.Open();
                    string word = (string)mycommand.ExecuteScalar();
                    label14.Text = word;
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message);
                }
            }

string cs = @"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename= C:\Users\Pavle\Documents\Visual Studio 2015\Projects\Test slagalica\Test slagalica\Slagalica-DB.mdf;Integrated Security=True";
            string queryString = "SELECT * FROM table1 WHERE LEN(Reci) >=10 AND LEN(Reci) <=12 ORDER BY RAND()";
            string query = "SELECT * FROM table1 ORDER BY RAND()";
            using (SqlConnection connection = new SqlConnection(cs))
            {
                SqlCommand mycommand = new SqlCommand(queryString, connection);
                SqlCommand mycommand2 = new SqlCommand(query, connection);
                try
                {
                    connection.Open();
                    string word = (string)mycommand.ExecuteScalar();
                    word = (string)mycommand2.ExecuteScalar();
                    label14.Text = word;
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message);
                }

SELECT TOP 1 [WordColumnName] -- replace this with the name of the column that holds your word.
  FROM table1 
 WHERE LEN(Reci) >=10 
   AND LEN(Reci) <=12 
 ORDER BY RAND()

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

string cs = @"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename= C:\Users\Pavle\Documents\Visual Studio 2015\Projects\Test slagalica\Test slagalica\Slagalica-DB.mdf;Integrated Security=True";
            string queryString = "SELECT * FROM table1 WHERE LEN(Reci) >=10 AND LEN(Reci) <=12 ORDER BY RAND()";
            using (SqlConnection connection = new SqlConnection(cs))
            {
                SqlCommand mycommand = new SqlCommand(queryString, connection);
                try
                {
                    connection.Open();
                    string word = (string)mycommand.ExecuteScalar();
                    label14.Text = word;
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message);
                }

Pavlex4 wrote:

I add ORDER BY RAND() but I won't show random word other time!!!

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

string cs = @"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename= C:\Users\Pavle\Documents\Visual Studio 2015\Projects\Test slagalica\Test slagalica\Slagalica-DB.mdf;Integrated Security=True";
            string queryString = "SELECT * FROM table1 WHERE LEN(Reci) >=10 AND LEN(Reci) <=12 ORDER BY NEWID()";
            using (SqlConnection connection = new SqlConnection(cs))
            {
                SqlCommand mycommand = new SqlCommand(queryString, connection);
                try
                {
                    connection.Open();
                    string word = (string)mycommand.ExecuteScalar();
                    label14.Text = word;
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message);
                }
            }

Pavlex4 wrote:

I shuffled word like this: string shuffled_word = new string(word.OrderBy(r => random.Next()).ToArray());

Pavlex4 wrote:

But I don't know how to every time I click button show letter of word on other label?

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]