Download Source Code and Handon

helpful Guide for CShare Developers

• 
  
• Working With Numbers
• Dates and Times
• Conditional Logic
• Compare Operators
• Loops
• Defi ne New Types
• fields
• properties
• methods
• constructors
• Inheritance
• override inherited method
• call base class version
• Working with XML
• Load an XML fi le
• Working With Text
• Create a text file
• Read from a text fi le
• Working With a Database
• insert a record
• read records
• read a single value
• linq
• Dynamic DataType and expandoObject
• Optional Parameter
• Parallel Programing
• Parallel For Loop
• PLINQ

Download Tutorial

Download Source Code

Usama Wahab KHan

ADO.Net Classe is Absent in Silverlight That why some time Developer get confused How Retrieve Data in Silvrelight Application? Silverlight Provide ServiceModel Class You Thought this Class You can Call Web services ,WCF Services , RIA Services, Syndication (Rss,Atom) To Get Data. For Communicate with Data Base Web Prefer to Use Entity Framework Or We Can Use Linq to Sql, ADo.net Also through Services . Here i am try to Retrieve Data form Sql in my DataGridControl

1 Create Silverlight Application.

2 Add DataGrid Control and set its Properties .

3 Add Web Service to you Asp.net Application Where u display Silverlight Application (.XAP).

3 Add EntityFramework Data Model and Connect it to Database Thought Wizard.

4 Add any Table to your EntityFramework Data Mode Like (Products).

5 Add Function in your webservice (MydataServices.asmx.cs) .

6 Set return Type to List tableName type like List.

7 Add Linq Select Qurey and return toList() .

8 Add Service in you Silver light Application in Service References

9 Create load function call Service and Service Completed Event

10 on Completed ( EventArgs e ) Retrieve e.result.tolist() ,

11 assigned to DataGrid Item Source Property

Prss F5

Download Sourec Code Here

By Usama Wahab Khan

SEO( Search engine optimization ) is One of the Important Part for internet base Website SEO or E-Marketing is Very Important for get you site top take in Search engg:
or get more Visitor, Normally Search engines bot scan pages like mysite.com\asp you site and save you meta specially Keywords . but mostly the did get dynamic pages we were crated by the help of qureystring like mysite.com\MobileProduct.aspx?Product="Mobile" . Before asp.net 4.0 where were generate Metadata like Dynamic Keywords,Description,Title , for dynamic website like shopping cart there were hundreds
Product in database but u Search Engg only listed those pages those were query Now in asp.net 4.0 we had solution all of these problems we can resistor Our dynamic Pages with the help of asp.net 4.0 feature called Page Routing it has been introduce in Asp.net MVC now you can use this feature in asp.net-4.0 here i try to create one demo application where i had Products, Category's i will care Product page and route them and each page have dynamically generate keyword,title metadata

here u can see auto generated metadata and page routing it Product page dynamically generate from database

1. vs 2010 >New Website and named mycartapplicaiton
2. Right click on App_data folder add northwinds database from sample crate linq to sql add table and view

3. Right click on solution explorer and add two asp.net webform Product.aspx,Categories.aspx.
3 add gridview and set template like this on default.aspx
<asp:gridview id="GridView1" runat="server" allowpaging="True" allowsorting="True" autogeneratecolumns="False" backcolor="#CCCCCC" bordercolor="#999999" borderstyle="Solid" borderwidth="3px" cellpadding="4" cellspacing="2" datakeynames="CategoryID" datasourceid="SqlDataSource1" forecolor="Black"><br /> <columns><br /> <asp:templatefield headertext="CategoryName" sortexpression="CategoryName"><br /> <itemtemplate><br /> <a href="'Categories/<%#">'><br /> <asp:label id="Label1" runat="server" text="'<%#">'></asp:Label><br /> </a><br /> </itemtemplate><br /> </asp:TemplateField><br /> <asp:boundfield datafield="Description" headertext="Description" sortexpression="Description"><br /> </columns><br /> <footerstyle backcolor="#CCCCCC"><br /> <headerstyle backcolor="Black" bold="True" forecolor="White"><br /> <pagerstyle backcolor="#CCCCCC" forecolor="Black" horizontalalign="Left"><br /> <rowstyle backcolor="White"><br /> <selectedrowstyle backcolor="#000099" bold="True" forecolor="White"><br /> </asp:GridView>
set sqldatasorce with wizard connectionstring >select columns [CategoryName], [Description], [CategoryID], [Picture] FROM table[Categories]

