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

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

.Net Flow

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...

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

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">

</head>

<body>

<div>

<asp:GridView ID="outergrid" runat="server" AutoGenerateColumns="false" OnRowDataBound="drop" ShowFooter="true" DataKeyNames="id" >

<asp:TemplateField HeaderText="textbox1">

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

</ItemTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="textbox2">

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

</ItemTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="coutrydrop">

<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">

<asp:DropDownList runat="server" ID="drops" AppendDataBoundItems="true" >

<asp:ListItem Value="-1">--Select--</asp:ListItem>

</asp:DropDownList>

</ItemTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="innergrid">

<asp:GridView ID="innergrid" runat="server">

</asp:GridView>

</ItemTemplate>

<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">

</head>

<body>

<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">

<asp:BoundField DataField="Countryid" HeaderText="Countryid" InsertVisible="False"

ReadOnly="True" SortExpression="Countryid" />

<asp:TemplateField HeaderText="Categories">

<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">

<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}'">

<asp:ControlParameter Name="categoryParam" ControlID="ddlCategories" PropertyName="SelectedValue" />

</FilterParameters>

</asp:SqlDataSource>

</ItemTemplate>

</asp:TemplateField>

</Columns>

</asp:GridView>

</div>

</form>

</body>

</html>

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

WEB.CONFIG

<?xml version="1.0"?>

<!--

For more information on how to configure your ASP.NET application, please visit

http://go.microsoft.com/fwlink/?LinkId=169433

-->

</connectionStrings>

<system.web>

</system.web>

</configuration>