Dot.Net Seva: November 2017

Interview Questions-Answers ►
Home
C#
Asp.Net
Sql Server
Jquery
IIS

Tuesday 28 November 2017

Double click on gridview using asp.net

1./////////// HTML

<asp:GridView ID="GridView1" runat="server" DataKeyNames="ID" AutoGenerateColumns="false"

OnRowDataBound="GridView1_RowDataBound" OnRowCommand="GridView1_RowCommand">

<asp:BoundField DataField="Name" HeaderText="Name" />

<asp:BoundField DataField="Country" HeaderText="Country" ItemStyle-Width="150" />

<asp:CommandField SelectText="Select" ShowSelectButton="true" Visible="false" />

</Columns>

</asp:GridView>

2.//////////// Event on page directory

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" EnableEventValidation="false" %>

3.////////// CS

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)

{

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

{

e.Row.Attributes.Add("ondblclick", "__doPostBack('GridView1','Select$" + e.Row.RowIndex + "');");

e.Row.Attributes["style"] = "cursor:pointer;";

}

protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)

{

int index = Convert.ToInt32(e.CommandArgument);

GridViewRow gvRow = GridView1.Rows[index];

}

Show update progress model inside trigger in asp.net

//////html

<asp:UpdateProgress ID="UpdWt" runat="server" DisplayAfter="1" AssociatedUpdatePanelID="UpdMaster">

Please Wait <span id="loadspn">.</span>

</div>

</ProgressTemplate>

</asp:UpdateProgress>

///////// JS

window.onsubmit = function () {

if (Page_IsValid) {

var updateProgress = $find("<%= UpdWt.ClientID %>");

window.setTimeout(function () {

updateProgress.set_visible(true);

}, 100);

}

</script>

Hide update progress model inside Response.End() in asp.net after download excel

//////html

<asp:UpdateProgress ID="UpdWt" runat="server" DisplayAfter="1" AssociatedUpdatePanelID="UpdMaster">

Please Wait <span id="loadspn">.</span>

</div>

</ProgressTemplate>

</asp:UpdateProgress>

///////// JS

window.onsubmit = function () {

if (Page_IsValid) {

var updateProgress = $find("<%= UpdWt.ClientID %>");

window.setTimeout(function () {

updateProgress.set_visible(false);

}, 5000);

}

</script>

Monday 20 November 2017

Enable Disable div and inside control using jquery

////////////// Exp

<head>

$(document).ready(function () {

$("#btnDisable").on("click", function () {

$("#divContainer").find("input, button, submit, textarea, select").attr("disabled", "disabled");

$("#divContainer").find("a").click(function (e) {

e.preventDefault();

});

$("#btnEnable").on("click", function () {

$("#divContainer").find("input, button, submit, textarea, select").removeAttr("disabled");

$("#divContainer").find("a").unbind("click");

});

</script>

</head>

<body>

UserName<br />

<br />

Password<br />

<br />

<input type="checkbox" id="chbRember" />Rember me

<br />

<br />

</div>

</body>

</html>

Saturday 18 November 2017

Calculate textarea characters using jquery

/////////////////////// html

<asp:TextBox ID="txt_Remarks" runat="server" CssClass="form-control" TextMode="MultiLine"

MaxLength="150" Height="50px" onkeyup="return txt_area_Charc(this, 'txtCCountChar', 150)"></asp:TextBox>

//plugin-

///////////// js

function txt_area_Charc(val, txtcid, mval) {

var len = val.value.length;

if (len >= mval) {

val.value = val.value.substring(0, mval);

if (len == mval && txtcid != "") {

$('#' + txtcid).text((mval - (len)) + " Character Left");

}

return false;

} else {

if (txtcid != "") {

$('#' + txtcid).text((mval - (len)) + " Character Left");

}

// result

Transpose multiple columns to single column name and single row to their corresponding columns

/////////////// Sql problem

SELECT 'Data'as [Totals], sum(isnull([Avare],0))[Avare],sum(isnull([Blackgram],0))[Blackgram],sum(isnull([Cowpea],0))[Cowpea],sum(isnull([Greengram],0))[Greengram],sum(isnull([Horsegram],0))[Horsegram],sum(isnull([Madaki],0))[Madaki],sum(isnull([TotalPulses],0))[TotalPulses],sum(isnull([Tur],0))[Tur] FROM [tbl_AgriCrop_AreaSown]

///////// Solution

SELECT field[Crops],value[Data (Ha.)]FROM(

SELECT sum(isnull([Avare],0))[Avare],sum(isnull([Blackgram],0))[Blackgram],sum(isnull([Cowpea],0))[Cowpea],sum(isnull([Greengram],0))[Greengram],sum(isnull([Horsegram],0))[Horsegram],sum(isnull([Madaki],0))[Madaki],sum(isnull([TotalPulses],0))[TotalPulses],sum(isnull([Tur],0))[Tur] FROM [tbl_AgriCrop_AreaSown]

)Dt

unpivot

(

value

for field in ([Avare],[Blackgram],[Cowpea],[Greengram],[Horsegram],[Madaki],[TotalPulses],[Tur])

)un

////// result

Using STUFF get multiple column Names in sing string in sql server

//// Sql

DECLARE @cols AS NVARCHAR(MAX),@Flg varchar(10)='18'

select @cols = STUFF((SELECT distinct ',[' + Description + ']' FROM mstLookup where lookupflag=@Flg FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)') ,1,1,'')

print @cols

//// Result

Wednesday 15 November 2017

Date range in bootstrap date picker control using jquery

//////HTML

<asp:TextBox class="form-control" runat="server" AutoComplete="off" ClientIDMode="Static"

placeholder="dd/mm/yyyy" ID="Startdate");" />

//////Jquery
1.

$(document).ready(function () {

setdatesRanges();

Sys.WebForms.PageRequestManager.getInstance().add_endRequest(setdatesRanges);

});

function setdatesRanges() {

Date_Range('Startdate', 'EndDate', true);

}

function Date_Range(tFrID, tToID, IsStartDate) {

var setMinDate = "";

if (IsStartDate == true) {

setMinDate = 'now';

}

$('#' + tFrID + ',#' + tToID + '').datepicker({

format: "dd/mm/yyyy",

useCurrent: false,

autoclose: true,

startDate: setMinDate

});

$("#Startdate").datepicker().on('changeDate', function (e) {

var minDate = new Date(e.date);

$('#' + tToID).datepicker('setStartDate', minDate);

$('#' + tToID).val($(this).val());

});

}