Asp . Net || SQL Server

Wednesday, 27 July 2016

trigger script

create table trig_parent(id int ,name varchar(20))
create table trig_child(id int ,name varchar(20))

create trigger trg_parent_id on trig_parent
for insert
as
begin

declare @id int,@name varchar(20)
select @id=id,@name=name from inserted
insert into trig_child values(@id,@name)

end

select *from trig_parent
select * from trig_child

alter table trig_parent add sno int identity(1,1)

update trig_parent set name='vinoth'

insert into trig_parent values(4,'new')

create trigger trg_parent_upd on trig_parent
for update
as
begin

declare @id int,@name varchar(20)
select @id=id,@name=name from inserted
insert into trig_child values(@id,@name)

select @id=id,@name=name from deleted
insert into trig_child values(@id,@name)

end

select * from trig_parent where name='vinoths'

delete from trig_parent where sno in(select sno from (select ROW_NUMBER() over(partition by name order by name) sr_no,* from trig_parent)x
where sr_no<>1)

select sno from (select ROW_NUMBER() over(partition by name order by name) sr_no,* from trig_parent)x
where sr_no<>1

Wednesday, 13 July 2016

Filter Date of birth for same age and particular month

create table ##age (id int,dob datetime)
insert into ##age values(1,'1990-02-25 09:18:58.740')
insert into ##age values(2,'1990-07-01 09:18:58.740')
insert into ##age values(3,'1998-05-25 09:18:58.740')
insert into ##age values(4,'1990-08-25 09:18:58.740')

create table #temp (id int,dob datetime,age int,month int)

insert into #temp (id,dob,age,month)
select id,dob,DATEDIFF(yy, dob, GETDATE()) - CASE WHEN
(MONTH(dob) > MONTH(GETDATE())) OR (MONTH(dob) = MONTH(GETDATE()) AND DAY(dob) > DAY(GETDATE())) THEN 1 ELSE 0 END as age,month(dob) as [month] from ##age

select * from #temp
select * from #temp where age =26 and [month] in (1,2,3,4,5,6,7,8)

How to calculate accurate age from date of birth in sql

DECLARE @date datetime, @tmpdate datetime, @age int
SELECT @date = '02/25/91'
SELECT @tmpdate = @date
SELECT @age = DATEDIFF(yy, @tmpdate, GETDATE()) - CASE WHEN (MONTH(@date) > MONTH(GETDATE())) OR (MONTH(@date) = MONTH(GETDATE()) AND DAY(@date) > DAY(GETDATE())) THEN 1 ELSE 0 END
SELECT @age

Thursday, 30 June 2016

Find Visitors Geographic Location-using-IP-Address-in-ASPNe

http://www.aspsnippets.com/Articles/Find-Visitors-Geographic-Location-using-IP-Address-in-ASPNet.aspx

Saturday, 25 June 2016

Bind Images with DropDownList using ASP.net

Create a New Folder with Name msdropdown , click on Download and Paste the files with jquery files to this folder.

Image Folder Name : Images

Sql Scripts :
create table ActorVotings (ID int identity(1,1) Primary Key,ActorName varchar(50),ActorImage varchar(50))

Webform1.aspx

%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm1.aspx.cs" Inherits="BindDropDownWithImages.WebForm1" %>

<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
<title>Dropdownlist with Images</title>
<link href="msdropdown/dd.css" rel="stylesheet" type="text/css"></link>
<script src="msdropdown/js/jquery-1.6.1.min.js" type="text/javascript"></script>
<script src="msdropdown/js/jquery.dd.js" type="text/javascript"></script>

<script language="javascript" type="text/javascript">
$(document).ready(function (e) {
try {
$("#ddlCountry").msDropDown();
} catch (e) {
alert(e.message);
}
});
</script>
<style type="text/css">
.style1
{
height: 26px;
}
</style>
</head>
<body>
<form id="form1" runat="server">
<asp:panel id="Panelp" runat="server" style="height: 100%; width: 100%;">
<div id="div1" runat="server" style="height: 870px; width: 100%;">
<table>
<tr>
<td align="right" class="style1" colspan="2">
<b>Select Your Favorite Actor: </b> </td>
<td class="style1" colspan="2">
<asp:dropdownlist autopostback="true" height="189px" id="ddlCountry" onselectedindexchanged="ddlCountry_SelectedIndexChanged" runat="server" width="147px"></asp:dropdownlist>
</td>
</tr>
<tr>
<td colspan="2">
<strong>You have Selected</strong></td>
<td colspan="2">
<asp:label id="lbltext" runat="server"></asp:label>
</td>
</tr>
<tr>
<td colspan="2">
<strong>Your IP Address is </strong>
</td>
<td colspan="2">
<asp:label id="Label1" runat="server"></asp:label>
</td>
</tr>
<tr>
<td>
 </td>
<td>
 </td>
<td>
 </td>
<td>
 </td>
</tr>
<tr>
<td>
 </td>
<td>
 </td>
<td>
 </td>
<td>
<asp:button height="26px" id="Button1" onclick="Button1_Click" runat="server" style="font-weight: 700;" text="Vote" width="97px">
</asp:button></td>
</tr>
</table>
<asp:panel height="112px" id="Panel1" runat="server">
<asp:label font-bold="True" font-italic="True" font-size="XX-Large" forecolor="#993300" id="Label2" runat="server" text="Thanks For Casting Your Vote...."></asp:label>
</asp:panel>

<br />

</div>
</asp:panel>
</form>
</body>
</html>--%>

Webform1.aspx.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;

