Geeks With Blogs

News


Rodney Vinyard - .NET & SQL Developer When all is said and done, more will be said than done May 2010 Entries
Better than dynamic SQL - How to pass a list of comma separated IDs into a stored proc
Better than dynamic SQL - How to pass a list of comma separated IDs into a stored proc: Derived form "Method 6" from a great article: · How to pass a list of values or array to SQL Server stored procedure · http://vyaskn.tripod.com/pa... Create PROCEDURE [dbo].[GetMyTable_ListByCom... (@CommaSepReqIds varchar(500)) AS BEGIN select * from MyTable q JOIN dbo.SplitStringToNumberTabl... AS s ON q.MyTableId = s.ID End ALTER FUNCTION [dbo].[SplitStringToNumberT... ......

Posted On Friday, May 28, 2010 1:56 PM

create a WinForms DataGridView checkbox column via databinding on dummy a SQL column
create a WinForms DataGridView checkbox column via databinding on dummy a SQL column select (Cast((SELECT 0 AS Active) as Bit)) AS [myCheckBox Column]

Posted On Tuesday, May 11, 2010 11:43 AM

How To: Get the DISTINCT rows in a DataTable or DataView

How To: Get the DISTINCT rows in a DataTable or DataView

http://devpinoy.org/blogs/keithrull/archive/2008/02/07/how-to-get-the-distinct-rows-in-a-datatable-or-dataview.aspx

Posted On Tuesday, May 11, 2010 9:49 AM

Copyright © Rodney Vinyard | Powered by: GeeksWithBlogs.net