ObjectDataSource Parameter. Please Help.
-
Hello, I have been waiting for answer to this question from last 2 days. I posted it in Sql Forum. But,I did not get answer. So, I am posting it here. I have one ObjectDataSource which has a Select query that requires Parameter @CompanyId. CompanyId is Guid and I want to compare it with a bunch of GUID. Can i pass those Guid programatically??? my Query is like.. select a.companyId, b.startdate, b..... from a,b where a.companyId IN (@CompanyID)
-
Hello, I have been waiting for answer to this question from last 2 days. I posted it in Sql Forum. But,I did not get answer. So, I am posting it here. I have one ObjectDataSource which has a Select query that requires Parameter @CompanyId. CompanyId is Guid and I want to compare it with a bunch of GUID. Can i pass those Guid programatically??? my Query is like.. select a.companyId, b.startdate, b..... from a,b where a.companyId IN (@CompanyID)
DotNetDominator wrote:
I have been waiting for answer to this question from last 2 days. I posted it in Sql Forum. But,I did not get answer.
There are many reasons you may not have received an answer. The bottom line is that this is a community site. People take their own time to answer questions. If you require an answer urgently then Microsoft Support can help for a small payment.
DotNetDominator wrote:
So, I am posting it here.
Your question has nothing to do with ASP.NET so it is inappropriate for this forum.
"On two occasions, I have been asked [by members of Parliament], 'Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?' I am not able to rightly apprehend the kind of confusion of ideas that could provoke such a question." --Charles Babbage (1791-1871) My: Website | Blog
-
Hello, I have been waiting for answer to this question from last 2 days. I posted it in Sql Forum. But,I did not get answer. So, I am posting it here. I have one ObjectDataSource which has a Select query that requires Parameter @CompanyId. CompanyId is Guid and I want to compare it with a bunch of GUID. Can i pass those Guid programatically??? my Query is like.. select a.companyId, b.startdate, b..... from a,b where a.companyId IN (@CompanyID)
Hi there, You can define a select parameter for the ObjectDataSource control, then create a handler for the
Selectingevent of the datasource control. In the handler, you can pass a list of the CompanyID values to the input parameter collection. Using Parameters with the ObjectDataSource Control [^] -
Hi there, You can define a select parameter for the ObjectDataSource control, then create a handler for the
Selectingevent of the datasource control. In the handler, you can pass a list of the CompanyID values to the input parameter collection. Using Parameters with the ObjectDataSource Control [^]Hi, Mr.Mackay, I Do appreciate the help provided by people by taking time for it from their busy schedule. But, I did mean to blaim any one for not getting reply. It's just that I was desperate to have answer because I've to finish this project in 10 days. I'll surely consider your suggestion of joining Microsoft support for urgent answer. But, As long as I am a student, I can not afford it. I joined this forum because, I found it very authentic and rich with knowledge. Anyway...I'll take care in selection of forum before i post. Thank you. Hi minhpc_bk, I am very very thankful for the reply.. Just what i wanted... It is running fine now... earlier i was thinking to pass parameter as http://vyaskn.tripod.com/passing\_arrays\_to\_stored\_procedures.htm but it requires stored procedure.. Thank you very much for solution.