asp.net codes

How to get HTML of control before render event

2012-02-05T05:00:00.000-08:00

Suppose we have to show grid from ajax request than we can bind grid by data base and get its HTML structure. Code is bellow

GridView gv = new GridView();

gv.AutoGenerateColumns = true; //Your Logic to fill dataset/datatable

DataTable dt = new DataTable();

dt.Columns.Add(new DataColumn("Index"));

dt.Columns.Add(new DataColumn("Name"));

for (int i = 0; i < 10; i++) { DataRow row = dt.NewRow(); row["Index"] = i; row["Name"] = "dummyData" + i.ToString(); dt.Rows.Add(row); }

//bind the gridview

gv.DataSource = dt;

gv.DataBind();

//get the rendered HTML

StringBuilder sb = new StringBuilder();

StringWriter writer = new StringWriter(sb);

HtmlTextWriter txt = new HtmlTextWriter(writer);

gv.RenderControl(txt);

return sb.ToString();

Invoking javascript in iframe from parent page

2012-02-05T01:13:00.001-08:00

Invoking javascript in iframe from parent page

Supposethat you have base page page1.aspx. andyou have one iframe1 in page1.aspx call it popup1.

Socode control will look like this:

Suppose we write some function foo() on Popupl.aspx and we need samefunction on page1.aspx.

Than can we access it?

Yes.

By using following sytax:

window.frames. iframe1.foo();

JQuery and update panel.

2012-01-23T09:15:00.001-08:00

JQuery and update panel.

We faced problem when we have update panel and using .ready function of jquery.

than on asysnc request of update panel Jquery .ready is not fired than we have to use add_load of sys.Application class of scrip manager library.

JQuery:

$(document).ready(function IwillCallWhenPgeIsReady(

//IF you have update panel than it will never call on async request

){});

Update Panel:

Sys.Application.add_load(function() {});

Best Practices for Deployment of ASP.NET Applications Production

2012-01-23T08:57:00.000-08:00

Best Practices for Deployment of ASP.NET Applications Production

Compress file.

Compress JavaScript & aspx HTML file before deployment. This will reduce the size of file which optimizing rendering time.

Caching of static data.

Set the Cache of static content like images. or web page which have no user specific.

Set httpRuntime executionTimeout

If application may be accessed by slow internet connection then it wise step to increase execution time out.

We can set it on Web config file

Build Mode release

When application is about to deplaoy than builds it by release mode.

In release mode we have less information of error.

deployment retail

Set retail="true" in your machine.config

<system.web>

</system.web>

</configuration>

1. It will force the 'debug' flag in the web.config to be false,

2. It will disable page output tracing, and

3. It will force the custom error page to be shown to remote users rather than the actual exception or error message.

Create a new application pool for your site

When setting up your new site for the first time do not share an existing application pool. Create a new application pool which will be used by only by the new web

application.

app_Offline.htm

It also force an application restart in case you forget to do this for a deployment

DataTAble to Generic List

2011-10-05T09:24:00.000-07:00

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
public partial class _Default : System.Web.UI.Page
{
    class IndexName
    {
        public int Index { get; set; }
        public string Name { get; set; }
    }
    protected void Page_Load(object sender, EventArgs e)
    {
        DataTable dt = new DataTable();
        dt.Columns.Add(new DataColumn("Index"));
        dt.Columns.Add(new DataColumn("Name"));
        for (int i = 0; i < 10; i++) { DataRow row = dt.NewRow(); row["Index"] = i; row["Name"] = "dummyData" + i.ToString(); dt.Rows.Add(row); }
        //bind the gridview
        List<string> obj = new List<string>();
        obj = dt.Select().Select(t => t.Field<string>("index")).ToList();
        List<IndexName> obj2 = new List<IndexName>();
        obj2 = (from DataRow dr in dt.Rows
                select new IndexName
                {
                    Index = Convert.ToInt32(dr["Index"]),
                    Name = Convert.ToString(dr["Name"])
                }).ToList();
    }
}

2011-09-22T07:53:00.000-07:00

Hi,
Get HTML of server side control from ajax / webservice call.
This is used full when we have to show grid on page and fill operation needs a ajax funcaiton. than we can just bind grid with datasource and get its rendring HTML to send the response on called function.

GridView gv = new GridView();
gv.AutoGenerateColumns = true; //Your Logic to fill dataset/datatable
DataTable dt = new DataTable();
dt.Columns.Add(new DataColumn("Index"));
dt.Columns.Add(new DataColumn("Name"));
for (int i = 0; i < 10; i++) { DataRow row = dt.NewRow(); row["Index"] = i; row["Name"] = "dummyData" + i.ToString(); dt.Rows.Add(row); }
//bind the gridview
gv.DataSource = dt;
gv.DataBind();
//get the rendered HTML
StringBuilder sb = new StringBuilder();
StringWriter writer = new StringWriter(sb);
HtmlTextWriter txt = new HtmlTextWriter(writer);
gv.RenderControl(txt);
return sb.ToString();

aspnet_regiis.exe -i

2011-09-02T22:32:00.001-07:00

C:\Windows\Microsoft.NET\Framework\v2.0.50727

How to call other control events in page load c#

2011-08-29T11:41:00.001-07:00

Auto Hide Message

2011-08-07T10:38:00.001-07:00

disable dates between two dates in ajax Calder

2011-07-30T12:12:00.000-07:00

Hi,
I need to disable dates between two dates in ajax Calder and this link solved my problem.:

http://stackoverflow.com/questions/820192/disable-previous-dates-in-ajaxtoolkit-calendarextender

ValidateRequest 4.0 in visual studio 2010

2011-07-22T01:49:00.000-07:00

Hi,
We need to set
ValidateRequest="false"
and modify web config file settings are given below:
<httpRuntime requestValidationMode="2.0"/>
</system.web>

Thanks
Mahesh K. Sharma

get difference between two dates

2011-07-17T10:30:00.000-07:00

Hi
I need to calculate difference between two days and result required
1) Difference in year month & day.
2) First day is included as working day. means from 1st Jan to 31 Jan is 1 Month not 30 Days.

So I implemented logic:

A : Get the difference b/w both date.
B: Add difference in base date.
B 1) base date: year 0001, month : as from date's month: day as from date's day
B 2) if from date is leap year than base date: year 0004, month : as from date's month: day as from date's day
C: check if from_date's month is greater than to date than subtract 1 year from from_date & add 12 months.
D: check if from_date's day is greater than to date than subtract 1 month from from_date & add days of current month of to_date.
snips of code is:

DateTime dd = this.fromDate.AddDays(-1);//Becuase we including first day in calculation
DateTime dd2 = this.toDate;
TimeSpan ts = dd2.Subtract(dd);

DateTime dd3 = new DateTime();
int yearsubtrutin = 1;
if ((this.fromDate.Year % 4) == 0)
{
dd3 = new DateTime(0004, this.fromDate.Month, this.fromDate.Day);
yearsubtrutin = 4;
}
else
{
dd3 = new DateTime(0001, this.fromDate.Month, this.fromDate.Day);
yearsubtrutin = 1;
}
dd = this.fromDate;
dd3 = dd3.Add(ts);
this.year = dd3.Year - yearsubtrutin;
this.month = dd3.Month - this.fromDate.Month;
if (this.month < 0)
{
this.year = this.year - 1;
this.month = this.month + 12;
}

this.day = dd3.Day - this.fromDate.Day;
if (this.day < 0)
{
this.day = this.day + Getdays(this.toDate.Month, yearsubtrutin);

this.month = this.month - 1;

}
//

}

public int Getdays(int monthNumber, int isleap)
{
if (false)
return 29;
else
{
switch (monthNumber)
{
case 1:
return 31;
break;
case 2:
if (isleap == 4)
return 29;
else
return 28;
break;
case 3:
return 31;
break;
case 4:
return 30;
break;
case 5:
return 31;
break;
case 6:
return 30;
break;
case 7:
return 31;
break;
case 8:
return 31;
break;
case 9:
return 30;
break;
case 10:
return 31;
break;
case 11:
return 30;
break;
case 12:
return 31;
break;
default:
break;
}
}
return 0;
}

Thank
Mahesh

split view state into multiple fields

2011-07-11T10:44:00.000-07:00

split view state into multiple fields:

IIS can be set for max hidddn field data view state in case of this when browser submit the page
to iis than it gives error. So we need to split the data in to multiple view state
it can be set in web config file like we set the 100 KB of each view sate if it is bigger than it will split in to new view state

<pages maxPageStateFieldLength="100"></pages>
</system.web>

How to disable right click on web page with jquery; how to disable right click in javascript; how to disable right click in asp.net

2011-07-07T08:44:00.000-07:00

We have to bind contextmenu and return false from this.
This function also handel right click on images of web page. <script language="javascript" type="text/javascript">
    $(document).bind("contextmenu",function(e){
      return false;
     });
    </script>

Thanks
Mahesh

How to configure FCK Editor in asp.net c# [ Integrating FCKeditor in ASP.NET, how to use FCKeditor in asp.net, FCKEditor and ASP.NET, How to Download and install FCKeditor ASP.NET]

2011-06-29T22:28:00.001-07:00

Download FCK Editor FCKeditor 2.6.6, released on 15 February 2010.
You can find editor from following link:

http://ckeditor.com/download

2) Now add follwoing key field in web.config file

<add key="FCKeditor:UserFilesPath" value="image/"/>
This will create folder in location your site + "FCKeditor\editor\filemanager\browser\default\connectors\aspx\image\"when you upload image

3) Now you need to see priview on eiditor window.
for this i modify file
FCKeditor\editor\dialog\fck_image\fck_image.js
Add replaced follwoing code
Orignal code:
e.src = GetE('txtUrl').value ;
SetAttribute( e, "_fcksavedurl", GetE('txtUrl').value ) ;

Replaced By :

var srouce = String(document.location).substr(0,String(document.location).indexOf('/editor/'));
srouce = srouce + '/editor/filemanager/browser/default/connectors/aspx/'+ GetE('txtUrl').value;

e.src = srouce;
SetAttribute( e, "_fcksavedurl",srouce ) ;

The srouce contains the complete qulaify path. now you can modify image path in C# code.

4) In Same way you can
"FCKeditor\editor\dialog\fck_flash\fck_flash.js"
for flash upload.

Orignal Code SetAttribute( e, 'src', GetE('txtUrl').value ) ;
Modified code.
SetAttribute( e, 'src', srouce) ;

5) Now set aspx for variables _FileBrowserLanguage & _QuickUploadLanguage
FCKeditor\fckconfig.js

6) You can customize FCK Editor Toolbar button from
FCKConfig.ToolbarSets
this is also in FCKeditor\fckconfig.js.

7) Configure in Website.

a) Add FCK editor DLL inn your website.

b) Add FCK editor in tollbar menu.
]
c) Drag and drop FCK Editorr on your page.

<%

<FCKeditorV2:FCKeditor ID="FCKeditor1" BasePath="FCKeditor/" runat="server" Height="600"></FCKeditorV2:FCKeditor>
Set the base path propery for FCK Editor so it can access its directory.
BasePath="FCKeditor/"

Thanks
Mahesh@ Register Assembly="FredCK.FCKeditorV2" Namespace="FredCK.FCKeditorV2" TagPrefix="FCKeditorV2" %>

How to script manager Async Post Back Timeout on runtime

2011-06-29T22:24:00.000-07:00

If you have script manager on Master page and need to exceed AsyncPostBackTimeout only on specific page than.
add this code line in page_load event of your page.

ScriptManager _scriptMan = ScriptManager.GetCurrent(this);
_scriptMan.AsyncPostBackTimeout = 3600 * 15;

This will set AsyncPostBackTimeout upto 15 minutes.

Thakns
Mahesh

Insert date time from other culture to SQL Server us_english

2011-05-30T21:37:00.001-07:00

Insert date time from other culture to SQL Server us_english
1) To know which language is in use. @@Language
     select

2) To know all languages
     sp_helplanguage
3) For set new language :
    SET

4) For set new dateformat.
    SET dateformat dmy

Now set the format and

dateTime.ToString("MM/dd/yyyy", dateTimeFormat);DateTimeFormatInfo dateTimeFormat = (new CultureInfo("??-??")).DateTimeFormat; LANGUAGE us_englishhttp://www.sql-server-helper.com/tips/date-formats.aspx

2Nd:-
Set DD MM YYYY from C#
string dateFormat = "dd-MM-yyyy";
string Dtfrm = dateFrom.ToString(dateFormat);
Use in inline query with convert function
"date_from >= CONVERT(DATETIME,'" + Dtfrm + "',105) "

For example you can check following function in SQL and give correct result.
105

select CONVERT(DATETIME,'18.08.2010',105)
select CONVERT(DATETIME,'18-08-2010',105)
select CONVERT(DATETIME,'18/08/2010',105)

Thanks
Mahesh

Passing multiple parameters to predicates

2011-05-30T21:36:00.003-07:00

Step 1) Create a sample Class let say MyClass:
public class MyClass{
public int Age { get; set; }
public string TelephoneNumber { get; set; }
public string Name { get; set; }
}

Step 2) Create List of class and add some dummy values in list

objMyClass = new MyClass();
objMyClass.Age = 39;
objMyClass.Name = "mahesh";
objMyClass.TelephoneNumber = "9876561364";
objListOfMyClass.Add(objMyClass);
objMyClass = new MyClass();";"";
objMyClass = new MyClass();
objMyClass = "nabhay";
objMyClass.Age = 22;
objMyClass.Name = "rakshit";
objMyClass.TelephoneNumber = ""
objListOfMyClass.Add(objMyClass);

objMyClass =
objMyClass.Age = 18;
objMyClass.Name =
objMyClass.TelephoneNumber =
objListOfMyClass.Add(objMyClass);

Step 3)
Create new class in which we will create property to set the number of arguments and value, In real project we will only using the set attribute of property.

public class MyListMatcher{
public int Age { get; set; }
public string TelephoneNumber { get; set; }
public string Name { get; set; }
public bool Predicate(MyClass item)return ((item.Age == Age) && (item.TelephoneNumber == TelephoneNumber) && (item.Name == Name));}

Step 4) Now we have List and Predicated implemented logic so we have to just use it

objMyListMathcer.Name = "rakshit";
objMyListMathcer.Age = 18;
objMyListMathcer.TelephoneNumber = "987654321";
MyListMatcher objMyListMathcer = new MyListMatcher();
List<MyClass> objSelecteRes = objListOfMyClass.FindAll(objMyListMathcer.Predicate).ToList();

Thanks
Mahesh K. Sharms

Add a CalendarExtender to a GridView for month yearsetting (OnClientHidden OnClientShown)

2011-05-30T21:36:00.001-07:00

If we apply modification to calendar control then need to set property for its method and we need to create behaviour id for each calendar. using thesse settings in desing time it is easy but if we add these controls into gridview / datalist etc than we have to struggle with which calendar invoked the request.

For this we have to follwoing steps
step 1)
Add name space
using AjaxControlToolkit;
Step 2) In row databound event find the control and set its behaviour id wiht row index so each control has its own behaviour ID.
CalendarExtender AjaxCalendarTextBoxInvalidDate_To = (CalendarExtender)e.Row.FindControl("AjaxCalendarTextBoxInvalidDate_To");
AjaxCalendarTextBoxInvalidDate_To.BehaviorID = "calendar1" + e.Row.RowIndex;

Step 3)
Use the follwing script. In which we declared calendarID as global and set its id ones in function and used in all three function.

<script language="javascript" type="text/javascript">
var calendarID = '';
        function onCalendarShown(sender,e) {
calendarID = sender._id;
            var cal = $find(sender._id);
            //Setting the default mode to month
            cal._switchMode("months", true);

            //Iterate every month Item and attach click event to it
            if (cal._monthsBody) {
                for (var i = 0; i < cal._monthsBody.rows.length; i++) {
                    var row = cal._monthsBody.rows[i];
                    for (var j = 0; j < row.cells.length; j++) {
                        Sys.UI.DomEvent.addHandler(row.cells[j].firstChild, "click", call);
                    }
                }
            }
        }

        function onCalendarHidden(sender,e)
        {

        calendarID = sender._id;
           var cal = $find(sender._id);
            //Iterate every month Item and remove click event from it
              if (cal._monthsBody) {
                for (var i = 0; i < cal._monthsBody.rows.length; i++) {
                    var row = cal._monthsBody.rows[i];
                    for (var j = 0; j < row.cells.length; j++) {
                        Sys.UI.DomEvent.removeHandler(row.cells[j].firstChild,"click",call);
                    }
                }
            }
        }

        function call(eventElement)
        {
            var target = eventElement.target;
            switch (target.mode) {
            case "month":
                var cal = $find(calendarID);
                cal._visibleDate = target.date;
                cal.set_selectedDate(target.date);
                cal._switchMonth(target.date);
                cal._blur.post(true);
                cal.raiseDateSelectionChanged();
                break;
            }
            calendarID = '';
        }

    </script>

4) If you need to show calendare only for specific row/condition than u can declare ajax calendar in side the label and hide / show label on condition

<asp:Label Visible="false" ID="LableAjaxxToolKitCalendarContainer" runat="server" >
                                <ajax:CalendarExtender   ID="AjaxCalendarTextBoxInvalidDate_To" runat="server"
                                    Animated="False" FirstDayOfWeek="Monday" Format="MMM - yyyy" PopupButtonID="ImageAjaxCalendarTextBoxInvalidDate_To"
                                    TargetControlID="TextBoxInvalidDate_To" >

                                </ajax:CalendarExtender></asp:Label>

Thanks

Sarch Panel inside the grid

2011-04-30T05:26:00.001-07:00

This solution used JavaScript and HTML Markup:

/* Functionality: Assign the values in hidden filed now w e can use hiddenfield valus in server side code*/

