load report failed in iis7

You have to give permission to temp folder in server pc Click Start-->Run-->Type Explorer--> go to C:/ Windows temp Right click on Temp folder Properties give the user to full/write control

Trusted Connection failed for IIS7 in localhost

Create a new user of your PC (if you alreasy have do not to create) One of our websites use Impersonation and a specific user account with special permissions to access certain system resources. The first step in enabling impersonation is, setting up the correct attributes in the web.config file write By using the attribute impersonate="true", you are telling IIS that this website will be impersonating the configured user account.

• 1. Open IIS Manager
• 2. Expand computer name
• 3. Expand websites
• 4. Click on the specific website for which you want to use impersonation
• 5. On the right panel, under the heading "IIS", double click "Authenticaion".
• 6. Right click on "ASP.NET Impersonation" and select "Edit"
• 7. Choose "Specific User".
• 8. Click the SET button to provide the specific user name and password.

Press OK at the popup dialog to complete this step on enabling impersonation for website in IIS 7.0. How to choose process identity for Application Pool in IIS 7.0 To set the correct user identity for the application pool, follow the steps below:

• 1. Open IIS Manager
• 2. Click on "Application Pools" under the computer name
• 3. On the right panel, right click on the application pool name
• 4. Select "Advanced properties"
• 5. Select "Identity" under "Process Model".
• 6. Click on the button to set the user account.
• 7. Select "Custom account"
• 8. Click on the button to specify the user account and password.
• 9. Press "OK".

Row wise sum to the next row

whileprintingrecords; numbervar subtotal; subtotal := subtotal + ({@TotAmt})

Another Way To addrow in datatable using Jquery

Antecedents/Triggers	Consequences	Timing	Consistency
Sooner Later Certain Uncertain

