i am using a store procedure to access field in asp.net View, i am putting db columns in HTML table, it's workign except for one field, 'NetSalary'. It can't be accessed, it says that model doesn't contain it. i tried many ways but couldn't get to work. ALTER PROCEDURE [dbo].[GetMonthlyReport] @emplID INT = NULL, @month VARCHAR(50) = NULL, @BasicSalary int = null out ,@BSalaryHour int= Null out AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; IF (@emplID IS NOT NULL AND @month IS NOT NULL) --If Block …
|+0 forum 2|
`insert into table1 (Wicket,Run,Catch) values (Wicket+2,Run+22,Catch+5)` This statement is used to insert data using StoredProcedure. How can i insert data same way without using storeprocedure but using LinqToSql. What will be code for it.
|+0 forum 1|