How To Read The SharePoint Lists

HI Patel,

Nice Article...

Always use "Using"
using (SPSite objsiteCollection = new SPSite(webAppURL))
{
using (SPWeb objSite = objsiteCollection.OpenWeb())
{
so that the object will get dispose...

Whether you have customize the master page in sharepoint...can you please give me tips....

Hi,

I suggest that you have a look at the Camelot .NET Connector for Microsoft SharePoint. Its a standard ADO.NET Connector that allows you to select, insert, update or delete data from SharePoint as if it was a typical sql server (with optional where or limit statements). It is also good for inserting data from a ASP.NET form or similar. In this specific case, you could write something like:

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

connection.Open();

var adapter = new SharePointDataAdapter(@"SELECT Title, SiteUrl FROM `SupportClaims/CustomerSupport`", connection);

var dataTable = new DataTable();
adapter.Fill(dataTable);

reptCustomerSupportTab.DataSource = dataTable;
reptCustomerSupportTab.DataBind();

connection.Close();

Hi Shantanupatel,

Your approach is good.

But as a fresher it is quite difficult that where to start and how to do it.
You have simply write a code block.

For ex. you can see the example on below link that how they have explain step by step for a sharepoint beginner.

http://sharepointcafe.net/articles/event-handler-in-sharepoint.aspx

and

http://sharepointcafe.net/articles/webpartinsharepoint2010.aspx

Sorry to say that but if you are explaining some thing for beginners then you should start with step by step process.

Thanks.

Hi Kunda,
Thanks a lot for the feedback!

Yes, what you have scribbled is correct and that would be taken into account in the coming posts.

Thanks
Shantanu