Dot.Net Seva: June 2014

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

Tuesday 17 June 2014

create date Month and year Dropdownlist using jquery

<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>jQuery Generate years for dropdown</title>
<script type="text/javascript" src="http://code.jquery.com/jquery-1.8.2.js"></script>
<script type="text/javascript">
$(function () {
var yearvalue = 100; // Change to whatever you want
var currentyear = (new Date()).getFullYear();
for (var i = 0; i <= yearvalue; i++) {
var year = currentyear - i;
$('<option>', { value: year, text: year }).appendTo("#ddl_year");
}
});
$(function () {
var Dayvalue = 31; // Change to whatever you want
var ddate = 0;
for (var i = 1; i <= Dayvalue; i++) {
if (i < 10) {
ddate = "0" + i;
}
else {
ddate = i;
}
$('<option>', { value: ddate, text: ddate }).appendTo("#ddl_Date");
}
});
$(function () {
var Monthvalue = ["Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec"]; // Change to whatever you want
var monthval = "";
for ( var m = 0; m < 12; m++) {

monthval = Monthvalue[m];

$('<option>', { value: monthval, text: monthval }).appendTo("#ddl_Month");
}
});
</script>
</head>
<body>
<form id="form1">
<div>
Date:-<select id="ddl_Date"></select>
Month:-<select id="ddl_Month"></select>
Year:- <select id="ddl_year"></select>
</div>
</form>
</body>
</html>

Sunday 15 June 2014

Copy to clipboard in asp.net c# code behind

using namespace- System.Windows.Form

protected void btn_copyadd_Click(object sender, EventArgs e)

{
string addrs="Your text here"
Val = addrs;
System.Threading.Thread staThread = new System.Threading.Thread(new System.Threading.ThreadStart(myMethod));
staThread.ApartmentState = System.Threading.ApartmentState.STA;
staThread.Start();
lbl_title.Text = "Address";
lbl_messages.Text = addrs;

ModalAlert.Show();
}

private static string _Val;
public static string Val
{
get { return _Val; }
set { _Val = value; }
}
public static void myMethod()
{
System.Windows.Forms.Clipboard.SetText(Val);

}

Thursday 12 June 2014

Gridview cell click, mousedown, mouseup, event using jquery in asp.net

// Query

<script src="http://code.jquery.com/jquery-1.8.2.js" type="text/javascript"></script>

//Css

<style type="text/css">
.Colorcss{ background-color:#93BD00; cursor:pointer;}
</style>

<script type="text/javascript" language="javascript">
///////Start**************************OnClick
function jScript() {
$(function () {
$('#<%=Gridview.ClientID%> td').click(function () {
$(this).toggleClass("Colorcss");
checkva1();

});
});

var md = "";
var ms = "";
var scv = "";
$(function () {
$('#<%=Gridview.ClientID%> td').mousedown(function () {
md = $(this).index();
});
});

$(function () {
$('#<%=Gridview.ClientID%> td').mouseup(function () {
ms = $(this).index();
var trr = $('#<%=gvTimeSlot.ClientID%>').find('tr');
if (ms < md) { scv = ms; ms = md; md = scv; }
for (var i = md; i <= ms; i++) {
trr.find('td').eq(i).toggleClass("Colorcss");
}
checkva1();
});
});

}

Sys.Application.add_load(jScript);

function checkva1() {
var trr = $('#<%=Gridview.ClientID%>').find('tr');
var tdc = trr[0].cells.length;
var $tds = trr.find('td');
var Tivalue = "";
var co = "rgb(147, 189, 0)";
for (var rt = 0; rt < tdc; rt++) {
if ($tds.eq(rt).css("background-color") == co) {
Tivalue = Tivalue + "1";
}
else {
Tivalue = Tivalue + "0";
}
}

}

alert(Tivalue);
return false;
}

</script>

Pass DBNull.value for string and integer for dropdownlist and text value in asp.net

//Create an object

public object ConvertToDbReadyString(string value)
{
if (value == "0" || value == "")
return DBNull.Value;
else
return value;
}

//Pass value with sql parameter

SqlParameter[] pp = new SqlParameter[]
{
new SqlParameter("@SqlPara",ConvertToDbReadyString(tile)),// string
new SqlParameter("@SqlPara1",ConvertToDbReadyString(name)), //integer
new SqlParameter("@SqlPara2",ConvertToDbReadyString(age)),//integer
new SqlParameter("@SqlPara3",ConvertToDbReadyString(que)),//string
};
sqlCommon cmd;
cmd.ExecuteNonQuery(CN, CommandType.StoredProcedure, "insertdata", pp);

Monday 9 June 2014

ASP.NET – jQuery is not Working in UpdatePanels document.ready()

<script type="text/javascript">
    // JavaScript funciton to call inside UpdatePanel
    function jScriptfunctio() {
        $("#click").click(function () {
            alert("Clicked Me!");
        });
    }
</script>

<script type="text/javascript" language="javascript">
                Sys.Application.add_load(jScriptfunctio);
            </script>

Set Currently On page in asp.net

On master page

protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string pageValue = setpagevalue(pageName);
if (pageValue != "")
{ lbl_showpage.Text = pageValue; }
}
}

//Method

public string setpagevalue(string pagename)
{

string valdata = pagename;
switch(valdata){
case "ASP.homepage_aspx": return "Home Page"; break;
case "ASP.admin_aspx": return "Administration Page"; break;

//default
default: return string.Empty;
break;
}
}