function UpdateGrid(){

$('input[type=hidden][id$=HiddenFieldSColumn1]').val($('input[type=text][id=grvTestColumn1]').val());

/*HiddenFieldColumn2 grvTestColumn2*/

$('input[type=hidden][id$=HiddenFieldColumn2]').val($('input[type=text][id=grvTestColumn2]').val());

/*HiddenFieldSPEtternavn GVSPEmployeeEtternavn*/

if($('input[id$=ButtonSearchHiddenEventHandler]').length > 0)

{

$('input[id$=ButtonSearchHiddenEventHandler]')[0].click();

}

$(document).ready(

/*Functionality: 1)Create & append search panel inside the grid, 2)Assign values in textbox, */

function AddSearchPanel()

{

/*Add the search panel in grid*/

$('table[id$=grvTest] tr:first').after("<tr style='background-color:red;height:10px;'><td style='width:30px'> </td>

<td><input type='text' maxLength='1' id='grvTestColumn1' onchange='UpdateGrid();' onkeyup='SetDefalutButtonSearchPanel(event); ' style='height:15px;width:30px;font-size:12px' /></td> <td><input type='text' id='grvTestColumn2' onchange='UpdateGrid();' onkeyup='SetDefalutButtonSearchPanel(event); ' style='height:15px;width:50px;font-size:12px' /></td> <td><input type='text' id='GVSPEmployeeEtternavn' onchange='UpdateGrid();' onkeyup='SetDefalutButtonSearchPanel(event); ' style='height:15px;width:80px;font-size:12px' /></td> <td><input type='text' id='GVSPEmployeeFornavn' onchange='UpdateGrid();' onkeyup='SetDefalutButtonSearchPanel(event); ' style='height:15px;width:80px;font-size:12px' /></td> <td style='width:100px'>  </td> <td><input type='text' maxLength='20' id='GVSPEmployeeResourceType' onchange='UpdateGrid();' onkeyup='SetDefalutButtonSearchPanel(event); ' style='height:15px;width:100px;font-size:12px' /></td> <td><input type='text' id='GVSPEmployeeAdresse' onchange='UpdateGrid();' onkeyup='SetDefalutButtonSearchPanel(event); ' style='height:15px;width:80px;font-size:12px' /></td> <td><input type='text' id='GVSPEmployeePostnr' onchange='UpdateGrid();' onkeyup='SetDefalutButtonSearchPanel(event); ' style='height:15px;width:50px;font-size:12px' /></td> <td><input type='text' id='GVSPEmployeePoststed' onchange='UpdateGrid();' onkeyup='SetDefalutButtonSearchPanel(event); ' style='height:15px;width:100px;font-size:12px' /></td> <td><input type='text' id='GVSPEmployeeTlfnr' onchange='UpdateGrid();' onkeyup='SetDefalutButtonSearchPanel(event); ' style='height:15px;width:60px;font-size:12px' /></td> <td><input type='text' id='GVSPEmployeeMobilnr' onchange='UpdateGrid();' onkeyup='SetDefalutButtonSearchPanel(event); ' style='height:15px;width:60px;font-size:12px' /></td> <td style='width:100px'><img id='imgRefreshGridSearchPanel' onclick='ResetSearchPanel()' src='../Images/Refresh.gif' border='0' alt='reset' style='cursor:pointer' title='Refresh Q.B.E'></img></td> <td style='width:20px'> </td> </tr>");

/*Assign the values in search panel. Show the values of hidden values in text box*/

$('input[type=text][id=grvTestColumn1]').val($('input[type=hidden][id$=HiddenFieldSColumn1]').val());

$('input[type=text][id=grvTestColumn2]').val($('input[type=hidden][id$=HiddenFieldColumn2]').val());

});

/*Functionality: This function is used for reset the controls on Grid Search PanelCreated*/

function ResetSearchPanel()

{

$('table[id$=grvTest]').find('input[type=text]').each(function(index)

{

$(this).val('');

});

$('td[id$=tdHiddenFieldContainer').find('input[type=hidden]').each(function (index)

{

$(this).val('');

});

UpdateGrid();

}

/*Created for set the title of version information on user title bar.*/

$(document).ready(

function ShowCurrentVersion()

{RefreshCountPanel();}

);/* End of document ready funciton*/

/*Functionality; This function is used for handel enter key evetn on Search Panel inside the grid */

function SetDefalutButtonSearchPanel(e)

{

var evt = e ? e : window.event;

if (evt.keyCode == 13)/*Search if user hit enter key*/

{

UpdateGrid();

return false;

}

search panel inside the grid

2011-04-03T23:09:00.000-07:00

I have to add textbox on top row inside the grid. and when end user insert the search value than grid result should be populated accordingly.

But how i can add text box only on top row. CSS of grid does not allow me to add text boxes on header. my grid should look like this

Header: Emp# EmpName EmpAddd
Search TextBox : [_____] [_____] [______]
Lable show data : 1 aaa adress1
Lable show data : 2 bbb adress2
Lable show data : 3 ccc adress3

Search is not my problem but how i can add text box only for top row in grid view. I can not add always text box and give the look n feel of other text box as label.

SOLUTION:

1) READ THE html markup of grid.
create same row and add search textboxes in the td on document.ready function

2)Attach search function on change event for the all search textboxes call it function FilterGrid.

3) on FilterGrid set the value of search textboxes in hidden field.

4) call clcik event on filterGrid function and now on C# code behind get the values from hidden fields and filter the gird datasoruce.

5)when page again render than search panel will set again on document.ready function.

5A) if you are using update panel than call same function on update panels event's refresh or load funtion.

Also can add search panel in gridview in server side (C#):

protected void GVtest_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
//Create the Row
GridViewRow row = new GridViewRow(-1, -1, DataControlRowType.DataRow, DataControlRowState.Normal);
//Add the two Columns
if(e.Row.RowIndex == 1)
row.Cells.AddRange(CreateSarchPanel());
//get a reference to the table that holds this row
Table gridviweTable = (e.Row.Parent as Table);
//Add the row at 0 indx.
gridviweTable.Rows.AddAt(0, row);
}

}
private TableCell[] CreateSarchPanel()
{

TableCell[] cells = new TableCell[2];
TableCell cell;
TextBox tb = new TextBox();
tb.ID = "TextBoxSearchCriteria1";
//The first column
cell = new TableCell();
tb = new TextBox();
cell.Controls.Add(tb);
cells[0] = cell;

//The second column
cell = new TableCell();
TextBox tb2 = new TextBox();
tb2.ID = "TextBoxSearchCriteria2";
cell.Controls.Add(tb2);
cells[1] = cell;

return cells;
}

IE dropdown width issue, IE dropdown width problem,internet explorer dropdown list

2011-03-17T01:16:00.000-07:00

IE dropdown width issue, IE dropdown width problem,internet explorer dropdown list

We can add tooltip to all list items but in server side we have to add by loop. it is not feasible if u already

coded, or too many items can bind in dropdown list.

We can add tooltip for elements which are cutting in IE sample code is following it is based on jQuery

1)
<asp:DropDownList ID="DropDownListIEIssue" onmouseover="return test(this);" runat="server" Width="100">

</asp:DropDownList>

2)

3)
if (!IsPostBack)

{

string[] test = new string[] { "dddddddddddddddddddd", "aaaaaaaaaaaaaaaaaa", "bbbbbbbbbbbbbbbbbbbbbbbbbbbbb", "ccccccccc" };

DropDownListIEIssue.DataSource = test;

DropDownListIEIssue.DataBind();

}

Thanks
Mahesh K. Sharna$("option", sender).each(function () {
function AddToolTipOnDropDownLists(sender)
{
try
   {
     $("option", sender).each(function () {
       $(this).attr("title", $(this).html());
       });
      /*For slected element*/
     $(sender).attr('title',$('option:selected',sender).html())
   }
catch (Exception)
{

}
}

Logic in sorting (ASC/DESC) null in sorted column should be always bellow in values MS SqlSever

2011-03-10T10:16:00.000-08:00

We need the logic in sorting (ASC/DESC) the null of sorted column should be always bellow in values.
SQuery for MS SQL SERVER

create table #temp ( inde int, inde2 varchar(20))

insert into #temp values (null,'vvv')

insert into #temp values (1,'zzz')

insert into #temp values (2,'bbb')

insert into #temp values (null,'rrr')

insert into #temp values (null,'tttt')

insert into #temp values (1,'aaaa')

For example in #temp table if we sorted desc order than it should return 2,1,1 null,null,null and when we sort it by ASC than it should 1,1,2,null,null,null
We can achive this by following query

select * from #temp order by (case when inde IS null then 0 else 1 end) desc, inde desc

select * from #temp order by (case when inde IS null then 0 else 1 end) desc, inde asc

Thanks
Mahesh K. Sharma

How to set the text for a TextBox with TextMode as Password asp.net

2011-03-02T02:28:00.000-08:00

If we have to show the text value in text box where TextM ode property is set to password.

string password ="TestPassword";

TextBoxPassword.Attributes.Add("value", password);

Thanks
Mahesh K. Sharma

How to check overlapping Like start date end date, Reservation seat number, table booking in hotels

2011-02-24T07:37:00.000-08:00

I will post this in cupols of day if you want it now than email me mca.mks@gmail.com

How to set buzy mouse pointer/ Progress bar while async post back.

2011-02-18T21:37:00.001-08:00

The Asyn post back mostly done by Ajax or by Update panel.
So by the meantime we have to show the progress bar. but it is not good practive.
B'coz when you hit the button for full post back than your progress bar will not
come then buzy mouse pointer will show. so we should use buzy pointer and disable the backgroud. We can achive this by following method.

step 1. Create following CSS.
.progress_overlay
{
   position: fixed;
   width: 100%;
   height: 100%;
   top: 0px;
   left: 0px;
   background: #fff;
   filter: alpha(opacity=5);
   z-index:20000;
}
.progress_container
{
   position: fixed;
   width: 100%;
   height: 100%;
   top: 0px;
   left: 0px;
   background: transparent;
   z-index:20001;
}
.progress_inner
{
   display: block;
   padding: 10px 10px 10px 10px;
   text-align:center;
   width: 380px;
   height: 50px;
   margin: 25% auto 0 auto;
   background: transparent;
   z-index:20002;
}

Step 2.Add followind dive in your master page or page where you want to show this.

[div id="progress_overlay"]
   [div id="progress_overlay_inside"]
   [/div]
   [/div]
   [div style="display: none" id="progress_container"]
   [div id="progress_inner"]
   [/div]
   [/div]

Step 3. Add following JS If you are using Update panel

/* Region for progress bar / busy mouse pointer */

   /* Get the instance of PageRequestManager.*/
   var prm = Sys.WebForms.PageRequestManager.getInstance();
   /* Add initializeRequest and endRequest */
   prm.add_initializeRequest(prm_InitializeRequest);
   prm.add_endRequest(prm_EndRequest);

   /* Called when async postback begins */
   function prm_InitializeRequest(sender, args) {
   /* get the div and set it to visible and disable the background */
   ShowHourGlass();
   $("#progress_container").show();
   $("#progress_overlay").addClass('progress_overlay');
   $("#progress_container").addClass('progress_container');
   $("#progress_inner").addClass('progress_inner');
   }

   /* Called when async postback ends */
   function prm_EndRequest(sender, args) {
   /* get the div and hide it again */
   /* Remove the class*/
   HideHourGlass();
   $("#progress_container").hide();
   $("#progress_overlay").removeClass('progress_overlay');
   $("#progress_container").removeClass('progress_container');
   $("#progress_inner").removeClass('progress_inner');
   }

If we are using Ajax call method than just call these method before start and end of method.

/* End Region for progress bar / busy mouse pointer*/

Here we are showing hour pointer and hide hour class.

for example

   function HideHourGlass()
{
Wake("input"); // Not all needed in Mozilla browsers - just TD?
Wake("select");
Wake("a");
Wake("tr");
Wake("td");

document.body.style.cursor = '';
}

function Wake(tagName)
{
var ctrl, i;
var tags = document.getElementsByTagName(tagName);

for (i=0; i < tags.length; i++)
{
ctrl = tags[i];
ctrl.style.cursor = '';
}
}

function Sleep(tagName)
{
var ctrl, i;
var tags = document.getElementsByTagName(tagName);

for (i=0; i < tags.length; i++)
{
ctrl = tags[i];
ctrl.style.cursor = 'wait';
}
}

function ShowHourGlass()
{
Sleep("input"); // Not all needed in Mozilla browsers - just TD?
Sleep("select");
Sleep("a");
Sleep("tr");
Sleep("td");

document.body.style.cursor = 'wait';
//window.status = "Processing, please wait";
}

How to increase AsyncPostBackTime out of update panel

2011-02-18T21:34:00.001-08:00

Like in following code line we set the 15 Minute Asysn time

ScriptManager _scriptMan = ScriptManager.GetCurrent(this);
_scriptMan.AsyncPostBackTimeout = 3600 * 15;

Thanks
HelponDesk Team

PLINQ

2011-01-29T03:40:00.001-08:00

List[BabyName] b = new List[BabyName]();

BabyName ob = new BabyName();

for (int i = 0; i lt 10000000; i++)

{

ob = new BabyName();

ob.Name = i.ToString();

b.Add(ob);

}

ob = new BabyName();

ob.Name = "Mahesh";

b.Add(ob);

Stopwatch stopWatch = new Stopwatch();

stopWatch.Start();

var _sequentialQuery = from b2 in b

where b2.Name.Equals("Mahesh",StringComparison.InvariantCultureIgnoreCase)

select b2;

stopWatch.Stop();

::PLINQ ::

string ss = stopWatch.ElapsedTicks.ToString();

Stopwatch stopWatch2 = new Stopwatch();

stopWatch2.Start();

var _sequentialQuery2 = from b2 in b.AsParallel().WithDegreeOfParallelism(60)

where b2.Name.Equals("Mahesh", StringComparison.InvariantCultureIgnoreCase)

select b2;

stopWatch2.Stop();

string ss2 = stopWatch2.ElapsedTicks.ToString();

class BabyName

{

public string Name { get; set; }

}

Thanks

Mahesh K Sharma

Convert the dataTable to var

2011-01-29T02:19:00.000-08:00

var vObject = dataTable.Select().Select(t => new
{
Prop1= t["Column1"],
Prop2=
string.Concat(Convert.ToString(t["Column2"]), "(", Convert.ToString(t["Column3"]), ") ", Convert.ToString(t["Column4"])),
Prop3= t["Column5"],
Prop4= t["Column6"]
});

Thanks
Mahesh Sharma

set scrooll of div for selected item

2011-01-29T01:58:00.000-08:00

We have a div which contains 200 radio buttons. we fixed the height of div and set the vertical scroll now we want that scroll position should automatically set according to selected item.

For this we have to find the selected vaue and get its offsetTop value and set this value to div.ScroolTop.

Code is follwoing :

var container = document.getElementById('hhhjh');
var rowToScrollTo = document.getElementById('setID7');
alert(rowToScrollTo.offsetTop);
container.scrollTop = rowToScrollTo.offsetTop;

HTML Entity from child window to parent page

2011-01-29T01:56:00.000-08:00

Problem when we pass less than char from child window to parent then it changes &lt. after some time googling i did not find some full proof method. so i just created function to replace those vaue

function html_entity_decode(str) {

var ta=document.createElement("textarea");

ta.innerHTML=str.replace(//g,">");

return ta.value;

Thanks

Mahesh Sharma

How to get single quote & comma separated character set from datatable column: for example we want 'row1','row2','row3' from data table values

2011-01-29T01:49:00.000-08:00

How to get single quote & comma separated character set from datatable column:
for example we want 'row1','row2','row3' from data table values but without using looping.

1)
Following method takes 3 times more execution time compare to looping
System.Diagnostics.Stopwatch sw = new System.Diagnostics.Stopwatch();
sw.Start();

String[] ArrayResIds =
Array.ConvertAll(DataTable.Select(),
delegate(DataRow row) { return (String)row["ColumnName"]; }
);
string resIDsComaaSep = string.Concat("'",string.Join(",'",ArrayResIds),"'");
sw.Stop();

private static string ConvertToString(DataRow dr) { return Convert.ToString(dr[0]); }

2)
Following method takes 35 times more execution time compare to looping

System.Diagnostics.Stopwatch sw = new System.Diagnostics.Stopwatch();
sw.Start();

DataRow[] myrow = new DataRow[DataTable.Rows.Count];
DataTable.Rows.CopyTo(myrow, 0);
string[] ArrayResIds = Array.ConvertAll(myrow, new Converter(ConvertToString));

string resIDsComaaSep = string.Concat("'", string.Join(",'", ArrayResIds), "'");
sw.Stop();
string timeconsuming = sw.ElapsedTicks.ToString();

3) If oracle or sql available for this functionality than it easy to get comma separated string

--Sample table schema

Create table SchemaID([ID] smallint,SchemaID int NOT NULL)

--Dummy insert statements

Insert into SchemaID values (1,12)Insert into SchemaID values (1,13)Insert into SchemaID values (1,14)Insert into SchemaID values (2,15)Insert into SchemaID values (2,16)Insert into SchemaID values (2,17)Insert into SchemaID values (2,18)

--Solution

Declare @ID varchar(100)
Select @id=Coalesce(@ID + ', ', '') + Cast(SchemaID AS varchar(5)) From SchemaID Where [ID] = 1 SELECT @ID

Some Sites which i frequently used

2010-12-31T09:12:00.000-08:00

1) http://www.bbc.co.uk/hindi/

2) http://www.ndtv.com/video/live/channel/ndtv24x7

3) http://www.phpform.org/ for create HTML form

4) http://www.webdevelopersnotes.com/ -- basics tutorials

5) http://www.google.com/recaptcha -- for apply captcha

6) http://www.microgold.com/ -- Tools for documentation / development

7) http://bits.limebits.com/home/ -- create website

8) http://www.page4.me/ --create free website

9) http://www.ning.com/ -- create free social network and website

10) http://www.ablecommerce.com/ --Create E-commerce website

