This is my code for getting data from database based on id
Interface
[OperationContract]
List<Cus> GetSelectedCus(int Party_Dim_Key);
public List<Cus> GetSelectedCus(int Party_Dim_Key)
{
List<Cus> Cuss = new List<Cus>();
using (SqlConnection con = new SqlConnection(@"<>"))
{
using (SqlCommand cmd = new SqlCommand("Select * from CONSUMER2 where Party_Dim_Key=@Party_Dim_Key", con))
{
con.Open();
cmd.Parameters.AddWithValue("@Party_Dim_Key", Party_Dim_Key);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
Cus cus1 = new Cus();
cus1.Party_Dim_Key = int.Parse(dr["Party_Dim_Key"].ToString());
cus1.Customer_First_Nm = Convert.ToString(dr["Customer_First_Nm"]);
cus1.Customer_Gender_Nm = dr["Customer_Gender_Nm"].ToString();
cus1.PhoneNumber = Convert.ToString(dr["PhoneNumber"]);
cus1.Address = Convert.ToString(dr["Address"]);
cus1.City = Convert.ToString(dr["City"]);
cus1.Country = Convert.ToString(dr["Country"]);
cus1.Zipcode = Convert.ToString(dr["Zipcode"]);
cus1.EmailId = Convert.ToString(dr["EmailId"]);
cus1.Tagid = Convert.ToString(dr["Tagid"]);
cus1.SNo = Convert.ToString(dr["SNo"]);
cus1.batchid = int.Parse(dr["batchid"].ToString());
cus1.ClientId = int.Parse(dr["ClientId"].ToString());
cus1.pwd = Convert.ToString(dr["pwd"]);
cus1.CouponValue = int.Parse(dr["CouponValue"].ToString());
Cuss.Add(cus1);
}
con.Close();
return Cuss;
}
}
this code i am writting but i am not get any data from database
what is the mistake?
pleae correct my code