where "dc" is my DataBase DataContext

from a in dc.TableA
where (a.AddProductDate - DateTime.Now).TotalDays < 10
select a;

hope it helps :)

var query = from a in dc.TableA
   join b in dc.TableB on a.ColumnId equals b.ColumnId
   join c in dc.TableC on a.ColumnId equals c.ColumnId
   orderby a.Name, a.LastName descending
   select new { a, b, c };

foreach (var q in query)
{
   Console.Write(string.Format("Hello {0} {1}", q._a.Name, q._a.LastName));
}

hope it helps ;)

if we can choose, i choose to write my code in the code behind.. its better than have to recover files in svn, or compare the file with older versions.. who works with designers daily understand what i´m saying :D

my result:

XAML:

<sdk:DataGrid x:Name="dgResult"/>
<sdk:DataPager x:Name="dgResultPager" Margin="0,-1,0,0" PageSize="3" Source="{Binding Path=ItemsSource, ElementName=dgResult}" />

Code Behind:

public Entity()
{
    InitializeComponent();
    Loaded += new RoutedEventHandler(Entity_Loaded);
}

void Entity_Loaded(object sender, RoutedEventArgs e)
{
    BdDomainContext dc = new BdDomainContext();
    PagedCollectionView tempListView = new PagedCollectionView(dc.tb_Entities);
    dgResult.ItemsSource = tempListView;
    dc.Load(dc.GetTb_EntitiesQuery());
}

credits: http://msdn.microsoft.com/en-us/library/system.windows.data.pagedcollectionview%28VS.95%29.aspx

hope it helps ;)

http://qrcode.kaywa.com/

Just type the url (http://blog.tekdrop.com),
click generate it, and then: 

if you want to try it on your PC you can use the following program:

http://www.dansl.net/blog/?p=256

if you want to try on your mobile you can use:

http://reader.kaywa.com/

Simple!

using the DATEPART and DAYOFYEAR is very simple..

select Name
from tb_UserInfo
where datepart(dayofyear, BirthDate) between datepart(dayofyear,getdate()) and datepart(dayofyear, dateadd(day,7,getdate()))

in my example, I wanted to get the the days between a week, seven days.

hope it helps.

just add the following class to your CSS

<style type="text/css">
#centerdiv
{
position:absolute;
top: 50%;
left: 50%;
width:690px;
height:542px;
margin-top: -271px; /* negative half height*/
margin-left: -345px; /* negative half width*/
}
</style>

then

<div class="centerdiv">lalalala</div>

what does it mean ?

"... Apparently VS 2008 changed the base class for Typed DataTables 3.5 : public partial class SubusersDataTable : global::System.Data.TypedTableBase<SubusersRow> {
2.0: public partial class SubusersDataTable : global::System.Data.DataTable, global::System.Collections.IEnumerable {
 and you need to change all dependant assemblies to target 3.5 framework (if not done yet) and add a reference to assembly 'System.Data.DataSetExtensions, Version=3.5.0.0 ..."

thanks to: http://geekswithblogs.net/mnf/archive/2009/05/10/typed-datatables--base-class-in-vs008.aspx

Very interesting!

http://randomous.com/floatbox/demo

get the products ordered between Monday/Friday:

select product, price from tb_Order where DATEPART(weekday,OrderDate) between 2 and 6

get the products ordered in weekends:

select product,price from tb_Order where (DATEPART(weekday,OrderDate)=1 or DATEPART(weekday,OrderDate)=7)

why I'm using this values? check this post from Pinal Dave (sqlauthority.com)

sure, just need to use the RAISERROR in sql server.

in your ASP.Net application, inside a try{...} add your query, and in the catch prepare a label to receive the Error Message, that will be the message from SqlServer.

example:

after executing this the text of the label will be: [Error Message]

hope it helps.