its will look like this
<asp:sqldatasource id="SqlDataSource1" runat="server" connectionstring="">" <br /> SelectCommand="SELECT <br /> </asp:SqlDataSource>
4.add gridview on categories.aspx
<asp:gridview id="GridView1" runat="server" allowpaging="True" allowsorting="True" autogeneratecolumns="False" cellpadding="4" datasourceid="SqlDataSource1" forecolor="#333333" gridlines="None"><br /> <alternatingrowstyle backcolor="White"><br /> <columns><br /> <asp:templatefield headertext="CategoryName" sortexpression="CategoryName"><br /> <itemtemplate><br /> <a href="'Products/<%#">'><br /> <asp:label id="Label1" runat="server" text="'<%#">'></asp:Label><br /> </a><br /> </itemtemplate><br /> </asp:TemplateField><br /> <asp:boundfield datafield="QuantityPerUnit" headertext="QuantityPerUnit" sortexpression="QuantityPerUnit"><br /> <asp:boundfield datafield="UnitPrice" headertext="UnitPrice" sortexpression="UnitPrice"><br /> <asp:boundfield datafield="UnitsInStock" headertext="UnitsInStock" sortexpression="UnitsInStock"><br /> <asp:boundfield datafield="UnitsOnOrder" headertext="UnitsOnOrder" sortexpression="UnitsOnOrder"><br /> <asp:boundfield datafield="ReorderLevel" headertext="ReorderLevel" sortexpression="ReorderLevel"><br /> <asp:checkboxfield datafield="Discontinued" headertext="Discontinued" sortexpression="Discontinued"><br /> </columns><br /> <editrowstyle backcolor="#2461BF"><br /> <footerstyle backcolor="#507CD1" bold="True" forecolor="White"><br /> <headerstyle backcolor="#507CD1" bold="True" forecolor="White"><br /> <pagerstyle backcolor="#2461BF" forecolor="White" horizontalalign="Center"><br /> <rowstyle backcolor="#EFF3FB"><br /> <selectedrowstyle backcolor="#D1DDF1" bold="True" forecolor="#333333"><br /> </asp:GridView>

5. add sqldatasorce wizard for girdview ConnectionString>Select view Alphabetical list of products and columns ProductName, QuantityPerUnit, UnitPrice, UnitsInStock, UnitsOnOrder, ReorderLevel, Discontinued click on where button you will route option like this

