insert and retrive image from database in c#

Insert Image In Databse

public bool SaveImage()
        {
            FileStream fs = new FileStream(curFileName, FileMode.OpenOrCreate, FileAccess.Read);
            byte[] rawData = new byte[fs.Length];
            fs.Read(rawData, 0, System.Convert.ToInt32(fs.Length));
            fs.Close();
            try
            {
                if (curFileName != null)
                {
                    SqlCommand cmd = new SqlCommand("insert into ImageTable ([srno],[image]) values(@srno,@image)", con);
                    cmd.Parameters.Add("@srno", SqlDbType.NVarChar, 50).Value = textBoxSrNo.Text;
                    SqlParameter prm = new SqlParameter("@image", SqlDbType.Image, rawData.Length, ParameterDirection.Input, false, 0, 0, null, DataRowVersion.Current, rawData);
                    cmd.Parameters.Add(prm);
                    con.Open();
                    cmd.ExecuteNonQuery();
                   
                    MessageBox.Show("Success");
                }
                else
                {
                    MessageBox.Show("Empty File Path");
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
                return false;
            }
            finally
            {
                con.Close();
            }
            return true;
        }

retrive image from database

public void DisplayImage()
        {
            try
            {
                con.Open();
                SqlCommand cmd = new SqlCommand("SELECT image FROM ImageTable WHERE srno='" + textBoxSrNo.Text + "'", con);
                SqlDataAdapter sqlDA = new SqlDataAdapter(cmd);
                DataSet ds = new DataSet();
                sqlDA.Fill(ds, "ImageTable");
                int c = ds.Tables["ImageTable"].Rows.Count;
                if (c > 0)
                {
                    Byte[] byteBLOBData = new Byte[0];
                    byteBLOBData = (Byte[])(ds.Tables["ImageTable"].Rows[c - 1]["image"]);
                    MemoryStream stmBLOBData = new MemoryStream(byteBLOBData);
                    Image img;
                    //pictureBox1.Image = img.GetThumbnailImage(340, 165, null, new IntPtr());
                   
                   img = pictureBox1.Image = Image.FromStream(stmBLOBData);
                   pictureBox1.Image = img.GetThumbnailImage(200, 200, null, new IntPtr());
                    //pictureBox1.SizeMode = PictureBoxSizeMode.CenterImage;
                    pictureBox1.Show();

                    //Byte[] byteBLOBData = new Byte[0];
                    //byteBLOBData = (Byte[])(ds.Tables["ImageTable"].Rows[c - 1]["image"]);
                    //MemoryStream stmBLOBData = new MemoryStream(byteBLOBData);
                    //pictureBox1.Image = Image.FromStream(stmBLOBData);
                    //pictureBox1.SizeMode = PictureBoxSizeMode.CenterImage;
                    //pictureBox1.Show();
                }

            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
            con.Close();

        }

conditional execution of two classes in c#

Below code is the best solution when, developer wish to execute 2nd class, only if 1st class  get executed successfully

Class 1st

public bool SaveOtherInfo()
        {
            try
            {
                con.Open();
                if (textBoxSrNo.Text == "" || textBoxCARD2.Text == "" || textBoxFirstName.Text == "")
                {
                    ScriptManager.RegisterStartupScript(this, this.GetType(), "", "alert('One or more field are empty..');", true);
                    return false;
                }
                if (FileUpload1.FileName == "")
                {
                    ScriptManager.RegisterStartupScript(this, this.GetType(), "", "alert('Select Image');", true);
                    return false;
                }
                else
                {
                    param = " '" + this.textBoxSrNo.Text + "' ," +   

                            " '" + this.comboBoxRelocate.Text + " '";


                    strSQL = @"INSERT  INTO student VALUES (" + param + ")";

                    cmd.Connection = con;
                    cmd.CommandText = strSQL;
                    cmd.CommandType = CommandType.Text;

                    int i = cmd.ExecuteNonQuery();


                    if (i > 0)
                    {
                        ScriptManager.RegisterStartupScript(this, this.GetType(), "", "alert('Information submitted Successfully');", true);
                        return true;
                    }
                }
            }
            catch (Exception ex)
            {
                ScriptManager.RegisterStartupScript(this, this.GetType(), "", "alert('" + ex.Message + "');", true);
                return false;
            }
            finally
            {
                con.Close();
            }
            return true;
        }

Class 2nd

private bool SaveImage()
        {
            try
            {
                //Condition to check if the file uploaded or not
                if (FileUpload1.HasFile)
                {
                    //getting length of uploaded file
                    int length = FileUpload1.PostedFile.ContentLength;

                    //create a byte array to store the binary image data
                    byte[] imgbyte = new byte[length];

                    //store the currently selected file in memeory
                    HttpPostedFile img = FileUpload1.PostedFile;

                    //set the binary data
                    img.InputStream.Read(imgbyte, 0, length);
                    con.Open();

                    SqlCommand cmd = new SqlCommand("INSERT INTO ImageTable VALUES(@srno,@image)", con);
                    cmd.Parameters.Add("@srno", SqlDbType.NVarChar, 50).Value = textBoxSrNo.Text;
                    cmd.Parameters.Add("@image", SqlDbType.Image).Value = imgbyte;

                    int count = cmd.ExecuteNonQuery();
                    con.Close();
                    if (count > 0)
                    {
                        ScriptManager.RegisterStartupScript(this, this.GetType(), "", "alert('Image Inserted Successfully');", true);

                    }
                }
            }
            catch (Exception ex)
            {
                ScriptManager.RegisterStartupScript(this, this.GetType(), "", "alert('" + ex.Message + "');", true);
                return false;
            }
            finally
            {

            }
            return true;

        }

Button for checking classes execution and save data of both the classes if both classes executes successfully,

In short, If class"SaveOtherInfo" gets executed successfully then only class"SaveImage" get executed otherwise not..

protected void ButtonSave_Click(object sender, EventArgs e)
        {
            bool flag;
            flag = SaveOtherInfo();

            if (flag == true)
            {
                SaveImage();
            }
            else
            {
                ScriptManager.RegisterStartupScript(this, this.GetType(), "", "alert('Can not Insert Data');", true);
            }
        }

display two columns combobox c#

display two columns combobox c#

con.Open();
OleDbCommand cmd = new OleDbCommand("Select emaployeeFirstName + ' ' + employeeLastName as name from Employee", con);
OleDbDataAdapter da = new OleDbDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
comboBoxLabour.DisplayMember = "name";
comboBoxLabour.ValueMember = "name";
comboBoxLabour.DataSource = dt;
con.Close();

Passing label value to crystal report text object in c# windows application

 private void buttonFinish_Click(object sender, EventArgs e)
        {
            string FromMonth = comboBoxFromMonth.Text, FromYear= comboBoxFromYear.Text, ToMonth= comboBoxToMonth.Text, ToYear=comboBoxToYear.Text;
            Form6 frm = new Form6(FromMonth,FromYear,ToMonth,ToYear);
            frm.MdiParent = this.MdiParent;
            frm.Dock = DockStyle.Fill;
            frm.Show();
        }

Form 6: code behind

public Form6(string FromMonth, string FromYear, string ToMonth, string ToYear)
        {
            InitializeComponent();
            label1.Text = FromMonth;
            label2.Text = FromYear;
            label3.Text = ToMonth;
            label4.Text = ToYear;
        }

 private void Form6_Load(object sender, EventArgs e)
        {
            crystalReportViewer1.DisplayGroupTree = false;
        }

private void crystalReportViewer1_Load(object sender, EventArgs e)
        {
            ParameterFieldDefinitions crParameterFieldDefinitions;
            ParameterFieldDefinition crParameterFieldDefinition;
            ParameterValues crParameterValues = new ParameterValues();
            ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue();

            CrystalReport6 myreport;
            string selectSQL = null;
            selectSQL = "Select * from salaryslip where [year] between '" + label2.Text + "'AND '" + label4.Text + "' AND [month] between '" + label1.Text + "'AND'" + label3.Text + "'";
            con.Open();
            DataSet6 ds = new DataSet6();
            OleDbCommand cmd = new OleDbCommand(selectSQL, con);
            OleDbDataAdapter da = new OleDbDataAdapter(cmd);
            da.Fill(ds, "salaryslip");
            myreport = new CrystalReport6();
            myreport.SetDataSource(ds);
            crystalReportViewer1.ReportSource = myreport;

            crParameterDiscreteValue.Value = label1.Text;
            crParameterFieldDefinitions = myreport.DataDefinition.ParameterFields;
            crParameterFieldDefinition = crParameterFieldDefinitions["FromMonth"];
            crParameterValues = crParameterFieldDefinition.CurrentValues;

            crParameterValues.Clear();
            crParameterValues.Add(crParameterDiscreteValue);
            crParameterFieldDefinition.ApplyCurrentValues(crParameterValues);

            crParameterDiscreteValue.Value = label2.Text;
            crParameterFieldDefinitions = myreport.DataDefinition.ParameterFields;
            crParameterFieldDefinition = crParameterFieldDefinitions["FromYear"];
            crParameterValues = crParameterFieldDefinition.CurrentValues;

            crParameterValues.Clear();
            crParameterValues.Add(crParameterDiscreteValue);
            crParameterFieldDefinition.ApplyCurrentValues(crParameterValues);

            crParameterDiscreteValue.Value = label3.Text;
            crParameterFieldDefinitions = myreport.DataDefinition.ParameterFields;
            crParameterFieldDefinition = crParameterFieldDefinitions["ToMonth"];
            crParameterValues = crParameterFieldDefinition.CurrentValues;

            crParameterValues.Clear();
            crParameterValues.Add(crParameterDiscreteValue);
            crParameterFieldDefinition.ApplyCurrentValues(crParameterValues);

            crParameterDiscreteValue.Value = label4.Text;
            crParameterFieldDefinitions = myreport.DataDefinition.ParameterFields;
            crParameterFieldDefinition = crParameterFieldDefinitions["ToYear"];
            crParameterValues = crParameterFieldDefinition.CurrentValues;

            crParameterValues.Clear();
            crParameterValues.Add(crParameterDiscreteValue);
            crParameterFieldDefinition.ApplyCurrentValues(crParameterValues);

            da.Dispose();
            con.Close();
        }

how to bind data to listview in c#.net

             InitializeComponent();

            // Set the view to show details.
            lvwResult.View = View.Details;

            // Allow the user to edit item text.
            lvwResult.LabelEdit = true;

            // Allow the user to rearrange columns.
            lvwResult.AllowColumnReorder = true;

            // Select the item and subitems when selection is made.
            lvwResult.FullRowSelect = true;

            // Display grid lines.
            lvwResult.GridLines = true;

            // Sort the items in the list in ascending order.
            lvwResult.Sorting = SortOrder.Ascending;


private void Form_Load()
        {
            lvwResult.Columns.Clear();
            lvwResult.Items.Clear();
            lvwResult.View = View.Details;
            lvwResult.LabelEdit = true;
            lvwResult.Columns.Add("Company ID", 100, HorizontalAlignment.Center);
            lvwResult.Columns.Add("Company Name", 150, HorizontalAlignment.Center);
            lvwResult.Columns.Add("Company Website", 150, HorizontalAlignment.Center);
            lvwResult.Columns.Add("Company Email", 150, HorizontalAlignment.Center);
            con.Open();
            lvwResult.Items.Clear();
            lvwResult.Refresh();
            string OleDb = "select * from Company";
            OleDbCommand cmd = new OleDbCommand(OleDb, con);
            OleDbDataAdapter dap = new OleDbDataAdapter(cmd);
            DataSet ds = new DataSet();
            dap.Fill(ds);
            DataTable dt = ds.Tables[0];

            for (int i = 0; i < dt.Rows.Count; i++)
            {
                DataRow dr = dt.Rows[i];
                ListViewItem lvi = new ListViewItem(dr["companyID"].ToString());
                lvi.SubItems.Add(dr["companyName"].ToString());
                lvi.SubItems.Add(dr["companyWebsite"].ToString());
                lvi.SubItems.Add(dr["companyEmail"].ToString());
                lvwResult.Items.Add(lvi);
                lvwResult.FullRowSelect = true;

            }
            con.Close();
        }



private void lvwResult_SelectedIndexChanged(object sender, EventArgs e)
        {
            if (lvwResult.SelectedItems.Count > 0)
            {
                textBox1.Text = lvwResult.SelectedItems[0].Text;
            }

            ViewCompanyDetails objViewCompanyDetails = new ViewCompanyDetails(textBox1.Text);
            objViewCompanyDetails.MdiParent = this.MdiParent;
            objViewCompanyDetails.Dock = DockStyle.Fill;
            objViewCompanyDetails.Show();
            objViewCompanyDetails.Focus();
            this.Hide();
        }

connection state giving problem

if (dbConnection.State != ConnectionState.Open)
        dbConnection.Open();

how to bind combobox with datatable in c#

con.Open();
            cmd = new OleDbCommand("Select DISTINCT departmentName from Department", con);
            OleDbDataAdapter da = new OleDbDataAdapter(cmd);
            DataTable dt = new DataTable();
            da.Fill(dt);
            comboBoxDepartment.DisplayMember = "departmentName";
            comboBoxDepartment.ValueMember = "departmentName";
            comboBoxDepartment.DataSource = dt;
            con.Close();

export dataset to excel in c# windows application

Export Data in excel sheet from DataGridView C# Windows Application

Microsoft.Office.Interop.Excel.Application ExcelApp =
            new Microsoft.Office.Interop.Excel.Application();
            ExcelApp.Application.Workbooks.Add(Type.Missing);

            // Change properties of the Workbook

            ExcelApp.Columns.ColumnWidth = 20;

            // Storing header part in Excel
            for (int i = 1; i < dataGridView1.Columns.Count + 1; i++)
            {
                ExcelApp.Cells[1, i] = dataGridView1.Columns[i - 1].HeaderText;
            }

            // Storing Each row and column value to excel sheet
            for (int i = 0; i < dataGridView1.Rows.Count - 1; i++)
            {
                for (int j = 0; j < dataGridView1.Columns.Count; j++)
                {
                    ExcelApp.Cells[i + 2, j + 1] = dataGridView1.Rows[i].Cells[j].Value.ToString();
                }
            }
            MessageBox.Show("Excel file created , you can find the file D:\\Employee Data.xlsx");
            ExcelApp.Visible = true;
            ExcelApp.ActiveWorkbook.SaveCopyAs("D:\\Employee Data.xlsx");
            ExcelApp.ActiveWorkbook.Saved = true;
           
            //ExcelApp.Quit();

Export data to excel from c#

Export data to excel from c# windows application

  string   string1=comboBoxFromMarch.Text;
            string   string2=comboBoxToApril.Text;
            string   string3 = comboBox1.Text;

            Excel.Application myExcelApp;
            Excel.Workbooks myExcelWorkbooks;
            Excel.Workbook myExcelWorkbook;


            object misValue = System.Reflection.Missing.Value;

            myExcelApp = new Excel.ApplicationClass();
            myExcelApp.Visible = true;
            myExcelWorkbooks = myExcelApp.Workbooks;
            String fileName = @"E:\Documents and Settings\My Documents\Visual Studio 2008\\files\\3A.xls";
            // set this to your file you want
            myExcelWorkbook = myExcelWorkbooks.Open(fileName, misValue, misValue, misValue, misValue, misValue, misValue, misValue, misValue, misValue, misValue, misValue, misValue, misValue, misValue);

            Excel.Worksheet myExcelWorksheet = (Excel.Worksheet)myExcelWorkbook.ActiveSheet;

            //String cellFormulaAsString = myExcelWorksheet.get_Range("A10", misValue).Formula.ToString();
            // this puts the formula in Cell A2 or text depending whats in it in the string.
          
            myExcelWorksheet.get_Range("G7", misValue).Formula =   string1;
            myExcelWorksheet.get_Range("I7", misValue).Formula =   string2;
            myExcelWorksheet.get_Range("D10", misValue).Formula =   string3;

 Import Excel sheet data to c# windows application

 OleDbConnection con = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\filename.xls;Extended Properties= 'Excel 8.0;HDR=Yes;IMEX=1'");
            OleDbCommand cmd;
            OleDbDataReader dr;
            con.Open();
            cmd = new OleDbCommand("Select * from [Sheet1$]WHERE fullname='" + comboBox1.Text + "'", con);
            dr = cmd.ExecuteReader();
            if (dr.Read())
            {
                textBoxFatherHusbandName.Text = dr[""].ToString();
                textBoxPFActNo.Text = dr[""].ToString();
            }

            else
            {
                lblInfo.Visible = true;
                lblInfo.Text = "Person Does Not Exist";
            }
            con.Close();

Binary Tree in asp.net

Step 1: Databasse Design

Step 2: Binary Tree Structure(Tree.aspx)

 Step 3: Code behind(Tree.aspx.cs)

 using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
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;
using System.Xml.Linq;
using System.Data.SqlClient;


    public partial class WebForm5 : System.Web.UI.Page
    {
        string L = "0", R = "";
        ArrayList bk;
        SqlConnection con = new SqlConnection(@"ConnectionString");
        SqlCommand cmd;
        SqlDataReader dr;
        string joinside, reduserid, redside;

      
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                detail("1000");
                Lb1.Text = "1000";
                Session["SponsorID"] = Lb1.Text;
                bk = new ArrayList();
                bk.Add(Lb1.Text);
                Session["temp"] = bk;
            }
        }
        protected void Lb1_Click(object sender, EventArgs e)
        {
            LinkButton btn = (LinkButton)sender;
            string val = btn.Text;
            bk = ((ArrayList)Session["temp"]);
            bk.Add(val);
            Session["temp"] = bk;
            detail(btn.Text);
        }

        public void check()
        {
            Lb2L.Text = "Blank";
            Lb3R.Text = "Blank";
            Lb4L.Text = "Blank";
            Lb5R.Text = "Blank";
            Lb6L.Text = "Blank";
            Lb7R.Text = "Blank";
            Lb8L.Text = "Blank";
            Lb9R.Text = "Blank";
            Lb10L.Text = "Blank";
            Lb11R.Text = "Blank";
            Lb12L.Text = "Blank";
            Lb13R.Text = "Blank";
            Lb14L.Text = "Blank";
            Lb15R.Text = "Blank";
            i1.Src = "~/TreeImages/admin.png";
            i2.Src = "~/TreeImages/newmember.png";
            i3.Src = "~/TreeImages/newmember.png";
            i4.Src = "~/TreeImages/newmember.png";
            i5.Src = "~/TreeImages/newmember.png";
            i6.Src = "~/TreeImages/newmember.png";
            i7.Src = "~/TreeImages/newmember.png";
            i8.Src = "~/TreeImages/newmember.png";
            i9.Src = "~/TreeImages/newmember.png";
            i10.Src = "~/TreeImages/newmember.png";
            i11.Src = "~/TreeImages/newmember.png";
            i12.Src = "~/TreeImages/newmember.png";
            i13.Src = "~/TreeImages/newmember.png";
            i14.Src = "~/TreeImages/newmember.png";
            i15.Src = "~/TreeImages/newmember.png";
        }

        public void detail(string usr)
        {
            DataTable userD = new DataTable();
            TreeShow ss = new TreeShow();
            userD = ss.fillUserDetail(usr);
            if (userD.Rows.Count != 0)
            {
                Lb1.Text = usr;
                lblname.Text = userD.Rows[0]["username"].ToString();
                //lblljoin.Text = userD.Rows[0]["ljoining"].ToString();
                //lblrjoin.Text = userD.Rows[0]["rjoining"].ToString();
                //lblpair.Text = userD.Rows[0]["pair"].ToString();
                lblljoin.Text = "1";
                lblrjoin.Text = "1";
                lblpair.Text = "2";
                string joinside = userD.Rows[0]["joinside"].ToString();
                if (joinside == "left")
                {
                    i1.Src = "~/TreeImages/member.png";
                }
                else
                {
                    i1.Src = "~/TreeImages/member.png";
                }
            }

            check();
            ss.find(Lb1.Text, out L, out R);
          
            string l2 = L.ToString();
            string r3 = R.ToString();
            if (l2 != "")
            {
                Lb2L.Visible = true;
                Lb2L.Text = l2;
                cmd = new SqlCommand("select joinside from demoTable where userid='" + l2 + "'", con);
                con.Open();
                dr = cmd.ExecuteReader();
                if (dr.Read())
                {
                    joinside = dr[0].ToString();
                }
                con.Close();
                if (joinside == "left")
                {
                    i2.Src = "~/TreeImages/member.png";
                }
                else
                {
                    i2.Src = "~/TreeImages/member.png";
                }
                ss.find(l2, out L, out R);

                string l4 = L.ToString();
                string r5 = R.ToString();
                if (l4 != "")
                {
                    Lb4L.Visible = true;
                    Lb4L.Text = l4;
                    cmd = new SqlCommand("select joinside from demoTable where userid='" + l4 + "'", con);
                    con.Open();
                    dr = cmd.ExecuteReader();
                    if (dr.Read())
                    {
                        joinside = dr[0].ToString();
                    }
                    con.Close();
                    if (joinside == "left")
                    {
                        i4.Src = "~/TreeImages/member.png";
                    }
                    else
                    {
                        i4.Src = "~/TreeImages/member.png";
                    }
                    ss.find(l4, out L, out R);


                    string l8 = L.ToString();
                    string r9 = R.ToString();
                    if (l8 != "")
                    {
                        Lb8L.Visible = true;
                        Lb8L.Text = l8;
                        cmd = new SqlCommand("select joinside from demoTable where userid='" + l8 + "'", con);
                        con.Open();
                        dr = cmd.ExecuteReader();
                        if (dr.Read())
                        {
                            joinside = dr[0].ToString();
                        }
                        con.Close();
                        if (joinside == "left")
                        {
                            i8.Src = "~/TreeImages/member.png";
                        }
                        else
                        {
                            i8.Src = "~/TreeImages/member.png";
                        }
                    }
                    if (r9 != "")
                    {
                        Lb9R.Visible = true;
                        Lb9R.Text = r9;
                        cmd = new SqlCommand("select joinside from demoTable where userid='" + r9 + "'", con);
                        con.Open();
                        dr = cmd.ExecuteReader();
                        if (dr.Read())
                        {
                            joinside = dr[0].ToString();
                        }
                        con.Close();
                        if (joinside == "left")
                        {
                            i9.Src = "~/TreeImages/member.png";
                        }
                        else
                        {
                            i9.Src = "~/TreeImages/member.png";
                        }
                    }
                }
                if (r5 != "")
                {
                    Lb5R.Visible = true;
                    Lb5R.Text = r5;
                    cmd = new SqlCommand("select joinside from demoTable where userid='" + r5 + "'", con);
                    con.Open();
                    dr = cmd.ExecuteReader();
                    if (dr.Read())
                    {
                        joinside = dr[0].ToString();
                    }
                    con.Close();
                    if (joinside == "left")
                    {
                        i5.Src = "~/TreeImages/member.png";
                    }
                    else
                    {
                        i5.Src = "~/TreeImages/member.png";
                    }
                    ss.find(r5, out L, out R);
                    string l10 = L.ToString();
                    string r11 = R.ToString();

                    if (l10 != "")
                    {
                        Lb10L.Visible = true;
                        Lb10L.Text = l10;
                        cmd = new SqlCommand("select joinside from demoTable where userid='" + l10 + "'", con);
                        con.Open();
                        dr = cmd.ExecuteReader();
                        if (dr.Read())
                        {
                            joinside = dr[0].ToString();
                        }
                        con.Close();
                        if (joinside == "left")
                        {
                            i10.Src = "~/TreeImages/member.png";
                        }
                        else
                        {
                            i10.Src = "~/TreeImages/member.png";
                        }
                    }
                    if (r11 != "")
                    {
                        Lb11R.Visible = true;
                        Lb11R.Text = r11;
                        cmd = new SqlCommand("select joinside from demoTable where userid='" + r11 + "'", con);
                        con.Open();
                        dr = cmd.ExecuteReader();
                        if (dr.Read())
                        {
                            joinside = dr[0].ToString();
                        }
                        con.Close();
                        if (joinside == "left")
                        {
                            i11.Src = "~/TreeImages/member.png";
                        }
                        else
                        {
                            i11.Src = "~/TreeImages/member.png";
                        }
                    }
                }
            }
            if (r3 != "")
            {
                Lb3R.Visible = true;
                Lb3R.Text = r3;
                cmd = new SqlCommand("select joinside from demoTable where userid='" + r3 + "'", con);
                con.Open();
                dr = cmd.ExecuteReader();
                if (dr.Read())
                {
                    joinside = dr[0].ToString();
                }
                con.Close();
                if (joinside == "left")
                {
                    i3.Src = "~/TreeImages/member.png";
                }
                else
                {
                    i3.Src = "~/TreeImages/member.png";
                }
                ss.find(r3, out L, out R);
                string l6 = L.ToString();
                string r7 = R.ToString();
                if (l6 != "")
                {
                    Lb6L.Visible = true;
                    Lb6L.Text = l6;
                    cmd = new SqlCommand("select joinside from demoTable where userid='" + l6 + "'", con);
                    con.Open();
                    dr = cmd.ExecuteReader();
                    if (dr.Read())
                    {
                        joinside = dr[0].ToString();
                    }
                    con.Close();
                    if (joinside == "left")
                    {
                        i6.Src = "~/TreeImages/member.png";
                    }
                    else
                    {
                        i6.Src = "~/TreeImages/member.png";
                    }
                    ss.find(l6, out L, out R);
                    string l12 = L.ToString();
                    string r13 = R.ToString();
                    if (l12 != "")
                    {
                        Lb12L.Visible = true;
                        Lb12L.Text = l12;
                        cmd = new SqlCommand("select joinside from demoTable where userid='" + l12 + "'", con);
                        con.Open();
                        dr = cmd.ExecuteReader();
                        if (dr.Read())
                        {
                            joinside = dr[0].ToString();
                        }
                        con.Close();
                        if (joinside == "left")
                        {
                            i12.Src = "~/TreeImages/member.png";
                        }
                        else
                        {
                            i12.Src = "~/TreeImages/member.png";
                        }
                    }
                    if (r13 != "")
                    {
                        Lb13R.Visible = true;
                        Lb13R.Text = r13;
                        cmd = new SqlCommand("select joinside from demoTable where userid='" + r13 + "'", con);
                        con.Open();
                        dr = cmd.ExecuteReader();
                        if (dr.Read())
                        {
                            joinside = dr[0].ToString();
                        }
                        con.Close();
                        if (joinside == "left")
                        {
                            i13.Src = "~/TreeImages/member.png";
                        }
                        else
                        {
                            i13.Src = "~/TreeImages/member.png";
                        }
                    }
                }
                if (r7 != "")
                {
                    Lb7R.Visible = true;
                    Lb7R.Text = r7;
                    cmd = new SqlCommand("select joinside from demoTable where userid='" + r7 + "'", con);
                    con.Open();
                    dr = cmd.ExecuteReader();
                    if (dr.Read())
                    {
                        joinside = dr[0].ToString();
                    }
                    con.Close();
                    if (joinside == "left")
                    {
                        i7.Src = "~/TreeImages/member.png";
                    }
                    else
                    {
                        i7.Src = "~/TreeImages/member.png";
                    }
                    ss.find(r7, out L, out R);
                    string l14 = L.ToString();
                    string r15 = R.ToString();
                    if (l14 != "")
                    {
                        Lb14L.Visible = true;
                        Lb14L.Text = l14;
                        cmd = new SqlCommand("select joinside from demoTable where userid='" + l14 + "'", con);
                        con.Open();
                        dr = cmd.ExecuteReader();
                        if (dr.Read())
                        {
                            joinside = dr[0].ToString();
                        }
                        con.Close();
                        if (joinside == "left")
                        {
                            i14.Src = "~/TreeImages/member.png";
                        }
                        else
                        {
                            i14.Src = "~/TreeImages/member.png";
                        }
                    }
                    if (r15 != "")
                    {
                        Lb15R.Visible = true;
                        Lb15R.Text = r15;
                        cmd = new SqlCommand("select joinside from demoTable where userid='" + l14 + "'", con);
                        con.Open();
                        dr = cmd.ExecuteReader();
                        if (dr.Read())
                        {
                            joinside = dr[0].ToString();
                        }
                        con.Close();
                        if (joinside == "left")
                        {
                            i15.Src = "~/TreeImages/member.png";
                        }
                        else
                        {
                            i15.Src = "~/TreeImages/member.png";
                        }
                    }
                }
            }
        }

        protected void ImgBack_Click(object sender, ImageClickEventArgs e)
        {
            bk = ((ArrayList)Session["temp"]);
            int count = bk.Count;
            if (count > 0)
            {
                string last = bk[count - 1].ToString();
                bk.Remove(last);
                Session["temp"] = bk;
                detail(last);
            }
            else if (count == 0)
            {
                detail("1000");
                ScriptManager.RegisterStartupScript(this, this.GetType(), "Binary Tree Demo", "alert('This is Last User ID');", true);
            }
        }
        protected void Lb2L_Click(object sender, EventArgs e)
        {
            if (Lb2L.Text == "Blank")
            {
                if (Lb1.Text != "Blank")
                {
                    reduserid = Lb1.Text;
                    redside = "Left";
                    string url = "Registration.aspx?reduserid=" + reduserid + "&redside=" + redside;
                    Response.Redirect(url);
                }
                else
                {
                    ScriptManager.RegisterStartupScript(this, this.GetType(), "Binary Tree Demo", "alert('For registration Parent should not be blank');", true);
                }

            }
            else
            {
                bk = ((ArrayList)Session["temp"]);
                bk.Add(Lb2L.Text);
                Session["temp"] = bk;
                detail(Lb2L.Text);
            }
        }
        protected void Lb3R_Click(object sender, EventArgs e)
        {
            if (Lb3R.Text == "Blank")
            {
                if (Lb1.Text != "Blank")
                {
                    reduserid = Lb1.Text;
                    redside = "Right";
                    string url = "Registration.aspx?reduserid=" + reduserid + "&redside=" + redside;
                    Response.Redirect(url);
                }
                else
                {
                    ScriptManager.RegisterStartupScript(this, this.GetType(), "Binary Tree Demo", "alert('For registration Parent should not be blank');", true);
                }
            }
            else
            {
                bk = ((ArrayList)Session["temp"]);
                bk.Add(Lb3R.Text);
                Session["temp"] = bk;
                detail(Lb3R.Text);
            }
        }
        protected void Lb4L_Click(object sender, EventArgs e)
        {
            if (Lb4L.Text == "Blank")
            {
                if (Lb2L.Text != "Blank")
                {
                    reduserid = Lb2L.Text;
                    redside = "Left";
                    string url = "Registration.aspx?reduserid=" + reduserid + "&redside=" + redside;
                    Response.Redirect(url);
                }
                else
                {
                    ScriptManager.RegisterStartupScript(this, this.GetType(), "Binary Tree Demo", "alert('For registration Parent should not be blank');", true);
                }

            }
            else
            {
                bk = ((ArrayList)Session["temp"]);
                bk.Add(Lb4L.Text);
                Session["temp"] = bk;
                detail(Lb4L.Text);
            }
        }
        protected void Lb5R_Click(object sender, EventArgs e)
        {
            if (Lb5R.Text == "Blank")
            {
                if (Lb2L.Text != "Blank")
                {
                    reduserid = Lb2L.Text;
                    redside = "Right";
                    string url = "Registration.aspx?reduserid=" + reduserid + "&redside=" + redside;
                    Response.Redirect(url);
                }
                else
                {
                    ScriptManager.RegisterStartupScript(this, this.GetType(), "Binary Tree Demo", "alert('For registration Parent should not be blank');", true);
                }
            }
            else
            {
                bk = ((ArrayList)Session["temp"]);
                bk.Add(Lb5R.Text);
                Session["temp"] = bk;
                detail(Lb5R.Text);
            }
        }
        protected void Lb6L_Click(object sender, EventArgs e)
        {
            if (Lb6L.Text == "Blank")
            {
                if (Lb3R.Text != "Blank")
                {
                    reduserid = Lb3R.Text;
                    redside = "Left";
                    string url = "Registration.aspx?reduserid=" + reduserid + "&redside=" + redside;
                    Response.Redirect(url);
                }
                else
                {
                    ScriptManager.RegisterStartupScript(this, this.GetType(), "Binary Tree Demo", "alert('For registration Parent should not be blank');", true);
                }
            }
            else
            {
                bk = ((ArrayList)Session["temp"]);
                bk.Add(Lb6L.Text);
                Session["temp"] = bk;
                detail(Lb6L.Text);
            }
        }
        protected void Lb7R_Click(object sender, EventArgs e)
        {
            if (Lb7R.Text == "Blank")
            {
                if (Lb3R.Text != "Blank")
                {
                    reduserid = Lb3R.Text;
                    redside = "Right";
                    string url = "Registration.aspx?reduserid=" + reduserid + "&redside=" + redside;
                    Response.Redirect(url);
                }
                else
                {
                    ScriptManager.RegisterStartupScript(this, this.GetType(), "Binary Tree Demo", "alert('For registration Parent should not be blank');", true);
                }
            }
            else
            {
                bk = ((ArrayList)Session["temp"]);
                bk.Add(Lb7R.Text);
                Session["temp"] = bk;
                detail(Lb7R.Text);
            }
        }
        protected void Lb8L_Click(object sender, EventArgs e)
        {
            if (Lb8L.Text == "Blank")
            {
                if (Lb4L.Text != "Blank")
                {
                    reduserid = Lb4L.Text;
                    redside = "Left";
                    string url = "Registration.aspx?reduserid=" + reduserid + "&redside=" + redside;
                    Response.Redirect(url);
                }
                else
                {
                    ScriptManager.RegisterStartupScript(this, this.GetType(), "Binary Tree Demo", "alert('For registration Parent should not be blank');", true);
                }
            }
            else
            {
                bk = ((ArrayList)Session["temp"]);
                bk.Add(Lb8L.Text);
                Session["temp"] = bk;
                detail(Lb8L.Text);
            }
        }
        protected void Lb9R_Click(object sender, EventArgs e)
        {
            if (Lb9R.Text == "Blank")
            {
                if (Lb4L.Text != "Blank")
                {
                    reduserid = Lb4L.Text;
                    redside = "Right";
                    string url = "Registration.aspx?reduserid=" + reduserid + "&redside=" + redside;
                    Response.Redirect(url);
                }
                else
                {
                    ScriptManager.RegisterStartupScript(this, this.GetType(), "Binary Tree Demo", "alert('For registration Parent should not be blank');", true);
                }
            }
            else
            {
                bk = ((ArrayList)Session["temp"]);
                bk.Add(Lb9R.Text);
                Session["temp"] = bk;
                detail(Lb9R.Text);
            }
        }
        protected void Lb10L_Click(object sender, EventArgs e)
        {
            if (Lb10L.Text == "Blank")
            {
                if (Lb5R.Text != "Blank")
                {
                    reduserid = Lb5R.Text;
                    redside = "Left";
                    string url = "Registration.aspx?reduserid=" + reduserid + "&redside=" + redside;
                    Response.Redirect(url);
                }
                else
                {
                    ScriptManager.RegisterStartupScript(this, this.GetType(), "Binary Tree Demo", "alert('For registration Parent should not be blank');", true);
                }
            }
            else
            {
                bk = ((ArrayList)Session["temp"]);
                bk.Add(Lb10L.Text);
                Session["temp"] = bk;
                detail(Lb10L.Text);
            }
        }
        protected void Lb11R_Click(object sender, EventArgs e)
        {
            if (Lb11R.Text == "Blank")
            {
                if (Lb5R.Text != "Blank")
                {
                    reduserid = Lb5R.Text;
                    redside = "Right";
                    string url = "Registration.aspx?reduserid=" + reduserid + "&redside=" + redside;
                    Response.Redirect(url);
                }
                else
                {
                    ScriptManager.RegisterStartupScript(this, this.GetType(), "Binary Tree Demo", "alert('For registration Parent should not be blank');", true);
                }
            }
            else
            {
                bk = ((ArrayList)Session["temp"]);
                bk.Add(Lb11R.Text);
                Session["temp"] = bk;
                detail(Lb11R.Text);
            }
        }
        protected void Lb12L_Click(object sender, EventArgs e)
        {
            if (Lb12L.Text == "Blank")
            {
                if (Lb6L.Text != "Blank")
                {
                    reduserid = Lb6L.Text;
                    redside = "Left";
                    string url = "Registration.aspx?reduserid=" + reduserid + "&redside=" + redside;
                    Response.Redirect(url);
                }
                else
                {
                    ScriptManager.RegisterStartupScript(this, this.GetType(), "Binary Tree Demo", "alert('For registration Parent should not be blank');", true);
                }
            }
            else
            {
                bk = ((ArrayList)Session["temp"]);
                bk.Add(Lb12L.Text);
                Session["temp"] = bk;
                detail(Lb12L.Text);
            }
        }
        protected void Lb13R_Click(object sender, EventArgs e)
        {
            if (Lb13R.Text == "Blank")
            {
                if (Lb6L.Text != "Blank")
                {
                    reduserid = Lb6L.Text;
                    redside = "Right";
                    string url = "Registration.aspx?reduserid=" + reduserid + "&redside=" + redside;
                    Response.Redirect(url);
                }
                else
                {
                    ScriptManager.RegisterStartupScript(this, this.GetType(), "Binary Tree Demo", "alert('For registration Parent should not be blank');", true);
                }
            }
            else
            {
                bk = ((ArrayList)Session["temp"]);
                bk.Add(Lb13R.Text);
                Session["temp"] = bk;
                detail(Lb13R.Text);
            }
        }
        protected void Lb14L_Click(object sender, EventArgs e)
        {
            if (Lb14L.Text == "Blank")
            {
                if (Lb7R.Text != "Blank")
                {
                    reduserid = Lb7R.Text;
                    redside = "Left";
                    string url = "Registration.aspx?reduserid=" + reduserid + "&redside=" + redside;
                    Response.Redirect(url);
                }
                else
                {
                    ScriptManager.RegisterStartupScript(this, this.GetType(), "Binary Tree Demo", "alert('For registration Parent should not be blank');", true);
                }
            }
            else
            {
                bk = ((ArrayList)Session["temp"]);
                bk.Add(Lb14L.Text);
                Session["temp"] = bk;
                detail(Lb14L.Text);
            }
        }
        protected void Lb15R_Click(object sender, EventArgs e)
        {
            if (Lb15R.Text == "Blank")
            {
                if (Lb7R.Text != "Blank")
                {
                    reduserid = Lb7R.Text;
                    redside = "Right";
                    string url = "Registration.aspx?reduserid=" + reduserid + "&redside=" + redside;
                    Response.Redirect(url);
                }
                else
                {
                    ScriptManager.RegisterStartupScript(this, this.GetType(), "Binary Tree Demo", "alert('For registration Parent should not be blank');", true);
                }
            }
            else
            {
                bk = ((ArrayList)Session["temp"]);
                bk.Add(Lb15R.Text);
                Session["temp"] = bk;
                detail(Lb15R.Text);
            }
        }
    }
}

Step 4: Add class file (Treeshow.cs)

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;

/// <summary>
/// Summary description for TreeShow
/// </summary>
public class TreeShow
{

        SqlConnection con;
        SqlCommand cmd;
        SqlDataAdapter da;
        DataSet ds;
        DataTable dt;
        SqlDataReader dr;
        string sql;

        int status;
        public TreeShow()
        {
            con = new SqlConnection(@"Data Source=");
        }

        string msg;

        public void find(string apid, out string Left, out string Right)
        {
            Left = "";
            Right = "";
            cmd = new SqlCommand("select lleg,rleg from demoTable where userid='" + apid + "'", con);
            con.Open();
            dr = cmd.ExecuteReader();
            if (dr.Read())
            {
                if (dr[0].ToString() != "")
                {
                    Left = dr[0].ToString();
                }
                if (dr[1].ToString() != "")
                {

                    Right = dr[1].ToString();
                }
            }
            con.Close();
        }

        public DataTable fillUserDetail(string apid)
        {
            DataTable ufill = new DataTable();
            da = new SqlDataAdapter("select username,joinside,lleg,rleg from demoTable where userid='" + apid + "'", con);
            da.Fill(ufill);
            return ufill;

        }

}

Finally your tree will look like this at runtime