ahmedsa

Hi guys I make program to select data every day automatically by timer every second in c# In sql server 2005 i write the following query ALTER proc [dbo].[JeddahSalesAll] as SELECT ROW_NUMBER() OVER (ORDER BY dbo.[Jeddah-Live$Sales Header].No_) AS [S.N], dbo.[Jeddah-Live$Sales Line].[Document No_] AS 'OrderNo', dbo.[Jeddah-Live$Sales Header].[Bill-to Name] AS 'CustomerNo', dbo.[Jeddah-Live$Sales …

Hi guys i have problem this code send email based on timer every 5 minutes it working ok but my problem i need to determine first rcord updated not inserted and send email this is starting work this is my code Sales.SalesClass SalesClass1 = new Sales.SalesClass(); DataTable dt = SalesClass1.ShowSalesData("Data …

In this website there are strange thing or missing point Database is : http://files.engineering.com/getfile.aspx?folder=d93b360c-2dad-41da-bd63-23327dae5863&file=Database.JPG see no 15,16 different in language Interface PHP See Difference http://files.engineering.com/getfile.aspx?folder=9fc7f64f-6800-4427-baa6-ef05f3431839&file=PHP_WEB.JPG same interface code but different only in language How to change ???? to الصيانه i set collision for table is utf8_general_ci i set collision for …

suppose i need to make update the employee as following CREATE PROC UPDATE_EMPLOYEE ( @EmployeeID INT, @EmployeeName NVARCHAR(50) ) AS update Employee set EmployeeName=@EmployeeName where EmployeeID=@EmployeeID Suppose I have two useres A,B A modified or edit using stored procedure above employee no 5000 field EmployeeName B need to modify employee …

Hi guys I have problem i need to make ERD relation entity between employee and allowance Employee table Name address Basic Salary Bonus Allowance table House rent Food Allowance Moving Allowance Basic Salary is monthly and fixed Bonus is monthly and fixed food allowance is monthly and fixed for married …

Hi guys I need to make notification icon to any computers in Hr department when i added new Employee because my employee in my company forget to tell each others about any new employee added so that some process will by delayed Meaning IF i have 4 computers in HR …

Hi guys i have problem in my code when i try to copy image jpg from local disk in any place to network path DOMAIN it give me error the process cannot access the file it using by another process file why this message show and how to solve.the error …

Hi guys when i search record between two dates it works ok success but you must enter date from and dateto first to to make search i will show what i need from this example I need to search dynamic by 4 textbox 1-datefrom 2-dateto 3-EmployeeNo 4-EmployeeName but search i …

Hi guy when i run this Stored procedure it give me message error conversion faild when converting date time from charachter sting stored procedure as following Create proc searchData @StartDate datetime, @EndDate datetime as Declare @SQLQuery as nvarchar(2000) SET @SQLQuery ='SELECT * from Employee Where (1=1)' If (@StartDate is not …

I have windows form have 3 controls 1-textbox1 2-button 3-picture box1 what i need is to display image in picture box1 when i press button to show the file name that written in textbox by searching the file in shared folder in network and if found it show it example …

Hi guys i want to make database for payroll only but i dont know how to make structure for this suppose i want to calculate payroll every month for employees as following basic salary bonus overtime absence deduction meaning salary = basic salary +bonus+overtime-absence-deduction How i make database (ERD)Diagram for …

Recieve Data From Serial Com Port C# In One Line And Convert To int Posted A minute ago Hi guys i have problem i make code that take data from serial com port for weighting machine it is ok working but it recieve data in more lines.I try to make …

I make many to many relationship in erd diagram in sql server 2005 between ca and driver as following car table driver table car_driver table. I need to make fleet management program. When I make forms in windows form are i make car form driver form car_driver form When i …