6. product page repeat again same exercise code like this
<asp:detailsview id="DetailsView1" runat="server" autogeneraterows="False" backcolor="LightGoldenrodYellow" bordercolor="Tan" borderwidth="1px" cellpadding="2" datakeynames="ProductID" datasourceid="SqlDataSource1" forecolor="Black" gridlines="None" height="50px" width="125px"><br /> <alternatingrowstyle backcolor="PaleGoldenrod"><br /> <editrowstyle backcolor="DarkSlateBlue" forecolor="GhostWhite"><br /> <fields><br /> <asp:templatefield headertext="ProductName" sortexpression="ProductName"><br /> <edititemtemplate><br /> <asp:textbox id="TextBox1" runat="server" text="'<%#">'></asp:TextBox><br /> </edititemtemplate><br /> <insertitemtemplate><br /> <asp:textbox id="TextBox2" runat="server" text="'<%#">'></asp:TextBox><br /> </insertitemtemplate><br /> <itemtemplate><br /> <asp:label id="Label1" runat="server" text="'<%#">'></asp:Label><br /> </itemtemplate><br /> </asp:TemplateField><br /> <asp:boundfield datafield="QuantityPerUnit" headertext="QuantityPerUnit" sortexpression="QuantityPerUnit"><br /> <asp:boundfield datafield="UnitPrice" headertext="UnitPrice" sortexpression="UnitPrice"><br /> <asp:boundfield datafield="UnitsInStock" headertext="UnitsInStock" sortexpression="UnitsInStock"><br /> <asp:boundfield datafield="UnitsOnOrder" headertext="UnitsOnOrder" sortexpression="UnitsOnOrder"><br /> <asp:boundfield datafield="ReorderLevel" headertext="ReorderLevel" sortexpression="ReorderLevel"><br /> <asp:checkboxfield datafield="Discontinued" headertext="Discontinued" sortexpression="Discontinued"><br /> </fields><br /> <footerstyle backcolor="Tan"><br /> <headerstyle backcolor="Tan" bold="True"><br /> <pagerstyle backcolor="PaleGoldenrod" forecolor="DarkSlateBlue" horizontalalign="Center"><br /> </asp:DetailsView><br /> <asp:sqldatasource id="SqlDataSource1" runat="server" connectionstring="">" <br /> SelectCommand="SELECT [ProductName], [QuantityPerUnit], [UnitPrice], [UnitsInStock], [UnitsOnOrder], [ReorderLevel], [Discontinued], [CategoryName], [ProductID] FROM [Alphabetical list of products] WHERE ([ProductName] = @ProductName)"><br /> <selectparameters><br /> <asp:routeparameter defaultvalue="" name="ProductName" routekey="productname" type="String"><br /> </selectparameters><br /> </asp:SqlDataSource>
7 add Global.asax handler add this coe in protected void Application_Start(object sender, EventArgs e)
<br /> RouteTable.Routes.Add("ProductRoute", new Route("Categories/Products/{productname}",<br /> new PageRouteHandler("~/Products.aspx")));<br /><br /> RouteTable.Routes.Add("CategoryRoute", new Route("Categories/{catname}",<br /> new PageRouteHandler("~/Categories.aspx")));<textarea><br /><br />8 add this code in Categorie.aspx on pageload event<br /><textarea>if (Page.RouteData.Values["catname"] != null)<br /> {<br /> lblDisplay.Text += "<b>" + Page.RouteData.Values["catname"].ToString() + "</b>";<br /> }<br /> else<br /> {<br /> lblDisplay.Visible = false;<br /> }<br /><br /><br /><br /><br /> mydbDataContext db = new mydbDataContext();<br /> var query = db.Alphabetical_list_of_products.Take(100);<br /> var data = from c in db.Alphabetical_list_of_products.Take(100).ToList()<br /> where c.CategoryName == Page.RouteData.Values["catname"].ToString()<br /> select c.ProductName;<br /><br /><br /><br /><br /> Page.MetaDescription = "my Products Page";<br /> Page.Title = "My Products page ";<br /> //gen trage dynamic Keyword form database<br /> string[] keyword = data.ToArray();<br /> Page.MetaKeywords = string.Join(",", keyword);
9 add this code in Product.aspx on pageload event or dynamic keyword and meatadata
<br /><br /> mydbDataContext db = new mydbDataContext();<br /> <br /> var data = from c in db.Alphabetical_list_of_products.Take(100).ToList()<br /> where c.ProductName == Page.RouteData.Values["productname"].ToString()<br /> select c.ProductName;<br /><br /><br /> var query = from i in db.Products<br /> where i.ProductName == Page.RouteData.Values["productname"].ToString()<br /> select i;<br /><br /> Page.MetaDescription ="its "+ query.ToList()[0].ProductName+ "Page";<br /> Page.Title = "My "+query.ToList()[0].ProductName.ToString()+" page ";<br /> //gen trage dynamic Keyword form database<br /> string[] keyword = data.ToArray();<br /> Page.MetaKeywords = string.Join(",", keyword);