namespace BindDropDownWithImages
{
public partial class WebForm1 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Panel1.Visible = false;
BindDropDownList();
BindTitles();
lbltext.Text = ddlCountry.Items[0].Text;
}
}

private void BindTitles()
{
if (ddlCountry != null)
{
foreach (ListItem li in ddlCountry.Items)
{
li.Attributes["title"] = "Images/" + li.Value; // setting text value of item as tooltip
}
}
}

private void BindDropDownList()
{
//DataTable objdt = new DataTable();
//objdt = GetDataForChart();
//ddlCountry.DataSource = objdt;
//ddlCountry.DataTextField = "Actor";
//ddlCountry.DataValueField = "Id";
//ddlCountry.DataBind();
SqlConnection con = new SqlConnection("Data Source=GOKUL-PC\\GOKUL;Initial Catalog=Test;Integrated Security=true");
con.Open();
SqlCommand cmd = new SqlCommand("select * from ActorVotings", con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
ddlCountry.DataTextField = "ActorName";
ddlCountry.DataValueField = "ActorImage";
ddlCountry.DataSource = ds;
ddlCountry.DataBind();
con.Close();
}
protected void ddlCountry_SelectedIndexChanged(object sender, EventArgs e)
{
lbltext.Text = ddlCountry.SelectedItem.Text;
BindTitles();
if (lbltext.Text.Contains("rajini"))
{
Panelp.BackImageUrl = "~/Images/rajinifull.jpg";

}
else if(lbltext.Text.Contains("vijay"))
{
Panelp.BackImageUrl = "~/Images/vijayfull.jpg";
}
else if(lbltext.Text.Contains("kamal"))
{
Panelp.BackImageUrl = "~/Images/kamlfull.jpg";
}
else if(lbltext.Text.Contains("ajith"))
{
Panelp.BackImageUrl = "~/Images/ajithfull.png";
}
else if (lbltext.Text.Contains("vikram"))
{
Panelp.BackImageUrl = "~/Images/vikramfull.jpg";
}
}

public DataTable GetDataForChart()
{
DataTable dt = new DataTable();

dt.Columns.Add("Actor", typeof(string));
dt.Columns.Add("Id", typeof(string));

dt.Columns.Add("LabelValue");
var _objrow = dt.NewRow();
_objrow["Actor"] = "rajini";
_objrow["Id"] = "rajini.jpg";

dt.Rows.Add(_objrow);
_objrow = dt.NewRow();
_objrow["Actor"] = "kamal";
_objrow["Id"] = "kamal.jpg";

dt.Rows.Add(_objrow);

_objrow = dt.NewRow();
_objrow["Actor"] = "vijay";
_objrow["Id"] = "vijay.jpg";

dt.Rows.Add(_objrow);

_objrow = dt.NewRow();
_objrow["Actor"] = "ajith";
_objrow["Id"] = "ajith.jpg";

dt.Rows.Add(_objrow);

_objrow = dt.NewRow();
_objrow["Actor"] = "vikram";
_objrow["Id"] = "vikram.jpg";
dt.Rows.Add(_objrow);
return dt;
}

protected void Button1_Click(object sender, EventArgs e)
{
Panel1.Visible = true;
}
}
}

Monday, 20 June 2016

Simple-encrypting-and-decrypting-data-in-C#

http://www.codeproject.com/Articles/5719/Simple-encrypting-and-decrypting-data-in-C#

Thursday, 16 June 2016

C3

http://www.c-sharpcorner.com/code/2827/c-sharp-program-to-shutdown-or-turn-off-computer.aspx

http://www.c-sharpcorner.com/code/2700/read-excel-file-without-microsoft-jet-oledb-4-0-reference-file-saveas-or-excel.aspx

http://www.c-sharpcorner.com/code/2711/simple-bus-traffic-simulation-with-information-service.aspx

http://www.c-sharpcorner.com/article/train-wreck-pattern-cascade-method-pattern-in-C-Sharp/

http://www.c-sharpcorner.com/article/silent-installation-of-applications-using-C-Sharp/

http://www.c-sharpcorner.com/article/sending-sms-using-C-Sharp-application/

http://www.c-sharpcorner.com/code/2085/send-image-audio-video-and-message-from-c-sharp-to-whatsapp.aspx

http://www.c-sharpcorner.com/code/2048/desktop-activity-recording.aspx

http://www.c-sharpcorner.com/UploadFile/87b416/why-we-should-prefer-to-use-dispose-method-then-finalize-met/

http://www.c-sharpcorner.com/blogs/communicate-with-whatsapp-from-website-in-c-sharp1

Asp . Net || SQL Server

Wednesday, 27 July 2016

trigger script

Wednesday, 13 July 2016

Filter Date of birth for same age and particular month

How to calculate accurate age from date of birth in sql

Thursday, 30 June 2016

Find Visitors Geographic Location-using-IP-Address-in-ASPNe

Saturday, 25 June 2016

Bind Images with DropDownList using ASP.net

Monday, 20 June 2016

Simple-encrypting-and-decrypting-data-in-C#

Thursday, 16 June 2016

C3

QUICK Links

Dot Net Projects

ASP.Net Tutorial

AspDot Nets Interview Q&a

Asp.Net Interview tasks

ADO DOTNet Tutorial

Ado DotNet InterView Q & A

Ado DotNet Interview Tasks

C# Tutorial

C# Interview Questions

C# Interview Q&A

C# Interview Tasks

SQL Tutorial

SQL Interview Q&A

SQL Interview Tasks