hi,
i created a service like this
[OperationContract (Name = "GetAllCustomer")]
[WebInvoke(ResponseFormat = WebMessageFormat.Json,
BodyStyle = WebMessageBodyStyle.Wrapped,
UriTemplate="/View/Data?format={fr}",
Method="GET"
)]
Customer[] GetAllCustomer();
public class Customer
{
[DataMember]
public int CNo { get; set; }
[DataMember]
public string CName { get; set; }
}
and access my db in service.svc.cs
List<Customer> lstEmp = new List<Customer>();
String connString = ConfigurationManager.ConnectionStrings["connWebOrdering"].ConnectionString;
SqlConnection sqlConn = new SqlConnection(connString);
sqlConn.Open();
SqlDataAdapter da = new SqlDataAdapter("Select [cid], [cname] from [CustomerDB].[dbo].[contact] ", sqlConn);
DataSet ds = new DataSet();
&
View Complete Post