hi pradeep will u tell me the parametre @strSort passing for bnding childgridview
i need sp in sql server wil u pls help
i've but throws error (i am bit confuesd wit parametr of @strsort)
create proc sp_GetCustomerDetails
@strCustomerId varchar(50)
as
begin
select Orders.CustomerId,Orders.OrderId,Orders.ShipAddress,Orders.Freight,Orders.ShipName from Orders where Orders.CustomerId=@strCustomerId
union all
select @strCustomerId,Orders.OrderId,Orders.ShipAddress,Orders.Freight,Orders.ShipName from Orders where CustomerId=@strCustomerId having count(*)=0
end
pls do it soon...
Join Hands Change lives
Thanks & Regards
Straight Edge Society
Self-innovator, if this helps please login to Mark As Answer. | Alert Moderator