Miranju.net developer

 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; public partial class task2 : System.Web.UI.Page {     SqlConnection cn;     SqlCommand cm;     SqlDataReader dr;     protected void Page_Load(object sender, EventArgs e)     {         if(!IsPostBack)         {         }     }     protected void Button1_Click(object sender, EventArgs e)     {         string k = @"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\college.mdf;Integrated Security=True;User Instance=True";         cn = new SqlConnection(k);         cn.Open();         string k1="insert into student values('"+TextBox1.Text+"', '"+TextBox2.Text+"', '"+TextBox3.Text+"','"+TextBox4.Tex...

 datconncet database to web form(aspx) steps 1.include database library   SQLSERVER - library sqlclient   XML - library xml   ACCESS(excel) - library oledb How to use library  using system.data.library; eg. using system.data.sqlclient; step 2: create database object there are following object is used to create in a database  a.sqlconnection-representing database location/path  SYNTAX  sqlconnection objname; eg.sqlconnection cn; b.sqlcommand- representing all query(insert,update,select,delete)  SYNTAX sqlcommand objname; eg.sqlcommand cm; c.sqldatareader-it used to reading record from database(if we have to used select query then using datareader object) SYNTAX  sqldatareader objname; eg.sqldatareader dr; NOTE: all object is to be create before the page load step 3 Break the page reloading process(inside the page load event) if(!ispostback) { } DATABASE CODING(insert,update,delete,select and all query) step 1: Open connection step 2: Appl...

 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; public partial class Dview1 : System.Web.UI.Page {     SqlConnection cn;     SqlCommand cm;     SqlDataReader dr;     protected void Page_Load(object sender, EventArgs e)     {         if (!IsPostBack)         {         }     }     protected void Button1_Click(object sender, EventArgs e)     {         string k = @"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\college.mdf;Integrated Security=True;User Instance=True";         cn = new SqlConnection(k);         cn.Open();         string k1 = "select * from student";         cm = new SqlCommand(k1, cn);     ...

Data Transmission State management  session expire  query string  view state  cokkies application state session  1. Secure data transfermation  2. 60 sec of default time  3. how to create session      syntax            session["variable"]=control;           session["email"]=textbox1.text;    session is to be access in all website.  Q.how to access session?     All types of session is to be access inside the page load event  Query String 1. Query string is used to transfer data with URL 2. Query string does not use secure data tranfermation  3. Query string variable represent que mark.      Syntax Response.redirect("page.aspx?variable="+control); control=request.querystring["variable"]; Query string is to be acess in page load event   *Multiple variable in query string      (&)mpercent

Gridview gridview start with 0 position syntax: string location = @"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\college.mdf;Integrated Security=True;User Instance=True";         cn = new SqlConnection(location);         cn.Open();         //how to bind grid view          string k = "select * from student";         cm = new SqlCommand(k, cn);         dr = cm.ExecuteReader();         GridView1.DataSource = dr;         GridView1.DataBind();         dr.Close(); Template in grid view     1.template id used to inserting control in a grid view     2.Only one property is used to template field      Template field- Header text grid view select- edit column- template field - header text (student mark) How to insert control  in this concept we have to u...