Knowledgesharing

How to know the current postback is a full postback or partial postback in Asp.net

2011-11-16T03:11:00.000-08:00

Here is the code used to differentiate between partial or full post back in Asp.net.
if (Page.IsPostBack)
{

if (ScriptManager.GetCurrent(this.Page).IsInAsyncPostBack)

{
//Partial post back

}

else

{

//full post back
}

}

Silverlight vs Adobe Flash

2011-10-09T07:56:00.000-07:00

Several other technologies use a plug-in like Java, ActiveX,Shockwave, Adobe Flash, But Adobe flash is most popular among them.Still Adobe Flash has an advantages over silverlight

*Features*	*Silverlight*
Animation	Better Than Flash
File size	Not better than flash
Scripting	Better Than Flash
Video/Audio	Better Than Flash
Sound processing	Not better than flash
Accessibility	Not better than flash
Platform compatibility	Not better than flash
Text representation/SEO	Better Than Flash
Supported image formats	Not better than flash
Socket programming	Not better than flash
Webcam support	Not better than flash
Deployment	Not better than flash
Windows application	Not better than flash
Media streaming	Better Than Flash

How to check silverlight plug in installed

2011-10-09T07:50:00.000-07:00

If silverlight plug –in is not download on your machine then it shows you to download it on the silverlight content and after clicking it it will start downloading and if you click the run then it start running.

Advantage and Disadvantage of silverlight plug in

2011-10-09T07:27:00.000-07:00

Advantage:

The advantage of plug-in is that user needs to install it one time.It’a time taking process but still has a great advantage and browser can the browser can process any content that uses the plug-in seamlessly, with no further prompting.Silverlight allows you to develop more graphical and interactive applications.

Disadvantage;

It's a time taking process for the first time and No user want to wait for some time to see the content after downloading the plug in.

What is silverlight runtime?

2011-10-09T06:38:00.002-07:00

It's Plug-in for browser to display the silverlight content.

Introduction to Silverlight

2011-10-09T06:38:00.000-07:00

What is silverlight?

Silverlight is a cross-platform and cross-browser plug-in that exposes a programming framework and features that are a subset of the .NET Framework and Windows Presentation Foundation (WPF).

Silverlight is a web browser plug-in which is small in size and can be installed on demand and runs in all popular browsers, including Microsoft Internet Explorer, Mozilla Firefox, Apple Safari, Opera.It is similar to flash .It runs cross-browser , cross-platform that exposes a programming framework and features that are a subset of the .NET Framework and Windows Presentation Foundation (WPF) .You can develop business applications for the Web, desktop, and mobile devices .

How to manually configure webserver for asp.net 4.0

2011-09-20T06:20:00.000-07:00

Use below command in VS command prompt

C:\Windows\Microsoft.NET\Framework\v4.0.30319\aspnet_regiis -i

How to spilt data in sql server while using "IN" operator

2011-08-25T22:55:00.000-07:00

Sometime you send multiple comma separated values as parameter to a stored procedure.

Suppose you are set the parameter value as below

param[0].value = "3,4,5,6";

The above set value doesn't work in stored procedure.

But as the column type is int then it query condition  should be like  column name in (3,4,5) and if you send the parameter as

It doesn't work in stored procedure, So i have used a function to split it and to use it.

