Techno Freak

Using SharePoint Data in your LightSwitch Applications

noreply@blogger.com (Pritesh Gandhi) — Wed, 10 Aug 2011 15:15:00 +0000

One of the great features of LightSwitch is that it lets you connect to and manipulate data inside of SharePoint. Data can come from any of the built in SharePoint lists like Tasks or Calendar or it can come from custom lists that you create in SharePoint. .LightSwitch provides the ability to connect to multiple data sources like external databases and SharePoint and relate them together. However when you want to present data from multiple data sources on the same screen you need to tell LightSwitch the order in which you want to save this data.

More Details Refer this link

BCP Utility + Sql Server 2005 / 2008

noreply@blogger.com (Pritesh Gandhi) — Sat, 09 Jul 2011 07:35:00 +0000

This article is based on bcp (Bulk Copy Processing). BCP utility is generally used to transfer large data into own file format.

For More Details you can visit : http://msdn.microsoft.com/en-us/library/ms162802.aspx

This utility is useful to archiving log which is older then 30 days and It will dump all records to the file. If bcp commands run successfully then only delete command will execute and delete all the archiving records from database.

I have created Stored Procedure for Log Archiving. Please find list of advantage of Log Archive Script:

- Run "SQLInsertScriptForBCP.sql" for Creating Dummy Table for BCP.

- User can pass Table Name, No of Days Older, Path and File Name as parameter

- While Archive log if any error is generated then it will log that error and Delete command will not be executed.

- Automatically retrieve server name.

- You can run this utility on schedule also.

That's it.

Download Link

Regards

Pritesh Gandhi.

Reference links:

http://sqlfool.com/2008/12/bcp-basics/

SharePoint 2010 Client Object Model

noreply@blogger.com (Pritesh Gandhi) — Fri, 08 Jul 2011 15:14:00 +0000

1. SharePoint 2010: Client Object Model – an Introduction

2. SharePoint 2010: Client Object Model for JavaScript (ECMAScript)

3. SharePoint 2010: Managed .net Client with Client Object Model (OM)

4. SharePoint 2010 Silverlight Client Object Model - How to use

5. SharePoint 2010 Managed Client Object Model - Samples and Examples

6. http://msdn.microsoft.com/en-us/library/ee857094%28office.14%29.aspx

7. Client Object Model Advantage

Regards

Pritesh Gandhi

asp.net date validation with three drop down list

noreply@blogger.com (Pritesh Gandhi) — Mon, 06 Jun 2011 16:19:00 +0000

Hi,

If you want to do date validation on three drop down list then please find below is reference and Solution.

Reference : http://stackoverflow.com/questions/2100649/asp-net-date-validation-with-three-drop-down-list

var minYear=1900;

var maxYear=2100;

function daysInFebruary (year){

// February has 29 days in any year evenly divisible by four,

// EXCEPT for centurial years which are not also divisible by 400.

return (((year % 4 == 0) && ( (!(year % 100 == 0)) || (year % 400 == 0))) ? 29 : 28 );

}

function DaysArray(n) {

for (var i = 1; i <= n; i++) { this[i] = 31 if (i==4 || i==6 || i==9 || i==11) {this[i] = 30} if (i==2) {this[i] = 29} } return this } function isDate(strDay,strMonth,strYear ){ var daysInMonth = DaysArray(12) if (strDay.charAt(0)=="0" && strDay.length>1) strDay=strDay.substring(1)

if (strMonth.charAt(0)=="0" && strMonth.length>1) strMonth=strMonth.substring(1)

for (var i = 1; i <= 3; i++) { if (strYr.charAt(0)=="0" && strYr.length>1) strYr=strYr.substring(1)

}

month=parseInt(strMonth)

day=parseInt(strDay)

year=parseInt(strYr)

if (strMonth.length<1 || month<1 || month>12){

alert("Please enter a valid month")

return false

}

if (strDay.length<1 || day<1 || day>31 || (month==2 && day>daysInFebruary(year)) || day > daysInMonth[month]){

alert("Please enter a valid day")

return false

}

if (strYear.length != 4 || year==0 || yearmaxYear){
alert("Please enter a valid 4 digit year between "+minYear+" and "+maxYear)
return false
}

return true
}

