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[^]

Pavlex4 wrote:

How to make that when user enter word using given random letters from labels in textbox,user cannot enter letter that does not exist in given letters!!!

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

If [property].PropertyType.Name = GetType(List(Of )).Name Then
'I do not know what to do!!!!!!!!!!!!!!!!!?????????????

Else
Dim Object1Value As String = String.Empty
Dim Object2Value As String = String.Empty
If type.GetProperty([property].Name).GetValue(Object1, Nothing) IsNot Nothing Then
Object1Value = type.GetProperty([property].Name).GetValue(Object1, Nothing).ToString()
End If
If type.GetProperty([property].Name).GetValue(object2, Nothing) IsNot Nothing Then
Object2Value = type.GetProperty([property].Name).GetValue(object2, Nothing).ToString()
End If
If Object1Value.Trim() <> Object2Value.Trim() Then
Return False
End If

End If