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

An error has occurred while establishing a connection to the server when connecting to SQL server 2005, this failure may be caused by the fact that under default settings SQL server does not allow remote connection. ( provider: Named Pipes Provider, error: 40 – could not open a connection to SQL server. ) Previously I was explained about How to merge two columns value into single column in sql select statement, SQL Server- Case Sensitive Search in SQL Server  , SQL Server - Get List of All Table Names in Database   Fix/Workaround/Solution: Step 1) Make sure SQL SERVER is up and the instance you try to connect is running. Step 2) Your system Firewall should not block SQL Server port. Step 3) Go to Computer Management >> Service and Application >> SQL Server 2005 Configuration >> Network Configuration Enable TCP/IP protocol. Make sure that SQL SERVER port is by Default 1433. Step 4) Now follow this KB Article of MSDN depending on your server : h...

  In this article I will explain how to open jQuery UI Modal Dialog Popup Window from Server side on Button click in ASP.Net Previous Post  I was Explained about the    jQuery - Allow Alphanumeric (Alphabets & Numbers) Characters in Textbox using JavaScript  ,  Fileupload show selected file in label when file selected  ,  Check for file size with JavaScript before uploading   ,  Using the window.open method  . First add Jquery plugins like bellow   HTML Markup <script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.7.2/jquery.min.js"></script> <script src="http://ajax.aspnetcdn.com/ajax/jquery.ui/1.8.9/jquery-ui.js" type="text/javascript"></script> <link href="http://ajax.aspnetcdn.com/ajax/jquery.ui/1.8.9/themes/start/jquery-ui.css"     rel="stylesheet" type="text/css" /> <script type="text/javascript">     function ShowPop...

In this post i am try to explain Using the window.open method in different ways like Open page whiteout address bar , without menu bar . The syntax of the window.open method is given below : open (URL, windowName[, windowFeatures])  Previous Post  I was Explained about the    jQuery - Allow Alphanumeric (Alphabets & Numbers) Characters in Textbox using JavaScript  ,  Fileupload show selected file in label when file selected  ,  Check for file size with JavaScript before uploading  . URL The URL of the page to open in the new window. This argument could be blank. windowName A name to be given to the new window. The name can be used to refer this window again. windowFeatures A string that determines the various window features to be included in the popup window (like status bar, address bar etc) The following code opens a new browser window with standard features. window.open ( "http://easybus.in" , "mywindow"...

In this post I will explain about How  to open in new tab or window in Asp.net gridview This is the simplest way to add hyperlink to gridview Previous Post  I was Explained about the   Nested GridView in ASP.NET Using c# with show/hide     jQuery - Allow Alphanumeric (Alphabets & Numbers) Characters in Textbox using JavaScript  ,  Fileupload show selected file in label when file selected  ,  Check for file size with JavaScript before uploading  ,   Asp.Net AjaxFileUpload Control With Drag Drop And Progress Bar . Sample Gridview  <asp:gridview ID="bookslist" runat="server"> <Columns> <asp:TemplateField  ItemStyle- horizontalAlign="Center"> <ItemTemplate> <asp:HyperLink id="lnkDetails" runat="server" Target="_blank" NavigateUrl="~/BookDetail.aspx">Details</asp:HyperLink> </ItemTemplate> <asp:TemplateField> </Columns> </asp:gridview > <a href...

Import Gmail Contacts In Asp.Net 2.0,3.5,4.0 Using Google Data API C# And VB.NET .  Several times we need to create web applications which require to import or fetch Gmail Contacts or address book. This example will explain how to fetch or import Gmail contacts in Asp.net web applications. Previous Post  I was Explained about the    jQuery - Allow Alphanumeric (Alphabets & Numbers) Characters in Textbox using JavaScript  ,  Fileupload show selected file in label when file selected  ,  Check for file size with JavaScript before uploading  ,   Asp.Net AjaxFileUpload Control With Drag Drop And Progress Bar . For Importing Gmail Contacts in asp.net application we need to download Google Data API and install on system to get the desired dlls. Create a new website and visual studio and put these 3 dlls in BIN folder of application from the location google data API has been installed on ur system. 1. Google.GData.Cl...

Read CSV File or Data In ASP.NET using C# VB.NET And save to MS SQL Server. In this example i'm explaining how to read CSV file and save data to sql server. Previous Post  I was Explained about the    jQuery - Allow Alphanumeric (Alphabets & Numbers) Characters in Textbox using JavaScript  ,  Fileupload show selected file in label when file selected  ,  Check for file size with JavaScript before uploading  ,   Asp.Net AjaxFileUpload Control With Drag Drop And Progress Bar . My sql table has 3 columns FirstName,LastName and Department. and i m using datatable to read Data from CSV file and temporarily storing in datatable. First of all you need to add reference to Microsoft.VisualBasic dll by rightclicking in solution explorer,select add reference and select microsoft.VisualBasic from list. Add these namespaces in code behind of page. using System.Data; using System.Data.SqlClient; using Microsoft.VisualBasic.FileIO; Now ...

This Example explains how to use AjaxFileUpload Control With Drag Drop And Progress Bar Functionality In Asp.Net 2.0 3.5 4.0 C# And VB.NET. Previous Post  I was Explained about the   jQuery - Allow Alphanumeric (Alphabets & Numbers) Characters in Textbox using JavaScript  ,  Fileupload show selected file in label when file selected  ,  Check for file size with JavaScript before uploading  . May 2012 release of AjaxControlToolkit includes a new AjaxFileUpload Control  which supports Multiple File Upload, Progress Bar and Drag And Drop functionality. These new features are supported by Google Chrome version 16+, Firefox 8+ , Safari 5+ and Internet explorer 10 + , IE9 or earlier does not support this feature. To start with it, download and put latest AjaxControlToolkit.dll in Bin folder of application, Place ToolkitScriptManager  and AjaxFileUpload on the page. HTML SOURCE < asp:ToolkitScriptManager I...