Wednesday, May 13, 2015

VB.NET inventory management system Form designing models with report page


Form Designing Models with Report Page                        

  
  The various services incorporated in this project are employee with salary details, expenses, purchase details, sales details, report generation and administration. The stock details handle the changes of the cost add new, details about the stock available in each company, products and its item. It also has the facility to report the damaged product. The Stock deals with billing and service to the customer such as returning the products and damaged items. The employee deals with the employee personal details and salary details   . The administrator is control the overall system has the power to place the order for stock. It also has the privilege like adding a new company, new item, deleting a company and its item.                 

 Loading Form

  

Login Form



















Main Form(MDI)


 


































Report Page Models


















Database MS SQL 2005


USE [soft]

GO
/****** Object:  Table [dbo].[Do_s2_rop112]    Script Date: 03/22/2012 15:22:29 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Do_s2_rop112](
[SR-No] [int] NULL,
[Pro_ID] [nchar](15) NOT NULL,
[particular] [varchar](250) NULL,
[cost] [nchar](10) NULL,
[Stock] [nchar](10) NULL,
 CONSTRAINT [PK_Do_s2_rop112] PRIMARY KEY CLUSTERED 
(
[Pro_ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[padma_textile]    Script Date: 03/22/2012 15:22:47 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[padma_textile](
[SR-No] [int] NULL,
[Pro_ID] [varchar](150) NOT NULL,
[particular] [varchar](250) NULL,
[cost] [nchar](10) NULL,
[Stock] [nchar](10) NULL,
 CONSTRAINT [PK_padma_textile_1] PRIMARY KEY CLUSTERED 
(
[Pro_ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Company_Detsils]    Script Date: 03/22/2012 15:22:23 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Company_Detsils](
[Com_ID] [nchar](15) NOT NULL,
[Com_name] [varchar](50) NULL,
[cont_name] [varchar](150) NULL,
[Billing_Addr] [varchar](max) NULL,
[city] [varchar](150) NULL,
[state] [varchar](150) NULL,
[country] [varchar](150) NULL,
[Zip_code] [int] NULL,
[email] [varchar](150) NULL,
[Url] [varchar](150) NULL,
[telp_no] [nchar](15) NULL,
[mobile] [nchar](15) NULL,
[fax] [nchar](15) NULL,
[App_tax] [nchar](10) NULL,
[descr] [varchar](max) NULL,
 CONSTRAINT [PK_Company_Detsils] PRIMARY KEY CLUSTERED 
(
[Com_ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Suplayer_details]    Script Date: 03/22/2012 15:23:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Suplayer_details](
[Sup_ID] [varchar](50) NOT NULL,
[Com_name] [varchar](100) NULL,
[con_name] [varchar](150) NULL,
[Sup_address] [varchar](max) NULL,
[city] [varchar](150) NULL,
[state] [varchar](150) NULL,
[country] [varchar](150) NULL,
[zip_code] [int] NULL,
[Email] [varchar](150) NULL,
[URL] [varchar](250) NULL,
[Telp_No] [nchar](20) NULL,
[Mobile_no] [nchar](20) NULL,
[Fax] [nchar](20) NULL,
 CONSTRAINT [PK_Suplayer_details] PRIMARY KEY CLUSTERED 
(
[Sup_ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Damage_Items]    Script Date: 03/22/2012 15:22:27 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Damage_Items](
[No] [nchar](15) NOT NULL,
[Sup_ID] [nvarchar](50) NOT NULL,
[Date] [varchar](150) NULL,
[category] [nchar](15) NULL,
[Cmp_name] [varchar](150) NULL,
[Cont_name] [varchar](100) NULL,
[Mobile_no] [nchar](15) NULL,
[Pro_No] [nchar](20) NULL,
[Pro_name] [varchar](150) NULL,
[cost] [nchar](15) NULL,
[No_damages] [nchar](10) NULL,
[Total_amount] [nchar](10) NULL,
 CONSTRAINT [PK_Damage_Items_1] PRIMARY KEY CLUSTERED 
(
[No] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Employee_details]    Script Date: 03/22/2012 15:22:33 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Employee_details](
[Emp_id] [varchar](50) NOT NULL,
[Emp_Name] [varchar](150) NULL,
[Father_name] [varchar](150) NULL,
[desig] [varchar](100) NULL,
[department] [varchar](150) NULL,
[date_bir] [varchar](50) NULL,
[experi] [nchar](10) NULL,
[sex] [nchar](10) NULL,
[Basic_pay] [varchar](50) NULL,
[Address] [varchar](500) NULL,
[city] [varchar](150) NULL,
[state] [varchar](150) NULL,
[country] [varchar](150) NULL,
[zip_code] [nchar](15) NULL,
[Email] [varchar](150) NULL,
[tel_no] [nchar](15) NULL,
[mobile] [nchar](15) NULL,
 CONSTRAINT [PK_Employee_details] PRIMARY KEY CLUSTERED 
(
[Emp_id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[expensses_details]    Script Date: 03/22/2012 15:22:36 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[expensses_details](
[Expe_code] [nchar](15) NOT NULL,
[Report_date] [varchar](50) NULL,
[Bs_purpose] [varchar](250) NULL,
[Emp_id] [nchar](15) NULL,
[emp_name] [varchar](150) NULL,
[Mobile] [nchar](15) NULL,
[date] [varchar](50) NULL,
[category] [varchar](50) NULL,
[descri] [varchar](50) NULL,
[Amount] [nchar](10) NULL,
 CONSTRAINT [PK_ecpensses_details] PRIMARY KEY CLUSTERED 
(
[Expe_code] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[purchase_details]    Script Date: 03/22/2012 15:22:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[purchase_details](
[pur_no] [nchar](15) NOT NULL,
[pur_date] [varchar](150) NULL,
[Suplier_id] [nchar](15) NULL,
[Com_name] [varchar](150) NULL,
[Mobile] [nchar](15) NULL,
[Pro_Id] [nchar](15) NULL,
[Pro_name] [varchar](150) NULL,
[cost] [nchar](15) NULL,
[QTY] [nchar](15) NULL,
[Total_amount] [nchar](20) NULL,
 CONSTRAINT [PK_purchase_details] PRIMARY KEY CLUSTERED 
(
[pur_no] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Shipping_details]    Script Date: 03/22/2012 15:22:57 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Shipping_details](
[Ship_Id] [nchar](15) NOT NULL,
[Invoice_id] [nchar](15) NULL,
[date] [datetime] NULL,
[Com_Id] [nchar](15) NULL,
[Com_name] [varchar](150) NULL,
[To_Com] [varchar](max) NULL,
[working_day] [nchar](30) NULL,
[Shi_method] [varchar](50) NULL,
[Pro_Id] [nchar](15) NULL,
[Pro_name] [varchar](250) NULL,
[qty] [nchar](10) NULL,
[Cost] [float] NULL,
[Amount] [float] NULL,
 CONSTRAINT [PK_Shipping_details] PRIMARY KEY CLUSTERED 
(
[Ship_Id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Order_DO2S]    Script Date: 03/22/2012 15:22:42 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Order_DO2S](
[Invoice_og] [nchar](15) NOT NULL,
[date_to] [datetime] NULL,
[Invoice_no] [varchar](50) NULL,
[com_ID] [nchar](15) NULL,
[com_name] [varchar](150) NULL,
[Pro_ID] [varchar](150) NULL,
[proname] [nchar](100) NULL,
[Qty] [int] NULL,
[Rate] [int] NULL,
[Amount] [int] NULL,
 CONSTRAINT [PK_Order_DO2S] PRIMARY KEY CLUSTERED 
(
[Invoice_og] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Purchase_Return]    Script Date: 03/22/2012 15:22:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Purchase_Return](
[Index_no] [nchar](15) NOT NULL,
[Purchse_no] [nchar](20) NULL,
[Purchse_date] [datetime] NULL,
[Issued_date] [datetime] NULL,
[Category] [nchar](20) NULL,
[Sup_ID] [nchar](15) NULL,
[Cmp_name] [varchar](150) NULL,
[Pro_ID] [nchar](15) NULL,
[Pro_name] [varchar](150) NULL,
[cost] [nchar](15) NULL,
[No_damages] [nchar](10) NULL,
[Total_amount] [nchar](15) NULL,
 CONSTRAINT [PK_Purchase_Return] PRIMARY KEY CLUSTERED 
(
[Index_no] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[order_padma]    Script Date: 03/22/2012 15:22:45 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[order_padma](
[invoice_og] [nchar](10) NOT NULL,
[invoice_no] [varchar](50) NULL,
[data_to] [varchar](150) NULL,
[com_ID] [nchar](15) NULL,
[com_name] [varchar](150) NULL,
[Pro_ID] [varchar](150) NULL,
[proname] [nchar](100) NULL,
[Qty] [int] NULL,
[Rate] [int] NULL,
[Amount] [int] NULL,
 CONSTRAINT [PK_order_padma] PRIMARY KEY CLUSTERED 
(
[invoice_og] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[ns1]    Script Date: 03/22/2012 15:22:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ns1](
[nasme] [nchar](10) NULL,
[id] [nchar](10) NOT NULL,
[add] [nchar](10) NULL,
 CONSTRAINT [PK_ns1] PRIMARY KEY CLUSTERED 
(
[id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[ns2]    Script Date: 03/22/2012 15:22:39 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ns2](
[Id] [nchar](10) NOT NULL,
[name] [nchar](10) NULL,
[phone] [nchar](10) NULL,
[bb] [image] NULL,
 CONSTRAINT [PK_ns2] PRIMARY KEY CLUSTERED 
(
[Id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object:  ForeignKey [FK_ns2_ns2]    Script Date: 03/22/2012 15:22:39 ******/
ALTER TABLE [dbo].[ns2]  WITH CHECK ADD  CONSTRAINT [FK_ns2_ns2] FOREIGN KEY([name])
REFERENCES [dbo].[ns1] ([id])
GO
ALTER TABLE [dbo].[ns2] CHECK CONSTRAINT [FK_ns2_ns2]
GO