10 add this code in default.aspx on pageload event or dynamic keyword and meatadata
<br /> mydbDataContext db = new mydbDataContext();<br /> var query = db.Alphabetical_list_of_products.Take(100);<br /> var data = from c in db.Alphabetical_list_of_products.Take(100).ToList()<br /> select c.CategoryName;<br /><br /><br /><br /><br /> Page.MetaDescription = "my Categories Home Page";<br /> Page.Title = "My Categories ";<br /> //gen trage dynamic Keyword form database<br /> string[] keyword = data.ToArray();<br /> Page.MetaKeywords = string.Join(",", keyword);<br />


Download SourceCode
and enjoy asp.net 4.0 or any other help contant me
By Usama wahab khan

LINQ: .NET Language-Integrated Query
After two decades, the industry has reached a stable point in the evolution of object-oriented (OO) programming technologies. Programmers now take for granted features like classes, objects, and methods. In looking at the current and next generation of technologies, it has become apparent that the next big challenge in programming technology is to reduce the complexity of accessing and integrating information that is not natively defined using OO technology. The two most common sources of non-OO information are relational databases and XML.
Rather than add relational or XML-specific features to our programming languages and runtime, with the LINQ project we have taken a more general approach and are adding general-purpose query facilities to the .NET Framework that apply to all sources of information, not just relational or XML data. This facility is called .NET Language-Integrated Query (LINQ).
We use the term language-integrated query to indicate that query is an integrated feature of the developer's primary programming languages (for example, Visual C#, Visual Basic). Language-integrated query allows query expressions to benefit from the rich metadata, compile-time syntax checking, static typing and IntelliSense that was previously available only to imperative code. Language-integrated query also allows a single general purpose declarative query facility to be applied to all in-memory information, not just information from external sources.
.NET Language-Integrated Query defines a set of general purpose standard query operators that allow traversal, filter, and projection operations to be expressed in a direct yet declarative way in any .NET-based programming language. The standard query operators allow queries to be applied to any IEnumerable-based information source. LINQ allows third parties to augment the set of standard query operators with new domain-specific operators that are appropriate for the target domain or technology. More importantly, third parties are also free to replace the standard query operators with their own implementations that provide additional services such as remote evaluation, query translation, optimization, and so on. By adhering to the conventions of the LINQ pattern, such implementations enjoy the same language integration and tool support as the standard query operators.
The extensibility of the query architecture is used in the LINQ project itself to provide implementations that work over both XML and SQL data. The query operators over XML (LINQ to XML) use an efficient, easy-to-use, in-memory XML facility to provide XPath/XQuery functionality in the host programming language. The query operators over relational data (LINQ to SQL) build on the integration of SQL-based schema definitions into the common language runtime (CLR) type system. This integration provides strong typing over relational data while retaining the expressive power of the relational model and the performance of query evaluation directly in the underlying store.
Object Relational Designer (O/R Designer)
The Object Relational Designer (O/R Designer) provides a visual design surface for creating LINQ to SQL entity classes and associations (relationships) that are based on objects in a database. In other words, the O/R Designer is used to create an object model in an application that maps to objects in a database. It also generates a strongly-typed DataContext that is used to send and receive data between the entity classes and the database. The O/R Designer also provides functionality to map stored procedures and functions to DataContext methods for returning data and populating entity classes. Finally, the O/R Designer provides the ability to design inheritance relationships between entity classes.

Tutorial



1 open Vs 2008 and Create new website

2 Drag n Drop on Form Button and GridView Control From ToolBar

3 set there id girdView to Gvlinq and Button1 to btnbinding

4 Right Click on Solution Explorer click on Add newitem and Select linq to sql

5 Open Server Explorer and Drag and drop any table form Database if u did`nt Created at yat so Sample database is available in Sorcecode copy from there




6 goback to default.aspx and double Click on button
and write code blow

<br /> DataClasses1DataContext db = new DataClasses1DataContext();<br /><br /> var qury = from c in db.Public_Registrations<br /><br /> select c;<br /><br /><br /><br /> GvLinq.DataSource = qury;<br /><br /> GvLinq.DataBind();

try this linq and need any help so just contat me thank to spend your time on usamawahabkhan.blogspot.com learn free

Download Source Code

By

Usama Wahab Khan