using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlClient;
using System.Data;
namespace ConsoleApplication2
{
class Program
{
static void Main(string[] args)
{
SqlDataReader rdr = null;
var connectionString = @"server=myServer;database=myDatabase;uid=sa;pwd=mypassword";
using (var conn = new SqlConnection(connectionString))
using (var command = new SqlCommand("RetrieveSupplier", conn)
{
CommandType = CommandType.StoredProcedure
})
{
command.Parameters.Add(new SqlParameter("@Supid", 4));
conn.Open();
rdr= command.ExecuteReader();
while (rdr.Read())
{
Console.WriteLine(
"Name is {0}",
rdr["SupplierName"]
);
}
conn.Close();
}
Console.ReadKey();
}
}
}
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlClient;
using System.Data;
namespace ConsoleApplication2
{
class Program
{
static void Main(string[] args)
{
SqlDataReader rdr = null;
var connectionString = @"server=myServer;database=myDatabase;uid=sa;pwd=mypassword";
using (var conn = new SqlConnection(connectionString))
using (var command = new SqlCommand("RetrieveSupplier", conn)
{
CommandType = CommandType.StoredProcedure
})
{
command.Parameters.Add(new SqlParameter("@Supid", 4));
conn.Open();
rdr= command.ExecuteReader();
while (rdr.Read())
{
Console.WriteLine(
"Name is {0}",
rdr["SupplierName"]
);
}
conn.Close();
}
Console.ReadKey();
}
}
}