11) http://www.hl7.org/-- standards for health care websites

12) http://www.typetester.org/ -- Online tool for create CSS online

13) http://www.blueprintcss.org/ -- Tool for create CSS online
13) A. http://www.pagetutor.com/button_designer/index.html -- Design a new button

14) http://leftlogic.com/projects/entity-lookup/ -- Search for HTML entity codes for speacial characters

15) http://www.designerstoolbox.com/

16) http://new.myfonts.com/WhatTheFont/ --What is the font used in the webpage

17) http://www.buttonbrowser.com/main/index.php?page=buttonmaker

b) http://css-tricks.com/examples/ButtonMaker/-- Design Buttons

18) http://www.roundedcornr.com/ -- Create round corner box / div online

19) http://lab.rails2u.com/bgmaker/ -- Create back ground image

20) http://www.loadinfo.net/ b) http://ajaxload.info/ -- Create Ajax loader gif.

21) http://sickdesigner.com/index.php/2010/html-css/html5-starter-pack-a-sick-freebie/ -- HTML Templates

22) http://www.dropbox.com/ --Share store fiels online but never used

23) http://code.google.com/webfonts

24) http://www.dynamicdrive.com/

25) http://regexlib.com/

26) http://www.wisdom-soft.com/products/screenhunter.htm -- Get the screen shots

27) http://www.spadixbd.com/freetools/jruler.htm -- Get ruler / scale for measure screen

28) http://www.pixlr.com/editor/ --Edit / Create image online

29) http://www.webpagetest.org/

b) http://www.websiteoptimization.com/services/analyze/-- Test the loading of webpage on browser

http://www.devart.com/codecompare/?gclid=CPuZ-5f3uaYCFcQc6wodaHZNHw-- compare codes

30) http://www.itfundacorporation.com/ --Tutorials
31)http://www.freedigitalphotos.net/ -- Free Images
32)http://www.aceproject.com/ -- For Manage Projects, Bug, Docs,

Null Coalescing Operator ??

2010-12-23T07:27:00.000-08:00

For example, the myfunction whose return value may be a nullable int. In such cases, you can use the coalescing operator to quickly check if it is null and return an alternate value.

int myExpectedValueIfNull = 10;

int expectedValue = myfunction() ?? myExpectedValueIfNull

Add text in new line

2010-12-23T07:18:00.000-08:00

In many time Email body, Message Box, we need to display text, or some time we need to display text starting in new line, we use \r\n for this purpose. but environment class having property of newline for example

string newline = string.Concat("1",Environment.NewLine,"2",Environment.NewLine,"3",Environment.NewLine,"4",Environment.NewLine,"5");

// Response.Write(newline);

showNewLine.Text = newline;

Mahesh K. Shama

OverCome of string.Split(char) limitation

2010-12-23T06:58:00.000-08:00

String split method take chat as input, bur some time may be possible that this char added on string by user. so we need to add some combination of char for less possibility of this incident.

Example code is as follows :

const string DelimiterAndSpliter = "||";

string delimitedString = string.Concat("Str1",DelimiterAndSpliter,"Str2",DelimiterAndSpliter,"Str3",DelimiterAndSpliter,"str4", DelimiterAndSpliter,"str5");

string[] stringArray = System.Text.RegularExpressions.Regex.Split(delimitedString, System.Text.RegularExpressions.Regex.Escape(DelimiterAndSpliter));

Mahesh K Sharma.

What is Explicit and Implicit Interface Implementation

2010-12-23T06:50:00.000-08:00

Yes, very much. Did you know other than the syntax difference between the two, there existed a fundamental difference.

Implicit interface implementation on a class would be a public method by default and is accessible on the class's object or the interface.

Explicit interface implementation on a class would be a private method by default and is only accessible through the interface and not through the class object unlike the implicit implementation. Yes, through this you can force you clients to use the Interface and not the objects that implement it.

public interface IMyInterface

{

void MyMethod(string myString);

}

CLASS THAT IMPLEMENTS THE INTERFACE IMPLICITLY

public MyImplicitClass: IMyInterface

{

public void MyMethod(string myString)

{

///

}

CLASS THAT IMPLEMENTS THE INTERFACE EXPLICITLY

public MyExplicitClass: IMyInterface

{

void IMyInterface.MyMethod(string myString)

{

///

}

MyImplicitClass instance would work with either the class or the Interface:

MyImplicitClass myObject = new MyImplicitClass();

myObject.MyMethod("");

IMyInterface myObject = new MyImplicitClass();

myObject.MyMethod("");

MyExplicitClass would work only with the interface:

//The following line would not work.

MyExplicitClass myObject = new MyExplicitClass();

myObject.MyMethod("");

//This will work

IMyInterface myObject = new MyExplicitClass();

myObject.MyMethod("");

Set Title Case

2010-12-23T06:41:00.000-08:00

Hi ,

I need to display user name in title case. for example if user enter his first name as mahesh and middle name as kumar and surname as sharma than it should be display as "Mahesh Kumar Sharma".. irrespective of users enter format.

so i need a function which set the initial character of word in large. abc xyx def tuv

ChangeToTitleCase("abc xyx def tuv") should be return Abc Xyz Def Tuv.

The body of function is as follows :

private string ChangeToTitleCase(string inputText)

{

return Thread.CurrentThread.CurrentCulture.TextInfo.ToTitleCase((inputText?? string.Empty).ToLower());

}

Thanks

Mahesh K Sharma

How to download any content from server.

2010-12-17T08:49:00.000-08:00

for download any content you need to redirect to other page.
sya downloadContent.aspx?FileName="UniqueNameOfContentAsonServer.exe"&Name="NameWhichYouwantToShowInDownloadDialogBox"

call following function on page load event. :)

private void DownlaodContent()
{
if (Request.QueryString["FileName"] == null || Request.QueryString["Name"] == null)
{
return;
}
string _filePath = "";
System.IO.FileInfo _targetFile = null;
try
{
_filePath = Server.MapPath( Request.QueryString["FileName"].ToString());
_targetFile = new System.IO.FileInfo(_filePath);
if (_targetFile.Exists)
{
Response.Clear();
Response.ContentType = "text/plain";
Response.AddHeader("Content-Disposition", "attachment; filename=" + Request.QueryString["Name"].ToString());// + ".txt");
Response.WriteFile(_targetFile.FullName, true);
//_targetFile.Delete(); If you want to delete phycally after download a image
}

}
catch (Exception ex)
{

// Error logging as per existing application.
}
finally
{
_targetFile = null;
Response.Flush();
Response.End();
}
}

Thanks
Mahesh K. Sharma

Show default div instead of default tooltip with controls !!!

2010-12-17T07:05:00.000-08:00

For this we have text in title attribute of controls so we have to create a div on mouse over and hide on mouse out event. So we can create a function and call this fuction with desired controls.

In this fucntion we must have customized div propery say color etc. and we can use fade funcions of jQuery

this function is follwos :

(function($) {
$.fn.tooltip = function(options) {

var
defaults = {
background: '#fffdf0',
color: 'black',
rounded: true

},
settings = $.extend({}, defaults, options);

this.each(function() {
var $this = $(this);
var title = this.title;

if ($this.attr('title') != '') {
this.title = '';
$this.hover(function(e) {
// mouse over
if ($this.children("div[tooltip]").length < 1) {

$('')
.appendTo($this)
.html(title)//If we want to show decorate text with HTML styles
//.text(title)//If we need to show simple text
.hide()
.css({
position:'absolute',
backgroundColor: settings.background,
color: settings.color,
top: e.pageY + 10,
left: e.pageX + 20
})

.fadeIn(550);

}
else {
$this.children("div[tooltip]").html(title)
.fadeIn(550)

}

if (settings.rounded) {
$this.children("div[tooltip]").addClass('rounded');
}
}, function() {
// mouse out
$this.children("div[tooltip]").remove()
.fadeIn(550)
});
}

$this.mousemove(function(e) {
$this.children("div[tooltip]").css({
top: e.pageY + 10,
left: e.pageX + 20
});
});

});
// returns the jQuery object to allow for chainability.
return this;
}
})(jQuery);

We have to call this function :)

[script language="javascript" type="text/javascript"]
$(document).ready(function() {
$("a","#SectionOfPage").tooltip();

});

[/script]

Where "a" in control type and it It will apply only in div SectionOfPage.

Thanks
Mahesh K. Sharma

How to enable accept button when user complete crolled down than message

2010-12-17T07:01:00.000-08:00

function checkScrollPosition(divFrame)
{

if (divFrame.scrollHeight - divFrame.scrollTop + 17 - divFrame.offsetHeight < 50) {
document.getElementById('<%=ButtonAccept.ClientID%>').disabled = false;
document.getElementById('<%=LabelScrollMessage.ClientID%>').style.display = 'none';

}
}

Thanks
Mahesh K. Shamra

How to Create common javascript custom validator

2010-12-17T06:56:00.001-08:00

If in update panel
ScriptManager.RegisterExpandoAttribute(CustomValidatorTextBoxDOB, CustomValidatorTextBoxDOB.ClientID, "Date", TextBoxDOB.ClientID, false);
in in page
Page.ClientScript.RegisterExpandoAttribute(CustomValidatorTextBoxDOB.ClientID, "Date", TextBoxDOB.ClientID, false);

ClientValidationFunction="ClientValidate"

function ClientValidate(sender, arguments)
{
arguments.IsValid = false;
return false;

}
OnServerValidate="DateValidate"

protected void DateValidate(object source, ServerValidateEventArgs args)
{
args.IsValid = CommonClass.ValidateDate(args.Value);
}

How to localize with master page dropdown

2010-12-17T06:54:00.000-08:00

1) Add followoing code on index change event of Master page Dropdown

protected void DropDownListSelectLanguage_SelectedIndexChanged(object sender, EventArgs e)
{
Session["Culture"] = DropDownListSelectLanguage.SelectedValue;
Server.Transfer(Request.Path);

}
2) Create a base class and inherit the content pages with it or call fuction on contents page
InitializeCulture() envet.

protected override void InitializeCulture()
{

try
{

if ((Session["Culture"] != null))
{
LanguageCulture = Session[EMDMCConstants.SessionCulture ].ToString();
if (LanguageCulture != "0")
{
Thread.CurrentThread.CurrentUICulture = new CultureInfo(LanguageCulture);
Thread.CurrentThread.CurrentCulture = CultureInfo.CreateSpecificCulture(LanguageCulture);
base.InitializeCulture();

}
}

}
catch (Exception ex)
{
string _customException = "###Class Name - BaseClass.cs Source Function Name -InitializeCulture, ParameterCount - 0###";
LogManager.SetException(ex, null, _customException);

throw ex;

}

}

3) Do not forgot to add resx files of same page for this you can take reff of any site.

Regulare Expressions

2010-12-17T06:53:00.000-08:00

USER Name:
Accept username, user_name, username_123,
Not accept user name, 123Username, _username,

ControlToValidate="TextBoxUserId" Display="None" SetFocusOnError="True"runat="server" ErrorMessage="Invalid User name"meta:resourcekey="REVUserNameResource1">

USER PASSWORD:
Display="None" SetFocusOnError="True" ValidationExpression="(?!^[0-9@,|()[\]{}#.$%&_'*+:;^`'~?=!-]*$)(?!^[a-zA-Z@,|()[\]{}#.$%&_'*+:;^`'~?=!-]*$)^([a-zA-Z0-9@,|()[\]{}#.$%&_'*+:;^`'~?=!-]{6,25})$"
ControlToValidate="TextBoxPassword" meta:resourcekey="RegularExpressionValidator5Resource1">

CITY NAME:
Accept New yourk not accep numaric,special characters

ValidationExpression="^[a-zA-Z\s]{1,40}$" runat="server" Display="None" ErrorMessage="Enter Only Character"
meta:resourcekey="REVTextBoxCityNameResource1">

BLOOD GROPUP :
ErrorMessage="Enter Valid Blood Group." Display="None" runat="server"
meta:resourcekey="REVTextBoxBloodGroupResource1">

RESTICATED EXTENSIONS:
ErrorMessage="Can't upload exe or msi" Display="None">
LIMIT IN TEXT AREA
Display="None" ErrorMessage="Limit Exceed"
SetFocusOnError="True" ValidationExpression="(.|\r|\n){0,10}">

// valid date format for exp (mm/dd/yyyy )
//This R.E used for validate date with leap year I used this in javascript :
var RegExPattern = /^(?=\d)(?:(?:(?:(?:(?:0?[13578]|1[02])(\/|-|\.)31)\1|(?:(?:0?[1,3-9]|1[0-2])(\/|-|\.)(?:29|30)\2))(?:(?:1[6-9]|[2-9]\d)?\d{2})|(?:0?2(\/|-|\.)29\3(?:(?:(?:1[6-9]|[2-9]\d)?(?:0[48]|[2468][048]|[13579][26])|(?:(?:16|[2468][048]|[3579][26])00))))|(?:(?:0?[1-9])|(?:1[0-2]))(\/|-|\.)(?:0?[1-9]|1\d|2[0-8])\4(?:(?:1[6-9]|[2-9]\d)?\d{2}))($|\ (?=\d)))?(((0?[1-9]|1[012])(:[0-5]\d){0,2}(\ [AP]M))|([01]\d|2[0-3])(:[0-5]\d){1,2})?$/;
if(EntredDate.match(RegExPattern) == null)//If entred date is not matched then show message
{
arguments.IsValid = false;
return false;//show error message
}

How to save session after Directory.Delete() method.

2010-12-17T06:52:00.001-08:00

use out proc session
or
Paste following code on global.asax page

<%@ Import Namespace="System.Reflection" %>

void Application_Start(object sender, EventArgs e)
{
// Code that runs on application startup

//Preventing sessions after delete folder
PropertyInfo p = typeof(System.Web.HttpRuntime).GetProperty("FileChangesMonitor", BindingFlags.NonPublic | BindingFlags.Public | BindingFlags.Static);
object o = p.GetValue(null, null);
FieldInfo f = o.GetType().GetField("_dirMonSubdirs", BindingFlags.Instance | BindingFlags.NonPublic | BindingFlags.IgnoreCase);
object monitor = f.GetValue(o);
MethodInfo m = monitor.GetType().GetMethod("StopMonitoring", BindingFlags.Instance | BindingFlags.NonPublic);
m.Invoke(monitor, new object[] { });

}
Mahesh K. Sharma

Set The defalut button of a form

2010-12-17T06:51:00.001-08:00

Page.Form.DefaultButton = ImageButtonCompleterOrder.UniqueID

When to Use RegisterStartupScript & RegisterClientScriptBlock in code.

2010-12-17T06:46:00.000-08:00

Assume you have a control named "TextBox1" in aspx file, and its value is "2"
also, you have a javascript function called "ShowValue" which will alert the value of TextBox1.
so, your aspx file like this:
Code:

[title]Untitled Page[/title]
[script]
ShowValue = function()
{
alert(document.getElementById("TextBox1").value);
}
[/script]
[/head]
[body]
[form id="form1" runat="server"]
[div]
[asp:TextBox ID="TextBox1" runat="server" Text="2"][/asp:TextBox]
[/div]
[/form]
[/body]
[/html]

now, in server-side, at Page_Load method, you set value of "TextBox1" to "9" and call "ShowValue" from server.

Code:

TextBox1.Text = "9";
Page.ClientScript.RegisterStartupScript(Type.GetType("System.String"), "addScript", "ShowValue()", true);

that is.

The RegisterClientScriptBlock method adds a script block to the top of the rendered page.

while, the script block added by the RegisterStartupScript method executes when the page finishes loading but before the page's OnLoad event is raised.
(it means the RegisterStartupScript method adds a script block to the end of the rendered page.)

Thanks
Mahesh K. Sharma

How to set the focus on controls when ajax toolkit modal popup comes true

2010-12-17T06:41:00.000-08:00

1)In which control you want to focus set this as behaviour id of modalpopup
2)use this code block
In following example we set the focus on emergency code text box.

if ((!Page.ClientScript.IsStartupScriptRegistered("Startup"))) {
StringBuilder sb = new StringBuilder();
sb.Append("");
Page.ClientScript.RegisterStartupScript(Page.GetType(), "Startup", sb.ToString());

Thanks
Mahesh K. Sharma

How to add buttons for fullpost back in gridview while using update panels

2010-12-17T06:39:00.000-08:00

1)
Add following code on row_databound

ImageButton ImageButtonDocumentDownLoad = (ImageButton)e.Row.FindControl("ImageButtonDocumentDownLoad");

ScriptManager scriptManager = ScriptManager.GetCurrent(this);
scriptManager.RegisterPostBackControl(ImageButtonDocumentDownLoad);

//If grid view in user control

2)
ScriptManager scriptManager = new ScriptManager();
scriptManager.RegisterPostBackControl(ImageButtonDocumentDownLoad);

Thanks
Mahesh K. Sharma

How to prevent duplicate record instertion on Page referesh,considering i dont have any primary key.

2010-04-20T03:11:00.000-07:00

Hello Everyone,

Suppose I had Inserted one record, Now, when I refresh Page same record is inserted again though I had cleared all the textboxes after insertion. How can i avoid this???

For This you to put the following code

protected void Page_Load(object sender, EventArgs e)
{

if (!Page.IsPostBack)
{
Session["update"] = Server.UrlEncode(System.DateTime.Now.ToString());
}
}

protected void btnSubmit_PreRender(object sender, EventArgs e)
{
ViewState["update"] = Session["update"];
}

