Thursday, March 3, 2011

Creating a client from WCF service.. converting LIST<> to Array[]

A was getting the problem while downloading the contracts using the svcutil.exe, it was converting the List<> to Array[]. It happens because svcutil consider all lists to be array

So there is an option to download the List<> as well.

svcutil.exe /language:cs /out:g
eneratedProxy.cs /ct:System.Collections.Generic.List`1 http://satindersatty.com:1111/

Sunday, February 20, 2011

Update panel scroll problem solved

I have an updatepanel control in the middle of a page, and i have a link at the top of the same page. I refresh the updatepanel by clicking the link ;however, i want the updatepanel to scroll into view as well. My javascript scrollintoview method didnt work because updatepanel tries to keep the last position of the page after it is refreshed. So i searched google and found this script and added it to my page. It worked.

Friday, February 11, 2011

How to spoof a domain a domain name on your localhost

Hi,
Some time we need to check the live code on our local host and there are many API calls which works only on verified domains names, and when you run the same code on your localhost, those calls fails.

So there is an alternative to that. You can change the localhost name to original verified domain name. Thats called domain spoofing.

To do that, Just find the hosts file in your windows directory. Usually its available at following location

C:\WINDOWS\system32\drivers\etc\host

Open this file, you will see an entry for localhost, change localhost name to domain name you want to spoof.

Easy ... Right...

Friday, January 21, 2011

How to transfer data from CSV file to SQL

Hi,

First you need to create a table with similar number of columns (recommended), then create a format file from the table (using the bcp utility, already discussed in previous post), and then run the following command in sql management studio.

bulk insert tablename
from 'SourcetextfileCompletepath'
with (formatfile='formatfilelocation')

Tuesday, September 7, 2010

Creating format file to bulk insert data from text file

bcp DatabaseName.dbo.TableName format nul -c -f formatfilename -T

for example
bcp AdventureWorks2008R2.HumanResources.Department format nul -c -f Department-c.fmt -T


-T If you are using the window authentication
-c If you want format file to consider all data as char

If you are having more than one instance of the SQL server then you have to give the server name also like

C:\DOCUME~1\ssingh>bcp Northwind.dbo.ResponseTime_VarnishLog format nul -c -f va
rnishformat.fmt -T -S jfkmsc04\sql2008


Where
-S Server Name

Wednesday, July 22, 2009

AutoCompleteExtender problem in Update Panel

I was working with AutoComplete for TextBoxes and problem started when i put these autocomplete in Update Panel

Two components with the same id PopupBehavior' can't be added to the application

After every postback i was getting this java script error.

After a lot of investigation i found the solution

Suppose you have an autocomplete extender

< ajax Toolkit:AutoCompleteExtender
TargetControlID="myTextBox"
ServiceMethod="GetCompletionList"
ServicePath="AutoComplete.asmx"
MinimumPrefixLength="2"
CompletionInterval="1000"
EnableCaching="true"
CompletionSetCount="20" >
< /a jax Toolkit: Auto CompleteExtender>'



You have do some trick in Page Load

Public void page_load()
{
autocomplete1.ID= System.DateTime.Now.ToString();
}

So now every time your control will get new ID and you won't get any javascript error.

If anyone have any different solution, Please post it here