Mutakin.NET

Tipe Field Pecahan

2009-06-18T10:19:00.003+07:00

Tipe data pecahan di mysql untuk supaya bisa menampung pecahan waktu create harus:
contoh :
CREATE TABLE IF NOT EXISTS `mytable` (
`value1` float(2,1) NOT NULL default '0.0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1 ;

INSERT INTO `mytable` VALUES (16.7);

unable to start debugging on the web server because Integrated windows

2009-06-11T11:05:00.001+07:00

Unable to start debugging on the web server. Debugging failed because integrated Windows authentication is not enabled. Please see Help for assistance.
Posted by admin 14 November, 2008
Error : “Unable to start debugging on the web server. Debugging failed because integrated Windows authentication is not enabled. Please see Help for assistance.”
Fix : This error usually comes when you are using asp.net with IIS and try to debug the application. To fix it, you need to goto IIS - > Select your Virtual Directory -> Right-Click -> Properties -> Directory Security Tab -> Press the top most Edit button -> In the next form Check the lower most check box saying “Integrated Windows Authentication” and it will work.

Mengcopy Struktu serta isi tabel

2009-05-22T13:51:00.002+07:00

untuk mengcopy struktur dan isi tabel. tetapi tidak bisa mengcopy key dan relasi

bentuk : select * into newtabel from oldTabel

Meng Attach dan Detach Database Using Query

2009-03-20T18:04:00.003+07:00

untuk meng attach Database :

EXEC sp_attach_db
@dbname=N 'Namdatabse', @FileName1=N 'pathnya\namadatabase.mdf',
@Filename2= N 'Pathnya\Namadatabase.ldf'

sedangkan untuk Detach

EXEC sp_Detach_Db 'nama_database'

Mengubah Font, PaperSize,Orientation pada crystal report

2009-03-18T08:02:00.008+07:00

Menggunakan VB.net

Mungkin banyak teman-teman yang belum tau bagaiman mengubah papersize, font, Orientation pada crystal report lewat Vb.net

Imports CrystalDecisions.CrystalReports
Imports CrystalDecisions.CrystalReports.Engine
Imports CrystalDecisions.CrystalReports.Engine.Section
Imports CrystalDecisions.CrystalReports.Engine.FieldObject
Imports CrystalDecisions.CrystalReports.Engine.TextObject
Imports CrystalDecisions.Shared

Public Class Cetakan
Private rpt As Engine.ReportDocument
Private sub Cetak

Public Structure CetakKePrinter
Public namaReport As String
Public namaDatabase As String
Public namaServerDb As String
Public namaUserId As String
Public namaPassw As String
End Structure
rpt=new Engine.ReportDokumen

Dim cr As CetakKePrinter
cr.namaDatabase = data_base
cr.namaPassw = passWord
cr.namaServerDb = sErver
cr.namaUserId = "sa"
cr.namaReport = App_Path() & "/" & Me.NamaLaporan & ".rpt"
rpt.Load(cr.namaReport, OpenReportMethod.OpenReportByDefault)

Dim header As Single = 215.9 - UkuranBuku.Text
Dim Top As Integer = CInt((1440 / 25.4 * header) + (1440 / 25.4 * tinggi.Text))
Dim Left As Integer = CInt(1440 / 25.4 * kiri.Text)

rpt.PrintOptions.PaperSize = PaperSize.PaperLegal
rpt.PrintOptions.PaperOrientation = PaperOrientation.Landscape
rpt.PrintOptions.ApplyPageMargins(New CrystalDecisions.Shared.PageMargins(Left, Top, 0, 0))

Dim Huruf As New Font(Me.TxtHuruf.Text, Me.txtukuranhuruf.Text)
'pengubahan Section
Dim mySection As Section = rpt.ReportDefinition.Sections.Item("Section3")
Dim Teks As FieldObject
For i As Integer = 0 To MySection.ReportObject.Item.Count-1
Teks = mySection.ReportObjects.Item(i)
Teks.ApplyFont(Huruf)
Next
End Select
crp.ReportSource = rpt ' crp adalah Crystal Report Dokumen
crp.RefreshReport()

Setting Instalasi Sql Server 2005 Express

2009-03-05T15:56:00.001+07:00

1. Configuration Manager2. Network Config - Protocol SQL Express3. IP Address - Enabled Yes4. Browser harus otomatis hidup
Membuat SQL Dual Mode: Windows dan SQL Server AuthenticationHKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQL.ServerLogin Mode = 2
Surface ConfigurationRemoteConnection = Using TCP/IP
Jika Database ReadOnly1. Buka sql server configuration tools ->Sql server configuration manager -> clicksql server service -> click kanan sql server disebelah kanan -> pilih properties-> pada tab Logon ->opsi pilih built in -> dan pilih local system -> atach lagi database tsb2. maka cek diformat apa database disimpan Di NTFS atau Fat32 jika di NTFS maka set semua user menjadi Full Control

Berpindah Kolom pada baris yang sama di datagridview

2009-02-19T14:12:00.005+07:00

Public Class Form1

Public IdxRow As SByte
Public IdxCol As SByte

Sub lanjut()
IdxRow = Datagridview1.CurrentCell.RowIndex - 1
IdxCol = Datagridview1.CurrentCell.ColumnIndex
End Sub

Private Sub dg_CellEnter(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) Handles dg.CellEnter
lanjut()
End Sub

Private Sub Datagridview1_KeyUp(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyEventArgs) Handles dg.KeyUp
If e.KeyCode = Keys.Enter And posCol <>
Datagridview1.CurrentCell = DataGridview1(IdxCol + 1, IdxRow)
Else
Datagridview1.CurrentCell = Datagridview1(0, IdxRow + 1)
End If
End Sub

End Class

Meng-attach Database SQL Server Tanpa Disertai Log File

2009-02-19T12:57:00.002+07:00

Sumber : http://www.geocities.com/s_udirman

Database pada SQL Server terdiri dari dua file yaitu file datanya (yang disimpan dengan ekstensi .MDF) dan file log-nya (yang disimpan dengan ekstensi .LDF). Jika kita meng-attach suatu database melalui Enterprise Manager maka perlu menyertakan kedua file tersebut. Bagaimanakah jika kita hanya memiliki file .MDF nya saja?
Caranya mudah sekali, pada SQL Server terdapat stored procedure sp_attach_single_file_db. Stored procedure ini memang digunakan untuk meng-attach database yang hanya file data-nya saja (.MDF nya saja). Stored procedure ini memiliki dua buah parameter yaitu @dbname dan @physname. Parameter @dbname digunakan sebagai nama database yang hendak di-attach ke server sedangkan parameter @physname adalah nama fisik database (.MDF nya) termasuk path nya.
Sintaks dari stored procedure ini adalah sebagai berikut:
sp_attach_single_file_db [ @dbname = ] 'dbname', [ @physname = ] 'physical_name'
Pada saat Anda menjalankan stored procedure ini disertai dengan database yang hendak Anda attach maka secara otomatis SQL Server akan membuat file log (.LDF) yang baru. Cara ini juga banyak digunakan oleh orang lain untuk memperkecil ukuran dari log file SQL Server.
Berikut ini adalah contoh penggunaan stored procedure sp_attach_single_file_db. Misalnya Anda memiliki database yang bernama db_databarang dengan nama file fisik c:\sqlsvr\data\databrg.mdf. Maka perintah untuk meng-attach database tersebut adalah seperti di bawah ini.
sp_attach_single_file_db @dbname = 'db_databarang', @physname = 'c:\sqlsvr\data\databrg.mdf'
Demikianlah tips singkat seputar SQL Server ini. Semoga bermanfaat bagi Anda semua. Special thanks to Esa Ivani for love and support. Segala macam kritik dan saran bisa dikirimkan melalui sony-ak@sony-ak.com. Untuk melihat tulisan menarik lainnya silakan kunjungi http://www.sony-ak.com/.
Terimakasih.

The request failed with HTTP status 401: Access Denied

2009-02-12T11:02:00.005+07:00

Pada saat kita akses web service tiba-tiba terjadi error "The request failed with HTTP status 401: Access Denied" ini disebabkan setting IIS kita belum benar. Langkahnya : (sumber http://geekswithblogs.net/ranganh/archive/2006/02/21/70212.aspx)

We can resolve this issue by either of the following ways:
Enabling Anonymous Access in the IIS Directory SecurityTo do this, the following steps will help you.
1. Click "Start" - "Run" - Type "inetmgr" and press "Ok" or "Enter" Key
2. IIS Control panel opens.
3. Expand the appropriate nodes and navigate to the virtual directory of your Web Service Application.
4. Select the Virtual directory, Right Click and select "Properties"
5. Switch to the "Directory Security" Tab and then Click "Edit".
6. Check the "Anonymous Access" CheckBox.
7. Click "Ok" twice to exit.This should solve the issue.

2. Programattically assigning the Credential CacheIn case you dont have access to change the IIS Settings or you just dont want to allow anonymous because other applications are using it, then you can programatically provide the permissions by specifying the credential cache.Let us assume we have a Webservice, Service which has the default Web Method HelloWorld. Let us see the steps involved in accessing the service.Service Service1 = new Service();Service1.PreAuthenticate = true;Service1.Credentials = System.Net.CredentialCache.DefaultCredentials;Response.Write(Service1.HelloWorld());As you can see, we are passing the CredentialCache object for the Service1.This would ensure that we preauthenticate the access to the Service. This would be applicable in the case of Integrated Windows Authentication scenarios.Cheers and Happy Programming !!!
-->

Lagi di Padang

2009-02-11T15:44:00.004+07:00

Diskusi Pemerograman

2009-02-11T13:06:00.000+07:00