Retrieve Text and Value of ASP.Net DropDown List + JavaScript

noreply@blogger.com (Pritesh Gandhi) — Mon, 06 Jun 2011 15:27:00 +0000

// JavaScript Code

//Diplay the Text and Value of ASP Dropdown List

function DisplayTextAndValueofDropDown() {

var ddlDropDownID = document.getElementById("<%=DropDownList1.ClientID%>");

var DisplayText = ddlDropDownID.options[ddlDropDownID.selectedIndex].text;

var DisplayValue = ddlDropDownID.options[ddlDropDownID.selectedIndex].value;

alert(DisplayText);

alert(DisplayValue);

}

//HTML Code

<asp:dropdownlist id="DropDownList1" runat="server">
<asp:listitem text="TestText" value="TestValue"></asp:listitem>
<asp:listitem text="TempText" value="TempValue"></asp:listitem>
</asp:dropdownlist>

<asp:button id="btnValidation" onclientclick="DisplayTextAndValueofDropDown();" runat="server" text="Click Me"></asp:button>

Calling ASP.Net Validator from JavaScript

noreply@blogger.com (Pritesh Gandhi) — Tue, 17 May 2011 15:45:00 +0000

Hi ,

How to calll asp.net validators conttrol from JavaScript

Here is nice article for Calling ASP.Net Validator from JavaScript

http://razeeb.wordpress.com/2009/01/11/calling-aspnet-validators-from-javascript/

Regards

Pritesh Gandhi

PowerShell Script to Automatically Deploy Web Parts in SharePoint 2010

noreply@blogger.com (Pritesh Gandhi) — Wed, 23 Mar 2011 17:24:00 +0000

Please refer below links for deploy web part automatically through PowerShell.

http://ranaictiu-technicalblog.blogspot.com/2010/05/sharepoint-2010-deployment-powershell.html?showComment=1300872767931#c7781328997901984868

http://community.bamboosolutions.com/blogs/sharepoint-2010/archive/2010/12/20/sharepoint-2010-cookbook-powershell-script-to-deploy-bamboo-solutions-web-parts.aspx

Regards,Pritesh Gandhi |Cell : +919004046104 begin_of_the_skype_highlighting +919004046104 end_of_the_skype_highlighting | Site : www.gandhipritesh.com

My profiles:
Contact me: pritesh.b.gandhi PRIT0783

“

"Two things are infinite: the universe and human stupidity; and I'm not sure about the the universe." - Albert Einstein

”

Get this email app!

Signature powered by WiseStamp

Solution Do not Retract Or Do not Deploying

noreply@blogger.com (Pritesh Gandhi) — Sat, 19 Mar 2011 06:25:00 +0000

When you go to the 'Solution Management' screen of Central Administration and retract a solution (wsp) it seems to retract ok but the status of the solution remains ‘Deployed’. When you try and delete the solution in the GUI you then get an error saying that you must retract the solution first – but it is retracted!So you can say it almost hang mode where you are not able retract or deploying new solution

Please use below Commands for survive

// Disable Feature from Web Application

Disable-SPFeature -Identity FeatureFolderName -url http://sitename

Note : FeatureFolderName you can find from C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\TEMPLATE\FEATURES\

You can deactivate Feature from Site Collection .

// Uninstall Feature from Site Collection

Uninstall-SPFeature FeatureFolderName

Note : FeatureFolderName you can find from C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\TEMPLATE\FEATURES\

//Remove Solution from All Web Application

Uninstall-SPSolution -identity TestWebPart.wsp -allwebapplications

//Remove Solution from Central Administration using Force Command

remove-spsolution -identity TestWebPart.wsp.wsp -force

//Again Add Solution

add-spsolution -literalpath C:\TestWebPart.wsp

//Install Solution using Force Command

install-spsolution -identity TestWebPart.wsp -webapplication http://Siteurl -GACDeployment -force

