Programming & Interview questions

Assign the null value into the DataRow

2012-02-19T00:13:00.001-08:00

this code is shown for assigning null values into the

Datarow...

DataRow[] rows = dataTable1.Select("EqID = " + Convert.ToInt32(txtEquip.Attributes["EquipId"]));
rows[0]["Ph_number"] = string.IsNullOrWhiteSpace(txtPhNumber.Text) ? DBNull.Value : (object)Convert.ToInt32(txtPhNumber.Text);

Target control with in the update panel

2012-02-18T23:58:00.000-08:00

Move the ModalPopupExtender to the first update panel:

<asp:ImageButton ID="imgSearch" runat="server" Width="15px" ImageUrl="~/images/search.png"
                            AlternateText="Select Area" OnClientClick="FileUploadPopup()" />                      
                      
    <ajax:ModalPopupExtender ID="mpopArea1" runat="server" OkControlID="imgClose"
        PopupControlID="pnlPopUpsearch" BackgroundCssClass="modalBackground" TargetControlID="imgSearch">
    </ajax:ModalPopupExtender>
Panel out side of the update panel
    <asp:Panel ID="pnlPopUpsearch" runat="server">
      <asp:Label ID="lblTest" runat="server" Text="Welcome">

      </asp:Label>

 </asp:Panel>

ValidatorCalloutExtender in asp.net

2012-02-18T23:37:00.000-08:00

<asp:DropDownList runat="server" ID="ddlEquipment" AppendDataBoundItems="true"
                        class="class1">
                        <asp:ListItem Value="-1">--Select Equipment--</asp:ListItem>
                    </asp:DropDownList>
                    <asp:RequiredFieldValidator ID="rfv_Equipment" runat="server" ControlToValidate="ddlEquipment"
                        InitialValue="-1" ErrorMessage="Please Select Equipment" Display="None"
                        ValidationGroup="Request">
                    </asp:RequiredFieldValidator>
                    <ajax:ValidatorCalloutExtender ID="ValidatorCalloutExtender5" runat="server" PopupPosition="BottomLeft"
                        TargetControlID="rfv_Equipment" Width="180px" WarningIconImageUrl="~/images/icon_blue.png"
                        CssClass="CustomValidatorCalloutStyle">

AsyncPostBackTrigger in UpdatePanel

2012-02-18T23:33:00.000-08:00

Could not find an event named 'OnSelectedIndexChanged' on associated control 'dropdownlist1' for the trigger in UpdatePanel 'UpdatePanel1'...

Use selectedindexchanged in the place of OnSelectedIndexChanged for eventname of AsyncPostBackTrigger... 

<asp:UpdatePanel ID="upnlRestrictedArea" runat="server">
         <ContentTemplate>
            <asp:Panel ID="pnlResArea" runat="server" Style="display: none" BackColor="#F9F6F4"
        Height="350px" Width="380px">
        <div class="PopUpheader">
            <span id="Span1" class="msg">Select Restricted Area</span> <span style="float: right">
                <asp:ImageButton ID="imgClose_resArea" AlternateText="Close" runat="server" ImageUrl="~/images/favicon.ico" /></span>
        </div>
        <table width="85%" class="cssform">
            <tr>
                <td>
                    Select Area :
                </td>
                <td>
                    <asp:DropDownList ID="ddlRestricted" runat="server" AutoPostBack="true" AppendDataBoundItems="true"
                        OnSelectedIndexChanged="ddlResArea_SelectedIndexChanged">
                        <asp:ListItem Text="--Select Area--" Value="0"></asp:ListItem>
                    </asp:DropDownList>
                </td>
            </tr>
        </table>
        <br />
    </asp:Panel>
         </ContentTemplate>
         <Triggers>
           <asp:AsyncPostBackTrigger ControlID="ddlRestricted" EventName="selectedindexchanged" />
         </Triggers>
     </asp:UpdatePanel>

Get the values from devexpress Gridview in asp.net

2012-02-16T10:26:00.000-08:00

