Inquiridor
Está correto?

Pergunta
-
using System;
using System.Collections.Generic;
using System.Data.SqlClient;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
namespace ExemploADO
{
class SqlCommandSiMedBD
{
SqlConnection conn;
public SqlCommandSiMedBD()
{
// Instantiate the connection
conn = new SqlConnection("Data Source=(local);Initial Catalog=SiMedBD;Integrated Security=SSPI");
}
static void Main()
{
SqlCommandSiMedBD scd = new SqlCommandSiMedBD();
Console.WriteLine();
Console.WriteLine("Antes - Usuarios Insert");
Console.WriteLine("------------------------");
// use ExecuteReader method
scd.ReadData();
// use ExecuteNonQuery method for Insert
scd.Insertdata();
Console.WriteLine();
Console.WriteLine("Depois - Usuarios Insert");
Console.WriteLine("------------------------------");
scd.ReadData();
// use ExecuteNonQuery method for Update
scd.UpdateData();
Console.WriteLine();
Console.WriteLine("Depois - Usuarios Update");
Console.WriteLine("------------------------------");
scd.ReadData();
// use ExecuteNonQuery method for Delete
scd.DeleteData();
Console.WriteLine();
Console.WriteLine("Depois - Usuarios Delete");
Console.WriteLine("------------------------------");
scd.ReadData();
// use ExecuteScalar method
int numberOfRecords = scd.GetNumberOfRecords();
Console.WriteLine();
Console.WriteLine("Numero de registros: {0}", numberOfRecords);
Console.ReadKey();
}
/// <summary>
/// use ExecuteReader method
/// </summary>
public void ReadData()
{
SqlDataReader rdr = null;
try
{
// Open connection
conn.Open();
// 1. Instantiate a new command
SqlCommand cmd = new SqlCommand("select Nome from Usuarios", conn);
// 2. Call Execute reader
rdr = cmd.ExecuteReader();
while (rdr.Read())
{
Console.WriteLine(rdr[0]);
}
}
finally
{
// close reader
if (rdr != null)
{
rdr.Close();
}
// Close connection
if (conn != null)
{
conn.Close();
}
}
}
/// <summary>
/// use ExecuteNonQuery - Insert
/// </summary>
public void Insertdata()
{
try
{
// Open connection
conn.Open();
// command string
string insertString = @"insert into Usuarios (Nome, Login, Senha, Email) values ('Teste','teste','40BD001563085FC35165329EA1FF5C5ECBDBBEEF','teste@feevale.br')";
// 1. Instantiate a new command
SqlCommand cmd = new SqlCommand(insertString, conn);
// 2. Call ExecuteNonQuery
cmd.ExecuteNonQuery();
}
finally
{
// Close the connection
if (conn != null)
{
conn.Close();
}
}
}
/// <summary>
/// use ExecuteNonQuery - Update
/// </summary>
public void UpdateData()
{
try
{
// Open the connection
conn.Open();
// command string
string updateString = @" update Usuarios set Nome = 'TesteUpdate' where Nome = 'Teste'";
// 1. Instantiate command
SqlCommand cmd = new SqlCommand(updateString);
// 2. Set Connection
cmd.Connection = conn;
// 3. Call ExecuteNonQuery
cmd.ExecuteNonQuery();
}
finally
{
// Close the connection
if (conn != null)
{
conn.Close();
}
}
}
/// <summary>
/// use ExecuteNonQuery - Delete
/// </summary>
public void DeleteData()
{
try
{
// Open connection
conn.Open();
// command string
string deleteString = @" delete from Usuarios where Nome = 'TesteUpdate'";
// 1. Instantiate command
SqlCommand cmd = new SqlCommand();
// 2. CommandText
cmd.CommandText = deleteString;
// 3. Set Connection
cmd.Connection = conn;
// 4. Call ExecuteNonQuery
cmd.ExecuteNonQuery();
}
finally
{
// Close connection
if (conn != null)
{
conn.Close();
}
}
}
/// <summary>
/// use ExecuteScalar method
/// </summary>
/// <returns>number of records</returns>
public int GetNumberOfRecords()
{
int count = -1;
try
{
// Open the connection
conn.Open();
// 1. Instantiate command
SqlCommand cmd = new SqlCommand("select count(*) from Usuarios", conn);
// 2. Call ExecuteScalar
count = (int)cmd.ExecuteScalar();
}
finally
{
// Close the connection
if (conn != null)
{
conn.Close();
}
}
return count;
}
}
}
Todas as Respostas
-
Ola, peço que por favor seja mais específico no seu problema, onde exatamente esta sua dúvida neste trecho de código? O que não esta funcionando?
Acredito que tenha executado e alguma coisa não ocorreu como deveria ou exibiu algum erro.
Att, Rodrigo
Rodrigo Reis Ferreira
Microsoft Certified