Grid view code

using System;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
public partial class _Default : System.Web.UI.Page
{
    SqlConnection sqlCon = new SqlConnection(ConfigurationManager.ConnectionStrings["con"].ToString());

    protected void Page_Load(object sender, EventArgs e)
    {
        //if(!IsPostBack)
        //{
        //  BinData();
        //  //ddlfill();
        //}
        BinData();
     
           }

    protected void BinData()
    {
        //SqlDataAdapter sqlDa = new SqlDataAdapter("select * from Gridview", sqlCon);
        //DataSet Ds = new DataSet();
        //sqlDa.Fill(Ds, "Gridview");
        //GridView1.DataSource = Ds.Tables["Gridview"].DefaultView;
        //GridView1.DataBind();

        sqlCon.Open();
        SqlCommand sqlCmd = new SqlCommand("select * from Gridview",sqlCon);
        SqlDataReader dr = sqlCmd.ExecuteReader();
        if(dr.Read())
        {
            GridView1.DataSource = dr;
            GridView1.DataBind();
       
        }

        sqlCon.Close();


    }
    //public void ddlfill()
    //{
    //    for (byte i = 1; i < GridView1.PageCount; i++)
    //    {
    //        DropDownList1.Items.Add(i.ToString());
    //    }
    //}

   
    protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
    {

    }

protected void  GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
//  GridView1.PageIndex=e.NewPageIndex;
//    BinData();
//   btnSearch.Text = (e.NewPageIndex + 1) + "/out of/" + GridView1.PageCount;
}
protected void  GridView1_RowEditing(object sender, GridViewEditEventArgs e)
{
    //GridView1.EditIndex=e.NewEditIndex;
    //BinData();

}
protected void  GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
{
    //GridView1.EditIndex= -1;
    //BinData();
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
    int sid = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Value.ToString());
    GridViewRow row = GridView1.Rows[e.RowIndex];
    TextBox TSname = (TextBox)row.FindControl("txtSName");
    TextBox TSclass = (TextBox)row.FindControl("txtSClass");
    TextBox TSCollege = (TextBox)row.FindControl("txtSCollege");
    TextBox TSCourse = (TextBox)row.FindControl("txtSCourse");
    TextBox TSPlace = (TextBox)row.FindControl("txtSPlace");
    SqlCommand sqlCmd = new SqlCommand();
    sqlCon.Open();
    sqlCmd.Connection = sqlCon;
    sqlCmd.CommandType = CommandType.StoredProcedure;
    sqlCmd.CommandText = "usp_update";
    sqlCmd.Parameters.Add("@sid", SqlDbType.Int).Value = sid;
    sqlCmd.Parameters.Add("@sname", SqlDbType.VarChar, 50).Value = TSname.Text;
    sqlCmd.Parameters.Add("@sclass", SqlDbType.VarChar, 50).Value = TSclass.Text;
    sqlCmd.Parameters.Add("@scollege", SqlDbType.VarChar, 50).Value = TSCollege.Text;
    sqlCmd.Parameters.Add("@scourse", SqlDbType.VarChar, 50).Value = TSCourse.Text;
    sqlCmd.Parameters.Add("@splace", SqlDbType.VarChar, 50).Value = TSPlace.Text;
    sqlCmd.ExecuteNonQuery();
    sqlCon.Close();
    GridView1.EditIndex = -1;
    BinData();


}

protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
    int sid = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Value.ToString());
    GridViewRow row = GridView1.Rows[e.RowIndex];
    SqlCommand sqlcmd = new SqlCommand();
    sqlCon.Open();
    sqlcmd.Connection = sqlCon;
    sqlcmd.CommandType = CommandType.StoredProcedure;
    sqlcmd.CommandText = "usp_delete";
    sqlcmd.Parameters.Add("@sid", SqlDbType.Int).Value = sid;
    sqlcmd.ExecuteNonQuery();
    sqlCon.Close();
    GridView1.EditIndex = -1;
    BinData();


}
protected void Button1_Click(object sender, EventArgs e)
{

    if (ddlSelect.SelectedIndex > 0)
    {
        SqlDataAdapter sqlDa = new SqlDataAdapter("select * from sdetails where " + ddlSelect.SelectedItem.Text + " like  '%" + txtSearch.Text + "%'", sqlCon);
        DataSet Ds = new DataSet();
        sqlDa.Fill(Ds, "sdetails");
        GridView1.DataSource = Ds.Tables["sdetails"].DefaultView;

        GridView1.DataBind();
    }

    else
    {
        SqlDataAdapter sqlDa = new SqlDataAdapter("select * from sdetails", sqlCon);
        DataSet Ds = new DataSet();
        sqlDa.Fill(Ds, "sdetails");
        GridView1.DataSource = Ds.Tables["sdetails"].DefaultView;
        GridView1.DataBind();

    }
}