protected void btnSubmit_Click(object sender, ImageClickEventArgs e)
{

if (Session["update"].ToString() == ViewState["update"].ToString())
{
Session["update"] = Server.UrlEncode(System.DateTime.Now.ToString());

//Write your Insert Code.

}

Thank you.
Sanjeev Kumar

Simple steps for starting program

2009-05-15T00:54:00.000-07:00

BASEDB.CS

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using DataAccessLayer;
using BusinessLogic;

///

/// Summary description for BaseDB
///

namespace DataAccessLayer
{
public class BaseDB
{
///

/// This is a comman function which is used by various class files for getting dataset.
///

/// sqlcommand type object
/// Dataset which holds all the values
internal static DataSet GetDataset(SqlCommand oCommand)//Accepts sqlcommand and procedure name as parameters and makes connection with database to bring required data and returns dataset
{
using (DataSet oDataSet = new DataSet())
{
using (SqlConnection oConn = new SqlConnection(CommonClass.getConnectionPath()))
{
oCommand.Connection = oConn;
oCommand.CommandType = CommandType.StoredProcedure;
oCommand.CommandTimeout = 3600;
using (SqlDataAdapter oAdapter = new SqlDataAdapter())
{
oAdapter.SelectCommand = oCommand;
try
{
oAdapter.Fill(oDataSet);

}
catch (Exception e)
{
throw e;
}
}
}
return oDataSet;
}
}

///

/// This is a commen function used by various class files to get scalar values from databae.
///

/// sqlcommand type object
/// object
internal static object ExecuteScalar(SqlCommand oCommand)
{
object objectToRead = null;
using (SqlConnection oConn = new SqlConnection(CommonClass.getConnectionPath()))
{
if (oConn.State == ConnectionState.Closed)
{
oConn.Open();
}
oCommand.Connection = oConn;
oCommand.CommandType = CommandType.StoredProcedure;
oCommand.CommandTimeout = 3600;
try { objectToRead = oCommand.ExecuteScalar(); }
catch (Exception e) { throw e; }
}
return objectToRead;
}

///

/// Commen function shared by all the class file to execute update , delete queries and return nothing.
///

/// sqlcommand type object
internal static int ExecuteNonQuery(SqlCommand oCommand)
{
using (SqlConnection oConn = new SqlConnection(CommonClass.getConnectionPath()))
{
if (oConn.State == ConnectionState.Closed)
{
oConn.Open();
}
oCommand.Connection = oConn;
oCommand.CommandType = CommandType.StoredProcedure;
oCommand.CommandTimeout = 3600;
try { return oCommand.ExecuteNonQuery(); }
catch (Exception e) { return 0; }
}
}

///

/// Commen function shared by all the class file to execute update , delete queries
/// and return no. of rows affected, because in file we perform other operations on the base
/// of rows affected.
///

/// sqlcommand type object
///
internal static int ExecuteNonQuery_ReturnVal(SqlCommand oCommand)
{
int RowsAffected = 0;
using (SqlConnection oConn = new SqlConnection(CommonClass.getConnectionPath()))
{
if (oConn.State == ConnectionState.Closed)
{
oConn.Open();
}
oCommand.Connection = oConn;
oCommand.CommandType = CommandType.StoredProcedure;
oCommand.CommandTimeout = 3600;
try
{
RowsAffected = oCommand.ExecuteNonQuery();
return RowsAffected;
}
catch (Exception e)
{
return RowsAffected;

}
}
return RowsAffected;
}
}
}

COMMON CLASS

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
//--
using System.Data.SqlClient;

///

/// Summary description for CommonClass
///

///
namespace BusinessLogic
{
public class CommonClass
{
public CommonClass()
{
//
// TODO: Add constructor logic here
//
}

public static string getConnectionPath()
{
return ConfigurationManager.ConnectionStrings["connStr"].ConnectionString.ToString();
}

public static string Trim( TextBox tb)
{
return tb.Text.Trim();

}

public static void AddParameter(SqlCommand cmd, string parmName, string value)
{
parmName = "@" + parmName.Trim();
cmd.Parameters.AddWithValue(parmName, value);
}

///

/// This function used for bind GridView with dataset.
///

///
///
///
public static int Bind(DataSet dst, GridView gv)
{
try
{
if (dst.Tables[0].Rows.Count > 0)
{
gv.DataSource = dst;
gv.DataBind();
return 1;
}
else
{
return 2;
}
}
catch
{
return 0;/// Error

}

}

public static string StyleforSelectedRow()
{
return "this.originalstyle=this.style.backgroundColor;this.style.backgroundColor='#add8e6'";
}

///

/// Function is used for insert - between strings etc phone number
///

///
///
///
public static string PhoneString(string str, int len)
{
string retString = string.Empty;;
if (str.Length == len)
{
retString ="("+ str.Substring(0, 3) +") "+ str.Substring(3, 3) +"-"+ str.Substring(6, 4);
return retString;
}
return str;
}
///

/// This function break the email from @ when lenthh is > 25
///

public static string EMailBreak(string str, int len)
{
string retString = string.Empty; ;
if ((str.Length > len) && ( str.Contains("@")))
{

retString = str.Replace("@", "
@");
return retString;
}
return str;
}

}
}

APPLICATION PATH TO FIND WHERE APPLICATION

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
//--
using System.Data.SqlClient;

///

/// Summary description for CommonClass
///

/// This function used for bind GridView with dataset.
///

/// Function is used for insert - between strings etc phone number
///

/// This function break the email from @ when lenthh is > 25
///

user to select value from dropdown list

2009-05-01T05:48:00.000-07:00

For validating user selection in dropdownlist we can use rangevalidator. and values of drop down must be in integer type.
syntax is follows :-
[asp:RangeValidator ID="RVddRegistrationType" runat="server" ControlToValidate="ddRegistrationType" ErrorMessage="Select registration type" Display="None"
MaximumValue="100" MinimumValue="1" Type="Integer"][/asp:RangeValidator]

Thanks
Helpondesk Team

how to download the images / pdf / text files from a directroy.

2009-04-18T03:06:00.000-07:00

how to download the images / pdf / text files from a directroy.

There is one simple solution to set the path of that file with hyperlink button and when user right click the file button it will show option for download. what you think that it is correct. No.

so we have to get some steps

using directoryinfo class read all the files from dwonload directroy. and create a anchor tag redirecting on dowloadin page.

On Downlaoding page.

get the file name from url of page and

using FileStream class streamed out that file.
and that streamed file passed as constructor of binary reader class
and get the downlaod of server file.

Benifit :- this approch we can hide the orignal location of files.

code is following :-

On free download page.
// using System.IO;
DirectoryInfo di = new DirectoryInfo(Server.MapPath("~/images"));
int i = 0;
foreach (FileInfo fi in di.GetFiles())
{
HyperLink HL = new HyperLink();
HL.ID = "HyperLink" + i++;
HL.Text = fi.Name;
HL.NavigateUrl = "downloading.aspx?file=" + fi.Name;
Page.Controls.Add(HL);
Page.Controls.Add(new LiteralControl("<br/>"));
}

On freedownlaoding page
protected void Page_Load(object sender, EventArgs e)
{
string filename = Request["file"].ToString();
fileDownload(filename, Server.MapPath("~/images/"+filename));

}

private void fileDownload(string fileName, string fileUrl)
{
Response.Clear();
bool success = ResponseFile(Page.Request, Page.Response, fileName, fileUrl, 1024000);
if (!success)
Response.Write("Downloading Error!");
Response.End();
}

public bool ResponseFile(HttpRequest _Request, HttpResponse _Response, string _fileName, string _fullUrl, long _speed)
{
try
{
FileStream myFile = new FileStream(_fullUrl, FileMode.Open, FileAccess.Read, FileShare.ReadWrite);
BinaryReader br = new BinaryReader(myFile);
try
{
_Response.AddHeader("Accept-Ranges", "bytes");
_Response.Buffer = false;
long fileLength = myFile.Length;
long startBytes = 0;
int pack = 10240; //10K bytes
int sleep = (int)Math.Floor((double)(1000 * pack / _speed)) + 1;
if (_Request.Headers["Range"] != null)
{
_Response.StatusCode = 206;
string[] range = _Request.Headers["Range"].Split(new char[] { '=', '-' });
startBytes = Convert.ToInt64(range[1]);
}
_Response.AddHeader("Content-Length", (fileLength - startBytes).ToString());
if (startBytes != 0)
{
_Response.AddHeader("Content-Range", string.Format(" bytes {0}-{1}/{2}", startBytes, fileLength - 1, fileLength));
}
_Response.AddHeader("Connection", "Keep-Alive");
_Response.ContentType = "application/octet-stream";
_Response.AddHeader("Content-Disposition", "attachment;filename="
+ HttpUtility.UrlEncode(_fileName, System.Text.Encoding.UTF8));
br.BaseStream.Seek(startBytes, SeekOrigin.Begin);
int maxCount = (int)Math.Floor((double)((fileLength - startBytes) / pack)) + 1;
for (int i = 0; i <>
{
if (_Response.IsClientConnected)
{
_Response.BinaryWrite(br.ReadBytes(pack));
Thread.Sleep(sleep);
}
else
{
i = maxCount;
}
}
}
catch
{
return false;
}
finally
{
br.Close();
myFile.Close();
}
}
catch
{
return false;
}
return true;
}

Thanks
Helpondesk Team

findout howmany users are currently online

2009-04-15T06:23:00.000-07:00

Step 1 - > Create a class
namespace Utility
{
public class WebsiteVisitor
{
private string sessionId;
public string SessionId
{
get { return sessionId; }
set { sessionId = value; }
}
public string IpAddress
{
get { return ipAddress; }
set { ipAddress = value; }
}
private string ipAddress;
public string UrlReferrer
{
get { return urlReferrer; }
set { urlReferrer = value; }
}
private string urlReferrer;
public string EnterUrl
{
get { return enterUrl; }
set { enterUrl = value; }
}
private string enterUrl;
public string UserAgent
{
get { return userAgent; }
set { userAgent = value; }
}
private string userAgent;
public DateTime SessionStarted
{
get { return sessionStarted; }
set { sessionStarted = value; }
}
private DateTime sessionStarted;
public WebsiteVisitor(HttpContext context)
{
if ((context != null) && (context.Request != null) && (context.Session != null))
{
this.sessionId = context.Session.SessionID;
sessionStarted = DateTime.Now;
userAgent = string.IsNullOrEmpty(context.Request.UserAgent) ? "" : context.Request.UserAgent;
ipAddress = context.Request.UserHostAddress;
if (context.Request.UrlReferrer != null)
{
urlReferrer = string.IsNullOrEmpty(context.Request.UrlReferrer.OriginalString) ? "" : context.Request.UrlReferrer.OriginalString;
}
enterUrl = string.IsNullOrEmpty(context.Request.Url.OriginalString) ? "" : context.Request.Url.OriginalString;
}
}
}
public static class OnlineVisitorsContainer
{
public static Dictionary[string, WebsiteVisitor] Visitors = new Dictionary[string, WebsiteVisitor]();
}
}
Step 2- >
Add Global.aspx file in porject and use following name spaces
[%@ Import Namespace="System.Collections.Generic" %]
[%@ Import Namespace="Utility" %]
Use session start and session end event for global.aspx page
void Session_Start(object sender, EventArgs e)
{
Session["Start"] = DateTime.Now;
HttpContext currentContext = HttpContext.Current;
if (currentContext != null)
{
if (!OnlineVisitorsContainer.Visitors.ContainsKey(currentContext.Session.SessionID))
{
WebsiteVisitor currentVisitor = new WebsiteVisitor(currentContext);
OnlineVisitorsContainer.Visitors.Add(currentVisitor.SessionId, currentVisitor);
}
}
}
void Session_End(object sender, EventArgs e)
{
if (this.Session != null)
{
OnlineVisitorsContainer.Visitors.Remove(this.Session.SessionID);
}
}
Step 3 ->
One Third step we are able to show user informarmations
[asp:GridView ID="gvVisitors" runat="server" AutoGenerateColumns="False"
CellPadding="2" ForeColor="#333333" GridLines="Both" ]
[FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" /]
[RowStyle BackColor="#EFF3FB" /]
[Columns]
[asp:TemplateField HeaderText="Session Started"]
[ItemTemplate]
[%# ((DateTime)Eval("SessionStarted")).ToString("dd/MM/yyyy HH:mm:ss") %][br /]
[/ItemTemplate]
[/asp:TemplateField]
[asp:TemplateField HeaderText="Ip"]
[ItemTemplate]
[%# Eval("IpAddress") %]
[/ItemTemplate]
[/asp:TemplateField]
[asp:TemplateField HeaderText="Other"]
[ItemTemplate]
[span style="font-size:small;"]
[%# Eval("UserAgent") %][br /]
[%# Eval("EnterUrl") %][br /]
[/span]
[asp:HyperLink ID="refurl" Text='[%# Eval("UrlReferrer") %]' Font-Size="Small"
NavigateUrl='[%# Eval("UrlReferrer") %]' runat="server" Target="_blank" /]
[/ItemTemplate]
[/asp:TemplateField]
[/Columns]
[PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" /]
[SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" /]
[HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" /]
[EditRowStyle BackColor="#2461BF" /]
[AlternatingRowStyle BackColor="White" /]
[/asp:GridView]
Add name space on page
using Utility
if (!Page.IsPostBack)
{
if (OnlineVisitorsContainer.Visitors != null)
{
gvVisitors.DataSource = OnlineVisitorsContainer.Visitors.Values;
gvVisitors.DataBind();
}
}
Thanks
HelponDesk Team

How to wath howmany users currently on our site

2009-04-15T05:12:00.000-07:00

How to find a page control in usercontrol?

2009-04-13T03:01:00.000-07:00

Write down the following code snipps for find the control of page
in user control.

TextBox tb = new TextBox();
tb = (TextBox) this.Parent.FindControl("tb1");
tb.Text = "I m in user control 1";

Thanks
Helpondesk Team

How to use regular expression in javaScript

2009-04-06T09:47:00.000-07:00

Hi,
Today i got a problem to validate user validation on html form.
i m strange when i face difficulty on use Regular Expression. but i got the solution
from www.javascriptkit.com/ here i explained a validation with regular expression

there are two important thing pack the validation between two forward slash.
and on the value of text box use .search(regexp) . if it is -1 that mean match is fail

[script language="JavaScript1.2"]
function checkUSPhoneFormat()
{
var USPhoneFormat=/(($\d{3}$ ?)|(\d{3}-))?\d{3}-\d{4}/ //regular expression defining a US format number
if (document.myform.myinput.value.search(USPhoneFormat)==-1) //if match failed
alert("Please enter a valid format")
}
[/script]

[form name="myform"]
[input type="text" name="myinput" size=15]
[input type="button" onClick="checkUSPhoneFormat()" value="check"]

[/form]

Thanks
HelpOnDesk

How to load css and javascript file runtime

2009-04-06T07:36:00.000-07:00

Hi
In following function we demostrate that how to load css and javascirpt at runtime.

function loadjscssfile(filename, filetype){
if (filetype=="js"){ //if filename is a external JavaScript file
var fileref=document.createElement('script')
fileref.setAttribute("type","text/javascript")
fileref.setAttribute("src", filename)
}
else if (filetype=="css"){ //if filename is an external CSS file
var fileref=document.createElement("link")
fileref.setAttribute("rel", "stylesheet")
fileref.setAttribute("type", "text/css")
fileref.setAttribute("href", filename)
}
if (typeof fileref!="undefined")
document.getElementsByTagName("head")[0].appendChild(fileref)
}

loadjscssfile("myscript.js", "js") //dynamically load and add this .js file
loadjscssfile("javascript.php", "js") //dynamically load "javascript.php" as a JavaScript file
loadjscssfile("mystyle.css", "css") ////dynamically load and add this .css file

myscript.js" source:

var petname="Spotty"
alert("Pet Name: " + petname)

"mystyle.css" source:

#demotable td{
background-color: lightyellow;
}

#demotable b{
color: blue;
}

This code is taken from

http://javascriptkit.com/cutpastejava.shtml

Thanks
Help on desk

Typed DataSet

2009-04-03T10:19:00.000-07:00

Typed DataSet :-
Typed DataSets have all the functionality of DataSets, Typed DataSets directly inherit from the

DataSet classes. Some additional code generated by .NET Framework tools gives all the additional benefits of

Typed DataSets. Furthermore, you can access table and columns by name instead of having to use collection-based

methods with DataSets

-> Typed DataSets check types at compile time it also konwn as This is known as type-safe access
-> automatically complete lines while typing rather the describe each time column name.
Hi how to use Typed Data set
/ * 1-> add new item set dataset. give a name to it delete which coneection is provide by default with it.
* 2-> right click on dataset and add a new table.
* 3-> right click on table and add column which will filled by code.
* 4-> code snipp is bellow.
* note the column name of select command and dataset.xss shuld be same
*/
SqlConnection cn = new SqlConnection(@"Data Source=xxxxxx\VER2005;Initial Catalog=PUBS;Persist Security Info=True;User ID=xxx;Password=xxxx");
SqlCommand cmd = new SqlCommand("SELECT bookRecord.* FROM bookRecord", cn); SqlDataAdapter da = new SqlDataAdapter(cmd);
dsProducts tds = new dsProducts();
da.Fill(tds, tds.Tables[0].TableName);
foreach (DataRow oOrderRow in tds.DataTable1.Rows )
{ Response.Write ("BookID = " + oOrderRow["bookid"].ToString()); }
string ss = tds.DataTable1.Rows[0]["bookid"].ToString();
string ss2 = t ds.DataTable1.Rows[1]["bookid"].ToString();

Thanks
HelpOnDesck Team

how to set default button dynamically in page.

2009-04-03T04:45:00.000-07:00

There are many way to sortout this problem.
like wrapup each seprate panel and set the defaultbutton property on panel.or set the WebForm_FireDefaultButton onclick event of text box.But i like mostand prefer to keep this in practice is call javaScript function of for setdefault button this is aplicabe on firefox,IE,Safari id did not tyr it for netscape but i belive it will run. this function is
function clickButton(e, buttonid)
{ var evt = e ? e : window.event;
var bt = document.getElementById(buttonid);
if (bt)
{
if (evt.keyCode == 13)
{
bt.click();
return false;
}
}
}
we can implement it as follws
TextBox1.Attributes.Add("onkeypress", "return clickButton(event,'" + Button2.ClientID + "')"); TextBox2.Attributes.Add("onkeypress", "return clickButton(event,'" + Button3.ClientID + "')"); TextBox3.Attributes.Add("onkeypress", "return clickButton(event,'" + Button4.ClientID + "')"); TextBox4.Attributes.Add("onkeypress", "return clickButton(event,'" + Button5.ClientID + "')");

Thanks
HelponDesk Team

How to change css dynamicaly without using javaScript

2009-04-02T16:10:00.000-07:00

How to change css dynamicaly without using javaScript

[html]
[head]
[title]Change CSS Class[/title]
[style type="text/css"]
.ClassOut
{
background-color: black;
color: white;
font-weight: bold;
}

.ClassOver
{
background-color: white;
color: black;
font-weight: bold;
border: 1px solid black;
}
[/style]
[/head]
[body]
[p class="ClassOut" onmouseover="this.className='ClassOver';"
onmouseout="this.className='ClassOut';"]
Hi, I am a paragraph with text. If you hover your mouse
over me, my color changes . This is done by setting the
className CSS property.
[/p]
[/body]
[/html]

Thanks
HeelpOnDesk Team

How to create a table with fixed header

2009-04-02T16:04:00.000-07:00

How to create a table with fixed header

[table style="width: 300px" cellpadding="0" cellspacing="0"]
[tr]
[td]Column 1[/td]
[td]Column 2[/td]
[/tr]
[/table]

[div style="overflow: auto;height: 100px; width: 320px;"]
[table style="width: 300px;" cellpadding="0" cellspacing="0"]
[tr]
[td]Value 1[/td]
[td]Value 2[/td]
[/tr]
[tr]
[td]Value 1[/td]
[td]Value 2[/td]
[/tr]
[tr]
[td]Value 1[/td]
[td]Value 2[/td]
[/tr]
[tr]
[td]Value 1[/td]
[td]Value 2[/td]
[/tr]
[tr]
[td]Value 1[/td]
[td]Value 2[/td]
[/tr]
[tr]
[td]Value 1[/td]
[td]Value 2[/td]
[/tr]
[/table]
[/div]

Thanks
Helpondesk team

How to Embed Video Player in ASPX page

2009-04-02T15:55:00.000-07:00

we can very easily embed the media player on web page
sample code is follows
I read it form following link

http://alistapart.com/articles/byebyeembed

[object type="video/x-ms-wmv"
data="movie.wmv" width="320" height="260"]
[param name="src" value="movie.wmv" /]
[param name="autostart" value="true" /]
[param name="controller" value="true" /]
[/object]

Thanks

Publish Post

HelpOnDesk Team

sending email with attachment using Attachment Class

2009-04-02T14:04:00.000-07:00

For sending email with attachment we usally upload file on server and after sending the email delete it from sever. but .net 2.0 interdues new class Attachment which provide us a eazy way with IO.Stream and filename. this class has a constructor that allows you to pass an IO.Stream and a file name. Conveniently, the FileUpload control has a FileContent property that returns the uploaded file as an IO.Stream. All that's left to do is to

get the file name from the uploaded file using Path.GetFileName and you're good to go.

private void functionSendMailWithAttachment(FileUpload FileUpload1)
{

if (FileUpload1.HasFile)
{
string toAddress = "reciver@gmail.com";
string fromAddress = "admin@helpondesk.com";
string mailServer = "smtp.server.com";

MailMessage myMailMessage = new MailMessage();

myMailMessage.To.Add(toAddress);
myMailMessage.From = new MailAddress(fromAddress);
myMailMessage.Subject = "Never :) ";

string fileName = FileUpload1.PostedFile.FileName;
Attachment myAttachment = new Attachment(FileUpload1.FileContent, fileName);
myMailMessage.Attachments.Add(myAttachment);

SmtpClient mySmtpClient = new SmtpClient(mailServer);
//if you want to send mail from local host.
/// SmtpClient smtpClientho = new SmtpClient("localhost");

mySmtpClient.Send(myMailMessage);
}

}

Add fileupload control on aspx page.

[asp:FileUpload ID="FileUpload1" runat="server" /]

namespace
using System.Net.Mail;

Thanks
Helpondesk Team

Cursor for get all the table name in database

2009-03-27T06:24:00.000-07:00

This cursor is used for get all the table name form database.
and we can simply add the sql commands in this cursor. as
I shown in Print Statement.

Declare @t varchar (1024)
Declare tbl_cur cursor for
select TABLE_NAME from INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' order by TABLE_NAME
OPEN tbl_cur
FETCH NEXT from tbl_cur INTO @t
WHILE @@FETCH_STATUS = 0
BEGIN
-- print ('sp_rename '+ @t +','+@t+'Notused')
print ('select * from '+ @t )
print 'GO'
FETCH NEXT from tbl_cur INTO @t
END
CLOSE tbl_cur
DEALLOCATE tbl_Cur

Thanks
HELPONDESK TEAM

steps to set minimum and maxumum length of passwerd

2009-03-19T06:42:00.000-07:00

Hi
This is simple steps to set minimum and maxumum length of passwerd.

Step 1) For Req. filed

[asp:RequiredFieldValidator ID="RequiredFieldValidator2" runat="server"
ControlToValidate="txtpassword" Display="None"
ErrorMessage="Your password is a required field."][/asp:RequiredFieldValidator]

Step 2) For set Min n Max length of password.

[asp:RegularExpressionValidator ID="RegularExpressionValidator7" runat="server"
ControlToValidate="txtpassword" Display="None"
ErrorMessage="password shuld be 6-32 characters" ValidationExpression="\w{6,}"][/asp:RegularExpressionValidator]

Thanks
Helpondesk Team

funcition for calculating distacne from langitude and latetude.

2009-03-14T02:16:00.001-07:00

private double distance(double lat1, double lon1, double lat2, double lon2, string unit)
{
double totalDistance;
double theta, dist;
theta = lon1 - lon2;
dist = Math.Sin(deg2rad(lat1)) * Math.Sin(deg2rad(lat2)) + Math.Cos(deg2rad(lat1)) * Math.Cos(deg2rad(lat2)) * Math.Cos(deg2rad(theta));
dist = acos(dist);
dist = rad2deg(dist);
totalDistance = dist * 60 * 1.1515;
if (unit == "K")
{
totalDistance = totalDistance * 1.609344;
return totalDistance;
}
else if (unit == "N")
{
totalDistance = totalDistance * 0.8684;

return totalDistance;

}
else
{
return 0.00;
}

}

private double acos(double rad)
{
if (Math.Abs(rad) != 1)
{
return pi / 2 - Math.Atan(rad / Math.Sqrt(1 - rad * rad));

}
else if (rad == -1)
{
return pi;
}
else
{
return 0.00;

}

}

private double deg2rad(double Deg)
{
return Convert.ToDouble(Deg * pi / 180);
}

private double rad2deg(double Rad)
{
return Convert.ToDouble(Rad * 180 / pi);
}

Delete Duplicate Records -- Without having Primary key

2009-03-13T03:54:00.000-07:00

-----------Delete Duplicate Records ---------------------------
-------- Without having Primary key ---------------------------
CREATE TABLE [SalesHistory]
( [Product] [varchar](10) NULL,
[SaleDate] [datetime] NULL,
[SalePrice] [money] NULL )
GO
INSERT INTO SalesHistory(Product, SaleDate, SalePrice)
SELECT 'Computer','1919-03-18 00:00:00.000',1008.00
UNION ALL
SELECT 'BigScreen','1927-03-18 00:00:00.000',91.00
UNION ALL
SELECT 'PoolTable','1927-04-01 00:00:00.000',139.00
UNION ALL
SELECT 'Computer','1919-03-18 00:00:00.000',1008.00
UNION ALL
SELECT 'BigScreen','1927-03-18 00:00:00.000',91.00
UNION ALL
SELECT 'PoolTable','1927-04-01 00:00:00.000',139.00

set rowcount 1
select 'start'
while @@rowcount > 0
begin

delete a from SalesHistory a
where
(
select count(*) from saleshistory b

where a.product = b.product and a.saledate = b.saledate and a.SalePrice = b.SalePrice)>1
end

set rowcount 0

select product,saledate, SalePrice from SalesHistory

Whats new in ASP.NET 3.5

2009-03-12T02:11:00.000-07:00

Whats new in ASP.NET 3.5
Some important featues which are introduce in with framework 3.5
ASP.NET AJAX
In ASP.NET 2.0, ASP.NET AJAX was used as an extension to it. You had to download the extensions and install it. However in ASP.NET 3.5, ASP.NET AJAX is integrated into the .NET Framework, thereby making the process of building cool user interfaces easier and intuitive.
The integration between webparts and the update panel is much smoother. Another noticeable feature is that you can now add ASP.NET AJAX Control Extenders to the toolbox in VS2008. Even though this is an IDE specific feature, however I feel it deserves a mention over here for developers, who had to add extenders using source view earlier. It is also worth noting that Windows Communication Foundation (WCF) now supports JSON along with other standard protocols like SOAP, RSS and POX.
New Controls
The ListView and DataPager are new controls added along with a new datasource control called the LinqDataSource.
ListView
The ListView control is quiet flexible and contains features of the Gridview, Datagrid, Repeater and similar list controls available in ASP.NET 2.0. It provides the ability to insert, delete, page (using Data Pager), sort and edit data. However one feature of the ListView control that stands apart, is that it gives you a great amount of flexibility over the markup generated. So you have a complete control on how the data is to be displayed. You can now render your data without using thetag. You also get a rich set of templates with the ListView control.
DataPager
DataPager provides paging support to the ListView control. The best advantage is that you need not have to keep it ‘tied’ with the control on which the paging is being done. You can keep it anywhere on the page.
DataPager gives you a consistent way of paging with the controls that support it. Currently only ListView supports it as it implements the IPageableItemContainer. However support is likely to be added to other List controls as well.
LINQ
LINQ (Language Integrated Query) adds native data querying capability to C# and VB.NET along with the compiler and Intellisense support. LINQ is a component of .NET 3.5. LINQ defines operators that allow you to code your query in a consistent manner over databases, objects and XML. The ASP.NET LinqDataSource control allows you to use LINQ to filter, order and group data before binding to the List controls.
ASP.NET Merge Tool
ASP.NET 3.5 includes a new merge tool (aspnet_merge.exe). This tool lets you combine and manage assemblies created by aspnet_compiler.exe. This tool was available earlier as an add-on.
New Assemblies
The new assemblies that would be of use to ASP.NET 3.5 developers are as follows:
System.Core.dll - Includes the implementation for LINQ to Objects
System.Data.Linq.dll - Includes the implementation for LINQ to SQL
System.Xml.Linq.dll - Includes the implementation for LINQ to XML
System.Data.DataSetExtensions.dll - Includes the implementation for LINQ to DataSet
System.Web.Extensions.dll: Includes the implementation for ASP.NET AJAX (new enhancements added) and new web controls as explained earlier.
Some other important points for move to asp.net 3.5
ASP.NET 3.5 provides better support to IIS7. IIS7 and ASP.NET 3.5 modules and handlers support unified configuration.
You can have multiple versions of ASP.NET on the same machine.
For those who are wondering what happened to ASP.NET 3.0, well there isn’t anything called ASP.NET 3.0.
VS 2002 worked with ASP.NET 1.0, VS 2003 worked with ASP.NET 1.1, and VS 2005 worked with ASP.NET 2.0. However VS 2008 supports multi-targeting, i.e it works with ASP.NET 2.0, and ASP.NET 3.5.
Intellisense with javaScript for rapid developement.
Addin system p2p base class Active directory Anonymous types with static type inference Paging support for ADO.NET ADO.NET synchronization API to synchronize local caches and server side datastores Asynchronous network I/O API Support for HTTP pipelining and syndication feeds. New System.CodeDom namespace.

Useful Link

2009-02-24T13:37:00.000-08:00

You will find very UseFul Link Here http://mattberseth.com

How to Get Location Of any Control using Sys.UI.DomElement.getLocation class in Javascript

2009-02-24T11:15:00.000-08:00

Hi
Today I want to share a small but very good javascript that is used to get the Location of any control by using the Control using Sys.UI.DomElement.getLocation Class..

Step 1:)
Write the HTML of any control , here suppose we are using the Button .
< id="Btn" text ="FindLocation" onclientclick= "return findLoc(this);" runat="server">

Step 2:)

Write the javascript like below...

function findLoc(ctrlBtn)
{
var location = Sys.UI.DomElement.getLocation(ctrlBtn);
alert(location.x);
alert(location.y);
alert(ctrlBtn.offsetWidth);
alert(ctrlBtn.offsetHeight)
return false;
}

Thanks:
Sanjeev Kumar

Simple Way to Use Cascading DropdownList

2009-02-16T12:29:00.000-08:00

How to Use the Cascading Dropdown ? When You need Such type of requirment.Then Please follow the following Steps then You will find that it's very sipmle.
Step 1.) Adding Webservice to bind the Drop DownLIst
A.) Go to Website -> Add New Item ->Choose WebService ->Rename it as you want
(For Example here we have Taken the name of WebService "CascadingDataService.asmx")
B.) Write the CascadingDataService.cs code in App_Code folder as Given Below:-
using System;
using System.Web;
using System.Collections;
using System.Web.Services;
using System.Web.Services.Protocols;
using System.Data.SqlClient;
using System.Collections.Generic;
using System.Collections.Specialized;
using System.Data;
///

/// Summary description for CascadingDataService
///

[WebService(Namespace = "http://tempuri.org/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
[System.Web.Script.Services.ScriptService()]
public class CascadingDataService : System.Web.Services.WebService
{
string conString = System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ToString();
public CascadingDataService()
{
//Uncomment the following line if using designed components
//InitializeComponent();
}
[WebMethod]
public AjaxControlToolkit.CascadingDropDownNameValue[] GetDropDownCountries(string knownCategoryValues, string category)
{
SqlConnection sqlConn = new SqlConnection(conString);
sqlConn.Open();
SqlCommand sqlSelect = new SqlCommand("select * from country order by rowid ", sqlConn);
sqlSelect.CommandType = System.Data.CommandType.Text;
SqlDataAdapter sqlAdapter = new SqlDataAdapter(sqlSelect);
DataSet myDataset = new DataSet();
sqlAdapter.Fill(myDataset);
sqlConn.Close();
List cascadingValues = new List();
foreach (DataRow dRow in myDataset.Tables[0].Rows)
{
string categoryID = dRow["ID"].ToString();
string categoryName = dRow["CountryName"].ToString();
cascadingValues.Add(new AjaxControlToolkit.CascadingDropDownNameValue(categoryName, categoryID));
}
return cascadingValues.ToArray();
}
[WebMethod]
public AjaxControlToolkit.CascadingDropDownNameValue[] GetDropDownStates(string knownCategoryValues, string category)
{
int categoryID;
StringDictionary categoryValues = AjaxControlToolkit.CascadingDropDown.ParseKnownCategoryValuesString(knownCategoryValues);
categoryID = Convert.ToInt32(categoryValues["category"]);
SqlConnection sqlConn = new SqlConnection(conString);
sqlConn.Open();
SqlCommand sqlSelect = new SqlCommand("select * from state where CountryID = @categoryID", sqlConn);
sqlSelect.CommandType = System.Data.CommandType.Text;
sqlSelect.Parameters.Add("@categoryID", SqlDbType.Int).Value = categoryID;
SqlDataAdapter sqlAdapter = new SqlDataAdapter(sqlSelect);
DataSet myDataset = new DataSet();
sqlAdapter.Fill(myDataset);
sqlConn.Close();
List cascadingValues = new List();
foreach (DataRow dRow in myDataset.Tables[0].Rows)
{
string SubcategoryID = dRow["Id"].ToString();
string SubcategoryName = dRow["StateName"].ToString();
cascadingValues.Add(new AjaxControlToolkit.CascadingDropDownNameValue(SubcategoryName, SubcategoryID));
}
return cascadingValues.ToArray();
}
}

Step 2.) HTML page where we want to use the Cascading DropDown List :

Country : < id="ddlCountry" runat="server">
< id="CascadingDropDown1" runat="server" category="category" targetcontrolid="ddlCountry" prompttext="--Select Country--" loadingtext="Loading countries..." servicepath="CascadingDataService.asmx" servicemethod="GetDropDownCountries"> < /ajaxToolkit:CascadingDropDown >
State : < id="ddlState" runat="server">
< id="CascadingDropDown2" runat="server" category="subcategory" targetcontrolid="ddlState" parentcontrolid="ddlCountry" prompttext="--Select State--" loadingtext="Loading states..." servicepath="CascadingDataService.asmx" servicemethod="GetDropDownProducts">
< /ajaxToolkit:CascadingDropDown >

By following the Steps described above can make easy to use the Cascading DropDown List.

Thanks:
Sanjeev Kumar

popup window which Show on full screen regardless of system resulation

2009-02-10T06:16:00.000-08:00

Hi
Today we have to open a popup window which will show on fulll screen. and we can not set the resolution for it b'cz diff sys may have diff resolution we use screen.avilwidth and height peroperty) more detais are bellow :-

window.open("Default5.aspx",null,"fullscreen=yes,status=yes,toolbar=no,menuba
r=no,location=no");
window.resizeTo(screen.availWidth,screen.availHeight);testwindow.moveTo(0,0);//The code positions the popup on the top left corner
of the screen.

// fullscreen=yes it will show as window like when we press F11 button
Some genral features of popup window is shows in following ttable :-
status The status bar at the bottom of the window. toolbar The standard browser toolbar, with buttons such as Back and Forward. location The Location entry field where you enter the URL. menubar The menu bar of the window directories The standard browser directory buttons, such as What's New and
What's Cool resizable Allow/Disallow the user to resize the window. scrollbars Enable the scrollbars if the document is bigger than the window height Specifies the height of the window in pixels. (example: height='350') width Specifies the width of the window in pixels.

Thanks

Mahesh K. Sharma

Fire Item Command on DataList when CheckBox is Clicked

2009-02-06T08:05:00.001-08:00

Hi
Today i am wondering to get a problem, when i fired a checkbox (postback enabled) will not wire up the item command on data list. and when i replace checkbox with button it works. 0) then i got a wise solution that keep a button in datalist and explicty genrate its click event when check box is clicked. for this i put code in item databound event of datalist.

// Find controls : -
CheckBox chk1 = (CheckBox)(e.Item.FindControl("chk1"));
Button Button1 = (Button)(e.Item.FindControl("Button1"));
// Add javasCript on onClick event to check box which call click evetnt of button. and after it
// Item command will fire

chk1.Attributes.Add("OnClick",
"javascript:document.getElementById('" + Button1.ClientID + "').click()");

Thansk
HelpOnDesk Team

javascript function for generate unique random number

2009-02-04T07:17:00.000-08:00

I created a javascript function for generate unique random number. for this function i take object of date and call funciton of getTime() which return milliseconds since 970/01/01 and i also add some random numeric value between 0 to 999 from make it Random.

code snips is as

[script language="javascript"]

function UniqRanDomNumber()

{

var d = new Date();

var randomnumber = Math.floor(Math.random()*1001);

var randomnumber = d.getTime() + randomnumber;

//alert(randomnumber.toString().length);

//alert(randomnumber.toString().substring(6,13)); // If we want to remove right side number whihc are prefixed

document.getElementById("lbl").innerHTML = randomnumber;

return false;

}

[/script]

lbl is id of label where we want to show the uniq random nubmer.

Thanks
HelpOnDesk Team

Genrate non Repetitive Random Number.

2009-02-03T13:24:00.000-08:00

HI,
Today I have to generate Non Repetitive random number. means a number may me 1234 but not 1224 means no same digit repeat on same number.

javascritp function is as follows :_

function generateRandomNumber(n)
{

if( n > 10)
{
alert('Please Enter 2 to 10');
return false;
}
var randomNo;
var finalArray=new Array();
while(finalArray.length < n)
{
randomNo = Math.floor(Math.random()*10);
if(finalArray.join('').indexOf(randomNo,0) == -1)
{
finalArray[finalArray.length] = randomNo;
}
}
document.getElementById("lbl").innerHTML = finalArray.join('');
return false;
}

Where lbl is id of label where we have to show the random number.

Thanks
Help OnDesk Team

Non Re

2009-02-03T13:23:00.001-08:00

Some Important Interview Questions..

2009-02-03T08:56:00.000-08:00

Hi ..

After a long long time I am here to post some interview questions on ASP.NET,
I hope that it will help you,

What is framework.
what is CLR? When its role comes?
What is connection pooling and object pooling? Difference
what is Authentication & authorization? types of authentication
what is customerror tag in web.config, its use
what is value type & ref type & where they are store.
what is assesmbly? types...
types of data control.
diff between server.transfer, server.execute & response.redirect
what is session management & types and diff?
how many column in datagrid and what r?
diff between datagrid, datalist, repeator ?
what are events of datagrid and sequence of execution?
what is Exception handling?
what is dataset, datareader, diff?
how many tables can be in dataset?
how to create COM+ in .net?
How to use com component in .net?
What is diff between metadata and menifest
What is http Handler?
What is serialization and its type?
What is uddi , soap , wsdl
What are the files required for deployment of the website?
what are different ways of debugging?
How can we debug an application if we do not have visual studio?
diff between web control , user control and custom control?
When to use remoting and when to use web service?
difference between interface and abstract classes?
From which class thus the web form is derived and what is its
heriarchy?
What is appsettings in web.config?
How we can use the com components in teh asp.net?
What is difference between UDF and stored procedures?
How we get values from stored procedure in asp.net code?
What is the purpose of abstract class?
What is diff between remoting and web service?
How many types of join are there in sql server?
What are different ways of authentication in .Net?
How the sessions are mantained in asp.net?
How we can transfer application from asp to asp.net?
what to do if i want that Class a can not be inherited?

1) What are ISAPI Filters?
2) What is process model in machine.config file?
3) Difference between inetinfo,aspnet_isapi.dll,aspnet_wp.
4) What are Composite controls in .Net ? How do u create them?
5) How can .Net assemblies be decompiled? What are the possible ways to prevent it?
6) Permission Settings in .Net
7) Difference between Http handlers & Http Modules.
8) Custom Configuration section of Web.Config?
9 Explain .Net remoting & its various communication channels
10) What are service oriented components?
11) Explain Serialization & various serialization formatters in .net
12) What is Event Bubbling?
13) How we can use the com components in the asp.net?

