VB.NET Programming Corner!

[ezzel03]

Hello ts.. may program po kasi na pinapagawa sa akin ng accounting office. Kailangan i-scan po yung document tapos converted to image. tapos may mga details po na automatically mai-sasave sa database po para magamit sa searching ng documents. using vb.net po. magpapatulong po sana ts.

thanks ts..

- - - Updated - - -

any idea po sana ts. on how to create the scanning and saving data process.

 

[kudeta21]

Hello ts.. may program po kasi na pinapagawa sa akin ng accounting office. Kailangan i-scan po yung document tapos converted to image. tapos may mga details po na automatically mai-sasave sa database po para magamit sa searching ng documents. using vb.net po. magpapatulong po sana ts.

thanks ts..

- - - Updated - - -

any idea po sana ts. on how to create the scanning and saving data process.

my template ba yung document mo?

 

[masker]

pano po maginsert ng special character sa database mga sir without using parameter curious lang ako mga sir

 

[kudeta21]

pano po maginsert ng special character sa database mga sir without using parameter curious lang ako mga sir

pwede ka gumamit ascii code

 

[maritesmacute]

Hello ts.. may program po kasi na pinapagawa sa akin ng accounting office. Kailangan i-scan po yung document tapos converted to image. tapos may mga details po na automatically mai-sasave sa database po para magamit sa searching ng documents. using vb.net po. magpapatulong po sana ts.

https://www.youtube.com/watch?v=sI_wcio-kXI

https://www.youtube.com/watch?v=d_l5-sBt-Mc

thanks ts..

- - - Updated - - -

any idea po sana ts. on how to create the scanning and saving data process.

i scan mo tapos kukunin mo yung detail? imposible to.. dapat bago ka tumanggap ng project or nag propose dapat nag research ka muna, para pwede kang tumanggi at mag reason out..

una salahat yung scanned documents ay considered as picture, Nilagay lang sa PDF yung iba pero still PICTURE pa din sya.. hindi mo makukuha yung data jan..

yung sample kasi jan, CREATED as PDF not SCANNED DOcuments

 

[denrico44]

First Post:

Populating DataGridView using MSAccess Database

http://symbianize.com/attachment.php?attachmentid=177200&stc=1&d=1276943189

Shown in 3ways
-using Dataset
-using DataReader
-binding the DataGridView to a dataset

http://symbianize.com/attachment.php?attachmentid=177201&stc=1&d=1276943476

Important points to learn:
OleDBConnection
OleDBCommand
OleDBAdapter
Dataset
DataReader
DataTable
Using My.Settings to save the database path

Program will search for the database if not found;
Sample code has comments as to how it is done
Post further questions if necessary:

Basic Steps:

Create a project:
Add a form:
Add this to the forms top most code
"Imports System.Data.OleDb"
Add the DataGridView
For non databound grid,
add the necessary columns using the datagridview designer (when selected; click the [>] button on the top rigth of the grid)
Follow the code provided


the file
ericVBNETAccess.rar
contains the design for the application series i wanted to construct for this thread
you will notice, walang pop windows, nasa tab page lang ang forms.
stay tuned to know how it is done.

UPDATED! - loading data into listview.

Updated SQL Server Sample
http://www.symbianize.com/attachment.php?attachmentid=369167&stc=1&d=1310119089

check also thee links
http://www.symbianize.com/showpost.php?p=8292447&postcount=2560
http://www.symbianize.com/showpost.php?p=8292571&postcount=2561
http://www.symbianize.com/showpost.php?p=8292709&postcount=2562

another sample of using usercontrol
http://www.symbianize.com/attachment.php?attachmentid=846939&d=1385380661

Galing sir you give me a headache

 

[henpaichi_-_]

patulong po mga sir, nag post ako ng question sa stackoverflow pero wala pang sagot. baka may makatulong sakin dito, eto ung post ko, pakibasa nman po. Salamat..

 

[jemiel10]

Patulong po mga sir sa vb.net 2010 with ms access
gumawa po kasi ako ng system at na compile ko na to executable file ang problema ko po yung sa database pag iniinstall ko sa ibang computer yung system ayaw mag add ng new data which means naka read lang yung permission sa access pero sa computer ko read/write, pag nililipat ko sa iba nagiging read lang pano puba maprevent yung ganon?
maraming maraming salamat po sa sasagot!!!

 

