HomeОбразованиеRelated VideosMore From: 1BestCsharp blog

VB.Net Inventory Management System Source Code ( visual basic .net project with mysql database )

138 ratings | 37979 views
VB.Net Sales and Inventory Management System ▶ Source Code: http://1bestcsharp.blogspot.com/2018/04/vbnet-inventory-system-source-code.html All My Programming Projects Here --- http://bit.ly/2HrU8hK My Source Code Store --- http://bit.ly/2OsC0TU VB.Net Course -- http://bit.ly/2wnNiVt subscribe: http://goo.gl/nRjPKk This Project Is Created Using .net technology (windows form) - visual basic .net programming language. - visual studio express 2013. - mysql database - canva.com for images - flatuicolorpicker.com for colors - iTextSharp (PDF library). this visual basic.net inventory system project can do: in this project if you login as an user with the user type user you can: in products tab: - add,edit,remove the selected product - display all products from mysql database into datagridview. - search products. in categories tab: - insert,update,delete selected category - show all categories from mysql database into datagridview. - when you select a category from the datagridview the products in this category will show up on a listbox - if you double click on the category a new form will show up with all products data in this category - navigate between categories using two buttons next and previous - button to clear textboxes in customers tab: - insert,update,delete selected customer - show all customers from mysql database into datagridview. - navigate between customers using two buttons next and previous - button to clear textboxes - when you select a customer, 1)set the customer data into textboxes, 2) get the customer number orders, 3) get the customer total orders amount, 4) get the customer last order date in orders tab: - when the order from will show up you can see 3 datagridview one for the customers, one for the products, and another for the products you want to add in the order - you can see the selected customer orders - you can display pro depending on the category you want using combobox - you can add a new customer - show all the orders - add the products you want to the order and select the quantity you want - remove the products you want from the order but if you login as an user with the user type admin you can a unique tab visible only for the admin, it's the user tab in users tab: - add,edit,remove the selected user share this video with your friends: https://youtu.be/qjHx7Rf5QIk c# version: https://youtu.be/tF7zShUZG7E
Html code for embedding videos on your blog
Text Comments (38)
Emman Oliver Dizon (1 day ago)
sir can we talk about the system? my email is [email protected] please
DK FUNKER (5 days ago)
i need this project
1BestCsharp blog (5 days ago)
link in the description
how to chang for db file visual utf8 because iam writing text arabic not work (???? )
thank you iam testing but i have questions i have visual 2010 and server php mysql i can to run without problem
Muhammad Shafiq (2 months ago)
Hi sir, I've seen the code and how you make the calculation ? I cant find
Muhammad Shafiq (1 month ago)
+1BestCsharp blog thanks !
1BestCsharp blog (2 months ago)
Muhammad Shafiq (2 months ago)
+1BestCsharp blog the calculation of the total price, just wanna see the code but i couldnt find it
1BestCsharp blog (2 months ago)
what calculation ?
Niel Jefferson Verdon (2 months ago)
How to subtract the quantity of database? Thanks for the help :))
jv pacadaljen (2 months ago)
tnx to help sir...
Simon205 (4 months ago)
hae someone help me am trying to display all images from mysl database but it keep showing just the first row here is my code try { String sql="select *from product"; pst=conn.prepareStatement(sql); rs = pst.executeQuery(); rs.next(); if (rs.next()); // while(rs.next()){ String add1 = rs.getString("pro_price"); jLabel80.setText(add1); String add2 = rs.getString("pro_name"); jLabel81.setText(add2); String add3 = rs.getString("pro_qty"); jLabel82.setText(add3); String add4 = rs.getString("pro_id"); jLabel83.setText(add4); BufferedImage im = ImageIO.read(rs.getBinaryStream("pro_image")); jLabel79.setIcon(new ImageIcon(im)); // } } catch (Exception err) { JOptionPane.showMessageDialog(this, err.getMessage()); }
1BestCsharp blog (4 months ago)
why are you posting a java code in a vb.net video anyway remove rs.next(); if (rs.next()); and use only -> while(rs.next()){
Hoobal Media (5 months ago)
why it is not freee
Villie Rae (5 months ago)
Thought this is for free. Lol.
Jerry Lucas (8 months ago)
can you make a sample project with report viewer?
joevenel tayong (9 months ago)
Good Day sir! Can I have a clue when you double click on the category a new form will show up with all products data in the category. Thanks a lot God bless you..
Jonathan Ismaila (3 months ago)
You could use Dim MyConn as SqlConnection (.....your connection string here...) Dim Query as String =Select * from Categories where CategoryName = @CatName Dim CmdCategory as New SqlCommand (Query, MyConn) CmdCategory.Parameters.Add("@CatName",SqlDbType.VarChar).Value=Listbox1.text Dim da as New SqlDataAdapter(cmd) Dim ds as Dataset da.fill(ds.tables(0)) DataGridView1.DataSource=ds.tables(0) Note: I assume you click a listbox which you already fulled with the category names. And you have a datagrid on your form which you want to display the data in.
joevenel tayong (7 months ago)
how did you make display the category list when you click the specific product name like for instance computer and then all the list are drop down in form. :) Thank you..
1BestCsharp blog (9 months ago)
and what's the question ?
Mark Reyes (10 months ago)
i am new here and i want to ask how can i connect the xampp mysql in visual studio 2012 is there a tuitorial pls help me
1BestCsharp blog (10 months ago)
open xampp and start apache & mysql and create the database "invetory_db" using "invetory_db.sql" script
Mark Reyes (10 months ago)
i already purchase the project and i did import the invetory_db.sql but the problem is "MySqlException was unhandled"
Adrian Ayala (11 months ago)
This project will make it step by step too?
Adrian Ayala (9 months ago)
you do not have the video tutorial of this system to sell it with the code?
Adrian Ayala (11 months ago)
1BestCsharp blog (11 months ago)
Christmas Song (11 months ago)
Do you have attendance system? Thanks
1BestCsharp blog (11 months ago)
Karleez Deak (11 months ago)
As usual, very good project and nothing to say 👍👍👍
Hoobal Media (5 months ago)
bro it is asking me money to buy project
Karleez Deak (11 months ago)
Hi 1BestCsharp I take almost all your classes and I am really impressed by all your efforts and I thank you for it. I'm stuck on the student information system project in java swing course. and I would please humbly ask you to send me all the source code of the project to this email address [email protected] Courage for future projects and thanks in advance. Sincerely .
G.VICKNESH VICKI (11 months ago)
Masss project
Djs Tech (11 months ago)
i need Student info project how to buy ?
Djs Tech (11 months ago)
Problem with my Card My card is Rupay Debit card

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.