protected void grvUserDetails_RowCommand(object sender, ASPxGridViewRowCommandEventArg

s e)
    {
        if (e.CommandArgs.CommandName == "Remove")
        {
            int noOfSelectedRequests = grvUserDetails.FocusedRowIndex;
            int id = Convert.ToInt32(e.CommandArgs.CommandArgument.ToString());
            var varSitename = grvUserDetails.GetRowValues(e.VisibleIndex, "FirstName");
            var objValres = grvUserDetailsGetRowValues(e.VisibleIndex, "AreaId");
            var objVal1 = grvUserDetails.GetRowValues(e.VisibleIndex, "Id");
           
        }
    }

Row Index with in the Data Table in asp.net

2012-02-16T10:09:00.000-08:00

 foreach (DataRow drow in dtbl.Rows)
        {
            int irow = dtbl.Rows.IndexOf(drow);
            DevExpress.Web.ASPxEditors.ASPxCheckBox chkIsolated = (DevExpress.Web.ASPxEditors.

ASPxCheckBox)Aspxgrid2.FindRowCellTemplateControl(irow, null, "chkIso");
            if (chkIsolated.Checked == true)
            {
                drow["isIsolate"] = true;
            }    
}

In the above Example also described about Checkbox list of devexpress with in the devexpress gridview in asp.net

Checkboxlist Checked Event Client Side Using JavaScript

2012-02-16T10:03:00.000-08:00

<script type="text/javascript">  

function CheckBoxChecked(ChkID) {
            var status = false;
            var CheckBoxID = document.getElementById('<%=chkHvecYes.ClientID%>');
            if (CheckBoxID.checked == true){
            status=true;
                return status;}
            else {
                alert('Please Select CheckBox');
                return status;
            }

        }

//chkHvecYes  is checkboxlist Id

function SeletedTab() {          
            var checkBoxArray = document.getElementById('<%=chkIso_action.ClientID%>').getElementsByTagName('input');           
                var checkBoxRef = checkBoxArray[5];     // for 7th Item in the checkboxlist 

                if (checkBoxRef.checked) {

document.getElementById('plock').style.display = "block";
 document.getElementById('plock').style.visibility = "visible";
                }

else
                    document.getElementById('plock').style.display = "none";document.getElementById('plock').style.visibility = "hidden";
            
        }

</script>

<p id="plock">

  Checkboxlist Checked Event or Onclick Client Side Using JavaScript

</p> 

<asp:CheckBoxList  ID="chkIso_action" runat="server" onclick="SeletedTab() ">

<asp:ListItem Text="Test1" Value="0">

<asp:ListItem Text="Test1" Value="1">

<asp:ListItem Text="Test1" Value="2">

<asp:ListItem Text="Test1" Value="3">

<asp:ListItem Text="Test1" Value="4">

<asp:ListItem Text="Test1" Value="5">    

</asp:CheckBoxList >

<asp:Button runat="server" Text="Submit" ID="btnHSubmit" OnClientClick="CheckBoxChecked(this)"></asp:Button>

OutPut Cache in asp.net

2012-02-12T06:39:00.000-08:00

Setting OutPut Cache in asp.net

<%@ OutputCache Duration="20" VaryByParam="none" %> //Created in Web User Control

Char[] Array in asp.net

2012-02-12T05:57:00.000-08:00

 char[] arrayInString = "for testing characters";

 int icnt = arrayInString.Length;   //getting Character array length

Generate Controls Dynamically and adding to the page in asp.net

2012-02-10T09:58:00.000-08:00

Getting data from database and generate controls based on table(database) columns and rows, generate label and textbox controls with in a html table dynamically and added to the Page in asp.net..... 

