Thursday, 29 March 2012

Grid view image bind from sharepoint list in onrowdata bound event

<
<


{

{





img.ImageUrl = imageurlvale;
}

}
protected void Grdshow_RowDataBound(object sender, GridViewRowEventArgs e)if (e.Row.RowType == DataControlRowType.DataRow)Label lblimg = e.Row.FindControl("lblimg") as Label;Image img = e.Row.FindControl("img") as Image;var text = lblimg.Text;SPFieldUrlValue imgurl = new SPFieldUrlValue(text);string imageurlvale = new Uri(imgurl.Url).AbsoluteUri;
td rowspan="7" style="display:none"><asp:Label ID="lblimg" runat="server" Text='<%#Eval("ProfilePicture")%>'></asp:Label></td>td><asp:Image ID="img" runat="server" /></td>

Monday, 26 March 2012

How to check programmatically if current user can edit a document stored in SharePoint?
 


Programmatically check current user can edit documents in document library




public static bool CanEditDocument(string DocumentURL)
        {
            if (string.IsNullOrEmpty(DocumentURL)) return false;
            using (SPSite tempSite = new SPSite(DocumentURL))
            {
                if (tempSite == null) return false;
                using (SPWeb tempWeb = tempSite.OpenWeb())
                {
                    SPFile Doc = tempWeb.GetFile(DocumentURL);
                    if (Doc == null) return false;
                    if ((Doc.Item.EffectiveBasePermissions &
                      SPBasePermissions.EditListItems)
        == SPBasePermissions.EditListItems)
                        return true;
                }
            }
            return false;
        }
How to check programmatically if current user can edit a document stored in SharePoint?
 
How to check programmatically if current user can edit a document stored in SharePoint?
 

Saturday, 24 March 2012

Export gridview to Excel with Css in Visual webpart



{
protected void btnexcel_Click(object sender, EventArgs e)try{

}

{

}
}
//add this after page load
this.bExport = true;catch (Exception ex)throw ex;
{

{

{

Page.Response.Clear();
Page.Response.Buffer =
Page.Response.ContentType =
Page.Response.AddHeader(
Page.Response.Charset =


System.IO.
System.Web.UI.
Grdshow.RenderControl(htw);
Page.Response.Write(sw.ToString());
Page.Response.End();
}
}

}
protected override void Render(HtmlTextWriter writer)if (Page != null)if (bExport)this.bExport = false;true;"application/ms-excel";"content-disposition", "attachment; filename=AmexReport" + DateTime.Now + ".xls");"UTF-8";HttpContext.Current.Response.Write("Amex Report");this.EnableViewState = false;StringWriter sw = new System.IO.StringWriter();HtmlTextWriter htw = new System.Web.UI.HtmlTextWriter(sw);base.Render(writer);

Tuesday, 20 March 2012

Create folder in sharepoint library programmatically
using
{

{
(SPSite osite =new SPSite("http://igrid103:2345"))using (SPWeb oweb = osite.OpenWeb())try{
oweb.AllowUnsafeUpdates =


libfolder.Add(
olist.Update();
oweb.AllowUnsafeUpdates =

}

{

}
}

}
true;SPList olist = oweb.Lists.TryGetList("Shared Documents");SPFolderCollection libfolder = olist.RootFolder.SubFolders;"http://igrid103:2345/Shared%20Documents/MyFolder/"+"subfolder");false;Console.WriteLine("Folder created sucessfully");catch (Exception ex)throw ex;Console.ReadLine();

Tuesday, 6 March 2012

Data table to bind gridview


Usercontrol

