Loading

records don’t print in my program but they print in viewer

records don’t print in my program but they print in viewer

Bruce Zelenka

7y728Learn iOS Programming

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading;
using System.Data.SqlClient;
namespace BrucesConsoleApp {
class Program {
static void Main(string[] args) {
try {
// Create the connection object
SqlConnection connection = new SqlConnection();
connection.ConnectionString = "Data Source=(localdb)\\MSSQLLocalDB;" +
"Initial Catalog=Books;Integrated Security=True";
// Create the command object and set the connection,
// SELECT statement
SqlCommand selectCommand = new SqlCommand();
selectCommand.Connection = connection;
selectCommand.CommandText = "SELECT * FROM Books";
selectCommand.CommandType = System.Data.CommandType.Text;
// Open the connection to the database
connection.Open();
SqlDataReader reader = selectCommand.ExecuteReader();
if (reader.Read()) {
Console.WriteLine($ "{reader.GetString(1)} {reader.GetString(2)}");
Console.WriteLine($ "");
}
reader.Close();
// Close the connection to the database
connection.Close();
} catch (Exception e) {
Console.WriteLine($ "Error");
Console.WriteLine(e.Message);
}
}
}
}

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Bruce Zelenka7y ago
I chnaged table name from Books to ProCSharp.Books. I ran. Got Message 'Error' 'Invalid object name ProCSharp.Books".
0
Bruce Zelenka7y ago
I did not get any error messages to print..
0
Guest User7y ago
Do you get an error?
0