WCF DataService Calling Stored Procedure ,CRUD in Silverlight

Friday, May 28, 2010




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


























































































































































































































































































































































































































by
Usama Wahab Khan

simple example ado.net

Monday, May 24, 2010

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();

Silverlight Load Large Data

Wednesday, May 19, 2010


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

One Day WorkShop At NED on SharePoint

Saturday, May 15, 2010

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)









Bounding Box Silverlight Query in Canvas

Thursday, May 13, 2010








By Usama Wahab Khan

Silverlight Blast balloons Game

Tuesday, May 11, 2010






Just Click On Balloons and blast them will get points
by
Usama Wahab Khan