-
Continue reading →: Agile
Agile is a software development methodology which use short iteration process (about 1-4 weeks) to get frequent feedback for aligning business requirement changes. There are roles in Agile : Scrum Master Scrum master is the leader and facilitator who ensures/helps agile process can be implemented well. Functional Responsibilities : Lead…
-
Continue reading →: ASP.Net #if DEBUG always return true
Change project properties. In Build tab, change configuration into “Release” and uncheck “Define DEBUG constant”
-
Continue reading →: ASP.net C# Reading Datetime value From Excel sheet
Try this : string sDate = (xlRange.Cells[4, 3] as Excel.Range).Value2.ToString(); double date = double.Parse(sDate); var dateTime = DateTime.FromOADate(date).ToString(“MMMM dd, yyyy”); I hope it can help you 🙂
-
Continue reading →: SQL Server – How To Find First And Last Date of Current Month
Here are the way how to find first and last date of current month DECLARE @today DATE SELECT @today = GETDATE() SELECT DATEADD(dd,-(DAY(@today)),@today) AS Date, ‘Last Date of Previous Month’ AS DateText UNION SELECT DATEADD(dd,-(DAY(@today)-1),@today) AS Date, ‘First Date of Current Month’ AS DateText UNION SELECT @today AS Date, ‘Today’…
-
Continue reading →: SQL Server – How to find stored procedure containing text
This is the way how to find stored procedure containing some text. We can search with table name or other sql object name. SELECT ROUTINE_NAME, ROUTINE_DEFINITION FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_DEFINITION LIKE ‘%blablabla%’ AND ROUTINE_TYPE=’PROCEDURE’ Thank you. Hopefully it is useful for you
-
Continue reading →: SQL Server – How To Find Tables With Foreign Key Name
I face condition where I have to find table with certain foreign key name. It is condition when I have to recreate (drop first) the table for rearrange table column. So how to find tables with certain foreign key name? Here is the script SELECT f.name AS ForeignKey , OBJECT_NAME(f.parent_object_id)…
-
Continue reading →: How to become system analyst – Understand what is going on
The very basic idea for a system analyst is understanding what is going on. Further,it is about understand the process of existing system. Analize the problem,or improvement point. And conduct a solution. But it is very important,to ensure whether the solution is solutive (I mean it really can solve the…
-
Continue reading →: Tutorial Pengenalan ASP.Net MVC Part 6 (Data binding)
Oke rekan2, lanjut lagi di artikel tutorial pengenalan ASP.Net MVC, sekarang udah di part 6. Masih inget tho artikel tutorial pengenalan ASP.Net MVC yg sebelum – sebelumnya. Tutorial Pengenalan ASP.Net MVC Part 1 , Tutorial Pengenalan ASP.Net MVC Part 2 (Menambahkan Controller), Tutorial Pengenalan ASP.Net MVC Part 3 (Menambahkan View), Tutorial Pengenalan ASP.Net MVC Part 4 – (Menghubungkan data dari…
-
Continue reading →: Konsep dasar pemrograman berorientasi objek (OOP) Part 3
Artikel ini adalah lanjutan dari Konsep dasar pemrograman berorientasi objek (OOP) Part 1 dan Konsep dasar pemrograman berorientasi objek (OOP) Part 2. 5. Inheritance (Pewarisan) Inheritance adalah pewarisan atribute atau method dari suatu class ke class lain. Class yang mewarisi disebut superclass. Dan class yang diwarisi disebut subclass. Sebuah subclass bisa…
-
Continue reading →: Konsep dasar pemrograman berorientasi objek (OOP) Part 2
Artikel ini adalah lanjutan dari artikel konsep dasar pemrograman berorientasi objek (OOP) part 1. 2. Class Class adalah template yang kita gunakan untuk membuat objek. Class berisi definisi variable – variable/property dan/atau method – method. Atribute/variable/property dibagi menjadi 2 jenis, yaitu