protected void ddlSelect_SelectedIndexChanged(object sender, EventArgs e)
{

}

protected void btnCancel_Click(object sender, EventArgs e)
{
    SqlDataAdapter sqlDa = new SqlDataAdapter("select * from sdetails", sqlCon);
    DataSet Ds = new DataSet();
    sqlDa.Fill(Ds, "sdetails");
    GridView1.DataSource = Ds.Tables["sdetails"].DefaultView;
    GridView1.DataBind();
}
protected void btnDelete_Click(object sender, EventArgs e)
{
    for (int i = 0; i < GridView1.Rows.Count; i++)
    {
        CheckBox ch = (CheckBox)GridView1.Rows[i].FindControl("chkDel");
        if (ch.Checked == true)
        {
            Label l1 = (Label)GridView1.Rows[i].FindControl("lblSid");
            sqlCon.Open();
            SqlCommand sqlCmd = new SqlCommand("delete from sdetails where sid='" + l1.Text + "'", sqlCon);
            sqlCmd.ExecuteNonQuery();
            sqlCon.Close();
        }

    }
    BinData();
}
protected void GridView1_SelectedIndexChanged1(object sender, EventArgs e)
{

}
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
    GridView1.PageIndex = DropDownList1.SelectedIndex;
    BinData();
    btnShow.Text = (DropDownList1.SelectedIndex + 1) + "Outof" + GridView1.PageCount;
}
protected void CheckBox2_CheckedChanged(object sender, EventArgs e)
{
    CheckBox ch;
    CheckBox chkall = (CheckBox)GridView1.HeaderRow.FindControl("Chkall");
    if (chkall.Checked == true)
    {
        foreach (GridViewRow gvr in GridView1.Rows)
        {
            ch = (CheckBox)gvr.FindControl("chkDel");
            ch.Checked = true;

        }
    }
    else
    {
        foreach (GridViewRow gvr in GridView1.Rows)
        {
            ch = (CheckBox)gvr.FindControl("chkDel");
            ch.Checked = false;

        }
    }
}
protected void btnInsert_Click(object sender, EventArgs e)
{
    TextBox TSid = (TextBox)GridView1.FooterRow.FindControl("txtSid");
    TextBox TSname = (TextBox)GridView1.FooterRow.FindControl("txtSName");
    TextBox TSclass = (TextBox)GridView1.FooterRow.FindControl("txtSClass");
    TextBox TSCollege = (TextBox)GridView1.FooterRow.FindControl("txtSCollege");
    TextBox TSCourse = (TextBox)GridView1.FooterRow.FindControl("txtSCourse");
    TextBox TSPlace = (TextBox)GridView1.FooterRow.FindControl("txtSPlace");
    sqlCon.Open();
    SqlCommand sqlCmd = new SqlCommand("insert into sdetails values('" + TSid.Text + "','" + TSname.Text + "','" + TSclass.Text + "','" + TSCollege.Text + "','" + TSCourse.Text + "','" + TSPlace.Text + "')", sqlCon);
    sqlCmd.ExecuteNonQuery();
    sqlCon.Close();
    TSid.Text = "";
    TSid.Text = "submitted";
}
protected void chkall_CheckedChanged(object sender, EventArgs e)
{
    CheckBox ch;
    CheckBox chkall = (CheckBox)GridView1.HeaderRow.FindControl("Chkall");
    if (chkall.Checked == true)
    {
        foreach (GridViewRow gvr in GridView1.Rows)
        {
            ch = (CheckBox)gvr.FindControl("chkDel");
            ch.Checked = true;

        }
    }
    else
    {
        foreach (GridViewRow gvr in GridView1.Rows)
        {
            ch = (CheckBox)gvr.FindControl("chkDel");
            ch.Checked = false;

        }
    }
}
protected void GridView1_SelectedIndexChanged2(object sender, EventArgs e)
{

}
}

code for login controls for sql server