private void getallowance()

    {

        DataTable dt = BLayer.getAllowColumns();

        if (dt.Rows.Count > 0)

        {

            //HtmlTableRow htr = new HtmlTableRow();

            Table tbl = new Table();

            tbl.ID = "table1";

            Page.Form.Controls.Add(tbl);

            foreach (DataRow dr in dt.Rows)

            {

                Label lbl = new Label();

                HtmlTableRow htr = new HtmlTableRow();

                HtmlTableCell htc = new HtmlTableCell();

                //htc.ColSpan = 2;

                for (int irow = 0; irow < 6; irow++)

                {

                    htc = new HtmlTableCell();

                    string strcolname = dr["columnname"].ToString();

                    string[] strtestcol = strcolname.Split("_".ToCharArray());

                    if (strtestcol.Length <= 1)

                    {

                        if (strcolname.ToUpper() == "CUG" || strcolname.ToUpper() == "TDS" || strcolname.ToUpper() == "LOAN")

                        {

                            if (irow == 4)

                            {

                                lbl.ID = "lbl" + strcolname;

                                lbl.Text = dr["Heading"].ToString();

                                htc.Controls.Add(lbl);

                                htc.Width = "265";

                            }

                            if (irow == 5)

                            {

                                TextBox TextBox1 = new TextBox();

                                TextBox1.ID = "txt" + strcolname;

                                TextBox1.CssClass = "formstyle01";

                                TextBox1.Enabled = false;

                                TextBox1.Font.Bold = true;

                                TextBox1.Text = string.Empty;

                                TextBox1.Style.Add("text-align", "right");

                                htc.Controls.Add(TextBox1);

                                htc.Width = "150";

                            }

                            htr.Cells.Add(htc);

                            tblcolded.Rows.Add(htr);

                        }

                    }

                    else

                    {

                        //htr = new HtmlTableRow();

                        if (irow == 2)

                        {

                            htc.Style["bgcolor"] = "#807d7d";

                            //htc.Controls.Add(cell);

                        }

                        if (irow == 3)

                        {

                            //row.Style["bgcolor"] = "#807d7d";

                            //htc.Controls.Add(row);

                        }

                        if (strtestcol[1].ToString() == "a")

                        {

                            if (irow == 0)

                            {

                                lbl.ID = "lbl" + strcolname;

                                lbl.Text = dr["Heading"].ToString();

                                htc.Controls.Add(lbl);

                                htc.Width = "265";

                            }

                            if (irow == 1)

                            {

                                TextBox TextBox1 = new TextBox();

                                TextBox1.ID = "txt" + strcolname;

                                TextBox1.CssClass = "formstyle01";

                                TextBox1.Enabled = false;

                                TextBox1.Font.Bold = true;

                                TextBox1.Text = string.Empty;

                                TextBox1.Style.Add("text-align", "right");

                                htc.Controls.Add(TextBox1);

                                //htr.Cells.Add(htc);

                                htc.Width = "150";

                                htc.VAlign = "middle";

                                htc.Align = "left";                               

                            }

                            htr.Cells.Add(htc);

                            htr.VAlign = "top";

                            tblcol.Rows.Add(htr);

                        }

                        else if (strtestcol[1].ToString() == "d")

                        {

                            if (irow == 4)

                            {

                                //Label lbl = new Label();

                                lbl.ID = "lbl" + strcolname;

                                lbl.Text = dr["Heading"].ToString();

                                htc.Controls.Add(lbl);

                                htc.Width = "265";

                            }

                            if (irow == 5)

                            {

                                TextBox TextBox1 = new TextBox();

                                TextBox1.ID = "txt" + strcolname;

                                TextBox1.CssClass = "formstyle01";

                                TextBox1.Enabled = false;

                                TextBox1.Font.Bold = true;

                                TextBox1.Style.Add("text-align", "right");

                                TextBox1.Text = string.Empty;

                                htc.Controls.Add(TextBox1);

                                //htr.Cells.Add(htc);

                                htc.Width = "150";

                                //tblcol.Rows.Add(htr);

                            }

                            htr.Cells.Add(htc);

                            //tblcol.Rows.Add(htr);

                            tblcolded.Rows.Add(htr);

                        }

                    }               

                }               

            }

        }

    }

Javascript Event for RadioButton in asp.net

2012-02-10T09:52:00.000-08:00

<script language="javascript" type="text/javascript">

  function RadioPermit(ID) {

            document.getElementById('<%=txtEndDate.ClientID%>').disabled = !document.getElementById(ID).checked;

              document.getElementById('<%=irblTemp.ClientID%>').checked = !document.getElementById(ID).checked;

              }

</script>

<input type="radio" runat="server" id="irblPermit" class="rbNormal" name="Permit"  onclick="RadioPermit(this.id);" />

<asp:TextBox ID="txtEndDate" Enabled="false" runat="server" CssClass="txNormal" onkeypress="return false;"></asp:TextBox> 

<input type="radio" runat="server" id="irblTemp" class="rbNormal" checked="true" />

Themes in asp.net

2012-02-10T09:45:00.000-08:00

