VB.NET Programming Corner!

[maskio]

Pwede po ba sa windows 8 gumawa ng program? Nabasa ko kasi pangXP lang. Anu po yung para sa Win8? TIA

pwedeng gumawa ng program kahit anong OS, (windows, linux, mac) at kahit anong version, 95, 98se, 2000, xp, vista, 7, 8, 9, 10, 12

 

[kibitzer08]

Sir paanu iconnect ang microsoft excel sa vb.net ? help plzz ...thnks

naigoogle mo na ba? at sinubukang pag aralan ang code at iapply ang code?

bigay ko mamaya sample source code ko.

 

[oozmakappa]

good day sir ! magtatanong lang sana po ako tungkol sa authors cutter may thesis kase kame ngaun na pinoproblema nalang namin e un authors cutter di namin makuha ung codings nea. so kaya po ako nandito para magtanong ng simpleng codings po para sa authors cutter po . simpleng reply lang po makaktulong na ng malaki samin. thX!

 

[VampireKira]

Meron ba ditong may experience sa pag gamit ng smart card technology using VB.Net? Hehe.

 

[Mhayapot]

ask ko lang po sana baka po alam nyo kung pano makapag add, edit,delete ng data sa vb.net na connected sa ms sql.? thanks po

 

[lesterluma]

ask ko lang po sana baka po alam nyo kung pano makapag add, edit,delete ng data sa vb.net na connected sa ms sql.? thanks po

sa first page yata meron..

 

[bobbyparkz]

ask ko lang po sana baka po alam nyo kung pano makapag add, edit,delete ng data sa vb.net na connected sa ms sql.? thanks po

yung tanung na ito ay masasagot na ng yes or no... so my answer is yes.. hehe ..

 

[bobbyparkz]

Sir paanu iconnect ang microsoft excel sa vb.net ? help plzz ...thnks

need mo lang sir ng tamang connection string sa pagbuild mo ng connection... here's a link na pwede mong magamit http://www.connectionstrings.com/excel/

 

[bobbyparkz]

Meron ba ditong may experience sa pag gamit ng smart card technology using VB.Net? Hehe.

meron po mam

 

[jake_lyson]

ano pa pwede gamitin except sa sqldatareader sa pagread ng recordset na ginagamit nio? tia

 

[jenzhire]

may nkaka alm po ba kung panu gumawa ng program for micro finance ? help po pls...
salamat

 

[bobbyparkz]

ano pa pwede gamitin except sa sqldatareader sa pagread ng recordset na ginagamit nio? tia

adodb lagi gamit ko..

 

[asthma]

Sir paanu iconnect ang microsoft excel sa vb.net ? help plzz ...thnks

add m muna sa reference ung Excel Object library para makuha m ung reference na:
- Microsoft.Office.Core
- Microsoft.Office.Interop.Excel
- VBIDE

example scenario:
may text sa A1 cell sa excel file na gusto mong ma-retrieve using VB.Net at ilagay sa textbox1

gawa ka ng isang textbox at isang button,

sa loob ng button_click :

ExcelReport = New Excel.Application
ExcelReport.Visible = False 'set this to true kung gusto mong maopen ung excel file
workbook = ExcelReport.Workbooks.Open(Application.StartupPath & "\excel_file.xls")
textbox1.Text = ExcelReport.Range("A1").Value
workbook.Application.DisplayAlerts = False
workbook.Close() 'after basahin ung cell icloclose ung excel file
workbook = Nothing
ExcelReport.Quit()
ExcelReport = Nothing

add'l info: pwede mo ding i-print ang items sa listview papunta sa ms excel

 

[jake_lyson]

adodb lagi gamit ko..

mali yata yung tanong ko,

dapat yata ganito :

ano pa pwede gamitin na pang manipulate sa recordset bukod sa datareader?

 

[oozmakappa]

Re: atuthors cutter vb.net