What is view state, session object ,cache object ,application object.
What is scope of view state, session object ,cache object ,application object.
Difference between cache object and application object.
Difference between interface and abstract class
What is data relation and write code that
What is trigger and types
Write code for abstract class, interface and define property in interface
Write query for second highest salary
If I use view state and go to second page and redirect to first page then view state maintain or not
On datagrid if I place button then what events will fire
If place datagrid inside another datagrid then what events will fire

Thank Guyes
HelpOnDesk Team

Calculate shipping charge with pay pal

2009-02-02T06:35:00.000-08:00

Calculate shipping charge with pay pal

1) With Buy Now button
In this button we can add shipping cost with hidden filed named as shipping and set value of shipping cost. So is is fixed for that item. Sample code for this

[form id="Form2" action="https://www.sandbox.paypal.com/cgi-bin/webscr" method="post"]

[input type="hidden" name="cmd" value="_ext-enter"]
[input type="hidden" name="redirect_cmd" value="_xclick"]
[input type="hidden" name="business" value="mca.mk_1233320111_biz@gmail.com"]
[input type="hidden" name="item_name" value="T-Shirt"]
[input type="hidden" name="amount" value="75.00"]

[input type="hidden" name="shipping" value="15.00"]

[input type="hidden" name="currency_code" value="USD"]
[input type="hidden" name="return" value="http://localhost/HTMLPAYPAL/Default2.aspx"]
[input type="hidden" name="cancel_return" value="http://localhost/HTMLPAYPAL/Default.aspx"]

