[Dev]C# – 페이지 8

Yahoo Weather API 날씨

2012년 08월 30일 golgol 0

/* 전세계 60000곳에 해당하는 실시간 날씨정보를 가져와보자! http://developer.yahoo.com/flash/ 에서 Web APIs Library 를 다운받자 astra-webapis-1.2.0.zip 를 압축을 풀고 Source 폴더 안의 com 폴더를 몽땅 fla파일이 […]

Thread.sleep

2012년 08월 17일 golgol 0


// sleep for about 2 seconds
Thread.sleep(2000L);
// sleep for about 2.5 seconds
Thread.sleep(2000L, 500000L);

1

2

3

4

5

6

// sleep for about 2 seconds

Thread.sleep(2000L);

// sleep for about 2.5 seconds

Thread.sleep(2000L, 500000L);

CommandTimeout

2012년 08월 17일 golgol 0

CommandTimeout Property Gets or sets the wait time before terminating the attempt to execute a command and generating an error.


[Visual Basic]
<strong>Public Property CommandTimeout</strong> <strong>As </strong><a href="ms-help://MS.NETFrameworkSDK/cpref/html/frlrfSystemInt32ClassTopic.htm">Integer</a>

1

2

3

4

[Visual Basic]

Public Property CommandTimeout As <a href="ms-help://MS.NETFrameworkSDK/cpref/html/frlrfSystemInt32ClassTopic.htm">Integer</a>


[C#]
<strong>public </strong><a href="ms-help://MS.NETFrameworkSDK/cpref/html/frlrfSystemInt32ClassTopic.htm">int</a><strong> CommandTimeout {get; set;}</strong>

1

2

3

4

[C#]

public <a href="ms-help://MS.NETFrameworkSDK/cpref/html/frlrfSystemInt32ClassTopic.htm">int</a> CommandTimeout {get; set;}

Remarks The time […]

DB connect

2012년 08월 06일 golgol 1


class DBData
{
static string connectionString = "server= localhost;uid=user;pwd=pass;database=SSC";

public static string Select(int Sending_SSC)
{
string ADW = null;

//SQL 연결설정
//Call stored procedure with parameter and return value
SqlConnection conn = new SqlConnection(connectionString);

try
{
conn.Open();

SqlCommand cmd = conn.CreateCommand();

cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "GetCachingADW";

SqlParameter paramSending_SSC = cmd.Parameters.Add("@Sending_SSC",SqlDbType.SmallInt);
paramSending_SSC.Direction = ParameterDirection.Input;
paramSending_SSC.Value = Sending_SSC;

SqlDataReader reader = cmd.ExecuteReader();

if (reader.Read())
{
ADW = reader["ADW"].ToString();
}

reader.Close(); // <- too easy to forget
reader.Dispose(); // <- too easy to forget
 conn.Close(); // <- too easy to forget

return ADW;
}

catch (Exception ex)
{
//클라이언트에게 예외를 던진다.
//throw ex;
string Err = ex.ToString();

return "";
}

}

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

class DBData

{

static string connectionString = "server= localhost;uid=user;pwd=pass;database=SSC";

public static string Select(int Sending_SSC)

{

string ADW = null;

//SQL 연결설정

//Call stored procedure with parameter and return value

SqlConnection conn = new SqlConnection(connectionString);

try

{

conn.Open();

SqlCommand cmd = conn.CreateCommand();

cmd.CommandType = CommandType.StoredProcedure;

cmd.CommandText = "GetCachingADW";

SqlParameter paramSending_SSC = cmd.Parameters.Add("@Sending_SSC",SqlDbType.SmallInt);

paramSending_SSC.Direction = ParameterDirection.Input;

paramSending_SSC.Value = Sending_SSC;

SqlDataReader reader = cmd.ExecuteReader();

if (reader.Read())

{

ADW = reader["ADW"].ToString();

}

reader.Close(); // <- too easy to forget

reader.Dispose(); // <- too easy to forget

conn.Close(); // <- too easy to forget

return ADW;

}

catch (Exception ex)

{

//클라이언트에게 예외를 던진다.

//throw ex;

string Err = ex.ToString();

return "";

}