good day sir. tanong ko lang po tungkol sa authors cutter po. di po kase namin mgawa ng ayos e. tanong lang po sana kung pano gawin po ung codes nea. yun lang po.. tnx in advance !

 

[joemonggalds]

page 1 MicroPOS-Access

salamat po sir

 

[kibitzer08]

ayun. naipost na pala ung sa excel.

 

[maskio]

when coding, never deprive yourself from sleep...

 

[endine87]

Good Evening Sir Eric, Paki evaluatenaman po ng code ko. Part of my Inventory System Project. Ginawa ko po kasi sa inventory system ko nag create ako sa VS ng Console Application project (not Windows Forms) Tapos from the Console, Call ko yung loginform ko at kung succesful depende sa access level ng user saka ko icacall yung MainForm for Admin or MainForm for Employees. Eto po yung code ko sa Module. Please give me suggestion kung may mas maganda po kayong paraan jan. Thanks in Advance.


==========================
Imports System.Windows.Forms
Imports System.IO


Module modInventorySystem

'***********************************************
'GLOBAL VARIABLES AND CONSTANT DECLARATIONS
'***********************************************
'Variable Naming Convention
'Global - g
'Module/Class Level - m
'Local to procedure - none


'Connection String (Consist of the provider and Datasource)
'TODO: Give the user the option to what database to connect
Public gstrconnection As String = "Provider=Microsoft.ACE.OLEDB.12.0;" & _
"Data Source = " & Directory.GetCurrentDirectory & "\dbInventorySystem.accdb"
Public gstrprogramDirectory As String

'Entry point for the InventorySystem Application
Sub Main()

'This is the Installation Directory of the Program
gstrprogramDirectory = Directory.GetCurrentDirectory()
Console.WriteLine("The Program Directory is:" & vbCrLf & gstrprogramDirectory & vbCrLf)

Console.WriteLine("Starting Program ...")

Console.WriteLine("Starting User Authentication...")

Dim strauthenticate As String
'The function LogMeIN() returns character "admin" or "member" if authentication is succesful. Else it returns "error"
strauthenticate = LogMeIn()

Console.WriteLine("Finished Authentication")
Console.WriteLine("Verifying User" & vbCrLf)

'Determine the Access level of the user
Select Case strauthenticate
Case "admin"
'execute form for admin
Console.WriteLine("Verification Successful" & vbCrLf & "The user is an administrator")
Case "member"

Console.WriteLine("Verification Successful" & vbCrLf & "The user is a member")
'execute program for members
Dim MemberWindow As New frmMainAppMember()
MemberWindow.Show()
AddHandler MemberWindow.FormClosed, AddressOf MainFormClosed
Application.Run()
Console.WriteLine("Member window Loaded")
Case "error"
'Prompt UNKNOWN USER then exit
Console.WriteLine("Unknown User")
End Select

End Sub 'Main

'*************************************************
'PROPERTY DECLARATIONS
'*************************************************

'*************************************************
'PROCEDURE DECLARATIONS
'*************************************************
Public Sub MainFormClosed()
Application.Exit()
End Sub 'CloseForm


'*************************************************
'FUNCTIONS DECLARATIONS
'*************************************************
Private Function LogMeIn() As String

Console.WriteLine("Entering Function LogMeIn")
Dim LogInForm As New frmLogMeIn()
LogInForm.Show()
AddHandler LogInForm.FormClosed, AddressOf MainFormClosed

'Run the application
Application.Run()

'The function method Authenticate() returns character "admin" or "member" if authentication is succesful. Else it returns "error"
Return LogInForm.Authenticate()

End Function 'LogMeIn

End Module 'modInventorySystem

 

[rhon6260]

Good PM guys

Ask ko sana Panu mag Loop sa Isang Datareader?

Meron kase akong Query na may 52 Fields at ListView na may 52 Columns

gusto ko sana mag loop nalang sa DataReader para hindi na Manu-manu ang pag add ng item sa ListView "More Lines of Code"

Note:
Kaya ListView yan kase Update lang ako sa Code, Madali sana kung naka DataGrid