1.subject: Insert Countrey Base State

1.
SUBJECT: INSERT COUNTREY BASE STATE

using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
public partial class Default4 : System.Web.UI.Page
{
int a;
SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["vy"].ToString());
SqlCommand cmd = new SqlCommand();
SqlDataAdapter adp = new SqlDataAdapter();
DataTable dt = new DataTable();
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
con.Open();
cmd.Connection = con;
cmd.CommandText = "select * from COUNTRY ";
adp.SelectCommand = cmd;
adp.Fill(dt);
DropDownList1.DataValueField = "cid";
DropDownList1.DataTextField = "cname";
DropDownList1.DataSource = dt;
DropDownList1.DataBind();
DropDownList1.Items.Insert(0, "-select-");
con.Close();
}
}
protected void Button1_Click(object sender, EventArgs e)
{
con.Open();
cmd.CommandText = "insert into state1 values('" + TextBox1.Text + "'," +DropDownList1.SelectedValue +")";
cmd.ExecuteNonQuery();
con.Close();
}
}
SUBJECT: SQL QUERY OF COUNTRY
create table country (cid int primary key,cname varchar(50))

create table state (sid int primary key,sname varchar(50),cid int foreign key references country)
create table district (dname varchar(50),sid int foreign key references state)
insert into country values(12,'US')

insert into state values(106,'US2',12)
insert into district values('U12',106)
select * from district

select * from state
select * from country
SUBJECT: COUNTRY-SELECT
using System;
using System.Data;
using System.Collections;
using System.Web;
public partial class Default3 : System.Web.UI.Page
{
{
if (!IsPostBack)
{
con.Open();
cmd.CommandText = "select * from COUNTRY ";
adp.Fill(dt);
DropDownList1.DataTextField = "cname";
con.Close();
}
}
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
con.Open();
cmd.CommandText = "select sname from state where cid=(select cid from country where
cname='"+DropDownList1.Text+"')";
adp.Fill(dt);
DropDownList2.DataTextField = "sname";
DropDownList3.ClearSelection();
con.Close();
}
{
con.Open();
cmd.CommandText = "select dname from district where sid=(select sid from state where sname='" +
DropDownList2.Text + "')";
adp.Fill(dt);
DropDownList3.DataTextField = "dname";
con.Close();
}
}
SUBJECT: DETAILED VIEW FROM DROP DOWN LIST

using System;
using System.Data;
using System.Web;
public partial class _Default : System.Web.UI.Page
{
SqlDataReader dr;
{
if (!IsPostBack)
{
con.Open();
cmd.CommandText = "select * from login ";
adp.Fill(dt);
DropDownList1.DataTextField = "id";
con.Close();
}
}
{
con.Open();
cmd.CommandText = "select * from login where id=" + DropDownList1.Text;
adp.Fill(dt);
DetailsView1.DataSource = dt;
DetailsView1.DataBind();
con.Close();
}
protected void DetailsView1_PageIndexChanging(object sender, DetailsViewPageEventArgs e)
{
}
}
SUBJECT: SELECT INSERT UPDATE GRID VIEW
using System;
using System.Data;
using System.Web;
{
SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["v"].ToString());
public void fill()
{
con.Open();
cmd.CommandText = "select * from emp";
adp.Fill(dt);
GridView1.DataSource = dt;
GridView1.DataBind();
con.Close();
}
public void Page_Load(object sender, EventArgs e)
{
if(!IsPostBack)
{
fill();
}
}
protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
{
GridView1.EditIndex = e.NewEditIndex;
fill();
}
protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
{
GridView1.EditIndex = -1;
fill();
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
GridViewRow gr = GridView1.Rows[Convert.ToInt32(e.RowIndex)];
TextBox t1, t2, t3;
t1 = (TextBox)gr.Cells[0].Controls[0];
con.Open();
cmd.CommandText = "update emp set name='"+t2.Text+"',place='"+t2.Text+"' where id="+t1.Text;
adp.Fill(dt);
con.Close();
fill();
}
protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{
TextBox1.Text = GridView1.SelectedRow.Cells[0].Text;
}
}
using System;
using System.Data;
using System.Web;
{
public void fill()
{
con.Open();
adp.Fill(dt);
con.Close();
}
{
if(!IsPostBack)
{
fill();
}
}
{
fill();
}
{
fill();
}
{
TextBox t1, t2, t3;
con.Open();
adp.Fill(dt);
con.Close();
fill();
}
{
}
using System;
using System.Data;
using System.Web;
{
public void fill()
{
con.Open();
adp.Fill(dt);
con.Close();
}
{
if(!IsPostBack)
{
fill();
}
}
{
fill();
}
{
fill();
}
{
TextBox t1, t2, t3;
con.Open();
adp.Fill(dt);
con.Close();
fill();
}
{
}
}

1.subject: Insert Countrey Base State

Uploaded by

Copyright:

Available Formats

1.subject: Insert Countrey Base State

Uploaded by

Document Information

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

1.subject: Insert Countrey Base State

Uploaded by

Copyright:

Available Formats

1.

SUBJECT: INSERT COUNTREY BASE STATE

create table country (cid int primary key,cname varchar(50))

insert into country values(12,'US')

select * from district

SUBJECT: DETAILED VIEW FROM DROP DOWN LIST

SUBJECT: SELECT INSERT UPDATE GRID VIEW

SUBJECT: SELECT INSERT UPDATE GRID VIEW

SUBJECT: SELECT INSERT UPDATE GRID VIEW

You might also like