Inserting new data to SQL 2000 database using Web Service

J

Julius

Hello everyone,

I had this big problem and i'm digging this for quite sometime now. Somehow
when i try to do the lab exercise of infopath it works but when i try to do
it for my needs i cant manage.

Here's the scenario;

I created a database in SQL 2000 with 3 tables namely employee file,
department and position. I will be adding new employee to employee file and
browsing the department where the employee belongs and its respective
position.

I try to create a webservice to do that. When i did was i follow the
concept of lab excercise 9 ADO.NET of infopath. The conflicting ideas is
first in the lab, it retrieves the data from SQL to infopath then update
which means the way i understand it; the field names in the infopath are
based on the data source which is from SQL.

On my side now, i create a new form of infopath from scratch and name the
fields as it would describe and use the controls of dropdown list from SQL
database (ie. department and position)

My problem is i need to submit this form in order to update the SQL database
but somehow i have a problem with my webservice.

Frankly speaking, i'm new to VS.NET and i'm digging as fast and much as i
can on c#. I know a bit on VB.NET but i'm interested and using c# on this
project.

For more clear scenario, i can even send you my infopath forms if you like.

For those that are expert on this, please help.

Thanks..
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top