To get string at position

We can use this.. hopefully this help

example we have a variable 'temp' with content like 'XX-YY-ZZ'

string[] variable = temp.Split('-');

we can use this to retrieve each element:
temp[index]

temp[0] = XX
temp[1] = YY
temp[2] = ZZ

Linq Samples

see here
http://msdn.microsoft.com/en-us/vcsharp/aa336746

Error when opening linq DBML

This surprise me when the error comes up..

It is written : "The operation could not be completed. Unspecified error" & it happened when i open Linq DBML

what's wrong with my project...??
After a little search in google I found that the problem was simple and it was not the fault of the program code too..

You know what..
the solution is just clear all application & system event log on event viewer...

whoalla.. that cure the error

How to generate increasing record number automatically in sql

When you want to do line/record numbering automatically on your query, simply use 'ROW_NUMBER()' . example:

SELECT ROW_NUMBER() OVER (ORDER BY [field1] asc/desc) as Row_Number, [Otherfields]
FROM [database].[dbo].[table]

that should do it...