Sajith Premachandran IT Professional

Search This Blog

Bind Array to Gridview

November 26, 2009

Get link
Facebook
X
Pinterest
Email
Other Apps

int[] intArray = { 1, 2, 3, 4, 5 };
GridView1.DataSource = intArray;
GridView1.DataBind();

Get link
Facebook
X
Pinterest
Email
Other Apps

Comments

Encrypt webconfig ConnectionString

To encrypt the connection string section follow the steps, 1. Go to Start -> Programm Files -> Microsoft Visual Studio 2005 -> Visual Tools -> Microsoft Visual Studio 2005 Command Prompt 2. Type following command, aspnet_regiis.exe -pef “connectionStrings” C:\Projects\DemoApplication -pef indicates that the application is built as File System website. The second argument is the name of configuration section needs to be encrypted. Third argument is the physical path where the web.config file is located. If you are using IIS base web site the command will be, aspnet_regiis.exe -pe “connectionStrings” -app “/DemoApplication” -pe indicates that the application is built as IIS based site. The second argument is the name of configuration section needs to be encrypted. Third argument “-app” indicates virtual directory and last argument is the name of virtual directory where application is deployed. If everything goes well you will receive a message “Encrypt...

Sql Function for String Concatenation

create function dbo.test2(@l3code varchar(20)) RETURNS varchar(2000) As BEGIN Declare @var varchar(2000) set @var='' Select @var = @var +'#'+ keyword from keyword where level3code=@l3code group by level3code,keyword return @var END select distinct level3code,dbo.test2(level3code) from keyword

Powered by Blogger

Bind Array to Gridview

Comments

Post a Comment