My Personal Blog's
VB.NET
SSIS: Update data from different table if data is Null
Nov 30th
SSIS: SSIS stands for SQL Server Integration Services. It is the new data transformation standard for SQL Server 2005 and has replaced the old SQL Server Data Transformation Services.
In this post, I want to show how to update data from different table with condition that the data is Null.
Read the rest of this entry »
ASP.NET – Convert CSV to Dataset
Jul 17th
In this post I will show you how to convert from .csv files to dataset in ASP.NET
Read the rest of this entry »
ASP.NET Cross Tab / Pivot from Data Table
Jun 22nd
Sometimes when you working with the large data, you might want to display the data in pivot table / cross tab. Crystal report have a very nice wizard to make our life easier to create cross tab, but not in vb.net
For example you have data table like Table CompanyDetail populated from the SQL Select Query below
Read the rest of this entry »
Create Multiple row / group header in gridview ASP.NET
Jun 12th
This article shows how to create multiple row / group header in gridview asp.net
first you need to add gridview to database and set the datasource connection.
After you have done with all of that, you just add this function to your code
Read the rest of this entry »
Connecting asp.net to Sql server 2005 stored procedures into dataset
Jun 10th
This article demonstrates how to use ASP.NET and ADO.NET with Visual Basic .NET to create and to call a Microsoft SQL Server stored procedure with an input parameter and an output parameter.
1 step create store procedure
Create Procedure GetAuthorsByLastName1 (@au_lname varchar(40), @RowCount int output) as select * from authors where au_lname like @au_lname; /* @@ROWCOUNT returns the number of rows that are affected by the last statement. */ select @RowCount=@@ROWCOUNT
Call the stored procedure in asp.net code
Read the rest of this entry »
Sending Email by your own Gmail account + Attachment using ASP.NET 2.0 and VB.NET
Jun 6th
First of all, you need need to set something in your gmail account to enable sending email using asp.net
1. Open you gmail account and go to setting
2. Click on Forwarding and POP/IMAP
3. Choose Enable POP for mail that arrives from now on
4. Click save changes
Here is the code for sending email from asp.net by using gmail account
Read the rest of this entry »
Read Excel Cell Value from ASP.NET 2008 – VB.NET
Jun 4th
In this article I will show how to read value from excel per cell,
First Im using FileUpload component from asp.net
<td>
<asp:FileUpload ID="uplFile" runat="server" Width="367px"/>
</td>
Function Terbilang (Indonesia Currency) vb.net
May 26th
This function is used to convert from numeric to text in indonesia language. This function was coded for vb.net
Public Function Terbilang(ByVal nilai As Long) As String
Dim bilangan As String() = {"", "satu", "dua", "tiga", "empat", "lima", _
"enam", "tujuh", "delapan", "sembilan", "sepuluh", "sebelas"}
If nilai < 12 Then
Return " " & bilangan(nilai)
ElseIf nilai < 20 Then
Return Terbilang(nilai - 10) & " belas"
ElseIf nilai < 100 Then
Return (Terbilang(CInt((nilai \ 10))) & " puluh") + Terbilang(nilai Mod 10)
ElseIf nilai < 200 Then
Return " seratus" & Terbilang(nilai - 100)
ElseIf nilai < 1000 Then
Return (Terbilang(CInt((nilai \ 100))) & " ratus") + Terbilang(nilai Mod 100)
ElseIf nilai < 2000 Then
Return " seribu" & Terbilang(nilai - 1000)
ElseIf nilai < 1000000 Then
Return (Terbilang(CInt((nilai \ 1000))) & " ribu") + Terbilang(nilai Mod 1000)
ElseIf nilai < 1000000000 Then
Return (Terbilang(CInt((nilai \ 1000000))) & " juta") + Terbilang(nilai Mod 1000000)
ElseIf nilai < 1000000000000 Then
Return (Terbilang(CInt((nilai \ 1000000000))) & " milyar") + Terbilang(nilai Mod 1000000000)
ElseIf nilai < 1000000000000000 Then
Return (Terbilang(CInt((nilai \ 1000000000000))) & " trilyun") + Terbilang(nilai Mod 1000000000000)
Else
Return ""
End If
End Function
SQL Server Management Objects with VB.net
May 23rd
SQL Server™ Management Objects (SMO) offer developers a robust toolset for operations such as backing up and restoring databases, and issuing Data Definition Language (DDL) commands. Using SQL SMO you can also connect to SQL Server, iterate through a collection of database objects and perform a variety of tasks against them.
I have been created simple program using vb.net 2008 and sql server 2005 using SQL SMO.
Read the rest of this entry »