<asp:GridView ID="grd" runat="server" AutoGenerateColumns="false"  CssClass="iGActOverDue" >
<Columns>
<asp:BoundField HeaderText="Name" DataField="Name" ItemStyle-ForeColor="#000000"  HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Center"/>
<asp:TemplateField>
<HeaderTemplate>
<asp:Label ID="lblheader" runat='server' Text="Joining Date"></asp:Label>
</HeaderTemplate>
<ItemTemplate>
<asp:Label ID="lbl" runat ="server" Text='<%# Eval("Joining Date", "{0:dd-M-yyyy}") %>' ForeColor="Black" ItemStyle-ForeColor="#000000" HeaderStyle-HorizontalAlign="left" ItemStyle-HorizontalAlign="Center">
</asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:BoundField HeaderText="Course" DataField="Course"   HeaderStyle-HorizontalAlign="Center" ItemStyle-ForeColor="#000000" ItemStyle-HorizontalAlign="Center"/>
<asp:BoundField HeaderText="Total Hours" DataField="Total Hours"   HeaderStyle-HorizontalAlign="Center" ItemStyle-ForeColor="#000000" ItemStyle-HorizontalAlign="Center" />
<asp:BoundField HeaderText="Completed Hours" DataField="Completed Hours"  HeaderStyle-HorizontalAlign="Center" ItemStyle-ForeColor="#000000" ItemStyle-HorizontalAlign="Center"/>
<asp:BoundField HeaderText="Total Assignments" DataField="Total Assignments"   HeaderStyle-HorizontalAlign="Center" ItemStyle-ForeColor="#000000" ItemStyle-HorizontalAlign="Center"/>
<asp:BoundField HeaderText="Completed Assignments" DataField="Completed Assignments"  HeaderStyle-HorizontalAlign="Center" ItemStyle-ForeColor="#000000" ItemStyle-HorizontalAlign="Center"/>
<asp:TemplateField>
<HeaderTemplate>
<asp:Label ID="lbltxt" Text="Email" runat="server"></asp:Label>
</HeaderTemplate>
<ItemTemplate>
<asp:Button ID="btnemail" Text="Send email" runat="server"  CssClass="ms-ButtonHeightWidth" HeaderStyle-HorizontalAlign="Center" ItemStyle-ForeColor="#000000" ItemStyle-HorizontalAlign="Center"/>
</ItemTemplate>
</asp:TemplateField>
<asp:BoundField HeaderText="Current Grade" DataField="Current Grade"  HeaderStyle-HorizontalAlign="Center" ItemStyle-ForeColor="#000000" ItemStyle-HorizontalAlign="Center"/>
</Columns>
</asp:GridView>


Code
 public void gridshow()
        {
            try
            {
                DataTable dt = new DataTable();
                dt.Columns.Add("Name", typeof(string));
                dt.Columns.Add("Joining Date", typeof(DateTime));
                dt.Columns.Add("Course", typeof(string));
                dt.Columns.Add("Total Hours", typeof(int));
                dt.Columns.Add("Completed Hours", typeof(int));
                dt.Columns.Add("Total Assignments", typeof(int));
                dt.Columns.Add("Completed Assignments", typeof(int));
                dt.Columns.Add("Current Grade", typeof(string));
                dt.Rows.Add("anand raj", "3 /6/ 2012", "SharePoint", 2, 3, 4, 3,"A+");
                dt.Rows.Add(" raj", "3 / 7 / 2012", "SharePoint", 2, 3, 4, 3,"B");
                dt.Rows.Add("albert", "3 / 8 / 2012", "SharePoint", 2, 3, 4, 3,"B+");
                dt.Rows.Add("rajkumar", "3/ 9 / 2012", "SharePoint", 2, 3, 4, 3,"C");
                dt.Rows.Add("vikram", "3/ 10 / 2012", "SharePoint", 2, 3, 4, 3,"A");
                dt.Rows.Add("andrews", "3/11 / 2012", "SharePoint", 2, 3, 4, 3,"A+");
                dt.Rows.Add("stalin", "3/ 12 / 2012", "SharePoint", 2, 3, 4, 3,"C");
                dt.Rows.Add("james", "3/ 13 / 2012", "SharePoint", 2, 3, 4, 3,"B+");
                dt.Rows.Add("anand", "3 / 14 / 2012", "SharePoint", 2, 3, 4, 3,"A");
                grd.DataSource = dt;
                grd.DataBind();
            }
            catch (Exception ex)
            {
                lblerror.Text = ex.Message;
            }
         
        }

Thursday, 1 March 2012

Get Portless Url


            Uri urlnew =new Uri( "http://igrid103:1990");
            string split = urlnew.Scheme + Uri.SchemeDelimiter + urlnew.Host+ ":" + uri.Port;
            Console.WriteLine(split);
            Console.ReadLine();
The Detail of the above code comes below

             //urinew.scheme==http
            //uri.schemedelimiter=://
            //urlnew.Host=igrid103
              uri.port=1990;