In Bold ho messo la parte dove non so che istruzioni mettere.
- Codice:
namespace Mydatabaseschool
{
class Program
{
static void Main(string[] args)
{
try
{
SqlConnection connection = new SqlConnection(@"Data Source=(localdb)\MSSQLLocalDB;Initial Catalog=[nomeDatabase];Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=True;ApplicationIntent=ReadWrite;MultiSubnetFailover=False");
SqlCommand cmd = new SqlCommand();
SqlDataReader reader;
cmd.CommandText = "select * from [nomeTabella]";
cmd.CommandType = CommandType.Text;
cmd.Connection = connection;
connection.Open();
reader = cmd.ExecuteReader();
[b]while(reader.Read())
{
}[/b]
connection.Close();
}
catch { }
}
}
}