TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Sindhu Mani
NA
1
1.1k
web services using C#
May 22 2013 4:56 PM
I have a requirement wherein:-
There are travel forms which our company uses where they have to enter details like emergency contacats, indirect funding, direct funding.
To start with we have no data in our tables, it is empty. Whenever any person enters any info the tables in the database has to be updated
and then when the second time they enter information it should populate the fields as it is already there in the database.
There are two parameters @Loginid and @Type
Type could be
Travel Coordinator ( AD Login, coordinator name, phone)
emergency contacts (AD Login, Name, phone)
Indirect funding(AD login, departmentmanager name, phone)
Direct funding (AD Login, departmentmanager name, phone)
Phonecustoms (AD login, serial number)
Laptop Customs(ad login, phone number)
TCO(column1, column2)
FSO(column1, column2)
based on the ad login and type get the other details from the table if it is there
there has to be two tables
1. id, ad login, sql query
2. description Column1 column2, column3, upto 10 columns with info such as name, adlogin, phone, manager etc..
The sql query will have the query querying the fields that have been entered.
So there has to be update and read written in the code.
Please advice on how I can go about it.
Reply
Answers (
1
)
Event in WebService
How to use Web API with REST Support in .net4.5