Posted by at No comments:

Thursday, May 7, 2015

How can solve the error ORA-12560: TNS:protocol adapter error


How can solve the error ORA-12560: TNS:protocol adapter error


Mainly this error consisting Oracle services. May be that Services had stopped then “ORA-12560: TNS:protocol adapter error” will be showing .there are the main three

  1)OracleXEClrAgent 
 2)OracleXETNSListener 
 3)OracleServiceXE



















Jest open the RUN >enter  'services' 




















click the right button on the OracleServiceXE then Start the service  problem will solve





Posted by at No comments:

Sunday, May 3, 2015

How to start Vb.net Program  Development 


 Step 1: First up on we should open then visual studio 2008 (you can use any version 2010,2012)

 Step 2:and open the file menu then New>>Project

Step 3: Then we will get a new project window we should select the 'Project type' as 'Windows Form application' on template section 
  

Give the Project name and give the project saving location and solution name what we have decided to give the project name then we can fix it on the solution name area




Step 4: Design like that and change the tools name with help of properties the properties name is 

                Text:- to change the caption of tools like total, ok and value 
 and double click the ok button then we will get a source code window like that 


Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim a, b, c As Integer
        a = Val(TextBox1.Text)
        b = Val(TextBox2.Text)
        c = a + b
        TextBox3.Text = c
    End Sub


dim is the public variable declaration a,b,c are the name of the variables  datatype is  integer 

a=val(Textbox1.text) := as per the vb.net  first time all values are string format so we should concert to numeric function for that the Val method is using  




Posted by at No comments:

Induction of the blog

The Green zone projec: Mainly targeted in helping  the students Those who are interested  the  software project development and web designing , they can easily archive their dreams through the blog .We are providing the easiest way for developing any information technology project.Have you been the graduation or post-graduation? Definitely you can complete your project through the Blog.   







Providing languages

  • Vb.Net
  • JAVA Programming
  • Go (programming language)
  • HTML 5

Database Technology

  • Oracle 11g
  • Microsoft SQL Server 2005 and 2008
  • Microsoft Access
  • Sq-lite 

 Job Portal Assistance 
  • Google
  • HCL
  • DELL
  • Wipro
  • Infosys
  • IBM
  • MICROSOFT
  • Flipkart
  • accenture
  • cisco
  • oracle
  • HP











Posted by at No comments:
Subscribe to: Posts (Atom)