منتدى فيجوال بيسك لكل العرب | منتدى المبرمجين العرب

منتدى فيجوال بيسك لكل العرب | منتدى المبرمجين العرب > قسم لغة الفيجوال بيسك VB.NET > قسم اسئلة VB.NET > جلب بيانات من اكثر من جدول
نسخة كاملة : جلب بيانات من اكثر من جدول
أنت حالياً تتصفح نسخة خفيفة من المنتدى . مشاهدة نسخة كاملة مع جميع الأشكال الجمالية .
الصفحات : 1 2 3

عبد الخالق

27-07-23, 05:59 PM
(27-07-23, 12:55 PM)ahmed_king2023 كتب : [ -> ]اخي توجد مشكلة في موقع
قمت برفعه علي ميديا فاير
https://www.mediafire.com/file/j2qjegwte...s.rar/file

للاسف المشروع يتضمن ادوات DevExpress فلن يعمل عندي و سكريبت القاعده غير مرفقه

اعمل مشروع جديد بدون ادوات خارجيه بنافذة واحده لعرض ناتج الاستعلام و رفع ملف القاعده مع سكريبت القاعده متضمنه بيانات

ahmed_king2023

27-07-23, 07:24 PM
عملت مشروع قاعدة بيانات اسمه HR
http://www.mediafire.com/file/20c0aam0tk...tion24.rar

عبد الخالق

27-07-23, 08:02 PM
(27-07-23, 07:24 PM)ahmed_king2023 كتب : [ -> ]عملت مشروع قاعدة بيانات اسمه HR
http://www.mediafire.com/file/20c0aam0tk...tion24.rar

اين القاعده او سكريبت القاعده
لا تعمل backup ارسل الملف او سكريبت

ahmed_king2023

27-07-23, 08:28 PM
USE [master]
GO

