CLR :( Common Lalguage Runtime ):
It is responsible For Language Intigration And Managing Memory Process
OR
ClR Must know Wt Type Of Language Developer Developed... With The Help Of CTS and CLS...
Every Question..What does it mean? Why is this? How it works?
Microsoft .Net (pronounced dot (.) net) may be a package element that runs on the Windows software package.
.Net provides tools and libraries that change developers to form Windows package a lot of quicker and easier.
Microsoft describes it as:".Net is that the Microsoft internet Service strategy to attach data, people,
system and devices through software".I'm Choulla Naresh..!
Monday, July 7, 2014
Delegate Interface AbstarctClass Pointer
Delegate: Delegate is A function Pointer. Wch Is Used to Point the Address Of Another Variable.
Delegate Are Two Types:
--> SingleCast Delegate
--> Multicast Delegate
When ever delegate Object refer to The addrss Of the Single method then it is Said to be singlevast Delegate.
When Ever delegate object Refer To multiple methods then it is said to be multicast Delegate
Pointer:
Pointer Is A Variable That Stores the Address Of Another Variable.
Interface:
InterFace contains undefined method..
OR
Its is a collection of members.. Without Any Defination..
Abstract Class:
Abstract Class Contains Defined And Undefined Methos
Or
It is A collection members.. With OR Without Any Any Defination
Delegate Are Two Types:
--> SingleCast Delegate
--> Multicast Delegate
When ever delegate Object refer to The addrss Of the Single method then it is Said to be singlevast Delegate.
When Ever delegate object Refer To multiple methods then it is said to be multicast Delegate
Pointer:
Pointer Is A Variable That Stores the Address Of Another Variable.
Interface:
InterFace contains undefined method..
OR
Its is a collection of members.. Without Any Defination..
Abstract Class:
Abstract Class Contains Defined And Undefined Methos
Or
It is A collection members.. With OR Without Any Any Defination
Trigger
It Is a One type Of stored procedure. Automatically Database Control hits The Trigger When Ever Event Accor
Sunday, July 6, 2014
Two Dropdowns gridview
<%@ 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">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:GridView ID="outergrid"
runat="server"
AutoGenerateColumns="false" OnRowDataBound="drop" ShowFooter="true"
DataKeyNames="id"
>
<Columns>
<asp:TemplateField HeaderText="textbox1">
<ItemTemplate>
<asp:TextBox ID="txtid" runat="server"></asp:TextBox>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="textbox2">
<ItemTemplate>
<asp:TextBox ID="txtname" runat="server"></asp:TextBox>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="coutrydrop">
<ItemTemplate>
<asp:DropDownList runat="server" ID="dropc" AppendDataBoundItems="true"
OnSelectedIndexChanged="dropc_SelectedIndexChanged"
AutoPostBack="true" >
<asp:ListItem Value="-1">--Select--</asp:ListItem>
</asp:DropDownList>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="statedrop">
<ItemTemplate>
<asp:DropDownList runat="server" ID="drops" AppendDataBoundItems="true"
>
<asp:ListItem Value="-1">--Select--</asp:ListItem>
</asp:DropDownList>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="innergrid">
<ItemTemplate>
<asp:GridView ID="innergrid" runat="server">
</asp:GridView>
</ItemTemplate>
<FooterTemplate>
<asp:Button ID="btnadd" Text="AddRows" runat="server" onclick="btnadd_Click" />
</FooterTemplate>
</asp:TemplateField>
</Columns>
</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;
using System.Data.SqlClient;
using System.Configuration;
public partial class _Default :
System.Web.UI.Page
{
public string con = ConfigurationManager.ConnectionStrings["con"].ToString();
SqlConnection cn;
SqlCommand cmd;
protected void
Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
//ViewState.Clear();
for (int i = 0; i
< 10; i++)
{
CreateGridView();
}
}
}
public void
CreateGridView()
{
//int numbers = 10;
DataTable dt = new
DataTable();
dt.Columns.Add("id", typeof(string));
dt.Columns.Add("txtid", typeof(string));
dt.Columns.Add("txtname", typeof(string));
dt.Columns.Add("countrydrop",
typeof(string));
dt.Columns.Add("statedrop",
typeof(string));
dt.Columns.Add("innergrid", typeof(string));
dt.Rows.Add("", "", "",
"", "","");
if (ViewState["dt"]
== null)
{
dt.Rows.Add("", "", "",
"", "","");
ViewState["dt"] = dt;
outergrid.DataSource = dt;
outergrid.DataBind();
}
else
{
DataTable dt2 = (DataTable)ViewState["dt"];
dt2.Rows.Add("", "", "",
"", "","");
ViewState["dt"] = dt2;
outergrid.DataSource = dt2;
outergrid.DataBind();
}
//if (ViewState["dt"] == null)
//{
//
dt.Rows.Add("", "", "", "",
"");
//
ViewState["dt"] = dt;
//
outergrid.DataSource = dt;
//
outergrid.DataBind();
//}
}
protected void drop(object sender, GridViewRowEventArgs
e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
var drop = (DropDownList)e.Row.FindControl("dropc");
var drops = (DropDownList)e.Row.FindControl("drops");
SqlConnection cnn = new
SqlConnection(con);
SqlCommand cmd = new
SqlCommand("select
* from country");
cmd.Connection = cnn;
SqlDataAdapter da = new
SqlDataAdapter(cmd);
DataSet
ds = new DataSet();
da.Fill(ds);
drop.DataSource = ds;
drop.DataTextField = "cname";
drop.DataValueField = "cid";
drop.DataBind();
int CID = Convert.ToInt32(drop.SelectedValue);
SqlCommand cmd1 = new
SqlCommand("select
* from state1 where cid=" + CID, cnn);
SqlDataAdapter da1 = new
SqlDataAdapter(cmd1);
DataSet ds1 = new DataSet();
da1.Fill(ds1);
drops.DataSource = ds1;
drops.DataTextField = "sname";
drops.DataValueField = "sid";
drops.DataBind();
}
}
public void
dropc_SelectedIndexChanged(object sender, EventArgs e)
{
DropDownList dropc = (DropDownList)sender;
GridViewRow row = (GridViewRow)dropc.NamingContainer;
DropDownList drops = (DropDownList)row.FindControl("drops");
int CID = Convert.ToInt32(dropc.SelectedValue);
cn = new SqlConnection(con);
cn.Open();
cmd =
new SqlCommand("select * from state1 where cid=" + CID,
cn);
SqlDataAdapter da = new
SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
drops.DataSource = ds;
drops.DataTextField
= "sname";
drops.DataValueField = "sid";
drops.DataBind();
ViewState["dt4"] =
ds.Tables.Add();
// DropDownList2.Items.Insert(0, new
ListItem("--Select--", "0"));
}
protected void
btnadd_Click(object sender, EventArgs e)
{
// Session.Clear();
if (ViewState["dt"]
!= null)
{
DataTable dt1 = (DataTable)ViewState["dt"];
DataRow dr = null;
if (dt1.Rows.Count > 0)
{
dr = dt1.NewRow();
dr["id"] = dt1.Rows.Count +
1;
dt1.Rows.Add(dr);
ViewState["dt"] = dt1;
for (int
i = 0; i < dt1.Rows.Count - 1; i++)
{
DropDownList ddp = (DropDownList)outergrid.Rows[i].Cells[2].FindControl("dropc");
dt1.Rows[i]["countrydrop"]
= ddp.SelectedItem.Text;
//DropDownList dds =
(DropDownList)outergrid.Rows[i].Cells[3].FindControl("drops");
//dt1.Rows[i]["statedrop"] =
dds.SelectedItem.Text;
////dr = dt1.NewRow();
ViewState["dt"] = dt1;
}
outergrid.DataSource = dt1;
outergrid.DataBind();
ViewState["dt"] = dt1;
//DropDownList dropc = (DropDownList)sender;
//GridViewRow row =
(GridViewRow)dropc.NamingContainer;
//DropDownList drops =
(DropDownList)row.FindControl("drops");
}
}
else
{
Response.Write("view is null");
}
previousdata();
}
private void
previousdata()
{
int a = 0;
if (ViewState["dt"]
!= null)
{
DataTable dt3 = (DataTable)ViewState["dt"];
if (dt3.Rows.Count > 0)
{
for (int
i = 0; i < dt3.Rows.Count; i++)
{
DropDownList ddp = (DropDownList)outergrid.Rows[a].Cells[2].FindControl("dropc");
DropDownList dds = (DropDownList)outergrid.Rows[a].Cells[3].FindControl("drops");
//dt2.Columns.Add("countrydrop",
typeof(string));
//dt3.Rows[a]["countrydrop"] =
ddp.SelectedItem.Text;
ddp.SelectedValue = dt3.Rows[i]["countrydrop"].ToString();
dds.SelectedValue = dt3.Rows[i]["statedrop"].ToString();
if (i < dt3.Rows.Count - 1)
{
ddp.ClearSelection();
ddp.Items.FindByText(dt3.Rows[i]["countrydrop"].ToString()).Selected
= true;
//dds.ClearSelection();
//dds.Items.FindByText(dt3.Rows[i]["statedrop"].ToString()).Selected
= true;
}
a++;
}
}
}
}
}
Friday, July 4, 2014
Two Dropdowns in GridView Country and State
<%@ 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">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:SqlDataSource ID="SqlDataSource1"
runat="server"
ConnectionString="<%$ ConnectionStrings:abc %>"
SelectCommand="SELECT *
FROM Country"></asp:SqlDataSource>
<asp:GridView ID="GridView1"
runat="server"
AutoGenerateColumns="False"
DataKeyNames="Countryid"
DataSourceID="SqlDataSource1">
<Columns>
<asp:BoundField DataField="Countryid"
HeaderText="Countryid"
InsertVisible="False"
ReadOnly="True"
SortExpression="Countryid"
/>
<asp:TemplateField HeaderText="Categories">
<ItemTemplate>
<asp:DropDownList ID="ddlCategories" AutoPostBack="true" DataTextField="CountryName"
DataValueField="Countryid"
DataSourceID="SqlDataSource1"
runat="server"
AppendDataBoundItems="true"
SelectedValue='<%# Bind("Countryid") %>' />
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Products">
<ItemTemplate>
<asp:DropDownList ID="ddlProducts" DataTextField="StateName" DataValueField="Stateid"
DataSourceID="SqlDataSource2"
runat="server"
/>
<asp:SqlDataSource runat="server" ID="sqlDataSource2" ConnectionString="<%$ ConnectionStrings:abc %>"
SelectCommand="SELECT *
FROM State"
FilterExpression="Countryid
= '{0}'">
<FilterParameters>
<asp:ControlParameter Name="categoryParam"
ControlID="ddlCategories"
PropertyName="SelectedValue"
/>
</FilterParameters>
</asp:SqlDataSource>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
</div>
</form>
</body>
</html>
<?xml version="1.0"?>
<!--
For more information on how to configure your ASP.NET application,
please visit
http://go.microsoft.com/fwlink/?LinkId=169433
-->
<configuration>
<connectionStrings>
<add name="abc" connectionString="Data
Source=KCLINK-PC\SQLEXPRESS;Initial Catalog=kclink;Integrated Security=True" providerName="System.Data.SqlClient"/>
</connectionStrings>
<system.web>
<compilation debug="true" targetFramework="4.0"/>
</system.web>
</configuration>
Subscribe to:
Posts (Atom)