Help n Handling web service in Gridview 3tier architecture

Question

#my code behind

public void ShowGrid()

{

ServiceReference1.Service1Client client = new ServiceReference1.Service1Client();

DataTable dt = client.DisplayProductDetails();

grdView1.DataSource = dt;

grdView1.DataBind();

}

# my web service coding

public class Service1 : IService1

{

BllClass bll = new BllClass();

public DataTable DisplayProductDetails()

{

return bll.DisplayProductDetails();

}

public void AddNewProduct(EntityClass en)

{

bll.AddNewProduct(en);

}

public void UpdateProductDetail(EntityClass en)

{

bll.UpdateProductDetail(en);

}

public void RemoveProduct(EntityClass en)

{

bll.RemoveProduct(en);

}

}

 

#webservice Iservice page coding

 

[ServiceContract]

public interface IService1

{

[OperationContract]

DataTable DisplayProductDetails();

[OperationContract]

void AddNewProduct(EntityClass en);

[OperationContract]

void UpdateProductDetail(EntityClass en);

[OperationContract]

void RemoveProduct(EntityClass en);

// 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 CompositeType

//{

// bool boolValue = true;

// string stringValue = "Hello ";

// [DataMember]

// public bool BoolValue

// {

// get { return boolValue; }

// set { boolValue = value; }

// }                                                              //I have commented it out becoz i have my entity layer seperately

// [DataMember]

// public string StringValue

// {

// get { return stringValue; }

// set { stringValue = value; }

// }

//}

 

#my bal

 

/// <returns></returns>

public DataTable DisplayProductDetails()

{

DataTable dt;

try

{

dt = new DataTable();

dt = dal.ProductDetailsDisplay();

return dt;

}

catch (Exception ex)

{

throw ex;

}

}

# Dal

 

public DataTable ProductDetailsDisplay()

{

DataTable dt = new DataTable();

SqlCommandBuilder cb;

SqlDataAdapter adp;

SqlConnection conn = new SqlConnection(constring);

try

{

conn.Open();

SqlCommand cmd = new SqlCommand("spDisplayProductDetails", conn);

cmd.CommandType = CommandType.StoredProcedure;

adp = new SqlDataAdapter(cmd);

cb = new SqlCommandBuilder(adp);

adp.Fill(dt);

return dt;

}

catch (SqlException)

{

throw new Exception("");

}

catch (FormatException)

{

throw new Exception("Input Field supplied was not there in the correct Format");

}

catch (NullReferenceException)

{

throw new Exception("");

}

catch (Exception ex)

{

throw new Exception(ex.Message);

}

finally

{

if (conn.State == ConnectionState.Open)

{

conn.Close();

}

}

}

 

 

The following code doesnt how any error but the thing is the grid is not displaying ? why it is happening?