My Personal Blog's
Archive for June, 2009
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 »
Connecting Crystal Report ASP.NET using Dataset
Jun 5th
Do you have so many problems with user logon database when you try to connecting asp.net to crystal report using SQL Server 2005 store procedure or table.
By using dataset, you dont have to worries about connection to sql server in crystal report.
First, you need to add or create new item of dataset object. Dataset object format as .xsd
Inside the dataset object, right click and add new datatable, after that right click on datatable and add column.
You can set the datatype as well.
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>
