WCF DataSerivce and EntityFramework Provideing wornderful Rest Web Service

so i am try to domeistrate Copy Record Update Delete database Functions In Silverlight Application or Call View,Stored Procedure and call dumay entity for complex type Before using this app plase check connectionsstring and database

Download Source code

by

Usama Wahab Khan

ADO.Net

---------------------SqlQuerys------------------------------------------
Select * from TableName or ViewName


Insert Into TableName
(colname,colname)
values
('calvalue','colvalue')


UPdate TableName
set ColumnName='Value', ColumnName='Value'


---------------------------------------ConnectionString---------
Data Source=myServerAddress;Initial Catalog=myDataBase;User
Id=myUsername;Password=myPassword;

SqlConnection cn = new SqlConnection("Data
Source=-SERVER\\express;Initial Catalog=GIS;Integrated Security=True");;


----------------------------------Disconnected
Ado.net-------------------------------------


xxxConnection cn = new xxxConnection();
xxxDataAdapter da = new xxxDataAdapter("Select * from",cn);
DataSet ds = new DataSet();
da.Fill(ds);
---------------- Data will be loaded in Dataset(ds) NOw you can change data--
---------------------After Change Data in Ds to save data In database -----
ds.AcceptChanges();
da.Update(ds);

----------------------------------connected
Ado.net-------------------------------------



xxxConnection cn = new xxxConnection();

xxxCommand cmd = new xxxCommand("SqlQuery",cn);

try
{
//Select Command
SqlCommand cmd = new SqlCommand("Select * From app_users", cn);
//Check Connection State and Open it
if (cn.State != System.Data.ConnectionState.Open) { cn.Open(); }
//Executereader to fatch data;
SqlDataReader reader = cmd.ExecuteReader();
//Read Data Till Last Record from While
while (reader.Read())
{
Console.WriteLine(reader[1].ToString());
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
finally
{
//last close connectionString
cn.Close();

}
Console.ReadLine();

Increase web service timeout Received Large Data from wcf
and add this in you silverlight application (ServiceReferences.ClientConfig)

Microsoft Arranged One Day 5 hours Sharepoint Training At NED University on
Monday 10 May 2010(10:00 Am to 4 pm)
Agenda
Give brief overview on Sharepoint services and moss.
Document Management
Collaboration
Enhanced Intranet
Search Engine
Portal Creation
SharePoint Components
Importance of Sharepoint in Enterprises
Sharepoint career Guide

HandOns
how to add custom Webpart
how to add custom feature

SharePoint

Trainer and TAs
Usama Wahab khan(Trainer)
Usama Aziz(MSP)
Naveed Sattar(TA)

Download Source Code

By Usama Wahab Khan

Just Click On Balloons and blast them will get points

Download SourecCode

by

Usama Wahab Khan