Update a share point list through asp.net application

To update a sharepoint list very first requirement is to reach upto that list. This can be possible with the help of sharepoint webservices. Share point webservice cannot called without authorization. If a user has full permission for sharepoint server access then by using his/her credentials we can call the share point webservices. First we need to add the required web service in our asp.net application. After adding webservices we get classes access of that webservice. Then call authentication webservice. This webservice is used for authentication of the user. Call to sharepoint webservices also depend upon the subsite process or subfolder process. So be careful during the call to subsites.
After successful authentication of the user a ticket will be generated by the sharepoint service for future operations. By using this ticket a user can call another webserice of sharepoint server. To update a list user need to call the lists.asmx webservce. By using authentication ticket of authentication.asmx websevice one can get list of all lists under root or subdomain. With the help of user defined xml one can update the required list of sharepoint server by using Update method of lists.asmx webservice.

Web Site Setup

Hi Friends,

To make a website set up in .net is quite easy. .net gave its own inbuilt tool for this purpose. Go to file add new project , go on Other project type select set up and deployment and from right hand side select webset up project. By doing this a webset project wil add in your website. After doing this you can add your website(s) in this project for which you want to create set up. When you run this websetup on windows it will ask for virtual directory name and then it will create your virtual directory in your iis and add website pages that you add in setup. This set can also create database in sqlserver. and configure your website on run time. i have done all this code and test it many times. Luckily it is working fine every where. Contact me to get that code.

Comma separated column values in sqlserver

If there is any requirement arieses we need to show comma separated column values eg:
Dummy values (Requirement)
abc,xyz,pqr etc.
Database column values
fields have an id
CatId CatName
1              abc
2              xyz
3              pqr

To achieve above requirement use following code:
DECLARE @Cat varchar(2000)Select @Cat = COALESCE(@Cat + ', ', '') + CAST(SubCategoryName AS varchar(200))FROM SubCategoryWHERE CategoryId=@CategoryIDReturn @Cat