//On Menu
<ul>
<li runat="server" id="id1"><a href='Page Name' onclick="setpagevalue('Page Name');">
<span>VFA Member Profile</span></a></li>
<li runat="server" id="id2"><a href='Page Name' onclick="setpagevalue('Page Name');">
<span>VFA Member Profile</span></a></li>

</ul>

//Javascript-

<script type="text/javascript">

function setpagevalue(valuepage) {

}
</script>

Restrict multiple login of a single user in asp.net using cache

//On Master Page

protected void Page_Init(object sender, EventArgs e)

{

Response.Cache.SetExpires(DateTime.UtcNow.AddMinutes(-1));

Response.Cache.SetCacheability(HttpCacheability.NoCache);

Response.Cache.SetNoStore();

}

protected void Page_Load(object sender, EventArgs e)

{

Response.Cache.SetCacheability(HttpCacheability.NoCache);

Response.Cache.SetAllowResponseInBrowserHistory(false);

Request.Browser.Adapters.Clear();

}

Globly- Login Page

public System.Data.DataTable dtSessionGlobal = new DataTable();

//On Page Load

protected void Page_Load(object sender, EventArgs e)

{

if (Cache["UserSessions"] != null)

{

dtSessionGlobal = (DataTable)Cache["UserSessions"];

if (dtSessionGlobal.Columns.Count == 0)

{

dtSessionGlobal.Columns.Add("UserName");

dtSessionGlobal.Columns.Add("SessionID");

}

else

{

dtSessionGlobal.Columns.Add("UserName");

dtSessionGlobal.Columns.Add("SessionID");

Cache["UserSessions"] = dtSessionGlobal;

}

//On All Page Load Event

protected void Page_Load(object sender, EventArgs e)

{

DataTable dtSessionGlobal = new DataTable();

if (Cache["UserSessions"] != null)

{

dtSessionGlobal = (DataTable)Cache["UserSessions"];

}

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

{

Response.Redirect("~/SignIn Users", false);

}

if (!IsPostBack)

{

if (dtSessionGlobal.Rows.Count > 0)

{

System.Data.DataRow[] dr = dtSessionGlobal.Select(" UserName='" + Session["UName"] + "' AND SessionID<>'" + Session.SessionID + "'");

if (dr.Length > 0)

{

Response.Redirect("~/SignIn Users");

}

else if (dtSessionGlobal.Select(" UserName='" + Session["UName"] + "'").Length == 0)

{

Response.Redirect("~/SignIn Users");

}

Sunday 8 June 2014

Open new tab in asp.net code behind

//HTML

<asp:Button ID="Button1" runat="server" Text="Button" 

onclick="Button1_Click" 

OnClientClick ="document.forms[0].target = '_blank';" />

//Code Behind

protected void Button1_Click(object sender, EventArgs e)

    {

        string newtabl = @"~/FrmNewContent.aspx";

        Response.Redirect(newtabl);       

    }

Saturday 7 June 2014

Get Control id using jquery

//id with control id

$('#<%=Controlid.ClientID%>').attr('id')

//Id with Class Name

$('.ButtonClass').attr('id');

Thursday 5 June 2014

Count Number of columns in a table using javascript or jquery

//HTML

<table id="table1">
<tr>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
</table>
cells
<script>
alert(document.getElementById('table1').rows[0].cells.length)
</script>

//Jquery

<script type="text/javascript">
$(document).ready(function () {
alert($(Table).find('tr')[0].cells.length);

});
</script>

Monday 2 June 2014

Direct insert and create table from Sql server Query-

//Sql Query-

Select * into TableNameA From TableNameB

Add CSS in gridview cells using jquery in asp.net

//HTML -GridView

<asp:GridView ID="GridView1" runat="server" >
</asp:GridView>

//Jquery-

<script src="Scripts/jquery-1.4.1.min.js" type="text/javascript"></script>

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

$(document).ready(function () {
$(function () {
$('#<%=GridView1.ClientID%> td').toggle(function () {
$(this).css('background', '#93BD00');

},
function () {
$(this).css('background', 'white', 'cursor', 'pointer', 'padding', '2px');
});
});
</script>

Check and Uncheck all Checkboxlist using javascript in asp.net

///HTML

<asp:CheckBoxList ID="CheckBoxList1" RepeatDirection="Vertical" runat="server" onclick="javascript: changeSelectAll ()">
</asp:CheckBoxList>

<asp:CheckBox ID="CheckBox1" runat="server" onclick="javascript: CheckBoxListSelect (this.id)" />

//CheckBoxList function

function CheckBoxListSelect(chkid, chblid) {
var chkBoxList = document.getElementById('<%= CheckBoxList1.ClientID %>');
var chkB = document.getElementById(chkid);
if (chkB.checked) {
var chkBoxCount = chkBoxList.getElementsByTagName("input");
for (var i = 0; i < chkBoxCount.length; i++) {
chkBoxCount[i].checked = true;
}
}
if (!chkB.checked) {
var chkBoxCount = chkBoxList.getElementsByTagName("input");
for (var i = 0; i < chkBoxCount.length; i++) {
chkBoxCount[i].checked = false;
}
}

return false;
}

//CheckBoxList function

function changeSelectAll() {
var chkBoxList = document.getElementById('<%= CheckBoxList1.ClientID %>');
var chkb = document.getElementById('<%= CheckBox1.ClientID %>')
var chekb = true;
var chkBoxCount = chkBoxList.getElementsByTagName("input");
for (var i = 0; i < chkBoxCount.length; i++) {
if (!chkBoxCount[i].checked) {
chekb = false;
break;
}
}
if (chekb) { chkb.checked = true; } else { chkb.checked = false; }
return false;
}