static void Main(string[] args)
{
object o = null;
string connStr = @"server=.\sqlexpress;database=TestDataBase20130807;Integrated security=true;";
string sql = @"select testNote from TestDataBase20130807..TestTbl where testId=3;";
using (SqlConnection conn = new SqlConnection(connStr))
{
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
conn.Open();
o = cmd.ExecuteScalar();
}
}
Console.WriteLine(o.ToString());
Console.ReadKey();
}
{
object o = null;
string connStr = @"server=.\sqlexpress;database=TestDataBase20130807;Integrated security=true;";
string sql = @"select testNote from TestDataBase20130807..TestTbl where testId=3;";
using (SqlConnection conn = new SqlConnection(connStr))
{
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
conn.Open();
o = cmd.ExecuteScalar();
}
}
Console.WriteLine(o.ToString());
Console.ReadKey();
}