목록전체 글 (286)

bboks.net™

C#에서 저장프로시저 사용하기

//Connection SqlConnection con = new SqlConnection(); con.ConnectionString = ConfigurationManager.ConnectionStrings["연결문자열"].ConnectionString; con.Open(); //Command SqlCommand cmd = new SqlCommand(); cmd.Connection = con; //사용할 프로시저 cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "sp 이름"; //입력 파라미터 cmd.Parameters.AddWithValue("@param1", "1234"); cmd.Parameters.AddWithValue("@par..
C# | ASP.NET/C# 2010. 4. 5. 10:33
MS SQL DateTime 비교

select * from table_name where condition_1 and (cast(sd_date as smalldatetime) >= cast('2006-05-02 00:00:01' as smalldatetime) and cast(sd_date as smalldatetime)
Database/MS-SQL 2010. 4. 2. 17:55
C# SqlDataReader NULL 검사

SqlDataReader reader = SqlCommand.ExecuteReader(); reader.IsDbNull(column_index)
C# | ASP.NET/C# 2010. 4. 1. 19:34
Java Anonymous Class

A type of inner class that has no name that you define right in the middle of a method (where static init blocks and instance init blocks count as methods). You define it, and create an object of that type as a parameter all in one line. An anonymous class is defined and instantiated in a single succinct expression using the new operator.Used for creating simple delegate callback objects.These a..
Java/Java 2010. 3. 24. 18:12
이전 Prev 1 ··· 51 52 53 54 55 56 57 ··· 72 Next 다음