SharePoint - Custom VIew in DVWP

i found a way to modify the views programatically in a custom list using this site http://www.devx.com/dotnet/Article/31762/1954

but this only applies to a listview is there a way we can also apply modify views programatically in a dataview webpart..

If you need to retrieve items from a list when developing web parts, application pages or custom field types you can best use the SPQueryobject from the SharePoint object model. This object is located in the Microsoft.SharePoint namespace of the Microsoft.SharePoint.dll located in the Global Assembly Cache.

Instantiate the object as follows:

SPQuery qry = new SPQuery();

The most important property is the Query property, which needs to be set to your CAML query:

string camlquery = "<OrderBy><FieldRef Name='Country' /></OrderBy><Where>"

    + "<Eq><FieldRef Name='LastName' /><Value Type='Text'>Smith</Value></Eq>"

    + </Where>";

qry.Query = camlquery;

At this point you can execute the query on your list:

SPListItemCollection listItemsCollection = list.GetItems(qry);

A small remark with the GetItems method of the SPList instance: this method returns a collection of type SPListItemCollection. It is possible that it is easier working with a DataTable. In that case you can execute the query as follows:

DataTable listItemsTable = list.GetItems(qry).GetDataTable();

let me know whether its working for you or not

Recently I came across a situation where I had to add a checkbox to each row of a DFWP and retrieve values of that check boxes in a HTML button click.

Here is what I added in my DFWP’s XSLT to get a check box in each row.

1. In SPD, add a Data View webpart to the page Date View >Insert Data View
2. Configure columns
3. Add an extra column to the left of the rendered data view (you can do this by selecting any left most cell and then Table > Insert > Column to the Left)
4. In the newly generated column, select first (or any <TD>) and then add a HTML check box (Insert > HTML > then Input (Checkbox)
   
   
5. Set the value property of the checkbox to use ID column’s value
   
6. Also add a html button somewhere outside the DFWP. In my example, I will attach an event handler that will read the check box values into an Array. <input
   id=”actionButton”
   type=button
   value=”Get Selected Item IDs”
   />
7. Now add the following script just after the button element.
   
   

   <script>
   

   document.getElementById(“actionButton”).onclick = function() {
   

   
   var idValues = new Array();
   

   $(“input:checkbox:checked”).each(function() {
   

   idValues.push(this.value);
   

   })
   

   alert(idValues.toString());
   

   }
   

   </script>
   

    

8. Here is the output
   

Regards

1. Using SharePoint designer, insert a data view web part onto the page you want to display in the list by selecting Data View > Insert Data View from the main menu.

2. Using the Data Source Library Task Pane in SharePoint designer select ‘Connect to another library‘ and browse to the site that contains the list you wish to display.

3. Expand the new site in the Data Source Library Task Pane and select the list or library that contains the information you wish to display. From the drop down select ‘Show Data‘ to populate the Data Preview tab.

4. From the list of columns, select the ones that you wish to display and select ‘Insert selected fields as… multiple item view’ from the drop down menu at the top of the window. This will populate the data view with sample information (in a table by default). At this stage you may get an error in the design view that states:

“The server returned a non-specific error when trying to get data from the data source. Check the format and content of your query and try again. If the problem persists, contact the server administrator”.

This can be corrected by modifying the <SelectParameters> tag of the <SharePoint:SPDataSource> element of the data view to contain the reletive url of the site for the WebUrl parameter (look at the default parameters to find this out – should be something similar to ‘/news/’).

5. (Optional) Modify the XSL for the data view to display the information in the format you require. By default there is often a large amount of redundant information, and in simple cases can be replaced with the following:


<XSL>
<xsl:stylesheet ...>
<xsl:output method="html" indent="no"/>
<xsl:template match="/">
<xsl:variable name="Rows" select="/dsQueryResponse/Rows/Row"/>
<ul>
<xsl:for-each select="$Rows">
<li>
<a href="{substring-before(@URL, ', ')}"><xsl:value-of select="substring-after(@URL, ', ')"/></a>
</li>
</xsl:for-each>
</ul>
</xsl:template>
</xsl:stylesheet>
</XSL>


6. Now you have the basic data coming through you can select to filter, sort, group or perform other data view related tasks by clicking on the arrow next to the data view in design view. I will cover some of these options in a later post.