protected void Login1_Authenticate(object sender,
AuthenticateEventArgs e)
    {   string u_id=Login1.UserName;
        string pwd=Login1.Password;

        SqlConnection con = new
SqlConnection("uid=sa;pwd=nivt;server=.;database=jobportal");
        try
        {
            con.Open();
            SqlDataAdapter da = new SqlDataAdapter("select *
from rec_registration where rec_username='" + u_id + "'", con);
            DataSet ds = new DataSet();
            da.Fill(ds);
            if (Login1.UserName ==
ds.Tables[0].Rows[0][0].ToString() && Login1.Password ==
ds.Tables[0].Rows[0][1].ToString())
            {
                Session["rec_uid"] = u_id;
                Session["rec_uname"] =
ds.Tables[0].Rows[0][3].ToString();
                Session["rec_type"] =
ds.Tables[0].Rows[0][5].ToString();

               Response.Redirect("rec_home.aspx");
                
            }
            else
            {
                Label2.Text = "Invalid Username/Password:";

            }
        }
        catch(Exception ex)
        {
            Label3.Text = ex.Message.ToString();
            Label2.Text = "Invalid Username";

        }
        finally
        {
            if (con.State == ConnectionState.Open)
            {
                con.Close();
            }
        }

    }

How to store image file in Sql server database?

//use this code to store image file in sql server database

//get directory Path(C:\\Temp) where image has stored and 
use these two method in ur program

        private void GetImagePath(string strDirectoryPath)
        {
            DirectoryInfo mobjDirInfo = new DirectoryInfo
(strDirectoryPath);
            //object[] mobjStore = new object
[Directory.GetFiles(strDirectoryPath, "*.JPG").Length];
            int counter =1;
            foreach (FileInfo fl in mobjDirInfo.GetFiles
("*.JPG"))
            {
                // Create a new stream to load this photo 
into
                FileStream stream = new FileStream
(fl.FullName.ToString(), FileMode.Open, FileAccess.Read);

                // Create a buffer to hold the stream bytes
                byte[] buffer = new byte[stream.Length];

                // Read the bytes from this stream
                stream.Read(buffer, 0, (int)stream.Length);

                // Now we can close the stream
                stream.Close();

                // Extract out the name of the file an use 
it for the name of the photo
                string strName = 
Path.GetFileNameWithoutExtension(fl.Name.ToString());

                // Insert the image into the database and 
add it to the tree
                InsertImageIntoDatabase(ref buffer, 
strName, counter);
                buffer = null;
                counter = counter+1;
            }
        }


//Insert Images into sql server (create table TBLIMAGE
(PHOTOID int,PHOTONAME varchar(20),PHOTO IMAGE))
        private void InsertImageIntoDatabase(ref byte[] 
buffer, string strPhotoName, int intPhotoid)
        {
            if (mobjConn.State == ConnectionState.Closed)
            {
                mobjConn.Open();
            }
            
            mobjCmd = new SqlCommand("Insert Into TBLIMAGE 
values(@PHOTOID,@PHOTONAME,@PHOTO)", mobjConn);
            mobjCmd.Parameters.Add("@PHOTOID", intPhotoid);
            mobjCmd.Parameters.Add
("@PHOTONAME",strPhotoName);
            mobjCmd.Parameters.Add("@PHOTO", buffer);
            mobjCmd.ExecuteNonQuery();

        }

//if u have any query please revert back

how to install the silver light to vs studio 2008

step:1


Down load the sp1 from below sit:

http://www.microsoft.com/downloads/en/confirmation.aspx?familyId=fbee1648-7106-44a7-9649-6d9f6d58056e&displayLang=en


Step2:

Downloading all type of files from Gridview

 protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
    {
         try
    {
        int fileindex = (int)GridView1.SelectedValue;

         string dbPath = null;
   
        DataSet path = Download.GetresourcePath(fileindex);

        foreach (DataRow row in path.Tables["filepath"].Rows)
        {
            dbPath = string.Format("{0}", row["filepath"]);

         }

            string filePath = @dbPath;

             string fileName = Path.GetFileName(filePath);

            System.IO.Stream stream = null;

            stream = new FileStream(filePath, System.IO.FileMode.Open, System.IO.FileAccess.Read, System.IO.FileShare.Read);
            long bytesToRead = stream.Length;
            Response.ContentType = "application/octet-stream";

             Response.AddHeader("content-Disposition", "attachment; filename=" + fileName);

              while (bytesToRead > 0)
            {
                if (Response.IsClientConnected)
            {
                byte[] buffer = new Byte[10000];
                int length = stream.Read(buffer, 0, 10000);
                Response.OutputStream.Write(buffer, 0, length);
                Response.Flush();
                bytesToRead = bytesToRead - length;
            }
            else
                {
                    bytesToRead = -1;

                }
        }
        }
        catch (Exception ex)
        {

        }

        }

Down load file from Solution Explorar

protected void Button2_Click(object sender, EventArgs e)
    {
        string s = DropDownList1.SelectedItem.Text;
        Response.Clear();
        Response.AddHeader("content-disposition", string.Format("attachment;filename={0}", s));
        Response.Charset = "";
        Response.ContentType = "application/vnd.xls";

        StringWriter stringWrite = new StringWriter();
        HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);
    
        Response.Write(stringWrite.ToString());
        Response.End();
    }