Creating themes / skin file in a folder App_Themes ,Extension for themes /Skin is : .skin

<asp:GridView SkinID="GridViewSkin" runat="server" CssClass="gridview" >

        <AlternatingRowStyle CssClass="grdalt" />

        <PagerStyle CssClass="grdpgr" />

</asp:GridView>

<asp:Calendar width="250" DayStyle-Width="34" DayStyle-Height="15"   runat="server"
    CellPadding="0" CellSpacing="0" FirstDayOfWeek="Monday" ShowGridLines="True"
    DayStyle-BackColor="#F99B98" DayStyle-ForeColor="Black" DayStyle-Font-Names="Arial"
    NextPrevFormat="ShortMonth" SkinID="CalendarSkin"
    SelectionMode="None">
    <DayHeaderStyle BackColor="Black" Font-Names="Arial" ForeColor="White" Font-Size="9pt" />
    <DayStyle Font-Names="Arial" ForeColor="Black" Font-Size="9pt">
    </DayStyle>
    <TitleStyle BackColor="Gray" Font-Names="Arial" ForeColor="White" HorizontalAlign="Center" />
</asp:Calendar>

<asp:TextBox SkinID="textboxSkin" CssClass="styleNormal" Width="180px"></asp:TextBox>

RowDataBound in gridview

2012-02-10T09:34:00.000-08:00

protected void grvdata_RowDataBound(object sender, GridViewRowEventArgs e)

    {

        try

        {

            if (Session["user"] == null)

            {

               Response.Redirect("../login.aspx");

            }

            else

            {

                if (e.Row.RowType == DataControlRowType.DataRow)

                {

                    DataRow dr = ((DataRowView)e.Row.DataItem).Row;

                  string applictnno = dr["applictnno"].ToString();

                    string Plotno= dr["Plotno"].ToString();

                    ((HyperLink)e.Row.FindControl("linkforallexec")).NavigateUrl = string.Format("~/pages/Executive.aspx?Plotno={0}", Plotno+ "&&applicationno="+ applictnno);  // navigate from one page to another page through using query string

               }

            }

        }

        catch (Exception)

        {

            throw;

        }

    }

Onkeypress for textbox in asp.net

2012-02-10T09:28:00.000-08:00

protected void Page_Load(object sender, EventArgs e)

{

 txtdate.Attributes.Add("onkeypress", "return false;");

}

Sending Group Emails in asp.net

2012-02-10T09:26:00.000-08:00

private void GetApplnumber()

