What's new
Symbianize Forum

Most of our features and services are available only to members, so we encourage you to login or register a new account. Registration is free, fast and simple. You only need to provide a valid email. Being a member you'll gain access to all member forums and features, post a message to ask question or provide answer, and share or find resources related to mobile phones, tablets, computers, game consoles, and multimedia.

All that and more, so what are you waiting for, click the register button and join us now! Ito ang website na ginawa ng pinoy para sa pinoy!

VB.NET Programming Corner!

Sino po meron ng sourcecode para sa Word Hunt puzzle game sa vb.net pa pm naman po kung meron kayung sourcecode please
 
i have this scenario.

i have a database on access having 5000 records, when i search that on my forms using datagridview, the searching is slow.
is there any other way or resources to make the searching fast?
 
Silentkiller16 said:
i have this scenario.

i have a database on access having 5000 records, when i search that on my forms using datagridview, the searching is slow.
is there any other way or resources to make the searching fast?
Click to expand...

where the code? im browsin 15k at a time, no problem, display instant
 
ericgmejia said:
i made this thread for all programmers starting their adventure in vb.net.

Please post relevant and sensible questions regarding vb.net,
share your knowledge and expertise, share codes and techniques.

Post question on how tos:
How to do this or that, ill supply bits of code to accomplish basic tasks.

Ill be posting series of samples leading to complete applications,
your suggestions are encouraged.
These samples will contain codes relevant to other tasks as well.

Platform = vs2003 to vs2012

i suggest learn and get the feel of vb.net/visual studio ide first before posting questions,
so that we can talk on the same page.


Topics:
Vb.net winforms (not web applications)
ado.net as applied in vb.net
crystal reports on vb.net
sqlserver as used in vb.net
msaccess as used in vb.net
classes
usercontrols

technologies:
Serial - like using sms, barcode and other hardware
tcp/ip - chat applications, sockets, internet applications
msmq - message queuing
remoting - executing assemblies in other computer
webservices - using webservices in windows forms
multithreading - executing more than 1 process at the same time


suggested third party tools:
devxpress 2009 free edition
sqlserver 2005 express edition

suggested references:
http://www.homeandlearn.co.uk/net/vbnet.html
http://www.java2s.com/tutorial/vb/catalogvb.htm

i currently use visual studio 2008 only, but basic codes will apply to all versions

please do not ask for a complete system,
instead use the codes and assistance that you will find here
to build your own system.


***thanks to moderators, sticky na ang thread!

Lets share knowledge so that we can be a more flexible and well rounded programmer. Be it for school or work.

Links:

first post: Populating datagridview using msaccess database
second post : Basic vb.net msaccess tutorial
sqlserver sample
Click to expand...


up for this topic
 
ericgmejia said:
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
Click to expand...

Alam nyo po ba kung pano mapapass yung mga value ng DatGridView papunta sa RDLC Report or Crystal Report?
 
Guys pa tulong naman about getting the sum in row of DataGridView

Example:

Column1 Column2 Column3 Column4
1 --- 1 ---- 1 = 3
2 ---- 2 ---- 2 = 6
3 ---- 3 ---- 3 = 9
4 ---- 4 ---- 4 = 12

Yung parang ganyan, pano makuha in a loop way?
 
Soichiro Jin said:
Guys pa tulong naman about getting the sum in row of DataGridView

Example:

Column1 Column2 Column3 Column4
1 --- 1 ---- 1 = 3
2 ---- 2 ---- 2 = 6
3 ---- 3 ---- 3 = 9
4 ---- 4 ---- 4 = 12

Yung parang ganyan, pano makuha in a loop way?
Click to expand...


pacheck na lang po itong sample program ko.
 

Attachments

  • WindowsApplication7.rar
    630.6 KB · Views: 24
robelisshit said:
pacheck na lang po itong sample program ko.
Click to expand...

Salamat po sir, pano po gawing dynamic? Connected kasi sa database yung data ko.

Example

ID Salary Miscellenaeous DeathContribution Saving TotaNetPay
1 5000 100 50 250 4600


Minsan kasi nag aadd and delete some column kami eh.

Example
ID Salary Miscellenaeous Saving TotaNetPay
1 5000 100 250 4650


Parang ganyan lang sir, nag a'add pa rin kahit dagdagan ng colum or iremove..
 
Guys, patulong naman po ako gusto ko sana mag create sa system ko ng level of permission na may administrator which is full access sa system and user na pde siyang mag view lang, pdeng mag edit, etc. patulong naman po.

Salamat
 
hello, meron po ba kaung tutorial for beginners? gusto ko lng po matuto ng VB.net
 
ericgmejia said:
i made this thread for all programmers starting their adventure in vb.net.

Please post relevant and sensible questions regarding vb.net,
share your knowledge and expertise, share codes and techniques.

Post question on how tos:
How to do this or that, ill supply bits of code to accomplish basic tasks.

Ill be posting series of samples leading to complete applications,
your suggestions are encouraged.
These samples will contain codes relevant to other tasks as well.

Platform = vs2003 to vs2012

i suggest learn and get the feel of vb.net/visual studio ide first before posting questions,
so that we can talk on the same page.


Topics:
Vb.net winforms (not web applications)
ado.net as applied in vb.net
crystal reports on vb.net
sqlserver as used in vb.net
msaccess as used in vb.net
classes
usercontrols

technologies:
Serial - like using sms, barcode and other hardware
tcp/ip - chat applications, sockets, internet applications
msmq - message queuing
remoting - executing assemblies in other computer
webservices - using webservices in windows forms
multithreading - executing more than 1 process at the same time


suggested third party tools:
devxpress 2009 free edition
sqlserver 2005 express edition

suggested references:
http://www.homeandlearn.co.uk/net/vbnet.html
http://www.java2s.com/tutorial/vb/catalogvb.htm

i currently use visual studio 2008 only, but basic codes will apply to all versions

please do not ask for a complete system,
instead use the codes and assistance that you will find here
to build your own system.


***thanks to moderators, sticky na ang thread!

Lets share knowledge so that we can be a more flexible and well rounded programmer. Be it for school or work.

Links:

first post: Populating datagridview using msaccess database
second post : Basic vb.net msaccess tutorial
sqlserver sample
Click to expand...


thankyouu dito
 
ericgmejia said:
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
Click to expand...



Mga Master may sample po ba kayo kung paano gumawa nang VPN for PC , then naka connect sa openvpn , i think openvpn lang nya then minomodify lang nila ,..
 
You must log in or register to reply here.

Similar threads

raven2709
Android (Kotlin & Java) Programming Corner!
Replies
1
Views
457
manlors
manlors
TambayBlues
Visual Studio 2023 - The Most Concise and Detailed Guide to Mastering all the Features and the Use of Visual Studio
Replies
0
Views
239
TambayBlues
TambayBlues
TambayBlues
Hands-On Visual Studio 2022: A Developer's Guide to New Features and Best Practices with .NET 8 and VS 2022 for Maximum Productivity, 2nd Edition
Replies
0
Views
267
TambayBlues
TambayBlues
Aimershin
[Udemy Course] PHP Registration Form, Email Verification & Responsive Email | Direct Download | Requested
Replies
7
Views
548
poiqwe
P
mythos
Cybersecurity Monitoring & Detection Lab
Replies
16
Views
1K
linuxspecialist
L
Back
Top Bottom