Remove Or Hide Sign in As Different User Option from Share Point

noreply@blogger.com (Pritesh Gandhi) — Sat, 12 Mar 2011 07:34:00 +0000

This article is useful for Remove Sign in as Different user From top Navigation.

Follow below steps for remove "Sign in as Different User"

Step 1 : Add Content Editor Web part

Step 2 : Copy below code

jQuery(document).ready(function($){

var objects = document.getElementsByTagName("ie:menuitem");

for (var i = 0; i < objects.length; i++) {

itm = objects[i];

if ($('#' + itm.id).attr("text") == "Sign in as Different User")

{

$('#' + itm.id).remove();

}

})

</script>

Step 3 : Save web part or web page.

Step 4 : Done.

Step 1 : Alternate solution is copy welcome.ascx control and move to Create Custom Control folder and move that welcome.ascx control .

Step 2 : Remove Sign in as different user menu item.

Step 3 : Change Master Page through Share Point Designer

<%@ Register TagPrefix="wssuc" Tagname="Welcome" src="_controltemplates/Welcome.ascx" %>

and change to your Custom Welcome User control

<%@ Register TagPrefix="wssuc" Tagname="Welcome" src="_controltemplates/CustomUserControl /Welcome.ascx" %>

Step 4 : Save master page.

Some References:

http://aaclage.blogspot.com/2009/01/sharepoint-custom-welcome-control.html

http://www.sharepointoverflow.com/questions/8884/unable-to-hide-loginasdifferentuser-menu-in-sp2010

Deploy Web Part Through SharePoint 2010 Management Power Shell

noreply@blogger.com (Pritesh Gandhi) — Thu, 03 Mar 2011 17:47:00 +0000

Here this article you can see list commands which is useful for deploying the web part in Farm Level ,Web Application leve or site collection level.In Sharepoint 2010 l you can run below commands on SharePoint 2010 Management Power Shell.

Add Web Part to Central Administration And Web Application Level

Step 1 : Open SharePoint 2010 Management Shell
        1. Verify that you meet the following minimum requirements: See Add-SPShellAdmin.
        2.On the Start menu, click All Programs.
        3. Click Microsoft SharePoint 2010 Products.
        4.Click SharePoint 2010 Management Shell.
        5. At the Windows PowerShell command prompt, type the following command:

// Add Solution to SharePoint 2010 Central Administration
Step 2 : Add-SPSolution -LiteralPath
    e.g Add-SPSolution -LiteralPath C:\TestWebPart.wsp

//Install Solution @ Web Application
Step 3 : Install-SPSolution -Identity -WebApplication
    e.g. Install-SPSolution -Identity "TestWebPart.wsp" -webapplication                                      "http://sitename"-GACDEployment

//Activate Site Collection Feature @ Web Application
Step 4 : Enable-SPFeature -Identity -URL http://url
    e.g. Enable-SPFeature -Identity ba5bc6d0-d2d9-4032-8334-7767aabb2414 -url                       http://sitename

    Enable-SPFeature -Identity TestWebPart_Feature1 -url http://sitename

Step 5 : On Completion of Step 3 , 4 and 5 your web part will be deploy on Web application and also feature is activate.

Same Way Remove Web Part from Web Application and Farm Level

-- Disable Feature from Web Application
Disable-SPFeature -Identity TestWebPart_Feature1 -url http://sitename

-- Remove Web Part from Web Application
Uninstall-SPSolution –Identity TestWebPart.wsp –WebApplication http://sitename
Remove-SPSolution–Identity TestWebPart.wsp

-- Remove Solution from Central Administration
Remove-SPSolution "TestWebPart.wsp"

-- Uninstall Feature from Site Collection

Uninstall-SPFeature FeatureFolderName

--To Update Existing web part
Update-SPSolution –Identity TestWebPart.wsp –LiteralPath “C:\TestWebPart.wsp” –GacDeployment

Listing Features on Farm,SiteCollection

--To see all features for a Web Application:
    Get-SPFeature -WebApplication http://webapplicationName

--To see all features for a Site Collection:
    Get-SPFeature -Site http://sitecollection

--To see all features for a Site:
    Get-SPFeature -Web http://siteurl

If Share Point solutions do not retract or do no Deploying then Please use below Commands for survive

//Remove Solution from All Web Application
Uninstall-SPSolution -identity TestWebPart.wsp -allwebapplications

//Remove Solution from Central Administration using Force Command
remove-spsolution -identity {name of wsp file.wsp} -force

//Again Add Solution
add-spsolution -literalpath C:\{FULL file system location\name of wsp file.wsp}

//Install Solution using Force Command
install-spsolution -identity TestWebPart.wsp -webapplication http://Siteurl -GACDeployment -force

References :

http://www.sharepointanalysthq.com/2010/09/sharepoint-2010-powershell-feature-cmdlets-2/
http://patrickboom.wordpress.com/2010/05/31/using-powershell-to-deploy-sharepoint-solutions-wsp-2/
http://www.dotnetmafia.com/blogs/dotnettipoftheday/archive/2009/12/02/adding-and-deploying-solutions-with-powershell-in-sharepoint-2010.aspx

Read and Write Binary Format from Database

noreply@blogger.com (Pritesh Gandhi) — Sat, 05 Feb 2011 09:04:00 +0000

Introduction :

This article is showing how to store file like ( word , excel , image ,pdf etc ... ) in Database.We are using BLOB ( Binary Large Object ) to store data to Microsoft SQL Server.

Below are some key points of article :

1. Restore Pubs Database in SQL Server.

2. User can upload document on Specified Folder.

3. Click on Store File in Binary Format . Data will be stored in Sql Server pubs database using binary object.

4 . Click on Load Binary file . It will read file from current uploaded file from pubs Database. Display as popup to save or open the file.

5. Cheers for life.

Download Link Coming Soon ....

Regards

Pritesh Gandhi

How to know logged in user information + Sharepoint 2010

noreply@blogger.com (Pritesh Gandhi) — Tue, 01 Feb 2011 14:00:00 +0000

Here is the Nice article for How to get logged in user information

List of Common TCP/IP Port Number

noreply@blogger.com (Pritesh Gandhi) — Thu, 30 Dec 2010 14:58:00 +0000

Download PDF File

LINQ Sample Application

noreply@blogger.com (Pritesh Gandhi) — Fri, 03 Dec 2010 15:56:00 +0000

Hi All ,

I have created one sample application for LINQ.
Which contains Add , Update , Delete and Order By events on Grid.

Find Below screen shot for LINQ Application.

Download Sample LINQ Example

Regards
Pritesh Gandhi

Generate PDF Reports Directly using ReportViewer Control in Asp.net + SSRS

noreply@blogger.com (Pritesh Gandhi) — Wed, 01 Dec 2010 13:12:00 +0000

Generate PDF Reports Directly using ReportViewer Control in Asp.net + SSRS

Here this article I am explaining how to generate PDF reports directly on specific shared folder using report viewer control of asp.net.

Step 1 : Create Dataset in App_Code folder

Step 2 : Create rdlc report and use that Dataset in RDLC report

Step 3 : Create ASPX page use Report Viewer control and Object DataSource for Bind rdlc report with Report Viewer control

Step 4 : paste below code for Generate PDF report using report viewer

private void GeneratePDF()
    {
      //ReportViewer1.Visible is set to false in design mode

      //ReportViewer1.Visible = true;
      string _connConnString = ConfigurationManager.ConnectionStrings["TestDBConnectionString"].ConnectionString;
      SqlConnection conn = new SqlConnection(_connConnString);

      DataSet thisDataSet = new DataSet();
      SqlCommand cmd = new SqlCommand("SELECT * FROM [TestDB].[dbo].ProductInfo", conn);

      cmd.CommandType = CommandType.Text;
     
      SqlDataAdapter adpt = new SqlDataAdapter(cmd);
      adpt.Fill(thisDataSet);

      LocalReport report = new LocalReport();
      string reportName = "CompletionCertificate";
      string deviceInfo =
        "<DeviceInfo>" +
        "  <OutputFormat>EMF</OutputFormat>" +
        "  <PageWidth>8.5in</PageWidth>" +
        "  <PageHeight>11in</PageHeight>" +
        "  <MarginTop>0.25in</MarginTop>" +
        "  <MarginLeft>0.25in</MarginLeft>" +
        "  <MarginRight>0.25in</MarginRight>" +
        "  <MarginBottom>0.25in</MarginBottom>" +
        "</DeviceInfo>";
      Warning[] warnings;
      string[] streamids;
      string mimeType;
      string encoding;
      string extension;
      report.EnableExternalImages = true;
      report.ReportPath = Server.MapPath("Report1.rdlc");
      ReportDataSource datasource = new
        ReportDataSource("DataSet1_ProductInfo",
        thisDataSet.Tables[0]);
      Random randNo = new Random();
      
      //Generate PDF
      string pdfName = "Test_" + randNo.Next(50000).ToString() + ".pdf";
      report.DataSources.Add(datasource);
      byte[] bytes = report.Render("PDF", deviceInfo, out mimeType, out encoding, out extension, out streamids, out warnings);
      FileStream fs = new FileStream(@"" + "c:\\" + "" + pdfName, FileMode.Create);
      fs.Write(bytes, 0, bytes.Length);
      fs.Close();

      //Generate Excel
      string excelName = "Test_" + randNo.Next(50000).ToString() + ".xls";
      report.DataSources.Add(datasource);
      byte[] bytesExcel = report.Render("Excel", deviceInfo, out mimeType, out encoding, out extension, out streamids, out warnings);
      FileStream fsExcel = new FileStream(@"" + "c:\\" + "" + excelName, FileMode.Create);
      fsExcel.Write(bytesExcel, 0, bytesExcel.Length);
      fsExcel.Close();

      
    }

Step 5 : PDF Report will generate Automatically on shared folder

Step 6 : That's all

101 LinQ Samples

noreply@blogger.com (Pritesh Gandhi) — Thu, 23 Sep 2010 13:41:00 +0000

http://msdn.microsoft.com/en-us/vcsharp/aa336746.aspx

Killer Shayries Part 2

noreply@blogger.com (Pritesh Gandhi) — Fri, 03 Sep 2010 07:35:00 +0000

Killer Shayries Part 2

1. Tumse pyaar karte karte hamne kar diya crime....

Tumse pyaar karte karte hamne kar diya crime....

." 1 is neither composite nor prime"

2. Agar dava chahiye toh dhundo koi chemist....

Agar dava chahiye toh dhundo koi chemist....

My NAME IS KHAN and I AM NOT A TERRORIST...

3. Yuh khamosh rehkar tadpoge kabtak....

Yuh khamosh rehkar tadpoge kabtak....

Cameraman praful ke saath deepak chaurasia AAJ TAK..

4.. Arj kiya hai..

He is KISSING

She is KISSING

He is KISSING

She is KISSING

* * *Some test missing

* * *some text missing

5. Woh mujhe chhod ke chali gayi usse pana mein chahun....

Woh mujhe chhod ke chali gayi usse pana mein chahun....

Ahun ahun ahun

6.mehgai ke iss daur mein karna padta hai apne kharche par kabooo..

Mehgai ke iss daur mein karna padta hai apne kharche par kabooo..

Ek chutki sindoor ki kimat tum kya jano Ramesh babu...

7. Akbar NE kharide 3-3 ghode..

Akbar NE kharide 3-3 ghode..

Aja aja dil nichode ....

Raat ki matki phode...

8.mein hoon yahan TU hai wahan...

Mein hoon yahan TU hai wahan..

LIFEBUOY hai jahan tandurusti hai wahan...

9. Blood donate karne se pehle hamesha uska group janchna...

Blood donate karne se pehle hamesha uska group janchna...

"BASANTI in kuton ke samne mat nachna...."

10 . Ratan tata NE establish kiya TATA..

Ratan tata NE establish kiya TATA..

"itni sakti hamen dena data "

In Commerce Server manager Profile resource display " web page can not be found "

noreply@blogger.com (Pritesh Gandhi) — Fri, 27 Aug 2010 13:00:00 +0000

Problem : When you open profile global resource file It display message web page can not be found ....

Solution : http://microsoftblog.co.in/commerceserver/troubleshoot-commerce-server-manager-is-not-loading-data-in-cs2009/

Nice Explanation ... Thanks Ravi ....

Sometime Website DataSource is Empty ..... in rdlc report

noreply@blogger.com (Pritesh Gandhi) — Fri, 13 Aug 2010 08:02:00 +0000

Problem :

Sometime it's problem that Business User Objects not displayed. SO you are not able to

select datasource for Creating rdlc report.

If you click on refresh button then also it's not displayed ...

Very weird and frustrated .... i can try lots of way but no solution find out ....

Finally i found solution and it's working kool ...

Thanks to Atelen ( http://forums.asp.net/p/1035423/4025430.aspx#4025430 )

Solution :

Hi. Workaround that worked for me.

1)Add ekstra aspx page

2)Add ReportViewer