[maskio]

Patulong po mga sir sa vb.net 2010 with ms access
gumawa po kasi ako ng system at na compile ko na to executable file ang problema ko po yung sa database pag iniinstall ko sa ibang computer yung system ayaw mag add ng new data which means naka read lang yung permission sa access pero sa computer ko read/write, pag nililipat ko sa iba nagiging read lang pano puba maprevent yung ganon?
maraming maraming salamat po sa sasagot!!!

ano gamit mo na DB, if mysql, edit mo permission ng user na gamit mo to connect to the database (check mo kung may write access at kung naka specify ba kung saang address/host or schema)

- - - Updated - - -

Hello ts.. may program po kasi na pinapagawa sa akin ng accounting office. Kailangan i-scan po yung document tapos converted to image. tapos may mga details po na automatically mai-sasave sa database po para magamit sa searching ng documents. using vb.net po. magpapatulong po sana ts.

https://www.youtube.com/watch?v=sI_wcio-kXI

https://www.youtube.com/watch?v=d_l5-sBt-Mc

thanks ts..

- - - Updated - - -

any idea po sana ts. on how to create the scanning and saving data process.

idea ko lang / suggestion: need mo pa din e proof read ang document like any other OCR software, try searching abby fine reader and omni page pro, check mo yung capabilities nila on reading images, you might get some inputs, God bless.

 

[jemiel10]

okay na sir sa user permission lang pala salamat po sa sagot

 

[ryankai]

Good day bago lang ako dito, ask ko lang kung meron na ba dito gumawa nang system with access control?

 

[kudeta21]

Good day bago lang ako dito, ask ko lang kung meron na ba dito gumawa nang system with access control?

madali lang yun sir. more on if else ka nun

 

[jesmac]

pssst , pwede po pa help.. if may msaccess ako na database tapos gusto kung ipalabas yung images at lagyan ko nang txtnme at txtprice and qty... tapos ma lagay sa datagridview or listview , pwede po ba yun? pa help po ako sa coding... maraming salamat poh

 

[r3amodee]

Good morning po. Patambay lang po. Dati po akong nag aral VB.NET sa TESDA yun nga lang nakalimutan ko na kung pano ulit simulan dahil di related ang trabaho ko ngayon sa napag aralan ko sa TESDA. Gusto ko lang sana ulit mag aral ng VB.NET thru your help. I know you could help me.

 

[janelskirabbit]

sir patulong naman po :0

pa Help naman po sa mga expert jan sa Visual Basic gamit po ang Visual Studio. Meron po kasi akong Project, Input po game name tapos merong listbox dun mastore ung name tapos kapg click lalabas ung description nung game sa output box. meron din po dapat pre loaded na gme ung listbox. meron po akong code kaso di ko po lam kung bakit wala description na lumalabas.okay na po ung delete at add button ko. description, find at update button po problema. salamat po sa makakatulong. eto po code.

lass MainWindow
Dim list1 As New Dictionary(Of String, String)
Private games As Object
Sub Output(ByVal Value As String)
txtgameDec.Text += Value + vbCrLf
txtgameDec.Text = listBox.SelectedItem.Value

End Sub
Sub Output1(ByVal Value As String)
txtgameName.Text += Value + vbCrLf
End Sub
Private Sub btnAdd_Click(sender As Object, e As RoutedEventArgs) Handles btnAdd.Click
listBox.Items.Add(txtInput.Text)
End Sub

Private Sub btnDel_Click_1(sender As Object, e As RoutedEventArgs) Handles btnDel.Click
listBox.Items.Remove(listBox.SelectedItem)
End Sub
Private Sub listBox_SelectionChanged(sender As Object, e As SelectionChangedEventArgs) Handles listBox.SelectionChanged

Dim cnt As Integer = listBox.Items.IndexOf(listBox.SelectedItem)
For ctr = 0 To listBox.SelectedItems.Count - 1
If (listBox.Items(ctr)) = listBox.SelectedItem Then
Output1(games.Keys(ctr))
Output(games.Values(ctr))
End If
Next

