Asp.net,C#.net,Sql Srver problems and solutions Blog

ASP.NET Scaffolding ASP.NET Scaffolding is a code generation framework for ASP.NET Web applications. It makes it easy to add boilerplate code to your project that interacts with a data model. In previous versions of Visual Studio, scaffolding was limited to ASP.NET MVC projects. With Visual Studio 2013, you can now use scaffolding for any ASP.NET project, including Web Forms. Visual Studio 2013 does not currently support generating pages for a Web Forms project, but you can still use scaffolding with Web Forms by adding MVC dependencies to the project. Support for generating pages for Web Forms will be added in a future update. When using scaffolding, we ensure that all required dependencies are installed in the project. For example, if you start with an ASP.NET Web Forms project and then use scaffolding to add a Web API Controller, the required NuGet packages and references are added to your project automatically. To add MVC scaffolding to

Urgent Walk In - Interviews - For TFS2012 Administrators - Hyderabad  Skills Required :         *  Work Space Configuration .           * TFVC Configurations .            * Managing Users and Groups.          * Source Control Security Rights and Permissions.          * Project Management .          * Build Management .          * Team build . Venue Details  : SyncApps Online Ventures Pvt. Ltd H.No 8-3-318-11-4B Jayaprakash Nagar, Ameerpet, Andhra Pradesh , Hyderabad 500073 040-64 61 89 89 - 040-68 68 68 68 support@easybus.in Mail Your Resume :                                 jobs@easybus.in For more Details Visit Us :                         http://syncrooms.com , http://easybus.in  Need to be join  with in 1 to 7 working days  

Finding the Closest Number / values using SQL Server 2005/2008 In one of the queries I was writing, I had to find out the closest match to a given value. In my case, it was a Price column and given a value, I had to find the prices of items that closely match it.   Previous post I explained about How to RESET identity columns in SQL Server , SQL Server- Case Sensitive Search in SQL Server , SQL Server - Get List of All Table Names in Database , What is sharding - Databases . Here’s how it can be done using the SQL Server ABS function   -- SAMPLE DATA DECLARE @TT TABLE ( ID int , Price float )     INSERT INTO @TT VALUES ( 1 , 23.29 )   INSERT INTO @TT VALUES ( 2 , 91.33 )   INSERT INTO @TT VALUES ( 3 , 78.45 )   INSERT INTO @TT VALUES ( 4 , 25.26 )   INSERT INTO @TT VALUES ( 5 , 11.13 )   INSERT INTO @TT VALUES ( 6 , 3.22 )   INSERT INTO @TT VALUES ( 7 , 29.33 )   INSERT INTO @TT VALUES ( 8 , 88.34 )   INSERT INTO @TT VALUES ( 9 , 48.44 )   INSERT INTO @TT VAL

What is Database sharding? Sharding is a type of database partitioning that separates very large databases the into smaller, faster, more easily managed parts called data shards. The word shard means a small part of a whole . Here's how Jason Tee explains sharding on The Server Side: "In the simplest sense, sharding your database involves breaking up your big database into many, much smaller databases that share nothing and can be spread across multiple servers." Technically, sharding is a synonym for horizontal partitioning. In practice, the term is often used to refer to any database partitioning that is meant to make a very large database more manageable. The governing concept behind sharding is based on the idea that as the size of a database and the number of transactions per unit of time made on the database increase linearly, the response time for querying the database increases exponentially.  Additionally, the costs of creating and maintaining

How to Write a Resume: Dos and Don'ts : Tips for Writing Effective Resume   Many people feel overwhelmed at the idea of writing their resume. How can you possibly describe your entire career in a page or two? But that's thinking about the resume in the wrong way. Remember this and commit it to memory:  Resumes are marketing documents . They aren't your life/work history. They aren't required to show your failures and shortcomings  Their purpose is to quickly tell a recruiter/hiring manager that you have the qualifications to do this work. Here are 5 Dos and 5 Don'ts for Resume Writing: Do Put your jobs in reverse chronological order.  Your last/current relevant job goes first. (You can choose to leave off an irrelevant, short term job.) Some people write "functional resumes", but many HR managers view these as attempts to hide something unpleasant. Move your education to the end of the page.  I know you're proud of your school, but unless

Urgent Walk In - Interviews - For DotNet Developers - Hyderabad Skills Required :                            C#.Net , Asp.Net ,SQL Server 2005,2008 ,AJAX                              JavaScript , JQuery. Knowledge On :                              MVC , Web Services , Web API . Qualification  :                             " Passionate to code and hardworking and Quick learning People " Venue Details  : SyncApps Online Ventures Pvt. Ltd H.No 8-3-318-11-4B Jayaprakash Nagar, Ameerpet, Andhra Pradesh , Hyderabad 500073 040-64 61 89 89 - 040-68 68 68 68 Support@easybus.in Mail Your Resume :                                 jobs@easybus.in For more Details Visit Us :                              http://syncrooms.com , http://easybus.in 

Error : 0x800a139e - JavaScript runtime error: Sys.WebForms.PageRequestManagerParserErrorException: The message received from the server could not be parsed What's a PageRequestManagerParserErrorException? The UpdatePanel control uses asynchronous postbacks to control which parts of the page get rendered. It does this using a whole bunch of JavaScript on the client and a whole bunch of C# on the server. Asynchronous postbacks are exactly the same as regular postbacks except for one important thing: the rendering. Asynchronous postbacks go through the same life cycles events as regular pages (this is a question I get asked often). Only at the render phase do things get different. We capture the rendering of only the UpdatePanels that we care about and send it down to the client using a special format. In addition, we send out some other pieces of information, such as the page title, hidden form values, the form action URL, and lists of scripts. As I mentioned,

SQL Reporting Service - Viewing reports in FULL SCREEN    There are 2 methods to achieve this Previously I was Explained about the  How to remove rows from GridView using jQuery in asp.net ,  Nested GridView in ASP.NET Using c# with show/hide  ,   How to Add a Locked Header Row to an ASP.NET GridView Control ,   How to remove rows from GridView using jQuery in asp.net , Popup window on button click in asp net 1. Modify ReportingServices.js in "Program Files\Microsoft SQL Server\MSSQL\Reporting    Services\ReportManager\js" 2. Create a frontend HTML page which forces the Report Manager to Open in Full Screen Mode.  METHOD I. =============================== Add the following lines in ReportingServices.js file:  //--- maximize window window.moveTo(0,0); window.resizeTo(screen.width,screen.height); Note: This will bring report manager in Maximized IE mode and not in Full Screen Mode.  METHOD II. ========== ====================

On Button Click How Open A page in new window in asp.net - c# code Task: Open a new window using c# code in asp.net website/web application. Description: The problem is this we can use Response.Redirect() method for redirect/open  new webpage in same window, But how we can open a new page in new window. Previously I was Explained about the   How to remove rows from GridView using jQuery in asp.net ,  Nested GridView in ASP.NET Using c# with show/hide  ,   How to Add a Locked Header Row to an ASP.NET GridView Control ,   How to remove rows from GridView using jQuery in asp.net So that I use javascript code(alert box) for popup new window in c# code behind file as describe below. I write below code on Button Click Event. // Dynamic Alert box javascript using c# code in asp.net  protected void btngeneraterecipt_Click(object sender, EventArgs e)     {         try         {             string queryString = "billformat.aspx";             string jquery = "window