DotNet By Srikanta Dash

Saturday, 11 July 2015

Ajax Call to controller and view

Create.cshtml
------------------------------------------------------------

@model MvcApplication1.Models.student

@{
ViewBag.Title = "Create";
}

<div id="dvPop" style="display:none;position:absolute;top:100px;left:100px;z-index:1000;height:400px;width:400px;background-color:red"></div>


<h2>Create</h2>

@using (Html.BeginForm()) {
@Html.ValidationSummary(true)

<fieldset>
<legend>student</legend>

<div class="editor-label">
@Html.LabelFor(model => model.FirstName)
</div>
<div class="editor-field">
@Html.EditorFor(model => model.FirstName)
@Html.ValidationMessageFor(model => model.FirstName)
</div>

<div class="editor-label">
@Html.LabelFor(model => model.LastName)
</div>
<div class="editor-field">
@Html.EditorFor(model => model.LastName)
@Html.ValidationMessageFor(model => model.LastName)
</div>

<p>
<input type="submit" value="Create" />

<input type="button" value="ShowList" onclick="showStudList();" />
</p>
</fieldset>
}

<div>
@Html.ActionLink("Back to List", "Index")
</div>
<script src="http://code.jquery.com/jquery-2.1.4.min.js"></script>
<script lang="javascript">
function showStudList() {

// $(this).load("/StudentName/index");

$.ajax({
type: "GET",
url: "/StudentName/index",
data: {},
success: function (viewHTML) {
document.getElementById('dvPop').style.display = '';
$("#dvPop").html(viewHTML);
},
error: function (errorData) { onError(errorData); }
});

}

</script>

----------------

StudentNameController.cs
--------------------------------

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using MvcApplication1.Models;

namespace MvcApplication1.Controllers
{
public class StudentNameController : Controller
{
//
// GET: /StudentName/

private adiEntities db = new adiEntities();

public ActionResult Index()
{
//Get student List
List<student> studList = db.students.Where(x=>x.FirstName=="Ram").ToList();
return PartialView("Index", studList);
}

}
}

Sunday, 5 July 2015

Event Bubbling

GridOperation.ASPX

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="GridOperation.aspx.cs" Inherits="UC_to_UC.LucyJobs.GridOperation" %>

<%@ Register src="ShowGrid.ascx" tagname="ShowGrid" tagprefix="uc1" %>

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

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">

<div>

<uc1:ShowGrid ID="ShowGrid1" runat="server" />

</div>
</form>
</body>
</html>

Pager.ASCX

<%@ Control Language="C#" AutoEventWireup="true" CodeBehind="Pager.ascx.cs" Inherits="UC_to_UC.LucyJobs.Pager" %>
<asp:DropDownList ID="ddlPager" runat="server" AutoPostBack="True"
onselectedindexchanged="ddlPager_SelectedIndexChanged">
<asp:ListItem>1</asp:ListItem>
<asp:ListItem>2</asp:ListItem>
<asp:ListItem>3</asp:ListItem>

</asp:DropDownList>

Pager.ASCX.cs

namespace UC_to_UC.LucyJobs

