namespace datafromdbservice { // NOTE: You can use the "Rename" command on the "Refactor" menu to change the interface name "IService1" in both code and config file together. [ServiceContract] public interface IService1 { [OperationContract] dataret GetData(int id); // TODO: Add your service operations here } // Use a data contract as illustrated in the sample below to add composite types to service operations. [DataContract] public class dataret { [DataMember] public string name { get { return name; } set { name = value; } } [DataMember] public int personid { get { return personid; } set { personid = value; } } [DataMember] public DateTime hiredate { get; set; } [DataMember] public DateTime enrolldate { get; set; } [DataMember] public string discriminator { get; set; } } } //service1.svc.cs public class Service1 : IService1 { SqlCommand cmd; SqlConnection con; SqlDataReader dr; dataret ds = new dataret(); public dataret GetData(int id) { con=new SqlConnection("Data Source=dell-pc;Initial Catalog=test1;Persist Security Info=True;User ID=Sa;Password=passwordone;MultipleActiveResultSets=True"); cmd=new SqlCommand("select * from person where id=1",con); con.Open(); dr = cmd.ExecuteReader(); while (dr.Read()) { ds.name = dr.GetValue(0).ToString(); ds.personid = Convert.ToInt32(dr.GetValue(1)); ds.hiredate = Convert.ToDateTime(dr.GetValue(2)); ds.enrolldate = Convert.ToDateTime(dr.GetValue(3)); ds.discriminator = dr.GetValue(4).ToString(); } return ds;
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)