Retrive the files For Dropdownlist

 protected void Page_Load(object sender, EventArgs e)
    {
        retrivefiles();
    }
    public void retrivefiles()
    {
      
        DirectoryInfo dinfo = new DirectoryInfo(Server.MapPath(("." + @"\images\")));
        FileInfo[] fileslist = dinfo.GetFiles();
        foreach (FileInfo fi in fileslist)
        {
            DropDownList1.Items.Add(fi.Name);
        }
    }

export data from gridview to excel And Pdf

Export To Excel
protected void Button1_Click(object sender, EventArgs e)
    {
        Response.Clear();
        Response.AddHeader("content-disposition", "attachment;filename=DocumentReport.xls");
        Response.Charset = "";
        Response.Cache.SetCacheability(HttpCacheability.NoCache);
        Response.ContentType = "application/vnd.ms-excel";
        System.IO.StringWriter stringWrite = new System.IO.StringWriter();
        System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);
        GridView gv = new GridView();
        gv.DataSource = ds;
        gv.DataBind();

     gv.RenderControl(htmlWrite);
        Response.Write(stringWrite.ToString());
        Response.End();
    }


export to Pdf


 protected void Button2_Click(object sender, EventArgs e)
    {

        Response.Clear();
        Response.AddHeader("content-disposition", "attachment;filename=DocumentReport.pdf");
        Response.Charset = "";
        Response.Cache.SetCacheability(HttpCacheability.NoCache);
        Response.ContentType = "application/pdf";
        System.IO.StringWriter stringWrite = new System.IO.StringWriter();
        System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);
        GridView gv = new GridView();
        gv.DataSource = ds;
        gv.DataBind();
       gv.RenderControl(htmlWrite);
        Response.Write(stringWrite.ToString());
        Response.End();
    }

Retrive the data from excel sheet ,Xml And Sql server2005

 protected void Button1_Click(object sender, EventArgs e)
    {
        sqlCon.Open();
        SqlCommand cmd = new SqlCommand("select type from spreadsheet where spreadsheetname='" + DropDownList1.SelectedItem.Text + "'", sqlCon);
        SqlDataReader dr = cmd.ExecuteReader();
        string type="";
        if (dr.Read())
        {
            type = dr[0].ToString();
        }
        sqlCon.Close();
        string filename = DropDownList1.SelectedItem.Text;
        switch (type)
        {
            case "Excel":
               
                string conn = ("Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + Server.MapPath(".\\datasources\\" + filename) + ";Extended Properties=\"Excel 8.0;\""); // or use instead of Excel 8.0 - Excel 5.0
                string SSQL = "SELECT *  from [sheet1$]";
                OleDbDataAdapter oleDA = new OleDbDataAdapter(SSQL, conn); // here use oleDataReader
                DataSet ds = new DataSet();
                //oleDA.TableMappings.Add("Table","ExcelTest"); // Require
                oleDA.Fill(ds);
                GridView1.DataSource = ds.Tables[0].DefaultView; // or [ ds ]
                GridView1.DataBind();
                break;
            case "XML":
                DataSet ds1 = new DataSet();
                ds1.ReadXml(Server.MapPath(@".\datasources\" + filename));
                GridView1.DataSource = ds1.Tables[0];
                GridView1.DataBind();
                break;
            case "SQLSERVER":
                SqlCommand cmd1 = new SqlCommand("select * from "+filename,sqlCon);
                SqlDataAdapter da = new SqlDataAdapter();
                DataSet ds2 = new DataSet();
                da.Fill(ds2);
                GridView1.DataSource= ds2.Tables[0];
                GridView1.DataBind();
                break;
        }




Get the All filenames in to dropdownlist from solution Explorar

 SqlConnection sqlCon = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ToString());
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            string username = (string)Session["username"];
            sqlCon.Open();
            SqlCommand cmd = new SqlCommand("select spreadsheetname from spreadsheet where username='"+username+"'", sqlCon);
            SqlDataReader dr = cmd.ExecuteReader();
            DropDownList1.Items.Add("Select");
            while (dr.Read())
            {
                DropDownList1.Items.Add(dr[0].ToString());
            }
            sqlCon.Close();
        }
    }
   
    }

to show the nested grid

l1 = (LinkButton)GridView1.Rows[GridView1.Rows.Count].FindControl("Label1");



GridView childgrid = (GridView)GridView1.Rows[1].Cells[3].Controls[1];

SqlDataAdapter sqlDa = new SqlDataAdapter("select * from dept where branchno='" + l1.Text + "'", con);
DataSet ds = new DataSet();
sqlDa.Fill(ds);
childgrid.DataSource = ds;
childgrid.DataBind();