[input type="submit" value="Buy Now" ]

[/form]

2) Two or more itmes clubed in on buy now button
In this button we add two different items under one click of buttons and set different different values of amount and shipping cost
using hidden value of shipping_x. means shipping_1 for first item and shipping_2 for second item and so on.

Sample code fro this is as follows :-

[form action="https://www.sandbox.paypal.com/cgi-bin/webscr" method="post"]
[input type="hidden" name="cmd" value="_cart"]
[input type="hidden" name="upload" value="1"]
[input type="hidden" name="business" value="mca.mk_1233244379_biz@gmail.com"]
[input type="hidden" name="item_name_1" value="Pink glaf 1"]
[input type="hidden" name="amount_1" value="1.00"]
[input type="hidden" name="shipping_1" value="5.00" ]

[input type="hidden" name="item_name_2" value="IGreen glaf 2"]
[input type="hidden" name="amount_2" value="2.00"]
[input type="hidden" name="shipping_2" value="3.00" ]
[input type="submit" value="PayNow"]
[/form]

3) With Add to Cart button
In this button we add items in paypal shopping cart the shipment cost will override from value of shipping hiddn filed but when we increase quantity in cart and click on update button on paypal shopping the shipping cost will increase from the value of hidden fleld shipping2.

Sample code for this is as follows :-

[form target="paypal" action="https://www.sandbox.paypal.com/cgi-bin/webscr" method="post"]
[input type="hidden" name="cmd" value="_cart"]
[input type="hidden" name="business" value="mca.mk_1233320111_biz@gmail.com"]
[input type="hidden" name="item_name" value="woolen Cap 1"]
[input type="hidden" name="item_number" value="WC1"]
[input type="hidden" name="currency_code" value="USD"]
[input type="hidden" name="amount" value="9.00"]

[input type="hidden" name="shipping" value="2.00"]
[input type="hidden" name="shipping2" value="1.00"]

[input type="hidden" name="return" value="http://localhost/HTMLPAYPAL/Default2.aspx"]
[input type="hidden" name="cancel_return" value="http://localhost/HTMLPAYPAL/Default.aspx"]

[input type="image" src="https://www.paypal.com/en_US/i/btn/x-click-but22.gif" border="0" name="submit" alt="Make payments with PayPal - it's fast, free and secure!"]
[input type="hidden" name="add" value="1"]
[/form]

if we [input type="hidden" name="shipping2" value="1.00"] set value of sipping2 is 0.00 then shipping cost will not increase for each additional item .

Thanks
HelpOnDesk Team

How to Integrate paypal with HTML

2009-01-30T01:19:00.000-08:00

How to Integrate paypal with HTML

Paypal is very common payment gate way and mostly used in HTML ,PHP,.NET web sites for sub mit payment to vendor.

Now I am explain steps of integrating in Paypal in our application.

Suppose we have a page where we set the item and price and other inforamation in html hidden fields.
General structure of page is as follows.

[form id="Form1" action="https://www.sandbox.paypal.com/cgi-bin/webscr" method="post"]
[input type="hidden" name="cmd" value="_xclick"] [input type="hidden" name="business" value="mca.mk_1233244379_biz@gmail.com"]
[input type="hidden" name="item_name" value="Item1"]
[input type="hidden" name="amount" value="100.00"]
[input type="hidden" name="currency_code" value="USD"]
[input type="hidden" name="return" value="http://localhost/eStoreFrontCS/Default2.aspx"]
[input type="hidden" name="cancel_return" value="http://localhost/eStoreFrontCS/Default.aspx"]
[asp:Label id="Label2" style="Z-INDEX: 101; LEFT: 784px; POSITION: absolute; TOP: 8px" runat="server"
ForeColor="White" BackColor="#C04000" Font-Bold="True" Width="20045px"]Loading payment process.....[/asp:Label]
[asp:Label id="Label3" style="Z-INDEX: 102; LEFT: 16px; POSITION: absolute; TOP: 8px" runat="server"
Font-Bold="True"]Wait ...[/asp:Label]
[/form]

In action tag we give the url of sandbox. This is starting step with paypal. Open the paypal.com

1)https://developer.paypal.com/ -] Signup now
2)after it you will recive a message “ Sandbox Signup Complete”
3)Check Email account which u specify in signup process. And click link for confermation.
4)Open paypal site with given link.
5)Choose option “Create a preconfigured buyer or seller account.” under TEST ACCOUNT tab.
6)Create a Buyer Account (Use to represent your customer's experience) must open “ Show Advanced Options “ link and give starting balance amout as 5000 USD or as your requirement. In Add note section copypaste the password so u can check it any time in test account secton.
7)Create a Seller Account (Use to represent yourself as the merchant) and also provide sum banalce under “ Show Advanced Options “ In Add note section copypaste the password so u can check it any time in test account secton.
8)Now the work with paypal site is over. Now come on your HTML page. And copy paste all code under form tag.
9)And after it put this script which submit page when it will load
10)[script language="JavaScript"]Form1.submit()[/script]
11) and now this will redirect u on this link https://www.sandbox.paypal.com/us/cgi-bin/webscr? With querystring.
12)Now in “ LOG IN TO PAYPAL “ frame put details of Buyer Account which u created for above code the details ar e as follows mca.mk_1233244323_per@gmail.com / pwd is testpwdtestpwd
13)enter pwd testpwdtestpwd
14) now confermation screen will come
15) Click on pay now button. And u wil get thanks msg window.
16)Now we have to check the effects on murchent and buyer account. So opent sandbox account.
17) Buyer account is debit form 100 USD
18)And murchant account is Credit by 96.8 USD.
Hope with above steps u can get basic idea of paypal account.

Thanks
HelpOnDesk Team

Retrive CSV from DATABASE

2009-01-09T06:25:00.000-08:00

HI
Aprox in every project we need to send mail to all registred user then we can retrive emailAddress
in CSV format and form frontend we can fetch all values from for loop and send these emails to user
in single database cycle.

Basic example of this type SP is as follows :-

create proc SelectEmailAddressInCSV
as
set nocount on
DECLARE @xyz VARCHAR(100)
declare @abc varchar(100)

set @abc=''

declare selemail cursor for

select email from dataadi

open selemail
fetch NEXT from selemail into @xyz
WHILE @@Fetch_status = 0
begin

set @abc= @abc+ @xyz+','

FETCH NEXT FROM selemail INTO @xyz
END
print @abc
CLOSE selemail
DEALLOCATE selemail

Table of dataadi is as follows

CREATE TABLE [dbo].[dataadi](
[ID] [int] NOT NULL,
[FirstName] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[LastName] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Email] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
CONSTRAINT [PK_dataadi] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

So Run this script and modified as your need

simppily we can add these three lines

DECLARE @values varchar(150), @delimiter char
SET @delimiter = ','
SELECT @values = COALESCE(@values + @delimiter, '') + u_name FROM tblsplit
SELECT @values AS [List of Emails]

Thanks
HelpOnDesk Team

Template for SP geting values one by one from CSV (Comma Seprated Values)

2009-01-09T05:58:00.000-08:00

HI,
Many time we need to update many records in database. for example if we using select all check boxes for delete or update the reocrds then we can save the selected id corespondit to selected check boxes and then pass all vlues in dataset as the form of CSV and the with the help of following SP we can get values one by one and
fire the query.
Template for SP to get values one by one from CSV. suppy two inputs first the csv and then charter which i used for seprate the values

create proc [ufn_CountChar] ( @pInput VARCHAR(1000), @pSearchChar CHAR(1) )
as
BEGIN

/*DECLARE @vInputLength INT*/
DECLARE @vIndex INT
DECLARE @vCount INT
DECLARE @s varchar(2)
DECLARE @str varchar(10)
declare @SubStr varchar(1000)

set @SubStr=''
SET @vCount = 0
SET @vIndex = 1
/*SET @vInputLength = LEN(@pInput)*/
set @str=''

WHILE @vIndex <= len(@pInput)
BEGIN
IF SUBSTRING(@pInput, @vIndex, 1) = @pSearchChar
BEGIN
SET @vCount = @vCount + 1
set @SubStr = substring(@pInput,len(@SubStr),len( @str))
select 'update insert delete query with this value - ' + @str
set @str=''
END
else
BEGIN
set @s=SUBSTRING(@pInput,@vindex,1)
set @str=@str+@s
print ' i m in else part'+ space(3)+ @str
if( @vIndex = len(@pInput))
begin
select 'update insert delete query with this value - ' + @str
end

END
SET @vIndex = @vIndex + 1

END

--select @str

END
GO

--ufn_CountChar 'afd,hghg,hgjgh',','

uplaoding an image and creating Thumbnail of same image according to heigth and width

2009-01-09T05:50:00.001-08:00

Hi
in this article we create a class for uplaoding an image and creating
Thumbnail of same image according to heigth and width of orignal image
means if we uplaod a landscapte image then its thumbnail will genrate as
landscape if image is as potrate its thumbnail will genrate as portrare.

call this function

