SharePoint .Net Learnings

Sunday, 17 February 2013

calling REST with Jquery from sharepoint 2010

I will show how to call REST service with JQUERY to fetch data from sharepoint list.

I have one sharepoint list called Employee1 which has 2 columns(Ename and Contact).

Include these 2 scripts:

<script src="Scripts/jquery-1.3.2.js" type="text/javascript"></script>

Tuesday, 5 February 2013

Working with Nested Repeater in Asp.net

Hi today I am writing on how to implement nested repeater.

I have taken 2 tables.
One is Emp{Eid(PK),Ename,Econt} and Book{Bid(PK),Bname,Eid(FK to EMP)}

So make these 2 tables in Sql Server database.

I want to show which employee has how many books under him/her.

Now I have taken 2 repeaters.below is the HTML

<form id="form1" runat="server">

<div><asp:Repeater ID="repParent" runat="server" OnItemDataBound="repParent_ItemDataBound">
<ItemTemplate ><table>
<tr>
<td>
<asp:HiddenField ID="hdnID" runat="server" Value=' <%# Eval("Eid") %>' /></td>
</tr><tr><td><b>Name :</b><asp:Label ID="lblEname" runat="server" Text=' <%# Eval("Ename") %>' /><br /></td><tr><td>------------------</td></tr></tr><tr><td><asp:Repeater ID="repChild" runat="server"><ItemTemplate><asp:Label ID="lblBname" runat="server" Text=' <%# Eval("Bname") %>' /><br /></ItemTemplate></asp:Repeater></td></tr>
</table></ItemTemplate><SeparatorTemplate>
</SeparatorTemplate></asp:Repeater></div></form>
Now on code behind paste following code.

namespace nestedRepeater{

public partial class WebForm1 : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e)    {

    if (!IsPostBack)
    {
    BindParentRep();
       }
    }

private void BindParentRep(){

string connStr = @"Data Source=your server name; initial catalog=Sales;integrated security=true";
SqlConnection conn = new SqlConnection(connStr);
string query = "select * from dbo.Emp";
SqlDataAdapter ad = new SqlDataAdapter(query,conn);
DataSet ds = new DataSet();ad.Fill(ds);
repParent.DataSource = ds;
repParent.DataBind();

}

protected void repParent_ItemDataBound(object sender, RepeaterItemEventArgs e){

if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem){

Repeater child = (Repeater)e.Item.FindControl("repChild");
HiddenField hdnId = (HiddenField)e.Item.FindControl("hdnID"); //Based on this Emp id I will //find all corresponding books.
if (hdnId.Value != null){

string connStr = @"Data Source=your server name; initial catalog=Sales;integrated security=true";
SqlConnection conn = new SqlConnection(connStr);
string query = "select Bname from dbo.Book where Eid=@Eid";
SqlDataAdapter ad = new SqlDataAdapter(query, conn);
SqlCommand cmd = new SqlCommand(query, conn);conn.Open();
cmd.Parameters.AddWithValue(
"@Eid", hdnId.Value);
SqlDataReader dr = cmd.ExecuteReader();child.DataSource = dr;
child.DataBind();
conn.Close();
}
}
}
}
}

After this press F5 to run.

Thursday, 17 January 2013

Highlight current page link on asp.net

How to highlight current page or link in asp.net.

Let's see it.

I have a site.master page like below.
-------------------------

<head runat="server">

<title></title>
<asp:ContentPlaceHolder ID="ContentPlaceHolder1" runat="server">
</asp:ContentPlaceHolder>
</head>

<body>
<form id="form1" runat="server">
<table><tr>
<td><asp:LinkButton ID="LinkButton2" runat="server" PostBackUrl="~/WebForm1.aspx">Page2</asp:LinkButton></td>
<td><asp:LinkButton ID="LinkButton3" runat="server" PostBackUrl="~/WebForm2.aspx">Page3</asp:LinkButton></td>
</tr></table>
<div>
<asp:ContentPlaceHolder ID="ContentPlaceHolder2" runat="server">
</asp:ContentPlaceHolder>

</div>
</form>
</body>
------------------------------------------------------------
Now on site.master.cs file write following code.

public partial class Site1 : System.Web.UI.MasterPage
{
protected void Page_Load(object sender, EventArgs e)
{

}
public void changecolor(Page obj)
{
if (obj is WebForm1)
{
LinkButton2.ForeColor = Color.Green;
LinkButton3.ForeColor = Color.Empty;

}
if (obj is WebForm2)
{
LinkButton2.ForeColor = Color.Empty;
LinkButton3.ForeColor = Color.Green;

}
}
}
---------------------------------------------------------
Now on each page load event write just following code.

protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Site1 myMasterPage = (Site1)Page.Master;
myMasterPage.changecolor(this.Page);
}
}
--------

Done..

Disable previous dates in calendar

How to disable the past dates in calendar control.

For this you need to write following simple code on DayRender event of calendar.

protected void Calendar1_DayRender(object sender, DayRenderEventArgs e)
{
if (e.Day.Date<System.DateTime.Today)
{
e.Cell.BackColor = System.Drawing.Color.LightGray;
e.Day.IsSelectable = false;
}
}

---------------------------------------------------------------------

Wednesday, 16 January 2013

How to check trust level for sharepoint 2010 custom application

Go to path:

C:\inetpub\wwwroot\wss\VirtualDirectories\10000 (10000 is your application port no)

Go to Web (config file)

and search for trust

You can see there Full/Custom/minimal kind of options.

How to create WSP from solution file visual studio

Often we need to create wsp(work solution package) from Solution file.

What we do

Step1: In Release mode Clean solution.
Step2:Check in bin folder of solution
bin>Release

Delete craeted wsp file from there.

Step3: Now Go to Build->Package

Now go to bin>Release

Your wsp file is created.you can check CAS policy there in solution file.

Go to package then.

Under Package.Template.xml

You can check CAS policy.

Select/Deselect all listbox items by checkbox

Simple code for executing this is

protected void CheckBox1_CheckedChanged(object sender, EventArgs e)

{

foreach (ListItem item in ListBox1.Items) {
item.Selected = CheckBox1.Checked;
}
}