{

public partial class Pager : System.Web.UI.UserControl

{

protected void Page_Load(object sender, EventArgs e)

{

}

public delegate void GetPageIndexEventHandler(CustomEventArgs e);

public event GetPageIndexEventHandler getPageCustomEvent;

protected void ddlPager_SelectedIndexChanged(object sender, EventArgs e)

{

if (getPageCustomEvent != null)

{

CustomEventArgs cArgs = new CustomEventArgs();

cArgs.PageNum = int.Parse(ddlPager.SelectedValue);

getPageCustomEvent(cArgs);

}

ShowGrid.ASCX

<%@ Control Language="C#" AutoEventWireup="true" CodeBehind="ShowGrid.ascx.cs" Inherits="UC_to_UC.LucyJobs.ShowGrid" %>

<%@ Register src="Pager.ascx" tagname="Pager" tagprefix="uc1" %>

<asp:GridView ID="gvStudents" runat="server" AllowPaging="true" PageSize="3" PagerSettings-Visible="false">

</asp:GridView>

<uc1:Pager ID="Pager1" runat="server" />

ShowGrid.ASCX.cs

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

namespace UC_to_UC.LucyJobs

{

public partial class ShowGrid : System.Web.UI.UserControl

{

List<student> oStudList = null;

protected void Page_Load(object sender, EventArgs e)

{

oStudList = new List<student>()

{

new student{roll=1,Name="Srikanta",Dept="MCA"},

new student{roll=2,Name="Sriram", Dept="MBA"},

new student{roll=3,Name="Susant",Dept="BA"},

new student{roll=4,Name="Srikanta1",Dept="MCA"},

new student{roll=5,Name="Sriram1", Dept="MBA"},

new student{roll=6,Name="Susant1",Dept="BA"},

new student{roll=7,Name="Srikanta2",Dept="MCA"},

new student{roll=8,Name="Sriram2", Dept="MBA"},

new student{roll=9,Name="Susant2",Dept="BA"},

new student{roll=10,Name="Srikanta3",Dept="MCA"},

new student{roll=11,Name="Sriram3", Dept="MBA"},

new student{roll=12,Name="Susant3",Dept="BA"}

};

if (!IsPostBack)

{

gvStudents.DataSource = oStudList;

gvStudents.DataBind();

gvStudents.PageIndex = 0;

}

else

{

Pager1.getPageCustomEvent += new Pager.GetPageIndexEventHandler(Pager1_getPageCustomEvent);

}

void Pager1_getPageCustomEvent(CustomEventArgs e)

{

BindStudentData(e.PageNum);

}

public void BindStudentData(int PageNum)

{

// gvStudents.DataSource = null;

oStudList = new List<student>()

{

new student{roll=1,Name="Srikanta",Dept="MCA"},

new student{roll=2,Name="Sriram", Dept="MBA"},

new student{roll=3,Name="Susant",Dept="BA"},

new student{roll=4,Name="Srikanta1",Dept="MCA"},

new student{roll=5,Name="Sriram1", Dept="MBA"},

new student{roll=6,Name="Susant1",Dept="BA"},

new student{roll=7,Name="Srikanta2",Dept="MCA"},

new student{roll=8,Name="Sriram2", Dept="MBA"},

new student{roll=9,Name="Susant2",Dept="BA"},

new student{roll=10,Name="Srikanta3",Dept="MCA"},

new student{roll=11,Name="Sriram3", Dept="MBA"},

new student{roll=12,Name="Susant3",Dept="BA"}

};

gvStudents.DataSource = oStudList;

gvStudents.DataBind();

gvStudents.PageIndex = PageNum;

}

Student.cs

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

namespace UC_to_UC.LucyJobs

{

public class student

{

public int roll { get; set; }

public string Name { get; set; }

public string Dept { get; set; }

}

CustomEventArgs.cs

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

namespace UC_to_UC

{

public class CustomEventArgs:EventArgs

{

// Declare a Code property of type string:

int _iPageNum;

public int PageNum

{

get

{

return _iPageNum;

}

set

{

_iPageNum = value;

}

Monday, 15 June 2015

LDAP authentication using form

https://support.microsoft.com/en-us/kb/316748

Tuesday, 28 April 2015

GridView with Paging and sorting

Connection string: Data Source=banka-pc;Integrated Security=true;Initial Catalog=test2

ASPX file:

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="gridviewSortPaging.aspx.cs"
Inherits="GridviewPagingSorting._Default" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>Gridview Paging and Sorting </title>
</head>
<body>
<form id="form1" runat="server">
<div>
<div style="font-size: 20px; font-family: Verdana">
<u> Gridview Paging and Sorting</u>
<br />
<br />
</div>
<div>
<asp:GridView ID="GridVwPagingSorting" runat="server" AutoGenerateColumns="False"
Font-Names="Verdana" AllowPaging="True" AllowSorting="True" PageSize="1" Width="75%"
OnPageIndexChanging="PageIndexChanging" BorderColor="#CCCCCC" BorderStyle="Solid"
BorderWidth="1px" OnSorting="Sorting">
<AlternatingRowStyle BackColor="#BFE4FF" />
<PagerStyle BorderColor="#CCCCCC" BorderStyle="Solid" BorderWidth="1px" />
<PagerSettings Mode="NumericFirstLast" FirstPageText="First" LastPageText="Last" PageButtonCount="2" NextPageText="next" PreviousPageText="prev" />
<HeaderStyle Height="30px" BackColor="#6DC2FF" Font-Size="15px" BorderColor="#CCCCCC"
BorderStyle="Solid" BorderWidth="1px" />
<RowStyle Height="20px" Font-Size="13px" BorderColor="#CCCCCC" BorderStyle="Solid"
BorderWidth="1px" />
<Columns>
<asp:BoundField DataField="name" HeaderText="Student Name" SortExpression="name" />
<asp:BoundField DataField="dob" HeaderText="DOB" SortExpression="dob" />
<asp:BoundField DataField="sal" HeaderText="Salary" SortExpression="sal" />

</Columns>
</asp:GridView>
</div>
<div style="color: Green; font-weight: bold">
<br />
<i>You are viewing page
<%=GridVwPagingSorting.PageIndex + 1%>
of
<%=GridVwPagingSorting.PageCount%>
</i>
</div>
</div>
</form>
</body>
</html>

ASPX.cs

using System;

using System.Configuration;

using System.Data;

using System.Data.SqlClient;

using System.Web.UI.WebControls;

namespace GridviewPagingSorting

{

public partial class _Default : System.Web.UI.Page

{

string Sort_Direction = "name ASC";

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

ViewState["SortExpr"] = Sort_Direction;

DataView dvEmployee = Getdata();

GridVwPagingSorting.DataSource = dvEmployee;

GridVwPagingSorting.DataBind();

}

private DataView Getdata()

{

using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ToString()))

{

DataSet dsEmployee = new DataSet();

string strSelectCmd = "SELECT [name],[dob],[sal] FROM [student]";

SqlDataAdapter da = new SqlDataAdapter(strSelectCmd, conn);

da.Fill(dsEmployee, "Student");

DataView dvEmp = dsEmployee.Tables["student"].DefaultView;

dvEmp.Sort = ViewState["SortExpr"].ToString();

return dvEmp;

}

protected void PageIndexChanging(object sender, GridViewPageEventArgs e)

{

GridVwPagingSorting.PageIndex = e.NewPageIndex;

DataView dvEmployee = Getdata();

GridVwPagingSorting.DataSource = dvEmployee;

GridVwPagingSorting.DataBind();

}

protected void Sorting(object sender, GridViewSortEventArgs e)

{

string[] SortOrder = ViewState["SortExpr"].ToString().Split(' ');

if (SortOrder[0] == e.SortExpression)

{

if (SortOrder[1] == "ASC")

{

ViewState["SortExpr"] = e.SortExpression + " " + "DESC";

}

else

{

ViewState["SortExpr"] = e.SortExpression + " " + "ASC";

}

else

{

ViewState["SortExpr"] = e.SortExpression + " " + "ASC";

}

GridVwPagingSorting.DataSource = Getdata();

GridVwPagingSorting.DataBind();

}

Web.Config

</connectionStrings>

Tuesday, 10 March 2015

Hidden field data

<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title></title>
<script language="javascript">
function ShowHdnVal() {
alert(document.getElementById('hdnAdi').value);
}
</script>
</head>
<body>
<form id="form1" runat="server">
<div>
<input type="hidden" id="hdnAdi" />
<asp:Button runat="server" ID="btnPost" Text="Post Me" OnClick="btnPost_Click" />

<input type="button" value="Show my hidden value" onclick="ShowHdnVal();" />
</div>
</form>
</body>
</html>

---------------------------------------

protected void btnPost_Click(object sender, EventArgs e)
{
if (true)
{
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), Guid.NewGuid().ToString(), "document.getElementById('hdnAdi').value='Avaneesh Dash';", true);
}
}

get Hidden field data

{

protected void Page_Load(object sender, EventArgs e)

{

}

protected void btnPost_Click(object sender, EventArgs e)

{

if (true)

{

ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), Guid.NewGuid().ToString(), "document.getElementById('hdnAdi').value='Avaneesh Dash';", true);

}

---------

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

<!DOCTYPE html>

<head>

function ShowHdnVal() {

alert(document.getElementById('hdnAdi').value);

}

</script>

</head>

<body>

<div>

<asp:Button runat="server" ID="btnPost" Text="Post Me" OnClick="btnPost_Click" />

</div>

</form>

</body>

</html>

Thursday, 4 December 2014

dataGridView to ListBox Drag Drop

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Text;

using System.Windows.Forms;

namespace Drag_and_Drop

{

public partial class Form1 : Form

{

string sSelectedVal = "";

public Form1()

{

InitializeComponent();

}

private void lstBx_DragEnter(object sender, DragEventArgs e)

{

if (e.Data.GetDataPresent(DataFormats.Text))

e.Effect = DragDropEffects.Copy;

else

e.Effect = DragDropEffects.None;

}

private void lstBx_DragDrop(object sender, DragEventArgs e)

{

lstBx.Items.Add(sSelectedVal);

}

private void Form1_Load(object sender, EventArgs e)

{

FillGrids();

}

private void dataGridView1_CellMouseDown(object sender, DataGridViewCellMouseEventArgs e)

{

sSelectedVal = dataGridView1.SelectedCells[0].Value.ToString();

dataGridView1.DoDragDrop(sSelectedVal, DragDropEffects.Copy | DragDropEffects.Move);

}

private void dataGridView2_CellMouseDown(object sender, DataGridViewCellMouseEventArgs e)

{

sSelectedVal = dataGridView2.SelectedCells[0].Value.ToString();

dataGridView2.DoDragDrop(sSelectedVal, DragDropEffects.Copy | DragDropEffects.Move);

}

private void FillGrids()

{

List<Student> students = new List<Student>()

{

new Student{Roll = 1,Name="Rakesh" },

new Student{Roll = 2,Name="Suresh" },

new Student{Roll = 3,Name="Rajesh"},

new Student{Roll = 4,Name="Harish" }

};

dataGridView1.DataSource = students;

List<Teacher> teachers = new List<Teacher>()

{

new Teacher{id = 1,Name="dgg" },

new Teacher{id = 2,Name="gfdgg" },

new Teacher{id = 3,Name="gfdgg"},

new Teacher{id = 4,Name="gfdg" }

};

dataGridView2.DataSource = teachers;

}

public class Student

{

public int Roll { get; set; }

public string Name { get; set; }

}

public class Teacher

{

public int id { get; set; }

public string Name { get; set; }

}