Tips For Programming

ASP.NET Ajax 3.5 error Sys.WebForms.PageRequestManagerParserErrorException

noreply@blogger.com (Alex's Blog) — Thu, 03 Mar 2011 08:57:00 +0000

A few days ago, I wanted to add an Export to Excel button in a page in my web application, that I used Ajax on it, But unfortunately it did not work properly and generated an error(the same as my post header). After searching in the net I found out I have to add a line in page. That's it, it Worked excellent :). If you encountered this error, you must add:

EnableEventValidation="false"

and also:

   <Triggers>
   <asp:PostBackTrigger ControlID="ControlName" />
   </Triggers>

Good luck :)

Gridview Sorting Problem

noreply@blogger.com (Alex's Blog) — Tue, 20 Apr 2010 11:55:00 +0000

When you bind a List to a Gridview, you can not sort it, because your data source is not a Dataset, Dataview or DataTable. So you should convert your data source (List) to a Dataset for example.

You can do it such as following code:

    1 public static DataSet dsSearch()
    2 {
    3 
    4     DataTable dtTelcoCenter = new DataTable();
    5     dtTelcoCenter.Columns.Add("Id", typeof(int));
    6     dtTelcoCenter.Columns.Add("City", typeof(string));
    7     dtTelcoCenter.Columns.Add("Capacity", typeof(int));
    8 
    9     IList<Telco> telcoCenter = Search(centerName, Prefix);// Search method return a list
   10 
   11 
   12     foreach (Telco telco in telcoCenter)
   13     {
   14         DataRow rowTelcoCenter = dtTelcoCenter.NewRow();
   15         rowTelcoCenter["Id"] = telco.Id;
   16         rowTelcoCenter["City"] = telco.City;
   17         rowTelcoCenter["Capacity"] = telco.Capacity;
   18         dtTelcoCenter.Rows.Add(rowTelcoCenter);
   19     }
   20     DataSet dsTelcoCenter = new DataSet();
   21     dsTelcoCenter.Tables.Add(dtTelcoCenter);
   22     return dsTelcoCenter;
   23 }


You can bind this Dataset to your Gridview data source

Rows to single column in Sql

noreply@blogger.com (Alex's Blog) — Tue, 20 Apr 2010 10:50:00 +0000

Sample table as Cities in rows is convert to single column

declare @retstr varchar(8000)  
 select Top 5 @retstr =  COALESCE(@retstr + ';','') + City   
from State  
print @retstr

How can you save a MS Office file into a database?

noreply@blogger.com (Alex's Blog) — Mon, 04 Jan 2010 12:03:00 +0000

If you want to save a MS Office document such as
Word doc in a database, you can do it with the
following VB.net code:

    Dim vStream As New FileStream("C:\Alex.doc", FileMode.Open) 
    Dim vLen As Integer = New FileInfo("C:\Alex.doc").Length
    Dim vBlob(vLen) As Byte
    Dim n As Integer = vStream.Read(vBlob, 0, vLen)
    Dim vSql As String =

"INSERT INTO tBlobTable (vId,vBlob) VALUES (1,@vBlob)"

    Dim sql As New SqlCommand(vSql, vConn)
    Dim sqlPar As New SqlParameter("@vBlob", SqlDbType.Image)
    sqlPar.Value = vBlob
    sql.Parameters.Add(sqlPar)

I hope you would find it useful.

Parameter Sniffing

noreply@blogger.com (Alex's Blog) — Sun, 29 Nov 2009 09:42:00 +0000

Sometimes maybe you find out your SP (Store Procedure) doesn't response in reasonable time despite Select statement, which you used in that SP, has good performance and result is shown you immediately. What's wrong with your SP?
There are different answers for that problem but when I faced on this problem, I realized it's strongly related to Parameter Sniffing.

You can solve Parameter Sniffing easily with follow this example:
If you have a SP such as GetOrderForCustomers that has Parameter Sniffing issue:

Create procedure GetOrderForCustomers (@CustID Varchar (20))
As
Begin
Select * from orders
Where customerid = @CustID
End

To solve problem you should change your SP similar:

Create procedure GetOrderForCustomers (@CustID Varchar (20))
As
Begin
Declare @LocCustID Varchar (20)
Set @LocCustID = @CustID
Select * from orders
Where customerid = @LocCustID
End

Good luck.

How to Speed up SQL Server Management Studio in SQL Server 2005?

noreply@blogger.com (Alex's Blog) — Wed, 25 Nov 2009 06:13:00 +0000

Have you ever launched  SQL Server Management Studio (SSMS) and had to wait over 60 seconds before you  could even log in? I have - all too often! It's annoying - and thankfully there's  an easy fix. 

Launch Internet Explorer
Browse to Tools -> Internet options -> Advanced tab
Uncheck the check box under Security called "Check for publisher's certificate revocation"

Now you'll be able to launch SSMS and it will be fast. BTW - this works particularly well for offline workstations/laptops. When you are connected to the internet and SSMS checks for this info (every 15 friggin' seconds) then it's fine - but when you aren't online, it has to wait for a timeout!

Increase your VS compile speed

noreply@blogger.com (Alex's Blog) — Mon, 23 Nov 2009 14:24:00 +0000

To increase your VS compile speed:

Install Microsoft hotfix 935225.

Install Microsoft hotfix 947315.

Use a true multicore processor (ie. an Intel Core Duo 2; not a Pentium 4 HT).

Use 3 parallel builds. In Visual Studio 2005, you will find the option in Tools > Options... > Projects and Solutions > Build and Run > maximum number of parallel project builds.

Defragment your hard drive regularly.

Disable virtual memory.

Visual studio IDE

noreply@blogger.com (Alex's Blog) — Sun, 15 Nov 2009 07:44:00 +0000

Visual studio is a pretty awesome IDE, but sometimes you just wish it would go faster.

Here's a list. All of these can be accessed on Tools->Options menu:

Disable F1. (Environment->Keyboard) This is probably the best advice that I found somewhere.
Disable "Animate environment tools" (Environment->General).
Disable Start Page (Environment->Startup).
Disable "Track Active Item in Solution Explorer" (Projects and Solutions).
Disable Navigation Bar (Text Editor->C#). I think this is available for every language.
Set "AutoToolboxPopulate" to false (Windows Forms Designer).
You can set the Code view as the default view when viewing Windows Forms. Just right-click on the cs file and select "Open With...".
Open Visual Studio using the command line (devenv) rather than using the Start menu. I don't know why but I notice it loads faster.
Turn off Track Changes. (Text Editor->Track changes)

Basically I just customized John Lam's settings. It's very minimal.

And also you can use ScottGu's Blog tips.

noreply@blogger.com (Alex's Blog) — Tue, 27 Oct 2009 04:56:00 +0000

Hi all my friends,

I want to start to writing in my weblog again but I want to write about Programming.

Maybe I'll have some mistake in my sentences such as grammatical mistake, because I'm a beginner in English then I want you to help me to improve and correct my mistakes. 