thumbnail oANB = new thumbnail();
oANB.CreateThumb(FileUpload1, @"Images\", @"Images\Thumbnail\");
oANB.CreateThumb(FileUpload1, @"Images\");

create a class with following code.

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Diagnostics;
using Microsoft.Win32;
using PAB.WebControls;
using System.Drawing;
using System.Drawing.Drawing2D;
using System.Drawing.Imaging;

public class thumbnail
{

public string UploadImage(string filename, string filetype, string str_folder_name_main, string str_folder_name_small,

FileUpload fileupload1, int width, int heigh)
{

if (fileupload1.PostedFile.ContentType == "image/pjpeg" || fileupload1.PostedFile.ContentType == "image/jpeg" ||

fileupload1.PostedFile.ContentType == "image/bmp" || fileupload1.PostedFile.ContentType == "image/gif")
{

string typ = fileupload1.PostedFile.ContentType;

fileupload1.PostedFile.SaveAs( HttpContext.Current.Server.MapPath( str_folder_name_main + filename + filetype));

if (str_folder_name_small.CompareTo(string.Empty) != 0)
{

CreateThumbnail(HttpContext.Current.Server.MapPath(str_folder_name_main + filename + filetype), width, heigh,

HttpContext.Current.Server.MapPath(str_folder_name_small + filename + filetype), 25, 25);
}

return "1";
}
else
{
return "0";
}
}

public string CreateThumbnail(string lcFilename, int lnWidth, int lnHeight, string OutputFilename, int hightPercent, int

widthPercent)
{
try
{
System.Drawing.Bitmap bmpOut = null;
Bitmap loBMP = new Bitmap(lcFilename);
ImageFormat loFormat = loBMP.RawFormat;
System.Drawing.Imaging.EncoderParameters Params = new System.Drawing.Imaging.EncoderParameters(1);
Params.Param[0] = new EncoderParameter(Encoder.Quality, 100L);
decimal lnRatio;
int thumbnamilHigth = Convert.ToInt32((loBMP.Height * hightPercent) / 100);
int thumbnamilWidth = Convert.ToInt32((loBMP.Width * widthPercent) / 100);

bmpOut = new Bitmap(thumbnamilHigth, thumbnamilWidth);

Graphics g = Graphics.FromImage(bmpOut);
g.SmoothingMode = System.Drawing.Drawing2D.SmoothingMode.HighQuality;
g.InterpolationMode = System.Drawing.Drawing2D.InterpolationMode.HighQualityBicubic;
g.FillRectangle(Brushes.White, 0, 0, thumbnamilHigth, thumbnamilWidth);
g.PixelOffsetMode = System.Drawing.Drawing2D.PixelOffsetMode.Half;

g.DrawImage(loBMP, 0, 0, thumbnamilHigth, thumbnamilWidth);
loBMP.Dispose();

bmpOut.Save(OutputFilename, ImageFormat.Jpeg);
bmpOut.Dispose();

return OutputFilename;
}
catch(Exception Ex)
{
return Ex.Message.ToString();

}

}

public bool checkImageType(HtmlInputFile FileUpload1)
{
if (FileUpload1.PostedFile.ContentType == "image/pjpeg" || FileUpload1.PostedFile.ContentType == "image/jpeg" ||

FileUpload1.PostedFile.ContentType == "image/bmp" || FileUpload1.PostedFile.ContentType == "image/gif")
{
return true;
}
else
{
return false;
}
}

public string CreateThumb(FileUpload fileUpload, string actIm, string tmbIm)
{
try
{
string filename = string.Empty;
string imagename = string.Empty;

string imgtype = string.Empty;
thumbnail thumb = new thumbnail();
filename = fileUpload.PostedFile.FileName;

imagename = filename.Substring(filename.LastIndexOf("\\") + 1, (filename.LastIndexOf(".") - 1) -

(filename.LastIndexOf("\\")));
imagename = imagename + DateTime.Now.Ticks.ToString() + GenrateRandomIamgeName(3);
imgtype = filename.Substring(filename.LastIndexOf("."));

if (thumb.UploadImage(imagename, imgtype, actIm, tmbIm, fileUpload, 95, 143).Equals("1"))
{
return imagename + imgtype;
}
else
{
return "";
}
}
catch
{
return "";
}

}

public string CreateThumb(FileUpload fileUpload, string actIm)
{
try
{
string tmbIm = string.Empty;
string filename = string.Empty;
string imagename = string.Empty;

string imgtype = string.Empty;
thumbnail thumb = new thumbnail();
filename = fileUpload.PostedFile.FileName;

imagename = filename.Substring(filename.LastIndexOf("\\") + 1, (filename.LastIndexOf(".") - 1) -

(filename.LastIndexOf("\\")));
imagename = imagename + DateTime.Now.Ticks.ToString() + GenrateRandomIamgeName(3);
imgtype = filename.Substring(filename.LastIndexOf("."));

if (thumb.UploadImage(imagename, imgtype, actIm, tmbIm, fileUpload, 95, 143).Equals("1"))
{
return imagename + imgtype;
}
else
{
return "";
}
}
catch
{
return "";
}

}

public string GenrateRandomIamgeName(int Length)
{
string listOfCharacter = "abcdefghijkmnopqrstuvwxyz0123456789";
Random randNum = new Random();
char[] chars = new char[Length];
int allCharacterCount = listOfCharacter.Length;

for (int i = 0; i < Length; i++)
{
chars[i] = listOfCharacter[(int)((listOfCharacter.Length) * randNum.NextDouble())];
}

return new string(chars);
}

}

Thanks
HelpOnDesk Team

CSharpWeb: New material from Abby

2009-01-07T04:06:00.000-08:00

HelpOnDesk Codes for site devlopement in asp.net

session expire problem.

2009-01-06T06:37:00.000-08:00

Hi,

In many application we want to live session aprox 2 - 10 Hrs. If we set session time out 10 Hrs then it is extra overload of server.
If we want to live one page then we can apply following idea for solve this problem. just do something with client browser.
so called javaScript for replace image on client borowser. this way session wil never expire on specefic page.or do work with iframes reload.

Second Idea to remove this idea is :-

1)Always create cookie when u add any records in session and write cookie
when session is null after time out in that condition read values from
cookie. in this way u find values after session time out.

In javaScript section:-

[script language="javascript" type="text/javascript"]

function AlwaysLive(imgName) {
myImg = document.getElementById(imgName);
if (myImg) myImg.src = myImg.src.replace(/\?.*$/, '?' + Math.random());
}
window.setInterval("AlwaysLive('imgReload')", 100000); //100 seconds

[/script]

HTML:
[img id="imgReload" width="1" height="1" src="images/close_btn.gif?" alt="" /]

you must save the ? with image extension.

Thanks
HelpOnDesk Team

USE of GENRIC CLASSES

2009-01-06T04:32:00.002-08:00

-------------USE GENRIC CLASSES-----------------
Mny friedns ask me how to use Genric in our application, and what is genric.
so second question is on your part what is genric. i m giving two simple but
quite important example of genric which suerly make u understand how to use
genric.

Generic Type
Generics introduce a flexibility that combines type safety with the ability to avoid committing
to a type at design time.
What
Generics enable class, delegate, interface, and struct types, and methods to be created with
type parameters that are placeholder types, which can be substituted when the type is known.
Where
Generics are commonly used in data structures—for example, collections and arrays, or in
passing method parameters.

Why
Generics overcome the overhead issues of casting and boxing between types, which adversely
affects performance.
How
Generics are specified within a pair of delimiters ("<" and ">") placed after the respective type
or method name. When the type is known, it is substituted for the generic placeholder, as the
following code snippet illustrates. Note that the method
GenericMethod is declared as generic,
as is its parameter. In the Main function, we vary the types of the method.
using System;
using System.Collections.Generic;
using System.Text;
namespace ModelT
{
public class ModelTGenerics
{
public static void GenericMethod(T arg)
{
Console.WriteLine("Calling Model T generic method, " + arg.GetType());
}
public static void Main()
{
//Call the generic method passing different types:
GenericMethod("Hallo Generics");
GenericMethod(16.75);
}
}
}

The Standard: Generic Type
The standard acknowledges the use of generics to reduce overhead and increase type
flexibility while retaining the protection of type safety.

In First example we pass two different type in single genric class.
In second example we get data with help of genric class.

First Example :-

add new page in ur test application and paste following code

protected void Page_Load(object sender, EventArgs e)
{
//create a string version of our generic class
Col mystring = new Col();
//set the value
mystring.Val = "hello";

//output that value
Response.Write("Value :- " + mystring.Val+"
");

//output the value's type
Response.Write("Type :- " + mystring.Val.GetType() + "
");

//create another instance of our generic class, using a different type
Col myint = new Col();
//load the value
myint.Val = 5;
//output the value
Response.Write("Value :- "+ myint.Val + "
");
//output the value's type
Response.Write("Type :- " + myint.Val.GetType() + "
");

}
public class Col
{
T t;
public T Val { get { return t; } set { t = value; } }
}

There are a few things to notice. The class name "Col" is our first indication that this Type is generic, specifically the

brackets containing the Type placeholder. This Type placeholder "T" is used to show that if we need to refer to the actual

Type that is going to be used when we write this class, we will represent it as "T". Notice on the next line the variable

declaration "T t;" creates a member variable with the type of T, or the generic Type which we will specify later during

construction of the class (it will actually get inserted by the Common Language Runtime (CLR) automatically for us). The

final item in the class is the public property. Again, notice that we are using the Type placeholder "T" to represent that

generic type for the type of that property. Also notice that we can freely use the private variable "t" within the class.

This example is form
and there is more example for genric on this page.

Second Example :-

In this example we get data with help of genric class

Step 1.
caeate a simple class as following.

using System;

///

/// Summary description for UserInfo
///

public class UserInfo
{
private string _userName = string.Empty;
private string _password = string.Empty;

public UserInfo(string userName, string password)
{
this._userName = userName;
this._password = password;
}

public string UserName
{
get
{
return _userName;
}
}

public string Password
{
get
{
return _password;
}
}
}

Step 2.

create genric class which uses its type as a above class

using System;
using System.Data;
using System.Configuration;
using System.Collections.Generic;
using System.Collections;
using System.Data.SqlClient;

///

/// Summary description for genricList
///

public class genricList
{
public genricList()
{

}
public System.Collections.Generic.IList fillIlist()
{
string st = ConfigurationManager.ConnectionStrings[0].ToString();
IList userinfos = new List();
string connectionString = ConfigurationManager.ConnectionStrings["PUBSConnectionString"].ToString();
string queryString = "SELECT * FROM GenricLogin";
using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlCommand command = connection.CreateCommand();
command.CommandText = queryString;

try
{
connection.Open();

SqlDataReader reader = command.ExecuteReader();

while (reader.Read())
{
UserInfo info = new UserInfo(reader[0].ToString(),reader[1].ToString());
userinfos.Add(info);

}
reader.Close();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}

return userinfos;
}
}

table structure

CREATE TABLE GenricLogin (username varchar(20), password varchar(20))

Insert some values in table

Insert into GenricLogin (username,password)

select 'aaaaa','111111'
union all
select 'bb','222222222'
union all
select 'ccc','33333333'

Step 3

now call this funciton on page and bind your dataGrid with genric

genricList objgenricList = new genricList();
dg.DataSource = objgenricList.fillIlist();
dg.DataBind();

with same way we can add as much classes as we required for bind different tables.

Thanks
HelpOnDesk Team

if session is expire then redirec user like yahoo email

2009-01-05T07:31:00.000-08:00

This code is redirect user on page where we show that is current session expired
and relogin login so on defautl button NavigateUrl="~/Admin/Login.aspx" Text="Click here to Login again" becz it is on preRender event so first it will execte

protected void Page_PreRender(object sender, EventArgs e)
{
HttpContext.Current.Response.AppendHeader("Refresh", Convert.ToString(((HttpContext.Current.Session.Timeout * 60) - 5)) + "; Url=Default.aspx");

}

Thanks
HelpOnDesk Team

Genrate Random Password

2009-01-05T04:04:00.000-08:00

Hi,

This fucntion is used for Genrate Password.

pass length of password for example GenrateRandomPassword(8);

for better result we can add timeTick for select integer or we can call to time this fuction recurlsivle
and then get substring portion for final password.

in my earlier post i also upload a dataBAse storeprocedure for caseSenstive password.

public static string GenrateRandomPassword(int PasswordLength)
{
string listOfCharacter = "abcdefghijkmnopqrstuvwxyzABCDEFGHJKLMNOPQRSTUVWXYZ0123456789#$&@-";
Random randNum = new Random();
char[] chars = new char[PasswordLength];
int allCharacterCount = listOfCharacter.Length;

for (int i = 0; i < PasswordLength; i++)
{
chars[i] = listOfCharacter[(int)((listOfCharacter.Length) * randNum.NextDouble())];
}

return new string(chars);
}

Thanks
HelpOnDeskTeam

Print a file without open it but this code work only when we select websete as a filesystem :(

2009-01-05T03:39:00.001-08:00

//this code alow print a document without open it. and this code allow pdf / txt/ //doc etc. but works only on filesystem website
/*System.Diagnostics.ProcessStartInfo PrintingProcess = new System.Diagnostics.ProcessStartInfo();
PrintingProcess.Verb = "print";
PrintingProcess.WindowStyle = ProcessWindowStyle.Hidden;
PrintingProcess.FileName = "c:/M.txt";//path for the file
PrintingProcess.UseShellExecute = true;
System.Diagnostics.Process.Start(PrintingProcess); */

The following code automaticaly close its print window un comment last three lines

Process PrintingProcess = new Process();
PrintingProcess.StartInfo.CreateNoWindow = false;
PrintingProcess.StartInfo.Verb = "print";
PrintingProcess.StartInfo.FileName = @"C:\m.txt";
PrintingProcess.Start();
//PrintingProcess.WaitForExit(10000);
//PrintingProcess.CloseMainWindow();
//PrintingProcess.Close();

Thanks
HelponDesk Team

Insert or Update Template for data base stored procedure

2009-01-02T06:38:00.000-08:00

Create PROC InsertUpdatetemplate
-- This proc is used for insert or update records
-- it is simple sp with roll back transaction
-- so we have to just upload this format
(

)

as

IF (exists(SELECT * FROM tablename WHERE condition))
BEGIN
--Update
BEGIN TRY
BEGIN TRAN

UPDATE qery

COMMIT TRAN
RETURN 1
END TRY
BEGIN CATCH
ROLLBACK TRAN
SELECT ERROR_NUMBER()[ERROR NUMBER],ERROR_LINE()[ERROR IN LINE],ERROR_PROCEDURE()[ERROR IN PROCEDURE],ERROR_MESSAGE()[ERROR

MESSAGE]
RETURN 0
END CATCH

END
ELSE
BEGIN
-- Insert

BEGIN TRY
BEGIN TRAN

insert query

COMMIT TRAN
RETURN 1
END TRY
BEGIN CATCH
ROLLBACK TRAN
SELECT ERROR_NUMBER()[ERROR NUMBER],ERROR_LINE()[ERROR IN LINE],ERROR_PROCEDURE()[ERROR IN PROCEDURE],ERROR_MESSAGE()[ERROR

MESSAGE]
RETURN 0
END CATCH

END

do not print 'PRINT BUTTON ' on printed copy page

2009-01-02T03:48:00.000-08:00

Steps .

1. Create a CSS
like
.print
{
dsplay:none;
}

2. Apply that CSS on those control which u dont want to print while printing

3. Add the refernce of style sheet file. in this case u have to set the media="print"

[link rel="stylesheet" type="text/css" href="Retailer/CSS/StyleSheet2.css" media="print"

/]

Thanks
HelpOnDesk Team

Why should I switch to CDOSYS when my current CDONTS code works great? send mail from cdosys and cdonts

2009-01-02T03:21:00.000-08:00

Some time our emails bounce from SMTP SERVER. when i analysis the problem i got three way to send mail. with free SMTP SERVER like gmail. etc server OR USING CDOSYS OR CDONTS. BUT the question: "Why should I switch to CDOSYS when my current CDONTS code works great?". Let me give a few reasons:

* CDONTS has been deprecated in IIS5 and is completely removed from Windows Server 2003, and even Windows XP. Yes, it is

possible to install on Windows Server 2003 but with the performance improvements and other enhancements, there should be no

need to do so.
* CDOSYS carries less overhead than CDONTS.
* HTML functionality is much improved with automatic generation of the TextBody by just setting the HTMLBody property.
* There are some new properties and methods that should have been included with CDONTS but weren't.

in my earlier post i already explain the code of send mail via gmail server so now we will focus on.

USE CDONTS.DLL

STEP 1) AS WE DESCRIBED ABOVE THAT CDONTS.DLL ARE NO MORE OVER IN WINDOW FOLDER SO CONFIGURE IT WHITH THIS WAY

Start + Run, regsvr32 c:\cdonts.dll
OR
Start + Run + cmd,
in command type and run

]regsvr32 [path for dll]

now add refference of cdonts.dll

CDONTS.NewMail mailsend1 = new CDONTS.NewMail();

string From = "helpondesk@blogspot.com";
string Subject = "xxxxxxxxxxxxxxxxxxxxxx";
string Body = "[html][body][table border=0 cellpading=0 cellspacing=0][tr][td]hi from

cdonts[/td][/tr][/table][/body][/html]";
string To = "helpondesk@blogspot.com";
mailsend1.BodyFormat = 0;
mailsend1.MailFormat = 0;
mailsend1.Importance = Convert.ToInt32(CDONTS.CdoImportance.CdoHigh);
mailsend1.Send(From, To, Subject, Body, 1);

how to implement second dll CDOSYS

we can also configure cdosys dll with same way as codonts.dll

using System.Web.Mail;

MailMessage eMail = new MailMessage();
eMail.To = "helpondesk@blogspot.com";

eMail.Subject = " 2222222222";
eMail.Body = "[html][table][tr][td]HI THIS MAIL FROM CDOSYS SO HOW ARE YOU[/td][/tr][/table]";
// Smtp configuration
eMail.From = "helpondesk@blogspot.com";
eMail.Fields.Add(CDO.CdoConfiguration.cdoSMTPAuthenticate, "1");
eMail.Fields.Add(CDO.CdoConfiguration.cdoSendUserName, "helpondesk@blogspot.com");
eMail.Fields.Add(CDO.CdoConfiguration.cdoSendPassword, "mypwd");
SmtpMail.SmtpServer = "smpt.domain.com";
eMail.BodyFormat = MailFormat.Html;
SmtpMail.Send(eMail);

Thanks
HelpOnDesk Team

Using PayPal Pro With ASP.Net application

2009-01-01T12:54:00.000-08:00

Hi Everybody..
"How to use PayPal Pro Method in Asp.Net 2.0 web Application", this is topic for today which, I want to add as my latest post .I hope all of you are well aware of this.Yet I am adding this for quick reference.
You can also take an idea from HERE .
You have to add the following code in your page and modified it as per your need...

protected void Page_Load(object sender, EventArgs e)
{
// Do Your Other Task Here...
UpdatePaymentStatus();
}
protected void UpdatePaymentStatus()
{
#region Paypal Return
try
{
string status = GetSuccessStatus();
if (status != null && status != string.Empty)
{
if (status.Contains("success"))
{
// Do Your DatBase related things ag save the transaction details in DB
// for eg: userID ,Unit Price,And Total Amount or anyother thing as needed
}
if (status.Contains("failed"))
{
// do as per your Logic
}
}
}
catch (Exception Ex)
{
Session["errorMessage"] = Ex.Message.ToString();
//Response.Redirect("index.aspx");
}
#endregion
}
protected void ImgPayMent_Click(object sender, ImageClickEventArgs e)
{
amount = Convert.ToDouble(lblPrice.Text);
string redirect = "";

//redirect += "https://www.paypal.com/cgi-bin/webscr";
redirect += "https://www.sandbox.paypal.com/cgi-bin/webscr";
redirect += "?cmd=_xclick";
redirect += "&business=books._1235082065_biz@gmail.com ";
//Where abc@youdomain.com is Merchant account ID
redirect += "&item_name=" + "My Testing Purpose";
redirect += "&item_number=1";
redirect += "&amount=" + String.Format("{0:0.00} ", amount);// This is amount Double Type
redirect += "&currency_code=USD";
redirect += "&no_shipping=1";
redirect += "&no_note=1";
redirect += "&return=http://HomeUrlOfSite/Purchase.aspx/success/";
redirect += "&cancel_return=http://HomeUrlOfSite/Purchase.aspx/failed/"
Response.Redirect(redirect);
}
protected string GetSuccessStatus()
{
if (Request.PathInfo.Length == 0)
return "";
else if (Request.PathInfo.Contains("success"))
return "success";
else if (Request.PathInfo.Contains("failed"))
return "failed";
return "";
}
}

Thanks:...
Sanjeev Kumar
HelpOnDesk Team

Fill DropDownList By Using Professional Ajax (AjaxMethod Attribute and CallBack)

2008-12-26T13:10:00.000-08:00

Hi..
Today I am going to post a very Basic but very important example .This is the example of the professional Ajax showing the usage of the "[Ajax.AjaxMethod()]" attrubute.
Here in this example i am just showing a string message and bind a dropdownList in javascript by calling the server side methods in javascript.
This is very basic example You can modify it according to your need .
Before doing all this you have to add refernce of ajax.dll in bin folder.
you can download the a sample project from HERE . This Project includs the ajax.dll also. you can get the dll from this link by downloading the sample project.

The step taken in this example are as given below.

Step 1.) Modification in web.config file
put the "< add verb="POST,GET...." in the HttpHandlers section in web.config as given below.

[system.web]
[httpHandlers]
[add verb="POST,GET" path="ajax/*.ashx"
type="Ajax.PageHandlerFactory, Ajax"/]
[/httpHandlers]

Step 2.) Make the AjaxMethod which we have to call in Javascript in Desgn file of the page Suppose we have the page
Test1.aspx in the folder "Sanjeev" (Sanjeev/Test1.aspx)
so the .cs file of the page looks like as given below..
Here the important things are :
A.) Ajax.Utility.RegisterTypeForAjax(typeof(Sanjeev_Test1));
Where "Sanjeev_Test1" is the Name of the ppartial class of the page.
B.) We have to put "[Ajax.AjaxMethod()]" attrubute before the method body.
=========================================================
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
public partial class Sanjeev_Test1 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
Ajax.Utility.RegisterTypeForAjax(typeof(Sanjeev_Test1));
}
[Ajax.AjaxMethod()]
public string GetName()
{
//to alert the simple string message to test
return "Sanjeev Kumar Chauhan";
}
[Ajax.AjaxMethod()]
public DataSet getDataSet()
{
//use to get the DataSet by which we have to bind the
//DropdownList
DataSet ds = new DataSet();
DataTable dt = new DataTable();
DataColumn dcText = getDataColumn("Text");
DataColumn dcValue = getDataColumn("Value");
dt.Columns.Add(dcText);
dt.Columns.Add(dcValue);
string strName = "Name";
string strValue = "sanjeev";
for (int i = 0; i < 6; i++)
{
DataRow dr = dt.NewRow();
dr[dcText] = strName + i.ToString();
dr[dcValue] = strValue + i.ToString();
dt.Rows.Add(dr);
}
ds.Tables.Add(dt);
return ds;
}
public DataColumn getDataColumn(string ColName)
{
DataColumn dc = null;
dc = new DataColumn(ColName, System.Type.GetType("System.String"));
return dc;
}
}
==================================================
3.) the aspx file of the page :