3) go to design mode--> klick > in upper right corner and choose Design new report.(and

after it opens, do not choose datasource , just close the window). (if you get out of range

error or something like that, go back to your rdlc and delete all items without a object

datasource from the report, build and repeat steps) After this the Website data soruce

window is back. Using visualt studio 2008 , workes every time for me and 3 other i work

with.

Sql Server 2008 Full Text Search Error

noreply@blogger.com (Pritesh Gandhi) — Tue, 08 Jun 2010 11:57:00 +0000

Error Msg :

Msg 30046, Level 16, State 1, Line 1

SQL Server encountered error 0x80070422 while communicating with full-text filter daemon host (FDHost) process. Make sure that the FDHost process is running. To re-start the FDHost process, run the sp_fulltext_service 'restart_all_fdhosts' command or restart the SQL Server instance.

I have faced this error when I am searching records from SQL Server 2008.

Solution :

Step 1 : Go to Start --> Run --> Services.msc

Step 2 : Click on SQL Full-text Filter Daemon Launcher (MSSQLSERVER) If it is Disable then Start Services

Step 3 : Click Properties --> Go To Log on Tab

Step 4 : Change Credential As Screenshot

Step 5 : Restart Service Again

Step 6 : Go To SQL Server Management Studio

Step 7 : Run Query - sp_fulltext_service 'restart_all_fdhosts'