End Sub

Sub Window_Loaded()
listBox.Items.Add("Counter Strike")
list1.Add("Counter Strike", "Barilan")

End Sub


End Class




Eto naman po XAML nung design nung Form ko.

<Grid Background="#FFE41E1E" Margin="0,0,3.2,-1.8">
<Grid.RowDefinitions>
<RowDefinition Height="184*"/>
<RowDefinition Height="11*"/>
</Grid.RowDefinitions>
<Label Content="Search:" Height="28" HorizontalAlignment="Left" Margin="26,10,0,0" Name="Label1" VerticalAlignment="Top" Width="48" />
<Button Content="Find..." Height="28" HorizontalAlignment="Left" Margin="419,12,0,0" Name="btnFind" VerticalAlignment="Top" Width="152" />
<TextBox Height="19" HorizontalAlignment="Left" Margin="95,12,0,0" x:Name="txtInput" VerticalAlignment="Top" Width="298" />
<Button Content="Add" Height="23" HorizontalAlignment="Left" Margin="420,54,0,0" x:Name="btnAdd" VerticalAlignment="Top" Width="44" />
<Button Content="Update" Height="23" HorizontalAlignment="Left" Margin="472,54,0,0" Name="btnUpdate" VerticalAlignment="Top" Width="50" />
<Button Content="Del" Height="23" HorizontalAlignment="Left" Margin="527,54,0,0" x:Name="btnDel" VerticalAlignment="Top" Width="45" />
<TextBox x:Name="txtgameName" Height="39" HorizontalAlignment="Left" Margin="95,40,0,0" VerticalAlignment="Top" Width="298" />
<TextBox Height="280" HorizontalAlignment="Left" Margin="95,122,0,0" x:Name="txtgameDec" VerticalAlignment="Top" Width="298" />
<ListBox x:Name="listBox" HorizontalAlignment="Left" Height="280" Margin="420,122,0,0" VerticalAlignment="Top" Width="151" FontFamily="Showcard Gothic">
<ListBoxItem FontFamily="Lucida Bright"/>
</ListBox>
<Label x:Name="Label3" Content="List of Games:" HorizontalAlignment="Left" Margin="421,84,0,0" VerticalAlignment="Top" Width="151" FontSize="21.333"/>
<Label x:Name="Label2" Content="Description:" HorizontalAlignment="Left" Margin="95,84,0,0" VerticalAlignment="Top" Width="298" FontSize="21.333"/>
</Grid>


eto po ung sample result:


View attachment 286091

 

[wilsonpoyjuance]

hi guys. bago lang po ako dito.
pahelp naman sa vb.net and crystal report.


nakaka gawa naman ako ng maayos dito, i am using XML to connect to my database, wc is mysql.

ang problem ko lang po pag na publish ko na yung project at naging EXE na di na gumaagana ng maayos yung crystal report,

anyone help me regarding with this one? or baka malli lang ako nag pag export. please help me..

 

[macroboytron]

hi guys. bago lang po ako dito.
pahelp naman sa vb.net and crystal report.


nakaka gawa naman ako ng maayos dito, i am using XML to connect to my database, wc is mysql.

ang problem ko lang po pag na publish ko na yung project at naging EXE na di na gumaagana ng maayos yung crystal report,

anyone help me regarding with this one? or baka malli lang ako nag pag export. please help me..

pag sa deployment, dapat install mo yung pre requisite.. like for example kung yung program mo is build sa 3.5 framework.. dapat may naka install na framework dun sa pc na pag dedeployan mo, or kasama yan installation ng program mo.

 

[zoom707]

Hi guys just wanna ask gagawa kasi ako ng program from vb.net transfered sa ms.access ang database tapos pag ipprint pwede din lumabas sa excel yung data? If pwede paano po. Tia

 

[fallen13]

May solution ba na makakapagcreate ng report(quarterly report) without using crystal report? If meron pashare naman mga sir TIA

 

[URAZKY]

Hi Guys,

I have question po pano gagawin let say my ginawa kasi akong program gumagamit siya ng web camera (image capturing). gusto ko sana once na capture ko na yung image automatic mag white background siya. hindi ko po alam pano gagawin patulong naman po. salamat.