/****** Object: Database
Script Date: 27/07/2023 06:13:23 م ******/
CREATE DATABASE
CONTAINMENT = NONE
ON PRIMARY
( NAME = N'HR', FILENAME = N'D:\Microsoft SQL Server\MSSQL12.AYMEN\MSSQL\DATA\HR.mdf' , SIZE = 3072KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
LOG ON
( NAME = N'HR_log', FILENAME = N'D:\Microsoft SQL Server\MSSQL12.AYMEN\MSSQL\DATA\HR_log.ldf' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
GO
USE
GO
/****** Object: Table [dbo].[dept] Script Date: 27/07/2023 06:20:43 م ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[dept](
[dept_id] [int] IDENTITY(1,1) NOT NULL,
[dept_name] [nvarchar](150) NULL,
[id_mange] [int] NULL,
[employee_id] [int] NULL,
CONSTRAINT [PK_dept] PRIMARY KEY CLUSTERED
(
[dept_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].[Employees] Script Date: 27/07/2023 06:20:43 م ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Employees](
[id] [int] IDENTITY(1,1) NOT NULL,
[EmployeeID] [int] NOT NULL,
[EmployeeName] [nvarchar](150) NULL,
[Nationality] [nvarchar](150) NULL,
[Gender] [nvarchar](50) NULL,
[phone] [varchar](150) NULL,
CONSTRAINT [PK_Employees] PRIMARY KEY CLUSTERED
(
[EmployeeID] 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].[management] Script Date: 27/07/2023 06:20:43 م ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[management](
[id] [int] IDENTITY(1,1) NOT NULL,
[manage_name] [nvarchar](150) NULL,
[employee_id] [int] NULL,
CONSTRAINT [PK_management] 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].[unit] Script Date: 27/07/2023 06:20:43 م ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[unit](
[id] [int] IDENTITY(1,1) NOT NULL,
[unit_name] [nvarchar](150) NULL,
[dept_id] [int] NULL,
[employee_id] [int] NULL,
CONSTRAINT [PK_unit] 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

عبد الخالق

27-07-23, 08:55 PM
(27-07-23, 08:28 PM)ahmed_king2023 كتب : [ -> ]USE [master]
GO

/****** Object: Database
Script Date: 27/07/2023 06:13:23 م ******/
CREATE DATABASE
CONTAINMENT = NONE
ON PRIMARY
( NAME = N'HR', FILENAME = N'D:\Microsoft SQL Server\MSSQL12.AYMEN\MSSQL\DATA\HR.mdf' , SIZE = 3072KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
LOG ON
( NAME = N'HR_log', FILENAME = N'D:\Microsoft SQL Server\MSSQL12.AYMEN\MSSQL\DATA\HR_log.ldf' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
GO
USE
GO
/****** Object: Table [dbo].[dept] Script Date: 27/07/2023 06:20:43 م ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[dept](
[dept_id] [int] IDENTITY(1,1) NOT NULL,
[dept_name] [nvarchar](150) NULL,
[id_mange] [int] NULL,
[employee_id] [int] NULL,
CONSTRAINT [PK_dept] PRIMARY KEY CLUSTERED
(
[dept_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].[Employees] Script Date: 27/07/2023 06:20:43 م ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Employees](
[id] [int] IDENTITY(1,1) NOT NULL,
[EmployeeID] [int] NOT NULL,
[EmployeeName] [nvarchar](150) NULL,
[Nationality] [nvarchar](150) NULL,
[Gender] [nvarchar](50) NULL,
[phone] [varchar](150) NULL,
CONSTRAINT [PK_Employees] PRIMARY KEY CLUSTERED
(
[EmployeeID] 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].[management] Script Date: 27/07/2023 06:20:43 م ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[management](
[id] [int] IDENTITY(1,1) NOT NULL,
[manage_name] [nvarchar](150) NULL,
[employee_id] [int] NULL,
CONSTRAINT [PK_management] 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].[unit] Script Date: 27/07/2023 06:20:43 م ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[unit](
[id] [int] IDENTITY(1,1) NOT NULL,
[unit_name] [nvarchar](150) NULL,
[dept_id] [int] NULL,
[employee_id] [int] NULL,
CONSTRAINT [PK_unit] 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

هذا السكريبت فيه تكوين الجدوال فقط ولم يتضمن بيانات
اعد السكريبت ولكن قم بتضمين البيانات
ايضا لم اجد الاستعلام الذي في اول الموضوع
قم بعمل سكريبت لكامل قاعده البيانات بشمل البيانات والاجراءات المخزنه ايضا

ahmed_king2023

27-07-23, 09:15 PM
CREATE TABLE [dbo].[dept](
[dept_id] [int] IDENTITY(1,1) NOT NULL,
[dept_name] [nvarchar](150) NULL,
[id_mange] [int] NULL,
[employee_id] [int] NULL,
CONSTRAINT [PK_dept] PRIMARY KEY CLUSTERED
(
[dept_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]
CREATE TABLE [dbo].[Employees](
[id] [int] IDENTITY(1,1) NOT NULL,
[EmployeeID] [int] NOT NULL,
[EmployeeName] [nvarchar](150) NULL,
[Nationality] [nvarchar](150) NULL,
[Gender] [nvarchar](50) NULL,
[phone] [varchar](150) NULL,
CONSTRAINT [PK_Employees] PRIMARY KEY CLUSTERED
(
[EmployeeID] 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
CREATE TABLE [dbo].[management](
[id] [int] IDENTITY(1,1) NOT NULL,
[manage_name] [nvarchar](150) NULL,
[employee_id] [int] NULL,
CONSTRAINT [PK_management] 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
CREATE TABLE [dbo].[unit](
[id] [int] IDENTITY(1,1) NOT NULL,
[unit_name] [nvarchar](150) NULL,
[dept_id] [int] NULL,
[employee_id] [int] NULL,
CONSTRAINT [PK_unit] 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
اخي لديك اسماء جدوال وحقوله في سكربت فوق

عبد الخالق

27-07-23, 09:52 PM
(27-07-23, 09:15 PM)ahmed_king2023 كتب : [ -> ]CREATE TABLE [dbo].[dept](
[dept_id] [int] IDENTITY(1,1) NOT NULL,
[dept_name] [nvarchar](150) NULL,
[id_mange] [int] NULL,
[employee_id] [int] NULL,
CONSTRAINT [PK_dept] PRIMARY KEY CLUSTERED
(
[dept_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]
CREATE TABLE [dbo].[Employees](
[id] [int] IDENTITY(1,1) NOT NULL,
[EmployeeID] [int] NOT NULL,
[EmployeeName] [nvarchar](150) NULL,
[Nationality] [nvarchar](150) NULL,
[Gender] [nvarchar](50) NULL,
[phone] [varchar](150) NULL,
CONSTRAINT [PK_Employees] PRIMARY KEY CLUSTERED
(
[EmployeeID] 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
CREATE TABLE [dbo].[management](
[id] [int] IDENTITY(1,1) NOT NULL,
[manage_name] [nvarchar](150) NULL,
[employee_id] [int] NULL,
CONSTRAINT [PK_management] 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
CREATE TABLE [dbo].[unit](
[id] [int] IDENTITY(1,1) NOT NULL,
[unit_name] [nvarchar](150) NULL,
[dept_id] [int] NULL,
[employee_id] [int] NULL,
CONSTRAINT [PK_unit] 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
اخي لديك اسماء جدوال وحقوله في سكربت فوق

اخي هل تعرف ما المقصود بالبيانات؟ المقصود Schema and Data لاني لم اجد بيانات لاجرب عليها الاستعلام

ايضا لم اجد الاستعلام الذي في اول الموضوع!
هل هود Stored Procedure؟

ahmed_king2023

28-07-23, 12:42 AM
اخي قاعده بيانات جديده تعتبر لايوجد لدي اي اجراء مخزن او بيانات جديده قاعده
انا اريد مثلا كيفية بحيث عندما ابحث عن موظف يظهر لي اي ادارة يتبع واي قسم واي وحدة
موظف عبد الخالق ادارة موارد بشرية قسم شؤون موظفين وحدة ملاك وظيفي
هدا سكربت
USE
GO
/****** Object: Table [dbo].[dept] Script Date: 27/07/2023 10:40:13 م ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[dept](
[dept_id] [int] IDENTITY(1,1) NOT NULL,
[dept_name] [nvarchar](150) NULL,
[id_mange] [int] NULL,
[employee_id] [int] NULL,
CONSTRAINT [PK_dept] PRIMARY KEY CLUSTERED
(
[dept_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].[Employees] Script Date: 27/07/2023 10:40:13 م ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Employees](
[id] [int] IDENTITY(1,1) NOT NULL,
[EmployeeID] [int] NOT NULL,
[EmployeeName] [nvarchar](150) NULL,
[Nationality] [nvarchar](150) NULL,
[Gender] [nvarchar](50) NULL,
[phone] [varchar](150) NULL,
CONSTRAINT [PK_Employees] PRIMARY KEY CLUSTERED
(
[EmployeeID] 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].[management] Script Date: 27/07/2023 10:40:13 م ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[management](
[id] [int] IDENTITY(1,1) NOT NULL,
[manage_name] [nvarchar](150) NULL,
[employee_id] [int] NULL,
CONSTRAINT [PK_management] 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].[unit] Script Date: 27/07/2023 10:40:13 م ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[unit](
[id] [int] IDENTITY(1,1) NOT NULL,
[unit_name] [nvarchar](150) NULL,
[dept_id] [int] NULL,
[employee_id] [int] NULL,
CONSTRAINT [PK_unit] 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
SET IDENTITY_INSERT [dbo].[management] ON

INSERT [dbo].[management] ([id], [manage_name], [employee_id]) VALUES (2, N'ادارة الموارد البشرية', NULL)
INSERT [dbo].[management] ([id], [manage_name], [employee_id]) VALUES (4, N'ادارة الشؤون الادارية', NULL)
SET IDENTITY_INSERT [dbo].[management] OFF
رقم وظيفي هو employee_id
بحيث يميز موظف عن الاخر
عندما ابحث عن موظف يكون هو يميزه عن موظف اخر

عبد الخالق

28-07-23, 02:17 AM
(28-07-23, 12:42 AM)ahmed_king2023 كتب : [ -> ]اخي قاعده بيانات جديده تعتبر لايوجد لدي اي اجراء مخزن او بيانات جديده قاعده
انا اريد مثلا كيفية بحيث عندما ابحث عن موظف يظهر لي اي ادارة يتبع واي قسم واي وحدة
موظف عبد الخالق ادارة موارد بشرية قسم شؤون موظفين وحدة ملاك وظيفي
هدا سكربت
USE
GO
/****** Object:  Table [dbo].[dept]    Script Date: 27/07/2023 10:40:13 م ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[dept](
[dept_id] [int] IDENTITY(1,1) NOT NULL,
[dept_name] [nvarchar](150) NULL,
[id_mange] [int] NULL,
[employee_id] [int] NULL,
CONSTRAINT [PK_dept] PRIMARY KEY CLUSTERED
(
[dept_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].[Employees]    Script Date: 27/07/2023 10:40:13 م ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Employees](
[id] [int] IDENTITY(1,1) NOT NULL,
[EmployeeID] [int] NOT NULL,
[EmployeeName] [nvarchar](150) NULL,
[Nationality] [nvarchar](150) NULL,
[Gender] [nvarchar](50) NULL,
[phone] [varchar](150) NULL,
CONSTRAINT [PK_Employees] PRIMARY KEY CLUSTERED
(
[EmployeeID] 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].[management]    Script Date: 27/07/2023 10:40:13 م ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[management](
[id] [int] IDENTITY(1,1) NOT NULL,
[manage_name] [nvarchar](150) NULL,
[employee_id] [int] NULL,
CONSTRAINT [PK_management] 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].[unit]    Script Date: 27/07/2023 10:40:13 م ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[unit](
[id] [int] IDENTITY(1,1) NOT NULL,
[unit_name] [nvarchar](150) NULL,
[dept_id] [int] NULL,
[employee_id] [int] NULL,
CONSTRAINT [PK_unit] 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
SET IDENTITY_INSERT [dbo].[management] ON

INSERT [dbo].[management] ([id], [manage_name], [employee_id]) VALUES (2, N'ادارة الموارد البشرية', NULL)
INSERT [dbo].[management] ([id], [manage_name], [employee_id]) VALUES (4, N'ادارة الشؤون الادارية', NULL)
SET IDENTITY_INSERT [dbo].[management] OFF
رقم وظيفي هو employee_id
بحيث يميز موظف عن الاخر
عندما ابحث عن موظف يكون هو يميزه عن موظف اخر

حاولت اطبق الاستعلام في اول الموضوع على مشروعك الاخير خصوصا السكريبت
فحصل رفض لان اسماء الجداول اتغيرت

ahmed_king2023

28-07-23, 07:37 PM
قمت بتطبيق علي سكربت جديد انا بحاجة الي مشروع
الصفحات : 1 2 3
منتدى فيجوال بيسك لكل العرب | منتدى المبرمجين العرب > قسم لغة الفيجوال بيسك VB.NET > قسم اسئلة VB.NET > جلب بيانات من اكثر من جدول