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

Entity Tags(Etags) in asp.net -  ETag vs Header Expires Introduction Entity Tags (ETags) are commonly used in Web applications to effectively leverage the power of using web farms, which is a non-fancy term for HTTP/S load balancing.  In web farms, a common practice is to set what is called ETags as it helps enhance performance in web farm scenarios.  ETags is controlled in IIS by a metabase property (ETAG_CHANGENUMBER) and this value is sent back to clients via response headers as instructed by the HTTP RFC 2616 .  If the ETag value is the same across a number of servers, then clients are not required to re-download content that already exists in the clients cache.  Without this value set to the same, clients might communicate on subsequent requests to another server in the web farm and receive an unnecessary response of data from the IIS server. For purposes of this blog, I will focus on modifications rather than further definition of ETags.  However, you can rea

Use Google Docs Viewer for Document viewing within Browser I was looking for a way to let users see Microsoft Word Doc or PDF files online while using my application without leaving their browser without downloading files and then opening it to view with Word or PDF viewer . I was looking for some way out either via any PHP or Microsoft.NET libraries, did some googling on that; but later on I just got an idea that google already has all code written for me.. when I have any email attachment in PDF or DOC or DOCX google does it for me ..! Even while searching I can see PDFs by converting them in HTML. So I just googled it up and found that Google already has this ability that we can use Google Docs Viewer without any Google Account Login . YES that's true no Google Account login is required. It's damn simple and easy. Just pass document path as attachment as parameter and we are done. Google Docs Viewer gives us ability to embed PDF, DOC/DOCX, PPT, TIFF:

I Have situation  need to store an array of string in a HiddenField in my web form with asp.net. But It was Generally Not Possible to Do , But we have different methods to Achieve this here the methods check once Previous Post  I was Explained about the    Fileupload show selected file in label when file selected  ,  Show jQuery UI Dialog Popup Window from Server Side ( Code Behind ) in ASP.Net ,  How to use the window.open()  method  ,   CONFIRMATION BOX WITH YES NO BUTTONS USING AJAX MODAL POPUP EXTENDER IN ASP.NET  , Dynamic Theme Switching - Creating User-Selectable Themes Probably a few methods would work. 1) Serialize the String[] in JSON This would be fairly easy in .NET using the JavaScriptSerializer class, and avoid issues with delimiter characters. Something like: String[] myValues = new String[] { "Red", "Blue", "Green" }; string json = new JavaScriptSerializer().Serialize(myValues); 2) Come up with a delimiter that never appears in t

Compare Outlook.com with Gmail.com & yahoomail .com Compare Outlook.com to other leading online, personal email services to see how it stacks up against the competition. Outlook.com has an intuitive UI, unique tools to organize your inbox, and ways to keep your address book automatically updated Security & privacy Switch Now Keeps spam in your inbox at less than 3% SSL turned on by default Doesn't serve targeted ads based on email contents Modern inbox Virtually unlimited storage (free) Watch videos or slide shows from your inbox Share, view, and edit Microsoft Office docs using Office Web Apps Send photo slide shows from your inbox Organize emails by conversation (optional) Reading pane (optional) Send mail from other email accounts One click mark as read Organizational tools Create aliases—additional addresses that link to your inbox Organize inbox by custom categories, folders, or both Auto-categorize newsletters 1 1 Flag important messages