[%@ Page Language="C#" AutoEventWireup="true" CodeFile="Test1.aspx.cs" Inherits="Sanjeev_Test1" %]
[!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"]
[html xmlns="http://www.w3.org/1999/xhtml" ]
[head id="Head1" runat="server"]
[title]Untitled Page[/title]
[script language="javascript" type="text/javascript"]
// function GetTasks() //Using Call Back
// {
// Sanjeev_Test1.GetName(GetName_CallBack);
// }
//function GetName_CallBack(response)//The CallBack function
// {
// alert(response.value);
// return false;
// }
// Without Using Call Back this also works properly
function GetTasks()
{
var str = Sanjeev_Test1.GetName();
alert(str.value);
}
function getDS()
{
var resp = Sanjeev_Test1.getDataSet();
var ds = resp.value;
if(ds.Tables[0].Rows.length == 0 )
{

// document.getElementById("ddl").options.length=0;
alert("There is no Term");
}
else
{
document.getElementById("ddl").options.length=0;
if(ds.Tables[0].Rows.length ] 0 )
{
for(var i=0; i[ds.Tables[0].Rows.length; i++)
{
var o = document.createElement("option");
o.value = ds.Tables[0].Rows[i].Value;
o.text = ds.Tables[0].Rows[i].Text;
document.getElementById('ddl').add(o);
}
}
}
}
[/script]
[/head]
[body]
[form id="form1" runat="server"]
[div]
[input type="button" id="btnHTML" value="ShowName" onclick="return GetTasks();" /]
[br /]
[input type="button" value="Fill DropDown" onclick="getDS();" /]
[asp:DropDownList ID="ddl" runat="server"]
[/asp:DropDownList]
[/div]
[/form]
[/body]
[/html]
================================================================
I hope you will enjoy this.
Thanks :
Sanjeev Kumar
HelpOnDeskTeam

Show Formatted Date And Time Using Java Script...

2008-12-22T11:00:00.000-08:00

Hello...
Today , I m here to give an example how to get the formated Date And Time using Java Script, and the Format is Like "Mon Dec 22 2008 10:52:07 PM" . so have a look on the following example...

function ShowFormattedDateAndTime()
{
var now = new Date() ;
var time=now.toLocaleTimeString();
var dayname=now.toDateString();
var totaldaytime=dayname+" "+time;
document.getElementById("Lbl").innerHTML="Draft Auto Saved at " + totaldaytime;
}

Sanjeev Kumar
HelpOn Desk Team

How to check the Date Format Using SQL SERVER 2005

2008-12-19T13:05:00.000-08:00

Hello ...
Today , I am presenting a very Good Stored procedure as well as the UseDefined funtion and its use in the stored procedure the date formate is MM/DD/YYYY.
-- The Procedure is Used to get the Data For Event start date,Begin Time and End Time.
CREATE proc [dbo].[usp_GetEventDateTime]
(
@eventId uniqueidentifier
--The EventId corresponds to which we have to get data
)
AS
BEGIN
Select eventDateTimeId, eventDate, beginTime, endTime
,dbo.udf_IsValidEventStartTimeFormat(beginTime) As 'StartTimeFormat', dbo.udf_IsValidEventEndTimeFormat(endTime) As 'EndTimeFormat'
From EventDateTime
Where eventId = @eventId
--dbo.udf_IsValidEventStartTimeFormat is used to get the correct format of the Time
END
The UserDefined Functio IsValidEventStartTimeFormatn Is Geven As Given Below:

============================================================================
CREATE FUNCTION [dbo].[udf_IsValidEventStartTimeFormat] (@beginTime varchar(50))
RETURNS smallint
AS
BEGIN
Declare @ReturnVal smallint
Set @ReturnVal = 1
If @beginTime = '' Or @beginTime IS NULL Or
CharIndex(':',@beginTime) <> 3 Or
CharIndex(' ',@beginTime) <> 6 Or
Len(SubString(@beginTime,CharIndex(' ',@beginTime)+1,Len(@beginTime))) != 2 Or
SubString(@beginTime,CharIndex(':',@beginTime)+1,1) = ' ' Or
isnumeric(substring(@beginTime,0,CharIndex(':',@beginTime))) !=1 Or
isnumeric(SubString(@beginTime,CharIndex(':',@beginTime)+1, CharIndex(' ',@beginTime) - (CharIndex(':',@beginTime)+1) ) ) !=1
Set @ReturnVal = 0 -- If not valid time format (HH:MM AM/PM)
RETURN @ReturnVal
END
With Love..
Sanjeev Chauahn
HelpOnDesk Team

Display On Status Bar Of the Browser Window

2008-12-17T11:25:00.000-08:00

Hi ...

Hi this time I am here with some easy wonder of java script . when you play with this I am sure you will enjoy this.

The 1st one is About :When we want to display the current Time in Status Bar. then You have to call the following java script function whereEver you need(Generally It will be called onload of the body in HTML)

function ShowTime()
{
var TimerKey
var now = new Date()
var Hours = now.getHours()
var Minutes = now.getMinutes()
var Seconds = now.getSeconds()
var TimeDisplay = document.getElementById("lblTime");
TimeDisplay.innerText = ((Hours > 12) ? Hours - 12 : Hours) + ((Minutes <> 12) ? " PM" : " AM")
window.status = ((Hours > 12) ? Hours - 12 : Hours) + ((Minutes <> 12) ? " PM" : " AM")
TimerKey = setTimeout("ShowTime()",1000)
}

And the 2nd one is About :When we want to display our Custom Message in Status Bar. then You have to call the following java script function whereEver you need(Generally It will be called onload of the body in HTML)

2.)

Thanks :

Sanjeev Chauhan

HelpOn Desk Team

use checkboxlist as checkboxsradiolist in javaScript

2008-12-16T02:56:00.000-08:00

Hello,
In this week I got a very intresting problem and for solving it we have to use JAVAScript.
look a simple view on problem. we are using the checkbox list for selection cretieria.
we have 5 checkbox list but 2 check box list used as an radiobutton list. means user can select
one option at a time and his previous selection must be show until he choose the other next
choice.
Other three are simple in which new selction is added as we do by default.
so consentrate on problem. for solveing it i created function saveMouserOverID(control)
which get the id of control where mouse jump upon the control.
and after it created a javascript fucntion CheckUnCheckBox(crtl) wehre if control goes in to
default case it will unchech all check box expect the currently clicked check box.
b'cz this id is stored in saveMouseOverFunction();
view of the code is follows.
We can also store that id in hiddenfield and first uncheckall the checkbox and after it check
the control where id is stored in hidden field.

Thanks
HElpOnDesk Team

structure of checkboxList

[asp:CheckBoxList onClick="return CheckUnCheckBox('ssss');" ID="RS" OnSelectedIndexChanged="dosomeserverside"
RepeatColumns="setIntasuwant" CellSpacing="setIntasuwan"
runat="server" AutoPostBack="True"]
[asp:ListItem onmouseover="javascript:saveMouserOverID('0')" Text="select ALL" Value="Selectall"][ /asp:ListItem]
[asp:ListItem onmouseover="javascript:saveMouserOverID('1')" Text="helpindesk" Value="Helpondesk"][ /asp:ListItem]
[asp:ListItem onmouseover="javascript:saveMouserOverID('2')" Text="sanjeev"
Value="Sanjeev"][ /asp:ListItem]
[ /asp:ChekcBoxList/]

function saveMouserOverID(control)
{
controlid=control;

}

function CheckUnCheckBox(ctrl)
{
var checkbox = document.getElementById('ctl00_ContentPlaceHolder1_'+ctrl);
var inputlist = checkbox.getElementsByTagName("input");
var i=0;
var id;
switch(ctrl)
{
case "shape":
for(i=0; i[inputlist.length; i++)
{
//id = 'checkImage'+(parseInt(i)+parseInt('4'));
if(inputlist[i].checked)
{
if(controlid == 0 && controlid != i)
{
inputlist[i].checked = '';
// document.getElementById(id).src=imgFalse;
}
else if(controlid !=0 && i==0)
{
inputlist[i].checked = '';
//document.getElementById(id).src=imgFalse;
}
}
}
break;
case "color":
for(i=0; i[inputlist.length; i++)
{
//id = 'checkImage'+(parseInt(i)+parseInt('23'));
if(inputlist[i].checked)
{
if(controlid == 0 && controlid != i)
{
inputlist[i].checked = '';
//document.getElementById(id).src=imgFalse;
}
else if(controlid !=0 && i==0)
{
inputlist[i].checked = '';
//document.getElementById(id).src=imgFalse;
}
}
}
break;

default:
for(i=0; i[inputlist.length; i++)
{
// if(ctrl == 'weight')
// {
//
// }
// else if(ctrl == 'price')
// {
//
// }
if(inputlist[i].checked)
{
if(controlid != i)
{
inputlist[i].checked = '';

}
}
else
{
inputlist[i].checked = '';

}
}
}
}
[/script]

APPLY GOOGLE LIKE SEARCH STORED PROCEDURE

2008-12-12T15:32:00.000-08:00

Hi..

Today I m posting a very good as well as very important Stored procedure which is used to apply the google type search in your data base here in this SP i am giving the IDs of the table in which i want to search.
Please have a look its very intersting..

CREATE PROCEDURE PROC_Google_Like_Search
(
@InputText varchar(100)
)
AS
BEGIN
SET NOCOUNT ON;

declare @SearchChar varchar(8000)
Set @SearchChar = '%'+ @InputText+ '%'--'%partner%'--, '11/11/2006'

declare @CMDMain varchar(8000), @CMDMainCount varchar(8000),@CMDJoin varchar(8000)
declare @ColumnName varchar(100),@TableName varchar(100)

declare dbTable cursor for
SELECT
Distinct b.Name as TableName
FROM
sysobjects b
WHERE id in ( 1195151303,1115151018,859150106) --*** see The Note Comment for this

-- b.type='u' and b.Name <> 'dtproperties'
--order by b.name
open dbTable
fetch next from dbTable into @TableName

WHILE @@FETCH_STATUS = 0
BEGIN
declare db cursor for
SELECT
c.Name as ColumnName
FROM
sysobjects b,
syscolumns c
WHERE
C.id = b.id and
b.type='u' and b.Name = @TableName
order by b.name

open db
fetch next from db into @ColumnName

set @CMDMain = 'SELECT ' + char(39) + @TableName + char(39) + ' as TableName,'+
' ['+ @TableName + '].* FROM [' + @TableName + ']'+
' WHERE '
set @CMDMainCount = 'SELECT Count(*) FROM [' + @TableName + '] Where '
Set @CMDJoin = ''

WHILE @@FETCH_STATUS = 0
BEGIN

set @CMDJoin = @CMDJoin + 'Convert(varchar(5000),[' +@ColumnName + ']) like ' + char(39) + @SearchChar + char(39) + ' OR '

fetch next from db into @ColumnName
end
close db
deallocate db

Set @CMDMainCount = 'If ('+ @CMDMainCount + Left(@CMDJoin, len(@CMDJoin) - 3)+ ') > 0 Begin '
Set @CMDMain = @CMDMainCount + @CMDMain + Left(@CMDJoin, len(@CMDJoin) - 3)
Set @CMDMain = @CMDMain + ' End '

Print @CMDMain

exec (@CMDMain)

fetch next from dbTable into @TableName
end
close dbTable
deallocate dbTable
END

***NOTE :-
To get the table id to be searched from the sysObject..
Select * from sysobjects where xtype='u' order by crdate desc

Thanks ...
Sanjeev Chauhan
HelpOnDesk Team

Code Help to Upload Image In Binary Format in SQL SERVER DB

2008-12-12T14:45:00.000-08:00

Hi...

The coming post is about to How we can store image in to the database in a binary foramt.
we are very thankful to Mr. Shameem Pundeer for his kind supports ..And I hope it will be carry on in the future..

Color1 is Datagird name. On Updatecommand of datagrid we write code to upload vedio and image in sql-server database.

private void color1_UpdateCommand(object source, DataGridCommandEventArgs e)
{
int getItemID = Convert.ToInt32(color1.DataKeys[e.Item.ItemIndex]);
System.Web.UI.HtmlControls.HtmlInputFile File1 = (System.Web.UI.HtmlControls.HtmlInputFile)e.Item.Cells[0].Controls[1];
System.Web.UI.HtmlControls.HtmlInputFile File2 = (System.Web.UI.HtmlControls.HtmlInputFile)e.Item.Cells[1].Controls[1];
TextBox txt1 = (TextBox)e.Item.Cells[2].Controls[1];
TextBox txt2 = (TextBox)e.Item.Cells[3].Controls[1];

if(File1.Value != "")// to upload vedio file on sql-server database
{

string fpath = File1.PostedFile.FileName;
string fName = System.IO.Path.GetFileName(fpath);
string currPath = Request.PhysicalApplicationPath;
File1.PostedFile.SaveAs(currPath+ "/_video/" + fName);

string SqlUpdFName = "update item set fileName='" + fName + "'" + " where itemID=" + getItemID ;
int AffrowUpd = Convert.ToInt32(oDBManager.ExecuteNonQuery(SqlUpdFName));
}

if(File2.Value != "")// Upload image file to sql-server database in binary format
{
////////////////////Deleting Last Image Which has to Update////////////////////////
string SqlDelImg = "Delete from image where itemID =" + getItemID;
int rowAff3 = Convert.ToInt32(oDBManager.ExecuteNonQuery(SqlDelImg));

////////////////////////////////////////////////////////////////////////////////////

int len = File2.PostedFile.ContentLength;
double k = Convert.ToDouble(len);
byte[] pic = new byte[len];
File2.PostedFile.InputStream.Read (pic, 0, len);
string imgContentType = File2.PostedFile.ContentType;
string imgName1 = File2.Value;
SqlConnection Conn = new SqlConnection(@ConfigurationSettings.AppSettings["ConnectionString"]);

try
{
Conn.Open ();
SqlCommand cmd1 = new SqlCommand ("insert into image" + "(imageContent, imageType, imageName, imageSize, itemID) values (@imageContent,@imageType, @imageName, @imageSize, @itemID )", Conn);
cmd1.Parameters.Add ("@imageContent",pic );
cmd1.Parameters.Add ("@imageType", imgContentType);
cmd1.Parameters.Add ("@imageName", imgName1);
cmd1.Parameters.Add ("@imageSize", k);
cmd1.Parameters.Add("@itemID",getItemID);

cmd1.ExecuteNonQuery ();
}
finally
{
Conn.Close ();
}

}

if(txt1.Text != "")
{
string SqlUpdIName = "update item set itemName='" + txt1.Text + "'" + " where itemID=" + getItemID;
int affUpdRow1 = Convert.ToInt32(oDBManager.ExecuteNonQuery(SqlUpdIName));

}

if(txt2.Text != "")
{
string SqlUpdPrice = "update item set itemPrice=" + txt2.Text + " where itemID=" + getItemID;
int affUpdRow2 = Convert.ToInt32(oDBManager.ExecuteNonQuery(SqlUpdPrice));

}

color1.EditItemIndex = -1;
BindDataGrid();

}

Thanks:
Sanjeev Kumar
HelpOnDesk Team