Want to papulate Sharepoint list using ASP.NET Form

[Vkas]

hi

I am Working in Moss !
My target is to populate the share point list using asp.net web Application

I had Create a website is Asp.net with a simple form having 3 text field and a button
I had created a list in the Share point site named as "test" having 3 fields I.e(Name, address and Phone No)

Target
I want to populate that list of share point through the Asp.net Form that i have created
when i click the button all the values of three of the text box should be passed or populate in the Share point list

Can Any one have Proper idea ABOUT THIS?
Should i use web services??? How?


or can any one can tell me the right direction if i am wrong?

Mean how to store values in share point list by external web application,

[Ulf E]

One simple way to do it is through the Camelot .NET Connector for Microsoft SharePoint. Its a ADO.NET driver for querying SharePoint using standard SQL syntax. So, in this example:

var connection = new SharePointConnection(@"
Server=yourspserver;
User=spuser;
Password=******;
Authentication=Ntlm");

connection.Open();

var command = new SharePointCommand(@"INSERT INTO `test` SET `Name` = 'the name', `Address` = 'the address', `Phone No` = 'the number'", connection);

command.ExecuteNonQuery();
connection.Close();