{

    if (Session["userData"] == null)

    {

        string strmsg = "Session has been expire, Please login again to continue";

        string stralert = "<script language=javascript>alert('" +strmsg + "');";

        stralert += "window.location='../login.aspx'</script>";

        Page.RegisterClientScriptBlock("alert", stralert);

    }

    else

    {

        user = (User1)Session["userData"];

        Executive = user.UserID.ToString();

        string applno = string.Empty;

        DataSet ds = new DataSet();

        ds = BussinessLayer.SendEmail(Executive, applno);  //getting data from database throug              BussinessLayer

        if (ds.Tables[0].Rows.Count > 0)

        {

            foreach (DataRow dr in ds.Tables[0].Rows)

            {

                if (dr["Email"].ToString() != string.Empty)

                {

                    Emails = Emails + dr["Email"].ToString() + ";" ;

//button click

protected void btnsend_Click(object sender, EventArgs e)

    {

        try

        {

            GetApplnumber();

            string id =Emails.ToString();

            string[] stremail = id.Split(';');

            for (int i = 0; i < stremail.Length - 1; i++)

            {

                MailMessage mailmm = new MailMessage();

                mailmm .From = new MailAddress("abc@def.com");

                mailmm .To.Add(new MailAddress(stremail[i].ToString()));

                mailmm .Subject = txtsubject.Text;

                mailmm .Body = txtbody.Text;

                mailmm .IsBodyHtml = true;

                SmtpClient client = new SmtpClient();

                client.EnableSsl = true;

                client.Timeout = 400000;

                client.Send(mailmm );

            }

        }

       catch(SmtpException ex)

        {

            lblres.Text = ex.ToString();

        }

    }

Using Hashtable in asp.net

2012-02-10T09:15:00.000-08:00

Hashtable hlist = new Hashtable();

hlist["applno"] = txtapplicationno.Text;

hlist["Flatno"] = txtflatno.Text;

hlist["Flatstataus"] = ddlflatstatus.SelectedValue;

hlist["Customername"] = txtcname.Text == "" ? string.Empty : txtcname.Text; //ternary operator in asp.net

hlist["amount"] = float.Parse(txtreceivedamt.Text);

string dueamt = txtdueamount.Text == "0" ? "0" : txtdueamount.Text;   //ternary operator in asp.net

File Upload in asp.net

2012-02-10T08:06:00.000-08:00

if (fUpload.PostedFile != null && fUpload.PostedFile.ContentLength > 0)
        {
            filename = Path.GetFileName(fUpload.PostedFile.FileName);
            string extension = Path.GetExtension(filename);
            string contentType = fUpload.PostedFile.ContentType;
            byte[] document = fUpload.FileBytes;
            ScriptManager.RegisterStartupScript(Page, this.GetType(), "Close", "CloseFileUploadPopUp();", true);
        }

Get the Content Type of File in asp.net

2012-02-10T08:01:00.000-08:00

 Response.ContentType = ReturnExtensions(fileExtn.ToString()); 

 //here fileExtn is string it may be .txt / .html /.avi etc...

 private string ReturnExtensions(string fileExtensions)
    {
        switch (fileExtensions)
        {
            case ".htm":
            case ".html":
            case ".log":
                return "text/HTML";
            case ".txt":
                return "text/plain";
            case ".doc":
                return "application/ms-word";
            case ".tiff":
            case ".tif":
                return "image/tiff";
            case ".asf":
                return "video/x-ms-asf";
            case ".avi":
                return "video/avi";
            case ".zip":
                return "application/zip";
            case ".xls":
            case ".csv":
                return "application/vnd.ms-excel";
            case ".gif":
                return "image/gif";
            case ".jpg":
            case "jpeg":
                return "image/jpeg";
            case ".bmp":
                return "image/bmp";
            case ".wav":
                return "audio/wav";
            case ".mp3":
                return "audio/mpeg3";
            case ".mpg":
            case "mpeg":
                return "video/mpeg";
            case ".rtf":
                return "application/rtf";
            case ".asp":
                return "text/asp";
            case ".pdf":
                return "application/pdf";
            case ".fdf":
                return "application/vnd.fdf";
            case ".ppt":
                return "application/mspowerpoint";
            case ".dwg":
                return "image/vnd.dwg";
            case ".msg":
                return "application/msoutlook";
            case ".xml":
            case ".sdxl":
                return "application/xml";
            case ".xdp":
                return "application/vnd.adobe.xdp+xml";
            default:
                return "application/octet-stream";
        }
    }

DataView in asp.net

2012-02-10T07:54:00.000-08:00

DepartmentsSectionsParameterBuilder pm1 = new DepartmentsSectionsParameterBuilder();
pm1.AppendEquals(DepartmentsColumn.AssetId, assetId.ToString());      

TList<DepartmentsSections> objDeptList = DataRepository.DepartmentsSectionsProvider.Find(pm1.GetParameters()); 

DataSet dsNode = new DataSet();

if (dsNode != null && dsNode.Tables[0].Count > 0 )

{

      dsNode = objDeptList.ToDataSet(true); //--Convert from List to dataset

      DataView dv = dsNode.Tables["Departments"].DefaultView;

dv.RowFilter = "SectionName='Section1'";

}

ModalPopupExtender in asp.net

2012-02-10T07:45:00.000-08:00

<asp:Button ID="btnTest" runat="server" Text="Click Here" />
       <ajax:ModalPopupExtender ID="mpopResArea" runat="server" OkControlID="imgClose_resArea"
     PopupControlID="pnlResArea" BackgroundCssClass="modalBackground" TargetControlID="btnTest">
    </ajax:ModalPopupExtender>
   <asp:Panel ID="pnlResArea" runat="server" style="display:none" BackColor="#F9F6F4" Height="350px" Width="380px" >
     <div class="PopUpheader">
                    <span id="Span1" class="msg">Select Restricted Area</span>
                    <span style="float:right">
                    <asp:ImageButton ID="imgClose_resArea" AlternateText="Close" runat="server" ImageUrl="~/images/close.gif" /></span>
                </div>
                <table width="85%" class="cssform">
                <tr>
                  <td>
                    Select Area :
                  </td>
                   <td>
                     <asp:DropDownList ID="ddlResArea" runat="server" AutoPostBack="true" AppendDataBoundItems="true" onselectedindexchanged="ddlResArea_SelectedIndexChanged">
                       <asp:ListItem Text="--Select Area--" Value="0"></asp:ListItem>
                     </asp:DropDownList>
                  </td>
                </tr>
                </table>
                <br />
                <center>
                     <dx:ASPxGridView ID="grvResarea_aspx" AutoGenerateColumns="False" KeyFieldName="Id;RestrictedAreaId" runat="server"
                            OnRowCommand="grvResarea_aspx_RowCommand">
                            <Columns>
                            <dx:GridViewDataTextColumn Caption="ID" FieldName="Id" Visible="false"></dx:GridViewDataTextColumn>
                            <dx:GridViewDataColumn Caption="Select">
                             <DataItemTemplate>
                               <asp:LinkButton ID="LinkButton1" runat="server" Text="Select" CommandName="Select" CommandArgument='<%# Eval("Id") %>'></asp:LinkButton>
                              </DataItemTemplate>
                            </dx:GridViewDataColumn>
                              <dx:GridViewDataTextColumn Caption="Restricted AreaID" VisibleIndex="2" FieldName="RestrictedAreaId"></dx:GridViewDataTextColumn>
                               <dx:GridViewDataTextColumn Caption="Site Name" VisibleIndex="3" FieldName="SiteName"></dx:GridViewDataTextColumn>
                            </Columns>
                 </dx:ASPxGridView>
                </center>
      </asp:Panel>

Bindable Property for User Control

2012-02-10T07:17:00.000-08:00

public string empName="";

//This property Makes bindable.

[System.ComponentModel.Bindable(true)] 

public string employeeName

{

get

{

      return empName;

}

set

{

      empName=value;

      this.txtName.Text = empName.ToString();

}

}

Convert the time to 24hr format in asp.net

2012-02-10T07:03:00.000-08:00

string[] strSTime =Convert.ToDateTime(Convert.ToDateTime(dview[0]["StartDtTime"]).ToShortTimeString()).ToString("H:mm").Split(":".ToCharArray());--Here dview means dataview

txtSDate.Text = Convert.ToDateTime(Convert.ToDateTime(txtDate.Text).ToShortDateString()).ToString("dd/MM/yyyy");--Converting date into dd/MM/yyyy format

rbl_test.SelectedValue = dview[0]["IsolationType"] == true ? "1" : "2";

TimeSpan ts;

ts = Convert.ToDateTime(Convert.ToDateTime(dview[0]["FinishDtTime"]).ToShortDateString()) - Convert.ToDateTime(Convert.ToDateTime(dview[0]["FromDate"]).ToShortDateString());--Calculating days using timespan in asp.net

Scrollbar in gridview

2012-02-08T10:10:00.000-08:00

For Scrollbar in devexpress gridview. 

<dx:ASPxGridView ID="gvSearch" runat="server" Width="98%" OnRowCommand="gvSearch_RowCommand"
                    KeyFieldName="ID" SettingsBehavior-AllowSort="

false" SettingsPager-Visible="false">
 <Settings ShowVerticalScrollBar="true" ShowHorizontalScrollBar="true" />

DBCC CHECKIDENT

2012-02-08T10:07:00.000-08:00

We can find the current identity seed by using DBCC checkident .

DBCC checkident (#a)

if we execute above query than we will find like below:

Checking identity information: current identity value 'some number', current column value 'some number'. 

DBCC CHECKIDENT ('tablename', 'RESEED', rowid)

Ex:DBCC CHECKIDENT ('IC_Request', 'RESEED', 2)

'table_name'

It Is the name of the table for which to check the current identity value .

RESEED

Specifies that the current identity value should be corrected.

Shortcut Keys in Visual Studio

2012-02-08T09:47:00.000-08:00

Ctrl + M + M --expand,minimize for single methods / events

Ctrl + M + O -- minimize for all methods / eventsCtrl + M + L -- expand for all methods / events