Friday, 31 January 2014
Always Visible ControlExtender
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="cc1" %>
Wednesday, 29 January 2014
Run time Field Add
select sum(sub1+Sub2+Sub3+Sub4+Sub5) as TOTAL from MCA1
HERE MCA 1 IS TABLE NAME
RUN TIME TIME FIELD NAME IS TOTAL
HERE MCA 1 IS TABLE NAME
RUN TIME TIME FIELD NAME IS TOTAL
Tuesday, 28 January 2014
Value add dynmanically in Grid view Item template
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="GradeCard.aspx.cs" Inherits="GradeCard" %>
<!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>
<asp:GridView ID="gvGrade" runat="server" AutoGenerateColumns="false"
DataKeyNames="RollNo" onrowdatabound="gvGrade_RowDataBound"
>
<Columns>
<asp:TemplateField HeaderText="Name">
<ItemTemplate>
<asp:Label ID="lblName" runat="server" Text='<%#Bind("Name") %>'/>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="RollNo">
<ItemTemplate>
<asp:Label ID="lblRollNo" runat="server" Text='<%#Bind("RollNo") %>'/>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Sub1" >
<ItemTemplate>
<asp:Label ID="lblSub1" runat="server" Text='<%#Bind("Sub1") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Sub2">
<ItemTemplate>
<asp:Label ID="lblSub2" runat="server" Text='<%#Bind("Sub2") %>'/>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Sub3">
<ItemTemplate>
<asp:Label ID="lblSub3" runat="server" Text='<%#Bind("Sub3") %>'/>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Sub4">
<ItemTemplate>
<asp:Label ID="lblSub4" runat="server" Text='<%#Bind("Sub4") %>'/>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Sub5">
<ItemTemplate>
<asp:Label ID="lblSub5" runat="server" Text='<%#Bind("Sub5") %>'/>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="TotalMarks">
<ItemTemplate>
<asp:Label ID="lblTotal" runat="server" Text='<%# Bind("Total") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
</Columns>
<EditRowStyle HorizontalAlign="Left" VerticalAlign="Bottom" />
</asp:GridView>
</div>
</form>
</body>
</html>
Code Behind
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;
using System.Configuration;
public partial class GradeCard : System.Web.UI.Page
{
DataSet ds = new DataSet();
SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["Y"].ToString());
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Marksheet();
Label sub1 = (Label)gvGrade.Rows[0].FindControl("lblSub1");
Label sub2 = (Label)gvGrade.Rows[0].FindControl("lblSub2");
Label sub3 = (Label)gvGrade.Rows[0].FindControl("lblSub3");
Label sub4 = (Label)gvGrade.Rows[0].FindControl("lblSub4");
Label sub5 = (Label)gvGrade.Rows[0].FindControl("lblSub5");
int s = Convert.ToInt32(sub1.Text) + Convert.ToInt32(sub1.Text) + Convert.ToInt32(sub2.Text) + Convert.ToInt32(sub3.Text) + Convert.ToInt32(sub4.Text) + Convert.ToInt32(sub5.Text);
ds.Tables[0].Columns.Add("Total");
DataRow dr = ds.Tables[0].NewRow();
dr["Total"] = s;
ds.Tables[0].Rows.Add(dr);
Marksheet();
}
}
private void Marksheet()
{
string sql = "Select * From MCA";
SqlCommand cmd = new SqlCommand(sql, con);
SqlDataAdapter sda = new SqlDataAdapter(cmd);
sda.Fill(ds);
if (!ds.Tables[0].Columns.Contains("Total"))
{
ds.Tables[0].Columns.Add("Total");
}
gvGrade.DataSource = ds;
gvGrade.DataBind();
}
<!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>
<asp:GridView ID="gvGrade" runat="server" AutoGenerateColumns="false"
DataKeyNames="RollNo" onrowdatabound="gvGrade_RowDataBound"
>
<Columns>
<asp:TemplateField HeaderText="Name">
<ItemTemplate>
<asp:Label ID="lblName" runat="server" Text='<%#Bind("Name") %>'/>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="RollNo">
<ItemTemplate>
<asp:Label ID="lblRollNo" runat="server" Text='<%#Bind("RollNo") %>'/>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Sub1" >
<ItemTemplate>
<asp:Label ID="lblSub1" runat="server" Text='<%#Bind("Sub1") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Sub2">
<ItemTemplate>
<asp:Label ID="lblSub2" runat="server" Text='<%#Bind("Sub2") %>'/>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Sub3">
<ItemTemplate>
<asp:Label ID="lblSub3" runat="server" Text='<%#Bind("Sub3") %>'/>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Sub4">
<ItemTemplate>
<asp:Label ID="lblSub4" runat="server" Text='<%#Bind("Sub4") %>'/>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Sub5">
<ItemTemplate>
<asp:Label ID="lblSub5" runat="server" Text='<%#Bind("Sub5") %>'/>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="TotalMarks">
<ItemTemplate>
<asp:Label ID="lblTotal" runat="server" Text='<%# Bind("Total") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
</Columns>
<EditRowStyle HorizontalAlign="Left" VerticalAlign="Bottom" />
</asp:GridView>
</div>
</form>
</body>
</html>
Code Behind
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;
using System.Configuration;
public partial class GradeCard : System.Web.UI.Page
{
DataSet ds = new DataSet();
SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["Y"].ToString());
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Marksheet();
Label sub1 = (Label)gvGrade.Rows[0].FindControl("lblSub1");
Label sub2 = (Label)gvGrade.Rows[0].FindControl("lblSub2");
Label sub3 = (Label)gvGrade.Rows[0].FindControl("lblSub3");
Label sub4 = (Label)gvGrade.Rows[0].FindControl("lblSub4");
Label sub5 = (Label)gvGrade.Rows[0].FindControl("lblSub5");
int s = Convert.ToInt32(sub1.Text) + Convert.ToInt32(sub1.Text) + Convert.ToInt32(sub2.Text) + Convert.ToInt32(sub3.Text) + Convert.ToInt32(sub4.Text) + Convert.ToInt32(sub5.Text);
ds.Tables[0].Columns.Add("Total");
DataRow dr = ds.Tables[0].NewRow();
dr["Total"] = s;
ds.Tables[0].Rows.Add(dr);
Marksheet();
}
}
private void Marksheet()
{
string sql = "Select * From MCA";
SqlCommand cmd = new SqlCommand(sql, con);
SqlDataAdapter sda = new SqlDataAdapter(cmd);
sda.Fill(ds);
if (!ds.Tables[0].Columns.Contains("Total"))
{
ds.Tables[0].Columns.Add("Total");
}
gvGrade.DataSource = ds;
gvGrade.DataBind();
}
Friday, 24 January 2014
Table Value Parameter
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="ViewState.aspx.cs" Inherits="ViewState" %>
<!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>
<panel>
<asp:Repeater ID="rpt" runat="server" ViewStateMode="Enabled">
<HeaderTemplate>
<table>
<tr>
<td width="150px" align="center">Name</td>
<td width="150px" align="center">Sex</td>
<td width="150px" align="center">Age</td>
</tr></table>
</HeaderTemplate>
<ItemTemplate>
<table>
<tr>
<td width="150px" align="center"><asp:Label ID="lblName" runat="server" Text='<%#Bind("Name") %>'/></td>
<td width="150px" align="center"><asp:Label ID="lblSex" runat="server" Text='<%#Bind("Sex") %>'/></td>
<td width="150px" align="center"><asp:Label ID="Age" runat="server" Text='<%#Bind("Age") %>'/></td>
</tr>
</table>
</ItemTemplate>
</asp:Repeater>
<br />
<br />
<asp:GridView ID="gv_Details" runat="server" AutoGenerateColumns="false"
Width="444px">
<Columns>
<asp:TemplateField HeaderText="Name">
<ItemTemplate>
<asp:Label ID="Name" runat="server" Text='<%#Bind("Name") %>'/>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Sex">
<ItemTemplate>
<asp:Label ID="Sex" runat="server" Text='<%#Bind("Sex") %>'/>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Age">
<ItemTemplate>
<asp:Label ID="Age" runat="server" Text='<%#Bind("Age") %>'/>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
<br />
<br />
<table width="450px">
<tr>
<td width="150px" align="center">Name</td>
<td width="150px" runat="server">
<asp:TextBox ID="txtName" runat="server"></asp:TextBox>
</td>
</tr>
<tr>
<td width="150px" align="center">Sex</td>
<td width="150px" runat="server">
<asp:TextBox ID="txtSex" runat="server"></asp:TextBox>
</td></tr>
<tr>
<td width="150px" align="center">Age</td>
<td width="150px" runat="server">
<asp:TextBox ID="txtAge" runat="server"></asp:TextBox>
</td>
</tr>
<tr>
<td ><asp:Button ID="btnAdd" runat="server" Text="AddNew" onclick="btnAdd_Click"
style="height: 26px" /></td>
<td>
<asp:Button Id="btnBind" Text="Bind" runat="server" onclick="btnBind_Click" />
</td>
</tr>
<tr>
<td colspan="2" align="center">
<asp:Button ID="btnInsert" Text="Insert" runat="server" onclick="btnInsert_Click" />
</td>
</tr>
</table>
</panel>
</div>
</form>
</body>
</html>
Code Behind
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;
using System.Configuration;
public partial class ViewState : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
DataTable dt = new DataTable();
protected void btnBind_Click(object sender, EventArgs e)
{
}
protected void btnAdd_Click(object sender, EventArgs e)
{
if (ViewState["Emp"] == null)
{
dt.Columns.Add("Name");
dt.Columns.Add("Sex");
dt.Columns.Add("Age");
}
else
dt=(DataTable)ViewState["Emp"];
DataRow dr=dt.NewRow();
dr["Name"]=txtName.Text;
dr["Sex"]=txtSex.Text;
dr["Age"]=txtAge.Text;
dt.Rows.Add(dr);
ViewState["Emp"] = dt;
dt =(DataTable)ViewState["Emp"];
}
protected void btnInsert_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["Y"].ToString());
con.Open();
dt = (DataTable)ViewState["Emp"];
SqlCommand cmd = new SqlCommand("SP_EMP",con);
cmd.CommandType=CommandType.StoredProcedure;
SqlParameter para = new SqlParameter();
para.ParameterName = "@EmployeeDetail";
para.Value = dt;
para.SqlDbType = SqlDbType.Structured;
cmd.Parameters.Add(para);
cmd.ExecuteNonQuery();
}
}
<!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>
<panel>
<asp:Repeater ID="rpt" runat="server" ViewStateMode="Enabled">
<HeaderTemplate>
<table>
<tr>
<td width="150px" align="center">Name</td>
<td width="150px" align="center">Sex</td>
<td width="150px" align="center">Age</td>
</tr></table>
</HeaderTemplate>
<ItemTemplate>
<table>
<tr>
<td width="150px" align="center"><asp:Label ID="lblName" runat="server" Text='<%#Bind("Name") %>'/></td>
<td width="150px" align="center"><asp:Label ID="lblSex" runat="server" Text='<%#Bind("Sex") %>'/></td>
<td width="150px" align="center"><asp:Label ID="Age" runat="server" Text='<%#Bind("Age") %>'/></td>
</tr>
</table>
</ItemTemplate>
</asp:Repeater>
<br />
<br />
<asp:GridView ID="gv_Details" runat="server" AutoGenerateColumns="false"
Width="444px">
<Columns>
<asp:TemplateField HeaderText="Name">
<ItemTemplate>
<asp:Label ID="Name" runat="server" Text='<%#Bind("Name") %>'/>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Sex">
<ItemTemplate>
<asp:Label ID="Sex" runat="server" Text='<%#Bind("Sex") %>'/>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Age">
<ItemTemplate>
<asp:Label ID="Age" runat="server" Text='<%#Bind("Age") %>'/>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
<br />
<br />
<table width="450px">
<tr>
<td width="150px" align="center">Name</td>
<td width="150px" runat="server">
<asp:TextBox ID="txtName" runat="server"></asp:TextBox>
</td>
</tr>
<tr>
<td width="150px" align="center">Sex</td>
<td width="150px" runat="server">
<asp:TextBox ID="txtSex" runat="server"></asp:TextBox>
</td></tr>
<tr>
<td width="150px" align="center">Age</td>
<td width="150px" runat="server">
<asp:TextBox ID="txtAge" runat="server"></asp:TextBox>
</td>
</tr>
<tr>
<td ><asp:Button ID="btnAdd" runat="server" Text="AddNew" onclick="btnAdd_Click"
style="height: 26px" /></td>
<td>
<asp:Button Id="btnBind" Text="Bind" runat="server" onclick="btnBind_Click" />
</td>
</tr>
<tr>
<td colspan="2" align="center">
<asp:Button ID="btnInsert" Text="Insert" runat="server" onclick="btnInsert_Click" />
</td>
</tr>
</table>
</panel>
</div>
</form>
</body>
</html>
Code Behind
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;
using System.Configuration;
public partial class ViewState : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
DataTable dt = new DataTable();
protected void btnBind_Click(object sender, EventArgs e)
{
}
protected void btnAdd_Click(object sender, EventArgs e)
{
if (ViewState["Emp"] == null)
{
dt.Columns.Add("Name");
dt.Columns.Add("Sex");
dt.Columns.Add("Age");
}
else
dt=(DataTable)ViewState["Emp"];
DataRow dr=dt.NewRow();
dr["Name"]=txtName.Text;
dr["Sex"]=txtSex.Text;
dr["Age"]=txtAge.Text;
dt.Rows.Add(dr);
ViewState["Emp"] = dt;
dt =(DataTable)ViewState["Emp"];
}
protected void btnInsert_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["Y"].ToString());
con.Open();
dt = (DataTable)ViewState["Emp"];
SqlCommand cmd = new SqlCommand("SP_EMP",con);
cmd.CommandType=CommandType.StoredProcedure;
SqlParameter para = new SqlParameter();
para.ParameterName = "@EmployeeDetail";
para.Value = dt;
para.SqlDbType = SqlDbType.Structured;
cmd.Parameters.Add(para);
cmd.ExecuteNonQuery();
}
}
Subscribe to:
Posts (Atom)