function addRow() { var tbl = document.getElementById('tbl'); var Row = parseInt(document.getElementById('hsb').value); var temprow=Row+1; var mainRow = tbl.insertRow(temprow); var trId ="tr"+temprow; mainRow.id=trId; var td = document.createElement("td"); td.colSpan='6'; var table = document.createElement("table"); table.border="0"; table.cellPadding="0"; table.cellSpacing="1"; table.width="100%" var newRow = table.insertRow(0); var sec = "'risk'"; var newCell = newRow.insertCell(0); newCell.width="50%" newCell.innerHTML = ' var newCell = newRow.insertCell(1); newCell.width="17%" newCell.innerHTML = ''; var newCell = newRow.insertCell(2); newCell.width="10%" newCell.innerHTML = 'SoonerLater'; var newCell = newRow.insertCell(3); newCell.width="10%" newCell.innerHTML = 'CertainUncertain'; td.appendChild(table); mainRow.appendChild(td); document.getElementById('hsb').value=temprow; }

Adding,Deleting Row in gridview using Jquery (Very Effective)

Records
Company	Product	Model	State	City	Quantity	Contact Mail ID	Select
onetwo	onetwo	onetwo	onetwo	onetwo
onetwo	onetwo	onetwo	onetwo	onetwo

Jqueyy code: $(document).ready( function () { $("#DuplicateRow").click( function () { var checkboxValues = []; $('input[type="checkbox"]:checked').each( function () { var $chkbox = $(this); var $actualrow = $chkbox.closest('tr'); var $clonedRow = $actualrow.clone(); $clonedRow.find("select").each( function (i) { this.selectedIndex = $actualrow.find("select")[i].selectedIndex; } ) $chkbox.closest('#tabletomodify').append($clonedRow); } ); } ); $("#DeleteRow").click( function () { var checkboxValues = []; $('input[type="checkbox"]:checked').each( function () { var $chkbox = $(this); $(this).closest("tr").remove(); } ); } ); $("#AddRow").click( function () { var row = document.getElementById("row"); // find row to copy var table = document.getElementById("tabletomodify"); // find table to append to var clone = row.cloneNode(true); // copy children too clone.id = "row"; // change id or other attributes/contents table.appendChild(clone); // add new row to end of table } ); $('#tabletomodify').on('change','.selcompany', function () { var optionSelected = $("option:selected", this); var valueSelected = this.value; alert(valueSelected); }); } );

Object Object , Json Parse Problem in jquery

success: function(msg) { alert("{Pid:'"+ faram+"'}"); var orders =msg; if (orders.length > 0) { alert(orders.length ); test(orders); } function test(data) { for (i in data) { for (k in data[i]) { alert(data[i][k]); } }

LINQ Tutorials

http://www.codeproject.com/Articles/46422/A-LINQ-Tutorial-Adding-Updating-Deleting-Data

Asp.net Gridview Lazy Loading

http://www.go4coding.com/post/2011/04/11/Auto-loading-content-on-page-scroll-in-aspnet-using-jquery.aspx http://aspsnippets.com/Articles/Loading-data-in-GridView-while-scrolling-down-in-ASPNet-using-jQuery-AJAX.aspx http://aspsnippets.com/Articles/Load-on-demand-data-in-GridView-on-scroll-using-ASPNet-and-jQuery-AJAX.aspx

"Invalid JSON primitive" in JQery, Ajax

Data Should Be written in this form if the argument is string data:'{Pid:'+ JSON.stringify(faram)+'}', or data:"{Pid:'"+ JSON.stringify(faram)+"'}", Success success: function(msg) { var orders =msg; if (orders.length > 0) { alert(orders); To Show The Errors error: function(xhr, textStatus, errorThrown) { alert(xhr.status); alert(errorThrown); alert(xhr.responseText);

Bootstrap Tools

http://designshack.net/articles/css/20-awesome-resources-for-twitter-bootstrap-lovers/ http://stylebootstrap.info/ http://charliepark.org/bootstrap_buttons/ http://bootstrapstyler.com/#themes https://wrapbootstrap.com/ http://bootswatch.com/ http://builtwithbootstrap.com/ http://www.extendingfireworks.com/ http://axutopia.com/twitter-bootstrap/ http://gui.repixdesign.com/#freebies http://fortawesome.github.io/Font-Awesome/ http://addyosmani.github.io/jquery-ui-bootstrap/ http://www.eyecon.ro/colorpicker-and-datepicker-for-twitter-bootstrap.htm http://designshack.net/articles/css/5-incredibly-useful-tools-built-into-twitter-bootstrap/ http://alistapart.com/article/building-twitter-bootstrap

Map Box

http://www.mapbox.com/help/#adding-custom-layers
http://www.mapbox.com/tilemill/docs/win-install/
http://www.mapbox.com/tilemill/docs/crashcourse/point-data/
http://www.mapbox.com/blog/mapping-google-doc-spreadsheet/
https://github.com/mapbox/tilemill/downloads
http://www.mapbox.com/tilemill/docs/manual/interface-tour/
http://www.enterprisedb.com/products-services-training/pgdevdownload
http://www.sharpgis.net/page/Shape2SQL.aspx

http://live.osgeo.org/en/quickstart/tilemill_quickstart.html
http://dataforradicals.com/the-insanely-illustrated-guide-to-your-first-tile-mill-map/
http://hub.qgis.org/projects/quantum-gis/wiki/Download

Full Width Footer in Bootstrap

<footer>
    <div class="footer">
       <div class="container narrow row-fluid">
          <div class="span4">
          </div>
          <div class="span3">
          </div>
          <div class="span5">
          </div>
       </div>
    </div></footer>

"SyntaxError: JSON.parse: unexpected character" in Asp.net ,ajax, jquery.....

in system.web

Paste the following code
<compilation debug="true">

<
assemblies><
add assembly="System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/></
assemblies></
compilation><
httpHandlers><
remove verb="*" path="*.asmx"/><
add verb="*" path="*.asmx" validate="false" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/><
add verb="*" path="*_AppService.axd" validate="false" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/><
add verb="GET,HEAD" path="ScriptResource.axd" type="System.Web.Handlers.ScriptResourceHandler, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" validate="false"/></
httpHandlers><
httpModules><
add name="ScriptModule" type="System.Web.Handlers.ScriptModule, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/></
httpModules>

PSD to HTML tutorials

http://css.dzone.com/articles/30-psd-html-tutorials
http://css3generator.com/

Zoom problem in Bootstrap

1) Go to Bootstrap.css
2)  img {
change 100% to none.
max-width:   none;
}

Bootstrap tutorial

http://charliepark.org/bootstrap_buttons/
http://www.pdftoexcelonline.com/success.aspx
http://www.htmlvalidator.com/htmlval/fontsandcolors.html
http://www.plugolabs.com/twitter-bootstrap-button-generator/

How to hide a row conditionally in crystal report

Crystal Reports ----->Report----->Selection Formula---->Record

write the following formula

{DataTable1.IssueQty}<>0;

It means If the value of IssueQty is not equal to 0 the a row will be visible otherwise visible is false

Windows Vista and Windows Server 2008 and later Adding Firewall Exception to Allow remote Database Access

To open a port in the Windows firewall for TCP access

1. On the Start menu, click Run, type WF.msc, and then click OK.
2. In the Windows Firewall with Advanced Security, in the left pane, right-click Inbound Rules, and then click New Rule in the action pane.
3. In the Rule Type dialog box, select Port, and then click Next.
4. In the Protocol and Ports dialog box, select TCP. Select Specific local ports, and then type the port number of the instance of the Database Engine, such as 1433 for the default instance. Click Next.
5. In the Action dialog box, select Allow the connection, and then click Next.
6. In the Profile dialog box, select any profiles that describe the computer connection environment when you want to connect to the Database Engine, and then click Next.
7. In the Name dialog box, type a name and description for this rule, and then click Finish.

Microsoft.ACE.OLEDB.12.0 provider is not registered in windows server 8

Basically, if you're on a 64-bit machine, IIS 7 is not (by default) serving 32-bit apps, which the database engine operates on. So here is exactly what you do: 1) ensure that the 2007 database engine is installed, this can be downloaded at: http://www.microsoft.com/downloads/details.aspx?FamilyID=7554F536-8C28-4598-9B72-EF94E038C891&displaylang=en 2) open IIS7 manager, and open the Application Pools area. On the right sidebar, you will see an option that says "Set application pool defaults". Click it, and a window will pop up with the options. 3) the second field down, which says 'Enable 32-bit applications' is probably set to FALSE by default. Simply click where it says 'false' to change it to 'true'. 4) Restart your app pool (you can do this by hitting RECYCLE instead of STOP then START, which will also work). 5) done, and your error message will go away.

Asp.net Menu Item Not Shown In internet Explorer

In the Head Section  of Pages or Master pages Just write the following Code

<meta http-equiv="X-UA-Compatible" content="IE=EmulateIE7" />

Element or class LIKE selector for JQuery

• [class*=main] will select elements whose classname contains 'main'
• [class~=main] will select elements whose classname has the word 'main' (delimited with spaces)
• [class$=main] will select elements whose classname ends in 'main'
• $("[class^=main]") will select all elements whose classname starts with 'main'

how to Add Multiple Value in a Variable In SQL Server

declare @Pipno table(V_3 varchar(500),V_2 varchar(10))

insert into @Pipno (V_3)
Select  COUNT(IMEINo)
 FROM  Jobsheet
WHERE    (ModCode ='H057') AND (ServiceCentreCd ='C009')
 GROUP BY IMEINo,ModCode
HAVING      (COUNT(IMEINo)> 1)
update @Pipno set V_2=1
 Select * from @Pipno

How to Export Crystal report in Excel in ASP.Net

private void printreportinExcel(string strReportPath, DataTable dt)

{
//strReportPath  is the report path, dt is the datatable
ReportDocument rptdoc = new ReportDocument();
rptdoc.Load(Server.MapPath(strReportPath));
rptdoc.SetDataSource(dt);

ExportOptions exportOpts1 = rptdoc.ExportOptions;rptdoc.ExportOptions.ExportFormatType =
ExportFormatType.Excel;rptdoc.ExportOptions.ExportDestinationType =
ExportDestinationType.DiskFile;rptdoc.ExportOptions.DestinationOptions =
new DiskFileDestinationOptions();((
DiskFileDestinationOptions)rptdoc.ExportOptions.DestinationOptions).DiskFileName = Server.MapPath("swapt.xls");rptdoc.Export();
rptdoc.Close();
rptdoc.Dispose();
Response.ClearContent();
Response.ClearHeaders();
Response.ContentType =
"vendor/ms-excel";Response.AppendHeader(
"Content-Disposition", "attachment; filename=swapt_Report.xls");Response.WriteFile(
"swapt.xls");Response.Flush();
Response.Close();

File.Delete(Server.MapPath("swapt.xls"));}

Refreshing an Update panel using Javascript in Asp.net

Refreshing Update panel using javascript in asp.net

 

Step:1

<asp:ScriptManager ID="ScriptManager1" runat="server" /> <div id="Container"> <asp:UpdatePanel runat="server" ID="UpdatePanel1" OnLoad="UpdatePanel1_Load"> <ContentTemplate> <asp:Label runat="server" ID="Label1" /> </ContentTemplate> </asp:UpdatePanel>

 

Step 2:

 

protected void UpdatePanel1_Load(object sender, EventArgs e){
  Label1.Text = DateTime.Now.ToString();}

Step3:

<div id="Container" onclick="__doPostBack('UpdatePanel1', '');">

Now Clicking anywhere in the Div it will update the update panel

positioning Labe,TextBox in asp.net

In the Client side Just add the Following code

Style="z-index: 102; left: 160px; position: absolute;top: 210px"

AjaxToolKit Not Working .sys object undefined problem in Asp.net

In The   <system.web>
Paste the Following Text
 I hope It will be Working

<httpHandlers>
<add path="CrystalImageHandler.aspx" verb="GET" type="CrystalDecisions.Web.CrystalImageHandler, CrystalDecisions.Web, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/>

<add path="Reserved.ReportViewerWebControl.axd" verb="*" type="Microsoft.Reporting.WebForms.HttpHandler, Microsoft.ReportViewer.WebForms, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" validate="false"/>
<remove verb="*" path="*.asmx"/>
<add verb="*" path="*.asmx" validate="false" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
<add verb="*" path="*_AppService.axd" validate="false" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
<add verb="GET,HEAD" path="ScriptResource.axd" type="System.Web.Handlers.ScriptResourceHandler, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" validate="false"/>
</httpHandlers>
<httpModules><add name="ScriptModule" type="System.Web.Handlers.ScriptModule, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
</httpModules>

How to write XML Schema from DataTable in C#

 Writing XML Schema from data table in C#

ds2.Tables[0].WriteXmlSchema(@"c:\TrialBalance.xsd");

How to find the Size of the Screen in C#.net

   
 To find the size (Height and Width) of the computer screen write the followingcode


  Rectangle resolution = Screen.PrimaryScreen.Bounds;
            int height = resolution.Size.Height;
            int width = resolution.Size.Width;

How to delete Duplicate Record From a Table in SQL Server

DELETE TOP (SELECT COUNT(*) -1 FROM dbo.Emptest WHERE EmpID = 'Basharat')  FROM dbo.Emptest  WHERE EmpID = 'Basharat'

How to Isert Data From Text File to SQL Server Table

BULK
INSERT TempSOC_Main--Table Name
FROM 'G:\KS_09_01_13_1133\SOCMain.txt'
WITH
(
FIELDTERMINATOR = ',',
ROWTERMINATOR = '\n'
)
GO