Step 8 : Msg Displayed : Command Completed Successfully.

Step 9 : Smile

What Would It Look Like?

noreply@blogger.com (Pritesh Gandhi) — Tue, 25 May 2010 07:25:00 +0000

Commerce Server 2009 Installation Guide

noreply@blogger.com (Pritesh Gandhi) — Thu, 20 May 2010 13:26:00 +0000

This guide provides an overview of the hardware, software, and security-enhanced configuration requirements for Commerce Server 2009, and detailed instructions for installing and configuring Commerce Server 2009 on a single computer.

Download

Localization And Globalization Resource + ASP.Net

noreply@blogger.com (Pritesh Gandhi) — Wed, 12 May 2010 11:28:00 +0000

Please refer below link for localization resource , Localization\Globalization Considerations and Tips

http://mosesofegypt.net/?tag=/localization

Commerce Server 2009 Broad View

noreply@blogger.com (Pritesh Gandhi) — Fri, 30 Apr 2010 05:35:00 +0000

Object Reference Not set to instance of an Object in SQL Server Reporting Service ( SSRS )

noreply@blogger.com (Pritesh Gandhi) — Tue, 27 Apr 2010 07:52:00 +0000

Hi Folks

Problem :

Some Times it is possible that when you are update framework or hotfix on frond end server then SQL Server Reporting service gives error " Object Reference Not set to instance of an Object "

Solution :

this problem is occurred because of Virtual Directory setting is changed. So Follow below steps :