Cannot INSERT data into table with identity column
In my program I have an EmployeeRegistry table which holds data of each employee’s work attendance. Every attendance record is uniquely distinguished by an IDENTITY COLUMN called “AttendanceID” which has an IDENTITY SEED of 1 and an IDENTITY increment of 1. However when I try to insert an attendance record to the table via my [...]

Answer Question   |  May 11, 2012  2:54 AM
INSERT statement, SQL Server 2005, SQL Server 2005 Express Edition, VB.NET 2005

Crystal Reports problem
here’s the coding for my crystal report display The above code is written in the report viewer form’s load event method. ‘this is the query for my dataset (used in objItemSale.GetSaleData(string) function) SELECT ItemSale.BillNo, ItemSale.IncomeID, Income.IncomeDate, Income.IncomeValue, ListItem.ItemID, Item.ItemName, ListItem.SaleQuantity, ListItem.SalePrice, ItemSale.SaleItemListID FROM Income INNER JOIN ItemSale ON Income.IncomeID = ItemSale.IncomeID INNER JOIN SaleItemList ON [...]

Answer Question   |  November 26, 2009  2:35 AM
Crystal Reports 8, SQL Server 2005 Express Edition, VB.NET 2005