Search DaniWeb - linqtosql

LinqToSql + Sql Server Express Backup/Restore + SMO 14 Years Ago by vbnetskywalker hi guys lately I've been experiencing LinqToSql + Sql Server Express 2005, and it was a great journey (… insert using LinqToSql 11 Years Ago by MARKAND911 `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. Gridview Paging from Stored Procedure >< 13 Years Ago by MichaelWClark … a stored procedure to handle paging and sorting. Linked a LinqToSql to it and bound my gridview from that. I use… Re: Gridview Paging from Stored Procedure >< 13 Years Ago by rohand … a stored procedure to handle paging and sorting. Linked a LinqToSql to it and bound my gridview from that. I use… Re: DataGridView ComboBox Column Edit 10 Years Ago by Begginnerdev You can look into using LINQtoSQL or some kind of business objects. LINQ to SQL automatically …-us/vstudio/bb688085.aspx) is a bunch of information on LINQtoSQL. Hope this helps! Re: procedure 14 Years Ago by Ionelul if you use LinqToSql, there is an easier way to do the insert. Check the following link for a good tutorial: [url]http://weblogs.asp.net/scottgu/archive/2007/05/19/using-linq-to-sql-part-1.aspx[/url] Ionut Re: procedure 14 Years Ago by sknake [QUOTE=Ionelul;1091684]if you use LinqToSql, there is an easier way to do the insert. Check … Re: LINQ bool value equal to null 13 Years Ago by jammiedude Ok got it. [icode] O.Confirmed.Equals(null) [/icode] works i just forgot to refresh my LINQtoSQL diagram after making the changes in the db! Re: Help With Linq 12 Years Ago by Skeldave …. I don't know if it matters by im using LINQTOSQL so I have loaded my database into a .dbml layout… Re: Beginner's Help 12 Years Ago by Skeldave … need a way of accessing the data. Your options are LINQtoSQL, EntityFramework and oledb (There are others but i suggest one… Re: insert using LinqToSql 11 Years Ago by pritaeas [Here](http://www.devasp.net/net/articles/display/1293.html) are some examples. Binding Gridview to Stored Proc via LinqToSql 13 Years Ago by MichaelWClark I am trying to bind my gridview to a stored procedure via Linq to SQL but keep getting 'Data source is an invalid type. It must be either an IListSource, IEnumerable, or IDataSource.' I know I am supposed to convert the stored Proc .ToList, but this method is not available to me and throws an error (BC30456: 'toList' is not a member of 'Integer').… Re: Binding Gridview to Stored Proc via LinqToSql 13 Years Ago by MichaelWClark Ok it turns out that the Linq didn't recognize the return type of my stored procedure. I changed the function declaration and added a class to the Linq.Designer.vb file as such: <Global.System.Data.Linq.Mapping.FunctionAttribute(Name:="dbo.usp_GetInvestorData")> _ Public Function usp_GetInvestorData(<Global.… Re: Binding Gridview to Stored Proc via LinqToSql 13 Years Ago by MichaelWClark UPDATE: Datas should be Data [code]ISingleResult(Of usp_GetInvestorDatasResult)[/code] [code]ISingleResult(Of usp_GetInvestorDataResult)[/code] Re: Gridview Paging from Stored Procedure >< 13 Years Ago by Michel88 hey try this source code 1. ALTER PROCEDURE dbo.EfficientGridViewPaging 2. 3. @pageIndex int, 4. @pageSize int 5. 6. AS 7. 8. BEGIN 9. 10. WITH Entries AS ( 11. 12. SELECT ROW_NUMBER() OVER (ORDER BY ID DESC) 13. AS RowNumber, random_data1, random_data2, random_data_etc 14. FROM the_table 15. ) … Re: Gridview Paging from Stored Procedure >< 13 Years Ago by MichaelWClark Thank you both for the links but the issue was not with the paging it self. The stored procedure preforms just as it should. The issue I was having is that I wanted the gridview to still show a pager so I could page the information. I was not able to override the pager and make it display as I wanted. I ended up just creating a custom pager that …