var difList = list1.Where(a => !list2.Any(a1 => a1.id == a.id)) .Union(list2.Where(a => !list1.Any(a1 => a1.id == a.id)));   Kaynak : StackOverFlow

Do?ru Yaz?m: public List<int> ImageString { get { if (this.ViewState[“ImageString”] == null) { this.ViewState[“ImageString”] = new List<int>(); } return (List<int>)(this.ViewState[“ImageString”]); } set { this.ViewState[“ImageString”] = value; } } Yanl?? Yaz?m: public List<int> ImageString { get { if (this.ViewState[“ImageString”] != null) { return (List<int>)(this.ViewState[“ImageString”]); } return new List<int>(); } set { this.ViewState[“ImageString”] = value; } } […]

SELECT  CAST(CAST(0 AS BINARY) AS UNIQUEIDENTIFIER)  

DECLARE @XML XML='<IDLIST><ID VALUE=”00000000-0000-0000-0000-000000000000″/></IDLIST>’ DECLARE @docHandle INT CREATE TABLE #tmp ( ID UNIQUEIDENTIFIER  ) EXEC sp_xml_preparedocument @docHandle OUTPUT, @XML INSERT INTO #tmp SELECT  * FROM OPENXML (@docHandle, ‘/IDLIST/ID’, 1) WITH(VALUE UNIQUEIDENTIFIER) EXEC sp_xml_removedocument @docHandle  

DECLARE @cols AS NVARCHAR(MAX); DECLARE @query AS NVARCHAR(MAX); select @cols = STUFF((SELECT distinct ‘,’ + QUOTENAME(Name) FROM property FOR XML PATH(”), TYPE ).value(‘.’, ‘NVARCHAR(MAX)’) , 1, 1, ”); SELECT @query = ‘SELECT * FROM ( SELECT o.object_id, p.Name, o.value FROM propertyObjects AS o INNER JOIN property AS p ON o.Property_Id = p.Id ) AS t […]

SELECT T2.FieldSomething, STUFF(( SELECT ‘,’ T1.Field FROM Table1 T1 WHERE T1.IDField =T2.IDField ORDER BY T1.Field FOR XML PATH(”) ), 1, 1, ”) AS FieldName FROM Table2 T2  

var results = from myRow in dt.AsEnumerable() select myRow[“Field”].ToString(); ddlControl.DataSource = results.Distinct().ToList();