RSS
 

Archive for the ‘Uncategorized’ Category

Generate sql script with data from database

07 Jul

How can we copy data as well the structure and schema as sql query? We need database publishing wizard for that.

Download the database publishing wizard and install it.

It will be installed at following location : C:\Program Files\Microsoft SQL Server\90\Tools\Publishing\

run the exe and you can get the sql file with all the data, schema and structure of the database you select.

 
 

Grouping Gridview

01 Apr

Some times we want to group gridview. ZNet is a good control for this use.
ZNet
We can use this for grouping and also for the comparison.

 
 

The Controls collection cannot be modified because the control contains code blocks

05 Mar

This is a common error. It occurs when we use <%= %> tag inside the head tag with runat=”server” given. You can get rid of the error by removing the runat=”server” from the head tag. But, sometimes, we want to keep that. We can use <%# %> instead of <%= %>. But, then, the value may not get bound and we may not get the value of the expression. So, when we use <%# %>, we have to add Page.Header.DataBind(); in the Page Load event.
More Info

 
 

25 Jan

 
 

Top Money giving Paid To Click site

23 Jan

Its an off topic. I just came to know about this site. They are giving the maximum for click. 50 cents for just clicking banners and 1 USD for reading their emails. Also, referral bonus is there.

payingptr.com

 
 

23 Jan

Use ScriptManager.RegisterStartupScript, when using ajax updatepanel to add javascript from codebehind.
for eg. just showing a message box, on of a button in updatepanel
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), “scriptname”, “var position=$(‘#” + Btn.ClientID + “‘).offset();$(‘#’).html(‘Button clicked’).css(position).fadeIn(2000).fadeOut(2000);”, true);

can get position using position method of jquery

 
 

First Post

23 Jan

My First Post. Hope this blog will help me and others too.

I am going to post all the new things I am learning everyday regarding programming. Hope it helps somebody.