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);
                }
            }