Asp.Net Ado.Net, C#.Net,Javascript Jquery Entity Framework,Ajax,MVC..! Happy coding..! :)

Tuesday, July 8, 2014

GridView Paging

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

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

</head>

<body>

<div>

<asp:GridView ID="grd" runat="server" AllowPaging="true" PageSize="3"

onpageindexchanging="grd_PageIndexChanging"

onpageindexchanged="grd_PageIndexChanged">

</asp:GridView>

</div>

</form>

</body>

</html>

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

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Data.SqlClient;

using System.Data;

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

{

DataClassesDataContext _objdbml = new DataClassesDataContext();

Country _objcountry = new Country();

protected void Page_Load(object sender, EventArgs e)

{

try

{

var da = from p in _objdbml.Countries

select p;

SqlCommand _objcmd = (SqlCommand)_objdbml.GetCommand(da);

DataSet ds = new DataSet();

SqlDataAdapter _dap = new SqlDataAdapter(_objcmd);

_dap.Fill(ds);

grd.DataSource = ds;

grd.DataBind();

}

catch (Exception ex)

{

Response.Redirect("Default2.aspx");

}

finally

{

}

protected void grd_PageIndexChanging(object sender, GridViewPageEventArgs e)

{

try

{

grd.PageIndex = Convert.ToInt32(e.NewPageIndex.ToString());

grd.DataBind();

}

catch (Exception ex)

{

Response.Redirect("Default2.aspx");

}

protected void grd_PageIndexChanged(object sender, EventArgs e)

{

}

Sql Query Stock And Sale

create table total(id int identity(1,1) primary key,item varchar(50),one int,two int)

insert into total values('Chair',5,8),('Table',9,9)

select * from total

create table done(id int identity(1,1) primary key,item varchar(50),one int,two int)

insert into done values('Chair',1,5),('Table',3,3)

select * from total

select * from done

select x.id,x.item,x.one-y.one as one,x.two-y.two as two

from total x

left outer join

done y on x.id=y.id

Monday, July 7, 2014

How to create user control in ASP.NET using C#

DateControl.ascx

<%@ Control Language="C#" AutoEventWireup="true" CodeFile="DateControl.ascx.cs" Inherits="MyControl" %>

<%@ Register assembly="AjaxControlToolkit" namespace="AjaxControlToolkit" tagprefix="asp" %>

<asp:ScriptManager ID="ScriptManager1" runat="server">

</asp:ScriptManager>

<asp:TextBox ID="txtDate" runat="server"></asp:TextBox> 

<asp:Image ID="imgCalenderIcon" runat="server" ImageUrl="~/Images/calender3.jpg" />

<asp:CalendarExtender ID="TextBox1_CalenderExtender" runat="server"

PopupButtonID="imgCalenderIcon"

TargetControlID="txtDate"

Format="dd/MM/yyyy">

</asp:CalendarExtender>

Include User Control to web form:

After creating User Control we have to include that to our web form. So here we have to crate @Register directive that includes following attributes,

· A TagPrefix attribute, which associates a prefix with the user control. This prefix will be included in opening tag of the user control element.

· A TagName attribute, which associates a name with the user control. This name will be included in the opening tag of the user control element.

· A Src attribute, which defines the virtual path to the user control file that you are including.

Sample code:

<%@ Register Src="~/DateControl.ascx" TagName="Date" TagPrefix="UC" %>

Here we have to create a web form which is include User Control we have created,

Designer source code:

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