asp.net and PHP websites shared service and data

Question

Hello Friends,

I have a SQL Server Tables and use Microsoft Tools (Visual Stuidio C# and ASP.Net) to develop web functionality. The data is processed and then business logic applied to transform results set. There is another group that I work with that  that uses php and they would like to use some of the data in there site as well.

I cannot give them direct access to the database but can provide a service they could call. I feel that WCF has more overhead  than we need but certainly is an option.

My Question is what are some other options that I could provide and what are the pro's and con's of each one with your preference.  What about WEB API can it be used by both asp.net and php? what are my limitations

Thanks in advance for your input.

Answer 1

That's a nice alternative... But I don't think I can apply that on our application right now since the requirements didnt allow a lot of development time. I can propose that on our next version maybe... Thanks for your suggestion...

Answer 2

Why like this.. First give users a "Search" facility for item. If found ask to update (Change button text to "Update") or else create a new one (Change button text to "Add New"). Something like this :)

Answer 3

Hi, 

Thanks for the comments... The requirement was quite a rush so I just did a work around. I used two buttons alternating their visibility on every post back depending on the result of the checking for the records existence... If the record doesn't exist, the Add button is visible. Otherwise, the update button is visible. The update is attached with attribute that calls on a client side script that asks the user for confirmation.

Answer 4

query resolved?

Answer 5

 if (MessageBox.Show("Do You Wish To continue", "Confirmation", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
                {
                        MessageBo.Show("yes pressed");
                 }
      

Answer 6

Have you looked at the articles in this web site? Especially the ones listed under "Our recommended articles" at the right side of this window?