My Personal Blog's
Read Excel Cell Value from ASP.NET 2008 – VB.NET
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>
Don’t Forget to add triger to set autopostback, or else some people may counter error when the want to get the file name after they click browse button. Normally you put this code at the buttom
<triggers>
<asp:PostBackTrigger ControlID="btnUpload" />
</triggers>
At behind code import
Imports Excel = Microsoft.Office.Interop
In event click
Dim oApp As New Excel.Excel.Application()
Dim oWBa As Excel.Excel.Workbook
Dim oWS As Excel.Excel.Worksheet
If uplFile.PostedFile.FileName <> "" Then
filename = Mid(uplFile.PostedFile.FileName, InStrRev(uplFile.PostedFile.FileName, "\") + 1, Len(uplFile.PostedFile.FileName) - InStrRev(uplFile.PostedFile.FileName, "\"))
uplFile.PostedFile.SaveAs(System.AppDomain.CurrentDomain.BaseDirectory & filename)
oWBa = oApp.Workbooks.Open(System.AppDomain.CurrentDomain.BaseDirectory & filename)
oWS = DirectCast(oWBa.Worksheets(1), Excel.Excel.Worksheet)
oApp.Visible = False
Dim strkey2(3) As String
strkey2(0) = CStr(oWS.Range("A1")
strkey2(1) = CStr(oWS.Range("B1")
strkey2(2) = CStr(oWS.Range("C1")
strkey2(3) = CStr(oWS.Range("D1")
oWS = Nothing
oWBa.Close()
oWBa = Nothing
oApp.Quit()
oApp = Nothing
End If
No comments yet.
No trackbacks yet.
VB.NET – ASP.NET communication between user control and web page using event handler
April 21, 2011 - 5:09 pm
Posted in ASP.NET | No comments
In this post, we want to show how button in user control communicate with web page in asp.net
First create user control called button.ascx.
Add 3 button, name it btnSave, btnEdit and btnCancel.
in button.ascx back code, add this code:
Public Partial Class button
Inherits System.Web.UI.UserControl
Public Event btnSaveHandler As System.EventHandler
[...]
Get first day of the month and last day of the month in VB.NET
June 3, 2010 - 4:31 pm
Posted in VB.NET | No comments
This code show how to get first date of the month and last day of the month date.
Private Function GetFirstDayOfMonth(ByVal dtDate As DateTime) As DateTime
Dim dtFrom As DateTime = dtDate
dtFrom = dtFrom.AddDays(-(dtFrom.Day – 1))
[...]
VB.NET Set Data Table to CSV File
This function show how to Convert DataTable to CSV File
Sub SetDataTable_To_CSV(ByVal dtable As DataTable, ByVal path_filename As String, ByVal sep_char As String)
Dim writer As System.IO.StreamWriter
Try
[...]
VB.NET Date Time Format Patterns
January 15, 2010 - 10:00 am
Posted in VB.NET | No comments
Standard Format Example List:
Format
Code
Result
MM/dd/yyyy
Date.Now().ToString(”d”)
1/15/2010
dddd, dd MMMM yyyy
Date.Now().ToString(”D”)
Friday, January 15, 2010
dddd, dd MMMM yyyy hh:mm tt
Date.Now().ToString(”f”)
Friday, January 15, 2010 11:06 AM
dddd, dd MMMM yyyy HH:mm:ss
Date.Now().ToString(”F”)
Friday, January 15, 2010 11:06:46 AM
MM/dd/yyyy h:mm tt
Date.Now().ToString(”g”)
1/15/2010 11:06 AM
MM/dd/yyyy HH:mm:ss
Date.Now().ToString(”G”)
1/15/2010 11:06:46 AM
MMMM dd
Date.Now().ToString(”m”)
January 15
dd MMM yyyy HH’:’mm’:’ss ‘GMT’
Date.Now().ToString(”r”)
Fri, 15 Jan 2010 11:06:46 GMT
yyyy’-’MM’-’dd’T’HH’:’mm’:’ss
Date.Now().ToString(”s”)
2010-01-15T11:06:46
yyyy’-’MM’-’dd HH’:’mm’:’ss’Z’
Date.Now().ToString(”u”)
2010-01-15 11:06:46Z
dddd, MMMM dd yyyy HH:mm:ss
Date.Now().ToString(”U”)
Friday, January [...]
VB.NET: How to implement Group By in DataSet using LINQ
December 10, 2009 - 11:45 am
Posted in LINQ, VB.NET | No comments
In this post I will show you the power of LINQ. At first I never try LINQ even when I developing project using Visual Studio 2008. But since I have no way to find a solution to one of my project, I start to explore LINQ which is give me a thought of how powerful [...]
ASP.NET: How to read XML Data String to Dataset
December 2, 2009 - 1:54 pm
Posted in VB.NET | No comments
The output of XML String:
<?xml version="1.0" encoding="utf-8" ?>
- <NewDataSet>
- <Table>
<CONDOM>Durex</CONDOM>
<SIZE>XL</SIZE>
<QTY>123</QTY>
<COLOR>616</COLOR>
</Table>
</NewDataSet>
In order to convert from XML to dataset, this is the code:
Dim MyDS as new Dataset("Table1")
Dim strReader As StringReader = New StringReader(YourXmlString)
MyDS.ReadXml(strReader)
ad#300×250]
ASP.NET: Convert String XML to XML Node
December 2, 2009 - 1:42 pm
Posted in VB.NET | No comments
For example I have string value like this:
<?xml version="1.0"?>
<Product type="Condom">
<CondomName>durex</CondomName>
[...]
ASP.NET: How to use Javascript alert inside AJAX UpdatePanel
Normally when we add Javascript Alert to our asp.net it will be like this:
Page. ClientScript.RegisterStartupScript(this.GetType(), "winPop", "alert(’Update is successful’)
but this code is not working if you using the code inside update panel.
So in order to add javascript in update panel you need to register you client script to your script manager as shown below:
ScriptManager.RegisterClientScriptBlock(Page, [...]
ASP.NET – Convert CSV to Dataset
In this post I will show you how to convert from .csv files to dataset in ASP.NET
Here is the function to convert CSV file to dataset in asp.net using vb.net.
First you need to upload the csv file into your web server, then save the file path.
Add this function code:
Private Shared Function [...]
Connecting asp.net to Sql server 2005 stored procedures into dataset
June 10, 2009 - 7:20 am
Posted in VB.NET | No comments
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 [...]
