Skip to main content

Grid View Assignment -01 [Attendence]

 Q. Insert checkbox and textbox in grid view and create a column in data base table named "Attendence" when a user Select the record using checkbox and input present/absent in textbox should be reflected to the database table.

Update Selection(button) 

Code- 

{

        string s = @"Data Source=49.50.88.43;Initial Catalog=grkistdb;Persist Security Info=True;User ID=grkistuser;Password=q2oR5w_356";

        cn = new SqlConnection(s);

        cn.Open();


        foreach (GridViewRow gr1 in GridView1.Rows)

        {


            CheckBox c1 = (CheckBox) gr1.FindControl("cb1");

            TextBox t1 = (TextBox)gr1.FindControl("tb1");


            if (c1.Checked)

            {

                

                string q = "update Chitransh_reg set Attendance ='" + t1.Text + "' where roll='"+gr1.Cells[1].Text+"'";

  

                cm = new SqlCommand(q, cn);

                

                cm.ExecuteNonQuery();

            } 


        }

    }



Comments

Post a Comment

Popular posts from this blog

DataBase Assignment

  1. Registration page(Design)  Note:- We used Range validator in Age 's textbox.  Coding- 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 Registration : System.Web.UI.Page {     SqlConnection cn;     SqlCommand cm;     SqlDataReader dr;     protected void Page_Load(object sender, EventArgs e)     {     }      //Coding of submit button     protected void Button1_Click(object sender, EventArgs e)     {         string p=@"Data Source=49.50.88.43;Initial Catalog=grkistdb;Persist Security Info=True;User ID=grkistuser;Password=q2oR5w_356";         cn = new SqlConnection(p);         cn.Open();         string q = "insert into Chitransh_reg values ( '"+TextBox1.Te...
Post a Comment
Read more

Grid View Assignment 02[Fetching Image from Data Base]

WRITE THE CODE FOR FIND BUTTON TO FIND THE DATA AND IMAGE WITH THE REFERENCE OF USER ID-     FIND BUTTON CODING-      protected void Find_Click(object sender, EventArgs e)     {         string k = @"Data Source=49.50.88.43;Initial Catalog=grkistdb;Persist Security Info=True;User ID=grkistuser;Password=q2oR5w_356";         cn = new SqlConnection(k);         cn.Open();         string q = "select * from addhar where id='" + TextBox1.Text + "'";         cm = new SqlCommand(q, cn);         dr=cm.ExecuteReader();         if (dr.Read())         {             TextBox2.Text = dr["name"].ToString();             TextBox3.Text = dr["address"].ToString();             Image1.ImageUrl = "~/pics/" + dr["status"].ToStr...
Post a Comment
Read more

FileUpload And QueryString

1. Took File Upload control, Button, Image button control,  Label (First Page) [Browse your desired file > Click on Upload Button > Image will be shown in Image Button Control  ]  Inside the event of ImageButton QueryString is defined.  CODING- 2. When we click on it then the next page will be shown Image ,Using QueryString-  (Next Page) Image control will be used-  Inside page_load event we will call QueryString.
Post a Comment
Read more