Try this
DataTable dt = new DataTable();
try
{
con = da_con.DA_Connect();
SqlCommand cmd = new SqlCommand("FetchShopSellerOnId", con);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter sqlDa = new SqlDataAdapter();
sqlDa.SelectCommand = cmd;
sqlDa.Fill(dt);
<pre> foreach (DataRow dRow in dt.Rows)
{
if (dt.Rows.Count > 0)
{
Label11.Tex = dRow["ShopOfficeDetailsId"].ToString();
}
}
In Above Code
dRow["ShopOfficeDetailsId"].ToString();
ShopOfficeDetailsID is used in stored procedure eg. Select ShopOfficeDetailsID ,, You can use your ID name