DOT NET WORLD: Apr 27, 2012

Friday, April 27, 2012

Ajax ConfirmationBox using jQuery in asp.net

Default.aspx

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

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="ajax" %>
<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
<title>Untitled Page</title>
<style type="text/css">
.modalBackground
{
background-color: Gray;
filter: alpha(opacity=80);
opacity: 0.8;
z-index: 10000;
}

.GridviewDiv {font-size: 100%; font-family: 'Lucida Grande', 'Lucida Sans Unicode', Verdana, Arial, Helevetica, sans-serif; color: #303933;}
Table.Gridview{border:solid 1px #df5015;}
.Gridview th{color:#FFFFFF;border-right-color:#abb079;border-bottom-color:#abb079;padding:0.5em 0.5em 0.5em 0.5em;text-align:center}
.Gridview td{border-bottom-color:#f0f2da;border-right-color:#f0f2da;padding:0.5em 0.5em 0.5em 0.5em;}
.Gridview tr{color: Black; background-color: White; text-align:left}
:link,:visited { color: #DF4F13; text-decoration:none }

</style>
<script language="javascript" type="text/javascript">
function closepopup() {
$find('ModalPopupExtender1').hide();
}
</script>
</head>
<body>
<form id="form1" runat="server">
<ajax:ToolkitScriptManager ID="ScriptManager1" runat="server">
</ajax:ToolkitScriptManager>
<asp:UpdatePanel ID="updatepnl1" runat="server">
<ContentTemplate>
<asp:GridView runat="server" ID="gvDetails" CssClass="Gridview"
DataKeyNames="UserId" AutoGenerateColumns="false">
<HeaderStyle BackColor="#df5015" />
<Columns>
<asp:BoundField DataField="UserName" HeaderText="UserName" />
<asp:BoundField DataField="FirstName" HeaderText="FirstName" />
<asp:BoundField DataField="LastName" HeaderText="LastName" />
<asp:TemplateField>
<ItemTemplate>
<asp:ImageButton ID="btnDelete" ImageUrl="~/Images/Delete.png" runat="server" onclick="btnDelete_Click" />
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
<asp:Label ID="lblresult" runat="server"/>
<asp:Button ID="btnShowPopup" runat="server" style="display:none" />
<ajax:ModalPopupExtender ID="ModalPopupExtender1" runat="server" TargetControlID="btnShowPopup" PopupControlID="pnlpopup"
CancelControlID="btnNo" BackgroundCssClass="modalBackground">
</ajax:ModalPopupExtender>
<asp:Panel ID="pnlpopup" runat="server" BackColor="White" Height="100px" Width="400px" style="display:none">
<table width="100%" style="border:Solid 2px #D46900; width:100%; height:100%" cellpadding="0" cellspacing="0">
<tr style="background-image:url(Images/header.gif)">
<td style=" height:10%; color:White; font-weight:bold;padding:3px; font-size:larger; font-family:Calibri" align="Left">Confirm Box</td>
<td style=" color:White; font-weight:bold;padding:3px; font-size:larger" align="Right">
<a href = "javascript:void(0)" onclick = "closepopup()"><img src="Images/Close.gif" style="border :0px" align="right"/></a>
</td>
</tr>
<tr>
<td colspan="2" align="left" style="padding:5px; font-family:Calibri">
<asp:Label ID="lblUser" runat="server"/>
</td>
</tr>
<tr>
<td colspan="2"></td>
</tr>
<tr>
<td>
</td>
<td align="right" style="padding-right:15px">
<asp:ImageButton ID="btnYes" OnClick="btnYes_Click" runat="server" ImageUrl="~/Images/btnyes.jpg"/>
<asp:ImageButton ID="btnNo" runat="server" ImageUrl="~/Images/btnNo.jpg" />
</td>
</tr>
</table>
</asp:Panel>
</ContentTemplate>
</asp:UpdatePanel>
</form>
</body>
</html>

Default.aspx.cs

using System;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Web.UI;
using System.Web.UI.WebControls;

public partial class _Default : System.Web.UI.Page
{
SqlConnection con = new SqlConnection("Data Source=.;Integrated Security=true;Initial Catalog=Database");
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
BindUserDetails();
}
}
protected void BindUserDetails()
{
//connection open
con.Open();
//sql command to execute query from database
SqlCommand cmd = new SqlCommand("Select * from UserDetails", con);
cmd.ExecuteNonQuery();
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
//Binding data to gridview
gvDetails.DataSource = ds;
gvDetails.DataBind();
con.Close();
}
protected void btnYes_Click(object sender, ImageClickEventArgs e)
{
//getting userid of particular row
int userid = Convert.ToInt32(Session["UserId"]);
con.Open();
SqlCommand cmd = new SqlCommand("delete from UserDetails where UserId=" + userid, con);
int result = cmd.ExecuteNonQuery();
con.Close();
if (result == 1)
{
lblresult.Text = Session["UserName"] + " Details deleted successfully";
lblresult.ForeColor = Color.Green;
BindUserDetails();
}
}
protected void btnDelete_Click(object sender, ImageClickEventArgs e)
{
ImageButton btndetails = sender as ImageButton;
GridViewRow gvrow = (GridViewRow)btndetails.NamingContainer;
Session["UserId"] = gvDetails.DataKeys[gvrow.RowIndex].Value.ToString();
Session["UserName"] = gvrow.Cells[0].Text;
lblUser.Text = "Are you sure you want to delete " + Session["UserName"] + " Details?";
ModalPopupExtender1.Show();
}
}

Passing values to Stored Procedure in VB.NET

Dim cmd As New SqlCommand
cmd.CommandType = CommandType.StoredProcedure
cmd.CommandText = "sp_customer_addupdate"

cmd.Parameters.Add("@customer_id", SqlDbType.BigInt, 0).Value = hdnId.Value
cmd.Parameters("@customer_id").Direction = ParameterDirection.InputOutput
cmd.Parameters.Add("@customer_name", SqlDbType.VarChar, 50).Value = txtLastName.Text & " " & txtFirstName.Text
cmd.Parameters.Add("@description", SqlDbType.VarChar, 50, 50).Value = txtDescription.Text
cmd.Parameters.Add("@address_1", SqlDbType.VarChar, 50).Value = txtAddr1.Text
cmd.Parameters.Add("@address_2", SqlDbType.VarChar, 50).Value = txtAddr2.Text
cmd.Parameters.Add("@city", SqlDbType.VarChar, 50).Value = txtCity.Text
cmd.Parameters.Add("@state", SqlDbType.VarChar, 50).Value = txtState.Text
cmd.Parameters.Add("@country", SqlDbType.VarChar, 50).Value = ddl_country.SelectedValue
cmd.Parameters.Add("@zip", SqlDbType.VarChar, 50).Value = txtZip.Text
cmd.Parameters.Add("@isdcode", SqlDbType.VarChar, 20).Value = txtisdcode.Text
cmd.Parameters.Add("@phone", SqlDbType.VarChar, 50).Value = txtPhone.Text
cmd.Parameters.Add("@created_id", SqlDbType.BigInt, 0).Value = Convert.ToInt64(dt.Rows(0)("user_id").ToString())
cmd.Parameters.Add("@last_update_id", SqlDbType.BigInt, 0).Value = Convert.ToInt64(dt.Rows(0)("user_id").ToString())

DataConnect.GetInstance.ExecuteNonQuery(cmd)

SQL query to create table

USE [Surgere1]
GO

/****** Object: Table [dbo].[asn] Script Date: 04/28/2012 10:08:14 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[asn](
[asn_id] [bigint] IDENTITY(1,1) NOT NULL,
[client_id] [bigint] NOT NULL,
[from_id] [bigint] NOT NULL,
[from_type] [varchar](50) NOT NULL,
[to_id] [bigint] NOT NULL,
[to_type] [varchar](50) NOT NULL,
[status] [varchar](50) NOT NULL,
[created_id] [bigint] NULL,
[created_dt] [datetime] NULL,
[last_update_id] [bigint] NULL,
[last_update_dt] [datetime] NULL,
[asn_no] [varchar](50) NULL,
CONSTRAINT [PK_asn] PRIMARY KEY CLUSTERED
(
[asn_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

Show gridview images with lightbox effect using asp.net

.Gridview

{

font-family:Verdana;

font-size:10pt;

font-weight:normal;

color:black;

}

.black_overlay{

display:none;

position: absolute;

top: 0%;

left: 0%;

width: 100%;

height: 100%;

background-color:black;

z-index:1001;

-moz-opacity: 0.8;

opacity:.80;

filter: alpha(opacity=80);

}

.white_content {

display:none;

position: absolute;

top: 25%;

left: 35%;

width: 25%;

padding: 0px;

border: 0px solid #a6c25c;

background-color: white;

z-index:1002;

overflow: auto;

}

.headertext{

font-family:Arial, Helvetica, sans-serif;

font-size:14px;

color:#f19a19;

font-weight:bold;

}

</style>

function ShowImages() {

document.getElementById('light').style.display = 'block';

document.getElementById('fade').style.display = 'block'

return false;

}

</script>

</head>

<body>

<asp:GridView runat="server" ID="gvImages" AutoGenerateColumns="false"

DataSourceID="sqldataImages" CssClass="Gridview"

HeaderStyle-BackColor="#61A6F8">

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

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

<asp:TemplateField HeaderText="Image">

<asp:ImageButton ID="imgbtn" runat="server" ImageUrl='<%#Eval("ImagePath") %>' OnClick="imgbtn_Click"/>

</ItemTemplate>

</asp:TemplateField>

</Columns>

</asp:GridView>

<asp:SqlDataSource ID="sqldataImages" runat="server" ConnectionString="<%$ConnectionStrings:dbconnection %>"

SelectCommand="select * from ImagesPath" >

</asp:SqlDataSource>

</div>

<tr>

<td align="center" colspan="2" class="headertext" >Gridview Image </td>

</tr>

<asp:Image ID="imglightbox" runat="server"/>

</td></tr>

</table>

</td></tr>

</table>

<asp:Label ID="txtlbl" runat="server" ></asp:Label></div>

</div>

</form>

</body>

</html>

protected void imgbtn_Click(object sender, EventArgs e)

{

ImageButton imgbtn = sender as ImageButton;

GridViewRow gvrow = imgbtn.NamingContainer as GridViewRow;

//Find Image button in gridview

ImageButton imgbtntxt =(ImageButton)gvrow.FindControl("imgbtn");

//Assign imagebutton url to image field in lightbox

imglightbox.ImageUrl = imgbtn.ImageUrl;

ScriptManager.RegisterStartupScript(Page, typeof(Page) , "ShowValidation", "javascript:ShowImages();",true);

}

DOT NET WORLD

Friday, April 27, 2012

Ajax ConfirmationBox using jQuery in asp.net

Passing values to Stored Procedure in VB.NET

SQL query to create table

Show gridview images with lightbox effect using asp.net

Using Authorization with Swagger in ASP.NET Core

Translate