USE [Database name]
GO
/****** Object:  UserDefinedFunction [dbo].[Split_String]    Script Date: 08/26/2011 11:12:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


ALTER FUNCTION [dbo].[Split_String](@Param_String varchar(2000),@Delmeter varchar(5))  
RETURNS @RtnValue table 
(
	Id int identity(1,1),
	Data nvarchar(100)
) 
AS  
BEGIN 
	Declare @Cnt int
	Set @Cnt = 1

	While (Charindex(@Delmeter,@Param_String)>0)
	Begin
		Insert Into @RtnValue (data)
		Select 
			Data = ltrim(rtrim(Substring(@Param_String,1,Charindex(@Delmeter,@Param_String)-1)))

		Set @Param_String = Substring(@Param_String,Charindex(@Delmeter,@Param_String)+1,len(@Param_String))
		Set @Cnt = @Cnt + 1
	End
	
	Insert Into @RtnValue (data)
	Select Data = ltrim(rtrim(@Param_String))

	Return
END

Example:

SELECT NAME FROM TABLENAME  WHERE FK_DEFAULT_ID    
IN (select data from [dbo].[Split_String] (@DEFAULTIDS,',') )

Note : @DEFAULTIDS is the parameter in stored procedure which contains value like "3,4,5,6" and type id varchar.

How to spilt string with string as a separator using c#

2011-08-17T23:11:00.000-07:00

It's easy to split a string using character but sometimes the separator may present in the string with not as separator then at that time result comes as wrong.To avoid this kind of error use string with unique combination like "$#%$" or "$%%^^" .There may a less possibility of presence of this kind of string inside your string,But if you can't separate it with the way you separate using char as separator.

Here is the sample :

string[] arrStr = typeOfrecord.Split(new string[] {"#$%^"}, StringSplitOptions.None);

Note: typeOfrecord is the string containing the separator as "#$%^".

How to covert column values of a datatable to string array or string

2011-08-17T23:02:00.000-07:00

Sometimes we need the column values of a datatable as string array.Most of the programmer follows the looping through the rows of datatable and append it to string or stringbuilder.But we can do it by a single statement with avoiding the looping.

string[] emCodesprmFocus = Array.ConvertAll(dtAllEm.Select(),row => (String)row["NAME"].ToString());

Note :dtAllEm is the datatable and NAME is the column.

If you want to convert the string array to string with "," as separator then

string names = String.Join(",", emCodesprmFocus);

Failed to access metadata info error in iis solution

2011-08-12T00:19:00.000-07:00

Use this command in VS command prompt to solve this error.

aspnet_regiis -iru

How to add handler to multiple dyanamically created buttons in C#

2011-08-12T00:15:00.001-07:00

You can add handler to dynamically created a button ,but might be confused with multiple buttons that is created dynamically .

Here is the given code to understand.

for (int i = 0; i < 10; ++i)
            {
                Button btn = new Button();
                btn.Text = "btn" + i.ToString() + "";
                btn.ID = "btn_" + i.ToString() + "";
                btn.Click += new EventHandler(btnSave_Click1);
                btn.CommandName = i.ToString();
                btn.CommandArgument = i.ToString();
                div1.Controls.Add(btn);
            }
            
          
        }
        protected void btnSave_Click1(object sender, EventArgs e)
        {
            Button btn = (Button)sender;
          
          switch (int.Parse(btn.CommandName))
          {
                case 0:
                    DoWhatever(btn.CommandArgument.ToString());
                    break;
                case 1:
                    DoSomethingElse(btn.CommandArgument.ToString());
                    break;
           }

        }
        private void DoWhatever(string args)
        {
            string ss = string.Empty;
        }
        private void DoSomethingElse(string args)
        {
        }

How to find duplicate rows in a table using sql queries.

2011-08-12T00:09:00.000-07:00

Here is the example.

SELECT [uid]     FROM [People]      WHERE [Name] IN (    SELECT [Name]    FROM [People]    GROUP BY [Name]    HAVING 
( COUNT([Name]) > 1 ))

How display list of procedure and function used a specific table

2011-08-12T00:07:00.000-07:00

It will display list of procedure or functions where you have used the table

sp_depends <tablename>

How to set control value of Iframe from parent page in javascript

2011-08-12T00:04:00.000-07:00

We set control value of Iframe from parent page in javascript by given code

parent.frmEditBiopsy1.form1.txtSubjective.value = 'sdfsdfsd';

txtSubjective is the textbox inside iframe.

frmEditBiopsy1 is the id of Iframe.

How to call a javascript function inside iframe from parent page

2011-08-12T00:01:00.001-07:00

We call a javascript function which is inside the iframe from parent page.

d = document;
f = d.frames ? d.frames['frameName'] : d.getElementById('frameId');
p = f.document || f.contentWindow.document;

p.functionName();

functionName() is the javascript function to be called from parent.

How to call parent function from iframe

2011-08-11T23:53:00.000-07:00

You can call a parent function from iframe.

Parent.parentfunctionname();

parentfunctionname() is the function in the parent page.

How to add Twitter to your website

2011-08-11T23:45:00.000-07:00

You can add twitter to your website and ca twit your link to other.

Here is the code.

<script type="text/javascript">
var twtTitle  = document.title;
var twtUrl    = location.href;
var maxLength = 140 - (twtUrl.length + 1);
if (twtTitle.length > maxLength) {
twtTitle = twtTitle.substr(0, (maxLength - 3))+'...';
}
var twtLink = 'http://twitter.com/home?status='+encodeURIComponent(twtTitle + ' ' + twtUrl);
document.write('<a href="'+twtLink+'" target="_blank"'+'><img src="tweetthis.gif"  border="0" alt="Tweet This!" /'+'><'+'/a>');
</script>

tweetthis.gif is the image you can display on your website.

How to start or stop a service using C#

2011-08-11T09:32:00.000-07:00

private void StartService()

{

System.ServiceProcess.ServiceController[] allService = System.ServiceProcess.ServiceController.GetServices();

foreach (System.ServiceProcess.ServiceController s in allService)

{

if (s.ServiceName.Equals("Alerter"))

{

if (s.Status.Equals(System.ServiceProcess.ServiceControllerStatus.Stopped))//check service staus

{

bool status = ServiceStartModeUpdate("Alerter", "Manual", "Can't start service");//provide service name here and startup Type that must be automatic or manual

if (status == true)

{

s.Start();

}

}

}

}

}

private bool ServiceStartModeUpdate(string serviceName, string startMode,string errorMsg)

{

uint successReturn = 1;

errorMsg = string.Empty;

string filterService =String.Format("SELECT * FROM Win32_Service WHERE Name = '{0}'", serviceName);

ManagementObjectSearcher querySearch = new ManagementObjectSearcher(filterService);

if (querySearch == null)// if match not found

{

return false;

}

else

{

try

{

ManagementObjectCollection services = querySearch.Get();//get that service

foreach (ManagementObject service in services)

{

if (Convert.ToString(service.GetPropertyValue("StartMode")) == "Disabled")//if startup type is Diasabled then change it

{

ManagementBaseObject inParams =service.GetMethodParameters("ChangeStartMode");

inParams["startmode"] = startMode;

ManagementBaseObject outParams =service.InvokeMethod("ChangeStartMode", inParams, null);

successReturn = Convert.ToUInt16(outParams.Properties["ReturnValue"].Value);

}

}

}

catch (Exception ex)

{

errorMsg = ex.Message;

throw;

}

}

return (successReturn == 0);

}

NOTE:

Just make some changes to stop a service as well.

Replace if (s.Status.Equals

(System.ServiceProcess.ServiceControllerStatus.Stopped)) with if

(s.Status.Equals(System.ServiceProcess.ServiceControllerStatus.Running)or

start,pending etc.. other than stopped)

Replace s.Start(); with t.Stop();

References to be added

1.System.Management 

2.System.ServiceProcess 

Namespace to be added:

using System.Management;

KnowledgeSharing: How to use Infragistic ultrawebgrid

2010-03-05T21:54:00.000-08:00

After installing Infragistics ,add some dll of it to your application and to use ultrawebgrid add the dll of it.then drag and drop that control from toolbox after right click on toolbox and selecting choose items then select ultrawebgrid.

After dropping it the clientside code will like this.

<igtbl:ultrawebgrid id="UltraWebGrid1" runat="server" Width="824px" UseAccessibleHeader="False">

                    <DisplayLayout AllowDeleteDefault="Yes" AllowAddNewDefault="Yes" AllowSortingDefault="OnClient"

                        RowHeightDefault="21px" Version="3.00" SelectTypeRowDefault="Extended" AllowColumnMovingDefault="OnServer"

                        SelectTypeCellDefault="Single" BorderCollapseDefault="Separate" EnableClientSideRenumbering="True"

                        EnableInternalRowsManagement="True" FixedHeaderIndicatorDefault="Button" AllowRowNumberingDefault="Continuous"

                        Name="UltraWebGrid1" CellClickActionDefault="Edit" AllowUpdateDefault="RowTemplateOnly">

                        <AddNewBox Hidden="False" Prompt="add row">

                                                        <ButtonStyle></ButtonStyle>

                        </AddNewBox>

                        <Pager ChangeLinksColor="True" StyleMode="CustomLabels" >

                            <Style >

                            </Style>

                        </Pager>

                        <HeaderStyleDefault TextOverflow="Ellipsis" Cursor="Hand"                              " CustomRules="background-image:url(/ig_common/images/Office2003OliveBG.png);background-repeat:repeat-x;">

                            <BorderDetails ColorTop="215, 223, 193" ColorLeft="215, 223, 193"></BorderDetails>

                        </HeaderStyleDefault>

                        <FrameStyle Width="824px" BorderWidth="1px"                             ></FrameStyle>

                        <FooterStyleDefault >

                            <BorderDetails ></BorderDetails>

                        </FooterStyleDefault>

                        <ClientSideEvents BeforeExitEditModeHandler="BeforeExitEditMode" BeforeEnterEditModeHandler="BeforeEnterEditmode"

                            BeforeSortColumnHandler="beforesort" DblClickHandler="MyDblClick" CellClickHandler="GridCellClick"

                            AfterRowDeletedHandler="AfterDelete" AfterEnterEditModeHandler="HandleAfterEnterEditMode" AfterRowActivateHandler="AfterRowActivate"

                            MouseOverHandler="MouseOver" InitializeRowHandler="initializerow" MouseOutHandler="MouseOut" BeforeRowDeletedHandler="BeforeDelete"

                            InitializeLayoutHandler="InitializeGrid" ClickCellButtonHandler="CellButtonClick"></ClientSideEvents>

                        <SelectedHeaderStyleDefault Font-Bold="True"></SelectedHeaderStyleDefault>

                        <EditCellStyleDefault BorderWidth="0px" BorderStyle="None"></EditCellStyleDefault>

                        <SelectedRowStyleDefault ForeColor="White" BackColor="#F09D21" CustomRules="background-image:url(/ig_common/images/Office2003SelRow.png);background-repeat:repeat-x;"></SelectedRowStyleDefault>

                        <RowStyleDefault >

                            <Padding Left="3px"></Padding>

                            <BorderDetails WidthLeft="0px" WidthTop="0px"></BorderDetails>

                        </RowStyleDefault>

                    </DisplayLayout>

                    <Bands>

                        <igtbl:UltraGridBand>

                            <COLUMNS>

                                <igtbl:UltraGridColumn Type="checkbox" IsBound="True"></igtbl:UltraGridColumn>

                            </COLUMNS>

                        </igtbl:UltraGridBand>

                        <igtbl:UltraGridBand>

                            <ROWEDITTEMPLATE>

                               

// add control for row template for editing and there will a ok button and cancel button                               

                                                            </ROWEDITTEMPLATE>

                            <ROWTEMPLATESTYLE

                                <BORDERDETAILS ></BORDERDETAILS>

                            </ROWTEMPLATESTYLE>

                        </igtbl:UltraGridBand>

                    </Bands>

                </igtbl:ultrawebgrid>

It has some clientside events ,after dropping it it have no clientside event tag.

you have to add that tag that is added in above.

that is

<ClientSideEvents BeforeExitEditModeHandler="BeforeExitEditMode" BeforeEnterEditModeHandler="BeforeEnterEditmode"

                            BeforeSortColumnHandler="beforesort" DblClickHandler="MyDblClick" CellClickHandler="GridCellClick"

                            AfterRowDeletedHandler="AfterDelete" AfterEnterEditModeHandler="HandleAfterEnterEditMode" AfterRowActivateHandler="AfterRowActivate"

                            MouseOverHandler="MouseOver" InitializeRowHandler="initializerow" MouseOutHandler="MouseOut" BeforeRowDeletedHandler="BeforeDelete"

                            InitializeLayoutHandler="InitializeGrid" ClickCellButtonHandler="CellButtonClick"></ClientSideEvents>

Every clientside event calling a javascript function.

for example in above  AfterRowActivateHandler="AfterRowActivate"

AfterRowActivateHandler calling AfterRowActivate function.

<script language="javascript">

function AfterRowActivate(gn, rowID)

            {

               

                var grid=igtbl_getGridById("UltraWebGrid1");

               

                var row=igtbl_getElementById(rowID);

                var n = rowID.replace("UltraWebGrid3r_","");

                   var x=grid.Rows.getRow(n).getCell(0).getValue();

               

               

            }   

</script>

passing two argument one for id of grid and one for id of row.

you can find the value of a cell using like this grid.Rows.getRow(n).getCell(0).getValue(); and assign to a control.

there are several clientside event that i have mentioned earlier.

and you try it using these function for respective clientsideevent.

<script language="javascript">

    function BeforeExitEditMode(tableName, itemName)

             {

                // Obtain the Row object for the current cell

                var row = igtbl_getRowById(itemName);

                // Obtain the Cell object for Column 9

                var cell = row.getCell(7);

               

                // Update the Cell value in Column 9

                //cell.setValue("Updated");

                    return 0;

            }

function BeforeEnterEditmode(gridname, cellid)

        {

           

       

                    var row=igtbl_getRowById(cellid);

               

                    var value=row.getCell(0).getValue();

                   

                   

                    if(value == "false")

                    {

                   

                        alert("plz check the checkbox");

                        return true;

                    }

                    else

                    {

                       

                        return false;

                    }

               

                   

    }           

function beforesort()

        {

            var grid = igtbl_getGridById('UltraWebGrid1');

            grid.Allowsort=3;

        }

function GridCellClick (gridName,CellID,button)

            {

               

                    if(button == 2)

                    {

                       

                        igtbl_UltraWebgrid3('UltraWebgrid3', event);

                        return true;

                    }

            }

            ROW_HEIGHT = 40;

            ROW_HEIGHT_DELTA = 10;

function MyDblClick(tableName,itemName)

        {

            var row = igtbl_getRowById(itemName);

           

            var cell = igtbl_getElementById(itemName);

            var parts = itemName.split("_");

             var grid = igtbl_getGridById('UltraWebGrid1');

             grid.AllowUpdate = true;

            if(parts[2]==1)

            {

           

                alert("can't be edited");

               

                grid.AllowUpdate = false;

                return false;

            }

            if (row != null)

            {

                if (row.Element.style.height == "")

                {

                row.Element.style.height = ROW_HEIGHT;

                }

                oldheight = parseInt(row.Element.style.height.replace(/px/,''));

                igtbl_resizeRow("UltraWebGrid1", row.Element.id, oldheight + ROW_HEIGHT_DELTA)

            }

               

           

        }

function HandleAfterEnterEditMode(gridID, cellID)

        {

            var cell = igtbl_getCellById(cellID);

            cell.Element.style.backgroundColor = "#99FFFF";

        }

    function AfterDelete()

        {

            // set deleting to true so when deleting

            // multiple rows confirm is shown only once

            deleting=true;

            del=true;

        }

function MouseOver(tableName, itemName, type)

        {

           

            if(type == 0)

            { // Are we over a cell

            var cell = igtbl_getElementById(itemName);

           

           

            cell.style.cursor = 'hand';

            cell.style.color = 'red';

           

            var label = document.getElementById("mylebel");

            var parts = itemName.split("_");

            if(label && parts.length>=3)

            label.innerHTML = "Current Row:" + parts[1] + " - Current Column:" + parts[2];//add a label control to your webform

            }

        }

function AfterRowActivate(gn, rowID)

            {

               

                var grid=igtbl_getGridById("UltraWebGrid1");

               

                var row=igtbl_getElementById(rowID);

                var n = rowID.replace("UltraWebGrid3r_","");

                //var x=grid.Rows.getRow(n).getCell(0).getValue();

               

               

            }   

 function InitializeRow(tableName,rowName)

           {

            var icount;

           

            var row = igtbl_getElementById(rowName);

            var FirstActiveCell = igtbl_getBandFAC(tableName, row);

            var objDd = document.getElementById("commonfield_drpdwn");

            igtbl_getCellById(row.cells[FirstActiveCell+2].id).setValue(objDd.options[objDd.selectedIndex].text);

             var x=document.getElementById("commonfield_drpdwn").options[document.getElementById("commonfield_drpdwn").selectedIndex].value;

            igtbl_getCellById(row.cells[FirstActiveCell+3].id).setValue(x);

             igtbl_getCellById(row.cells[FirstActiveCell+4].id).setValue(0);

            igtbl_getCellById(row.cells[FirstActiveCell+7].id).setValue(false);

           

            igtbl_getCellById(row.cells[FirstActiveCell+5].id).setValue(0);

            igtbl_getCellById(row.cells[FirstActiveCell+6].id).setValue(0);

           

            igtbl_getCellById(row.cells[FirstActiveCell+8].id).setValue(false);

           

            igtbl_getCellById(row.cells[FirstActiveCell+0].id).setValue(-1); //-1 for adding a new row

            igtbl_getCellById(row.cells[FirstActiveCell+9].id).setValue(0);

           

            flagExitAlert=1;

          

            }

           

          

             function CellButtonClick(gridId, cellId) {

            var oGrid = igtbl_getGridById(gridId);

        var oRow = igtbl_getRowById(cellId);

        oRow.editRow();

    }

function MouseOut(tableName, itemName, type)

        {

            if(type == 0) { // Are we over a cell

            var cell = igtbl_getElementById(itemName);

           

            cell.style.color = 'black';

           

            }

        }

    function BeforeDelete(gridname, rowid)

            {

                    if(!deleting) // used to determine if confirm box has shown yet

                    {

                    // show the confirm box

                    del = confirm("You sure you want to delete row(s)");

                    // set deleting to true so confirm is not shown again

                    deleting=true;

                    }

                    // returning true cancels the event so return the opposite

                    // of what the user selected in the confirm box

                    return !del;

                    alert(del);

            }

</script&gt;

you can editrow template means when you click a popuplike window will there where cell values will in textboxes or in other control where it can be editable.there you can edit it and there are two buttos that is ok button and cancel button.if you click ok button cell value will change according to your changes.

Bind a dropdown according to data in another drop down using traditional AJAX

2010-02-22T10:08:00.001-08:00

Code for client side written within script:

function CallTemplate()

            {

           

              //alert(document.getElementById('cmbAssignTo_cmbSimple').value);

                   

                   var objDd=  document.getElementById('ddlmenu')

                  

                    var strValue = objDd.options[objDd.selectedIndex].value;                   

                   

                    //Create XMLHttpRequest object:'request'

                       

                        CreateXmlHttpRequestObject();

                       

                        //Build the required Query string

                        var sPass=1;

                       

                        var retrieveParam = 'id='+ strValue;

                       

                        var retrieveURL = "AJAX.aspx";

                        var url = retrieveURL + '?' + retrieveParam;

                       

                        request.open('GET',url,true);

                       

                        request.onreadystatechange = CheckTemplate;

                   

                        request.send(null);   

            }

               

            function CheckTemplate()

            {

                document.getElementById("ddlsubmenu").innerText="";

                if(request.readyState == 4 || request.readyState == 'complete')

                {

                    if(request.status == 200)

                    {   

                            var opt=document.createElement("option");

                            opt.value="-1";

                            opt.text="----select subcategory---";

                            document.getElementById("ddlsubmenu").add(opt);

                            var DdVisitTemp = document.getElementById("ddlmenu");

                           

                            var rootFile = request.responseXML.documentElement;

                         

                            var Id = rootFile.getElementsByTagName('Id');

                           

                            var Name = rootFile.getElementsByTagName('Name');

                           

                              if(Id.length > 0 || Name.length > 0)

                              {

                       

                                for(var i=0;i
                                {
                                   
                                       if(Name.length > 0)
                                       {
                                         var opt=document.createElement("option");
                                       
                                        opt.value=Id[i].text;
                                           
                                        opt.text=Name[i].text;
                                       
                                        document.getElementById("ddlsubmenu").add(opt);
                                       
                                      }
                                   
                                }
                               
                            }
                             
                    }//    inner IF       
           
            } // Outer IF
           
        }
       
        function CreateXmlHttpRequestObject()
            {
                try
                {
                    request = new XMLHttpRequest();
                }
                catch(nething)
                {
                    try
                    {
                        request = new ActiveXObject('Msxml2.XMLHTTP');
                    }
                    catch(othr)
                    {
                        try
                        {
                            request = new ActiveXObject('Microsoft.XMLHTTP');
                        }
                        catch(err)
                        {
                            request = false;
                        }
                    }
                }
                if(!request)
                {
                    alert("Error initializing XMLHttpRequest object!");
                }
            }

code for ajax page i.e ajax.aspx

private void Page_Load(object sender, System.EventArgs e)
        {
                   
                        string id=string.Empty ;
            System.Text.StringBuilder strXml;
            string passedValue = Request.QueryString["id"];

                        string strFill=" select  PK_PRIMARY_KEY,TITLE_SUBMENU from SUBJECT_SUBMENU where FK_SUBJECTMENU_ID = '" + id + "' ";
           
            DataTable dttemp= con.connectiondatatable(strFill);
           


            int j=dttemp.Rows.Count;
            strXml = new System.Text.StringBuilder ();
            strXml.Append("");
           
            if(j > 0)
            {
             
                for(int i=0 ; i
                {
                   
                    strXml.Append(""+dttemp.Rows[i]["PK_PRIMARY_KEY"].ToString() +" ");
                    strXml.Append(" "+dttemp.Rows[i]["TITLE_SUBMENU"].ToString()+" ");
                }

            }
            else
            {
               
                strXml.Insert(-1,"");
               
            }

            strXml.Append("");
            XmlDocument xTemplate = new XmlDocument();
            xTemplate.LoadXml(strXml.ToString());

            Response.ContentType = "text/xml";
            Response.CacheControl = "No-cache";
            xTemplate.Save(Response.OutputStream);
           
            // Put user code to initialize the page here
        }

There are two tables

1.SUBJECTMENU

2.SUBJECT_SUBMENU

Relation between them

SUBJECT_SUBMENU.FK_SUBJECTMENU_ID=SUBJECTMENU.PK_SUBJECTMENU_ID

Step 1:

create two tables must have relationship between them like above.

step 2:

Bind 1st dropdown on page load.

step 3:

Write code for client side as well as ajax page.

When u change 1st dropdown ,2nd dropdown will change.

How to create a ajax page:

Add a webform and delete all code that will bydefault in client except tag containing page inherit.

Example:

<%@ Page language="c#" Codebehind="AJAX.aspx.cs" AutoEventWireup="false" Inherits="KnowledgeSharing.AJAX" %>

except this one

Encrypt web config in Asp.net

2010-02-22T10:07:00.001-08:00

You can encrypt sections of a configuration file to protect sensitive

information used by your application. This improves security by making it difficult for unauthorized access even if an attacker gains access to your configuration file.

The .NET Framework includes two protected-configuration providers that can be used to encrypt sections of a configuration file.

·        RSAProtectedConfigurationProvider, which uses the RSACryptoServiceProvider to encrypt configuration sections.

·         DPAPIProtectedConfigurationProvider, which uses the Windows Data Protection API (DPAPI) to encrypt configuration sections.

The unprotected app.config file

This is what the app.config file looks like when it is unprotected:

<?xml version="1.0" encoding="utf-8" ?>

<configuration>

<connectionStrings>

<add name="SampleSqlServer" connectionString=   "Data Source=localhost;Integrated Security=SSPI;

  Initial Catalog=SampleDatabase;" />

</connectionStrings>

</configuration>

The protected app.config file

This is what the app.config file looks like when it is protected using the built-in .NET 2.0 framework ConfigurationSection.Protect () functionality:

Using RsaProtectedConfigurationProvider

<?xml version="1.0" encoding="utf-8" ?>

<configuration>

    <connectionStrings

 configProtectionProvider="RsaProtectedConfigurationProvider">

    <EncryptedData Type="http://www.w3.org/2001/04/xmlenc#Element"

      xmlns="http://www.w3.org/2001/04/xmlenc#">

      <EncryptionMethod Algorithm="http://www.w3.org/2001/04/xmlenc#tripledes-cbc" />

      <KeyInfo xmlns="http://www.w3.org/2000/09/xmldsig#">

        <EncryptedKey xmlns="http://www.w3.org/2001/04/xmlenc#">

          <EncryptionMethod Algorithm="http://www.w3.org/2001/04/xmlenc#rsa-1_5" />

          <KeyInfo xmlns="http://www.w3.org/2000/09/xmldsig#">

            <KeyName>RSA Key</KeyName>

          </KeyInfo>

          <CipherData>            <CipherValue>RXO/zmmy3sR0iOJoF4ooxkFxwelVYpT0riwP2mYpR3FU+r6BPfvsqb384pohivkyNY7Dm4lPgR2bE9F7k6TblLVJFvnQu7p7d/yjnhzgHwWKMqb0M0t0Y8DOwogkDDXFxs1UxIhtknc+2a7UGtGh6Di3N572qxdfmGfQc7ZbwNE=

            </CipherValue>

          </CipherData>

        </EncryptedKey>

      </KeyInfo>

      <CipherData>        <CipherValue>KMNKBuV9nOid8pUvdNLY5I8R7BaEGncjkwYgshW8ClKjrXSM7zeIRmAy/cTaniu8Rfk92KVkEK83+UlQd+GQ6pycO3eM8DTM5kCyLcEiJa5XUAQv4KITBNBN6fBXsWrGuEyUDWZYm6Eijl8DqRDb11i+StkBLlHPyyhbnCAsXdz5CaqVuG0obEy2xmnGQ6G3Mzr74j4ifxnyvRq7levA2sBR4lhE5M80Cd5yKEJktcPWZYM99TmyO3KYjtmRW/Ws/XO3z9z1b1KohE5Ok/YX1YV0+Uk4/yuZo0Bjk+rErG505YMfRVtxSJ4ee418ZMfp4vOaqzKrSkHPie3zIR7SuVUeYPFZbcV65BKCUlT4EtPLgi8CHu8bMBQkdWxOnQEIBeY+TerAee/SiBCrA8M/n9bpLlRJkUb+URiGLoaj+XHym//fmCclAcveKlba6vKrcbqhEjsnY2F522yaTHcc1+wXUWqif7rSIPhc0+MT1hB1SZjd8dmPgtZUyzcL51DoChy+hZ4vLzE=

        </CipherValue>

      </CipherData>

    </EncryptedData>

  </connectionStrings>

</configuration>

Using  DataProtectionConfigurationProvider

<?xml version="1.0" encoding="utf-8" ?>

<configuration>

<connectionStrings configProtectionProvider="DataProtectionConfigurationProvider">

    <EncryptedData>

      <CipherData>        <CipherValue>AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAAC604ocVBjE6iwNotzM4ZMQQAAAACAAAAAAADZgAAqAAAABAAAABWwjYy7bwZdDql3nImdFcfAAAAAASAAACgAAAAEAAAAK/xpOyKKzMSGwg/XsFAi/5gAQAAVOSKtGe5k21uyyxt35111auSE746lH5Ij8E1839D9e/eoFKvxCXFkBtlQD/sftjEGzfrmeTQQMMP2c5kWCGINH1N5NOReK+vOxZHQzkUJxn4D2fOxknLrprMvnRawhPmuqLcHC3iZTxWnxYL9pSGs3Gk9bEbhhFFNZN/0AvJ6OlqfvhpaI6zA1NIbS4MYcQ3lAsmupjE4deOB7ocTooJTWoToAxVJ0gC+hJnQ7ZwHiQLUIGmeaAs8nt7t8NJSWMhsFHbYzjpSGO4q8Iet1xsCnbxo5CH/N9mdC8SZ9Nz4XLt9TlmWJhjFIuCbv7YoqhI8895EQsOsQ9VumFaj1jIqNHMS8lWLcZULC7ZM1Yn/Dvhk+bNgaljLNRotdPeMIwLAbqVUY9kzeM1alVbFNkmC0uvApCli4lAq5n9rNyK5xktzxbA0QFRrI2W1A9ns3Y6g5Jcy9ztdEVfSbU+jGkvPBQAAACdTt+x46DXMgPiRLp9lMd36IFWsA==</CipherValue>

      </CipherData>

    </EncryptedData>

  </connectionStrings>

</configuration>

How this was done

In order to protect a section of the app.config file, we can use the ProtectSection() function to encrypt that portion of the file. There is no need to unprotect the section. We can still read the information from the section; the built-in configuration manager will automatically decrypt the cipher text.

private void ProtectSection(string sectionName)

{

    // Open the app.config file.

    Configuration config = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None);

   

    // Get the section in the file.

    ConfigurationSection section = config.GetSection(sectionName);

   

    // If the section exists and the section is not readonly, then  

    // protect the section.

    if (section != null)

    {

        if (!section.IsReadOnly())

        {

            // Protect the section.

            section.SectionInformation.ProtectSection ("RsaProtectedConfigurationProvider");

            section.SectionInformation.ForceSave = true;

            // Save the change.

            config.Save(ConfigurationSaveMode.Modified);

         }

     }

}

Getting the value

As stated above, there is no need to unprotect or decrypt the app.config file to get the value of the connection string; the decryption is handled by the .NET 2.0 framework. Simply open the app.config file and read the value of the connection string, like this:

// Open the app.config file.

Configuration config = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None);

// Display the current connection string.

txtConnString.Text = config.ConnectionStrings.ConnectionStrings["SampleSqlServer"].ConnectionString;

How to restrict user to copy from a textbox or paste text to textbox using javascript

2010-02-22T10:06:00.001-08:00

This code demonstrate how to restrict user to copy from a textbox or paste text to textbox using JavaScript.

Here is the code :

<script language="javascript">

function copy() {

    alert("Can't copy the text");

    return false;

}

function paste() {

    alert("can't paste text");

    return false;

} 

</script>

<asp:TextBox ID="TextBox2" runat="server" Text="hi" oncopy="return copy();" onpaste="return paste();"></asp:TextBox>

Thanks,
Abhay

How to use autocompleteTextbox in Ajax

2010-02-22T10:05:00.001-08:00

It is easier for user searching a text when you enter some text, the all text begin with with that text will show so that you can chose it and go for searching.the type of thing is used by google seach,wikimapedia etc.i have used in my project.

First you have install ajaxtoolkit ,add reference of it in your application.

ADD ScriptManager then add a textbox.

Drag and drop AutoCompleteExtender from it then the code will be like this

<%@ Register assembly="AjaxControlToolkit" namespace="AjaxControlToolkit" tagprefix="cc1" %>

<body>

    <form id="form1" runat="server">

    <div>

      <asp:ScriptManager ID="ScriptManager1" EnablePageMethods=true runat="server">

        </asp:ScriptManager>

    <asp:TextBox ID="txt1" runat=server ></asp:TextBox>

  

    <cc1:AutoCompleteExtender

    runat="server"

    ID="autoComplete1"

    TargetControlID="txt1"//target control

    ServiceMethod="Getdata"//method should be pagemethod

    MinimumPrefixLength="1" //minimum character for showing data

    CompletionInterval="100"//completioninterval

    EnableCaching="true"

    CompletionSetCount="20"

     >

      

</cc1:AutoCompleteExtender>

     

    </div>

    </form>

</body>

Then goto serverside

add namespace

using System.Web.Services;

But reference for webservice added before if not then add first.

Write function for getting data

[WebMethod]//MUST BE USED BEFORE FUNCTION

//METHOD MUST BE STATIC

           public static string[] Getdata(string text, int count)

          {

          

                      string sql = "Select name from  L_PHYSICALEXAM Where name like @text";

            SqlConnection conn = new SqlConnection( your connection string);

            SqlDataAdapter da = new SqlDataAdapter(sql,conn);

           

            da.SelectCommand.Parameters.Add("@prefixText", SqlDbType.VarChar, 50).Value = text+ "%";

            DataTable dt = new DataTable();

            try

            {

                da.Fill(dt);

            }

            catch(System.Exception er)

            {

                string st = er.ToString();

            }

         

            string[] items = new string[dt.Rows.Count];

            int i = 0;

            foreach (DataRow dr in dt.Rows)

            {

               items.SetValue(dr["Name"].ToString(),i);

  i++;             }

            return items;

          

        }

When you enter first character it will start show those data starting from that character from database.

How to pass value from parent page to pop up without using querystring

2010-02-22T10:04:00.001-08:00

If you want pass some value from parent page to pop up without using query string then you can pass it as argument.

Take this example

For modalDialogue:

var retnBlood = window.showModalDialog("path of the pop up page, pass your argument, "status:No;dialogHeight:400px;dialogWidth:600px;resizable:0;scrollbars:1;center:yes");

You can find the value of argument in modal dialogue by this code

For Modal Dialogue:

function Show()

{

 var argVal = window.dialogArguments;

//save it in a hiddenfield as use it

}

Call this function at pageload using below code

protected void Page_Load(object sender, EventArgs e)

{               

ClientScript.RegisterStartupScript(this.GetType(), "alert", "&ltscript&gtShow();&lt/script&gt");

}

If you are using simple pop up instead of modal dialogue then use like below

function Show()

{

 var argVal = Window.opener;

//save it in a hiddenfield as use it

}

Thanks,
Abhay