For reading Excel files and getting the datastring FilePath = Server.MapPath("exmaple.xls"); DataSet myDataset = new DataSet(); string strConn = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + FilePath + @";Extended Properties=""Excel 8.0;HDR=Yes;IMEX=1"""; OleDbConnection conn = new OleDbConnection(strConn); conn.Open(); DataTable...
Wednesday, January 27, 2010
Tuesday, January 26, 2010
Firebug Extensions
Firebug is the most usefult addon tool for web development. It can help us to find the issues in css, ajax requests etc and many features. There are some other addons which can help to improve the utility of firebug. Learn M...
Monday, January 25, 2010
6-Hour Work At Home Video Certification Course
This Video Course Teaches How To Work From Home With Fortune 500 Companies. Great help for those like me who want to earn by working from home.Learn M...
Saturday, January 23, 2010
Ajax and UpdatePanel performance improvement
Most of the newbie programmers like me are ajaxifying a site by putting updatepanels all over the site. Now, I came to know that, putting updatepanel will not help you to improve your site's speed. We are using it, since it is very easy. You can understand why ajax updatenpanels should be avoided from the following linkWhy UpdatePanel Dangerous If you still want to use updatepanel, check the...
Top Money giving Paid To Click site
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....
Friday, January 22, 2010
Know the control which caused the postback
I got this from some site. It can be used to know the control which caused the postback.
public static Control GetPostBackControl(Page thePage)
{
Control myControl = null;
string ctrlName = thePage.Request.Params.Get("__EVENTTARGET");
if (((ctrlName...
Limit in Argument size for functions
I was trying to insert data to a sql table from code behind. But, when I tried to see the values using break point, I was not able to see the values. The following link shows the cause and reason.
Help L...
How to Register User Controls and Custom Controls in Web.config
If we register controls in the web.config, we don't have to register the control on each page. This is useful, if we have to use the same control on several pages.
Help L...
Display updateprogress in the clicked position
On the following example, progress bar(UpdateProgress1) is displayed on the position of the button which got clicked
function pageLoad()
{
var manager = Sys.WebForms.PageRequestManager.getInstance();
...
JQuery default functions
Following is the jquery default function that is run. we can use this to get the ajaxrequests
function pageLoad() {
if (!Sys.WebForms.PageRequestManager.getInstance().get_isInAsyncPostBack()) {
Sys.WebForms.PageRequestManager.getInstance().add_beginRequest(AjaxBegin); ...
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...
First Post
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 somebo...