DataBase Connection C# Simple Programming

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
using System.IO;

namespace Prodectbaseproject
{
  
    public partial class Login : Form
    {
        DAL Obj = new DAL();

        public Login()
        {
            InitializeComponent();
        }

        private void btnsubmit_Click(object sender, EventArgs e)
        {
            string radio = "";
            if (radfemale.Checked == true )
            {
                radio = "F";
            }
            else if (radmale.Checked == true)
            {
                radio = "M";
            }
            string category = "";
            if (Chkgenral.Checked == true)
            {
                category = "Genral";
            }
            else if (chkother.Checked == true)
            {
                category = "Other";
            }
            string str = "UserDetails_sp 'I','','" + txtname.Text + "','" + txtmailid.Text + "','" + combocity.Text + "','" + category + "','" + radio + "','" + picimage.ImageLocation + "','"+Convert.ToDateTime(dateTimePicker1 .Value.ToShortDateString ()) +"'";
            Obj.insertfun(str);
        }

        private void btnphoto_Click(object sender, EventArgs e)
        {
            OpenFileDialog openimage = new OpenFileDialog();
            openimage.Filter = "JPG|*.jpg|GIF|*.gif|PNG|*.png|BMP|*.bmp";
            if (DialogResult.OK == openimage.ShowDialog())
            {
                txtphoto.Text = openimage.FileName;
                btnphoto.Enabled = true;
                picimage.ImageLocation = openimage.FileName;
                picimage.SizeMode = PictureBoxSizeMode.StretchImage;


            }
            else
            {
                MessageBox.Show("Select File");
            }

        }
    }
}

View Page

  private void btnshow_Click(object sender, EventArgs e)
        {
            string str = "select * from crtWaiter where name ='" +cmbwaitername .Text+ "'";
            DataTable dt = new DataTable();
            dt = Obj.getdata(str);
            if (dt.Rows.Count > 0)
            {
                pictureBox1.ImageLocation = dt.Rows[0]["wtr_image"].ToString();
                txtsalary.Text = dt.Rows[0]["salary"].ToString();
                txtmobileno.Text = dt.Rows[0]["mobile_no"].ToString();
                txtdate.Text = dt.Rows[0]["Date"].ToString();
            }
        }

        private void WaitersProfile_Load(object sender, EventArgs e)
        {
            string str1 = "select name,Id from crtWaiter";
            Obj.fillcombo(cmbwaitername, "name", "Id", str1);
           
        }

Edit,Delete Record

public partial class crtstaff : Form
    {
        DAL Obj = new DAL();
        public crtstaff()
        {
            InitializeComponent();
        }
        AutoCompleteStringCollection nameCollection = new AutoCompleteStringCollection();
        private void save1_Click(object sender, EventArgs e)
        {

            try
            {

                if (save1.Text == "Save")
                {
                    if (stfname.Text == "" ||stfpost .Text ==""|| stfadd .Text =="" ||stfmobile .Text =="" || stfsal .Text =="")
                    {
                        MessageBox.Show("Enter the Employee Record");

                    }
                    else
                    {
                        //string constring = "Data Source=localhost\\SQLEXPRESS;Initial Catalog=bar_db;Integrated Security=True";
                        //SqlConnection con = new SqlConnection(constring);
                        string cmdstring = "insert into crtstaff (stfname,post,address,mobile_no,salary,Date) values( '" + stfname.Text + "','" + stfpost.Text + "', '" + stfadd.Text + "', '" + stfmobile.Text + "', '" + stfsal.Text + "','"+Convert .ToDateTime (dateTimePicker1 .Value .ToShortDateString())+"') ";
                        Obj.Inserfun(cmdstring);
                       // SqlCommand cmd = new SqlCommand(cmdstring, con);
                        //con.Open();
                       // cmd.ExecuteNonQuery();
                        MessageBox.Show("New Staff Member has  Been Added");
                        //con.Close();
                        this.Close();


                        stfpost.Text = "";
                        stfadd.Text = "";
                        stfmobile.Text = "";
                        stfsal.Text = "";

                        this.Hide();
                    }
                }
                else if (save1.Text == "Update")
                {

                    //string constring = "Data Source=localhost\\SQLEXPRESS;Initial Catalog=bar_db;Integrated Security=True";
                    //SqlConnection con = new SqlConnection(constring);
                    string cmdstring = "update crtstaff  set  post = '" + stfpost.Text + "' , address = '" + stfadd.Text + "' , mobile_no = '" + stfmobile.Text + "' ,  salary = '" + stfsal.Text + "',Date='" + Convert.ToDateTime(dateTimePicker1.Value.ToShortDateString()) + "' where stfname ='" + stfname.Text + "'";

                    Obj.Updatefun(cmdstring);
                    //SqlCommand cmd = new SqlCommand(cmdstring, con);
                    //con.Open();
                    //cmd.ExecuteNonQuery();
                    MessageBox.Show("Staff Member has  Been Updated ");
                   // con.Close();
                   

                    stfpost.Text = "";
                    stfadd.Text = "";
                    stfmobile.Text = "";
                    stfsal.Text = "";
                    save1.Enabled = false;
                    edit2.Enabled = true;
                   this.Close();
                }

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

        private void crtstaff_Load(object sender, EventArgs e)
        {
            string constring2 = "Data Source=localhost\\SQLEXPRESS;Initial Catalog=bar_db;Integrated Security=True";
            SqlConnection con2 = new SqlConnection(constring2);
            string cmdstring2 = "select distinct stfname from crtstaff order by stfname";
            SqlCommand cmd2 = new SqlCommand(cmdstring2, con2);
            SqlDataReader dr2;
            con2.Open();
        
            dr2 = cmd2.ExecuteReader();
            if (dr2.HasRows == true)
            {
                while (dr2.Read())
                {
                    nameCollection.Add(dr2["stfname"].ToString());

                }
            }

            dr2.Close();

            stfname.AutoCompleteMode = AutoCompleteMode.Suggest;
            stfname.AutoCompleteSource = AutoCompleteSource.CustomSource;
            stfname.AutoCompleteCustomSource = nameCollection;
                      

        }

        private void stfname_TextChanged(object sender, EventArgs e)
        {
            string constring2 = "Data Source=localhost\\SQLEXPRESS;Initial Catalog=bar_db;Integrated Security=True";
            SqlConnection con2 = new SqlConnection(constring2);
            string cmdstring2 = "select  stfname,post,address,mobile_no,salary from crtstaff where stfname = '" + stfname.Text + " ' ";
           SqlCommand cmd2 = new SqlCommand(cmdstring2, con2);
            SqlDataReader dr2;
            con2.Open();
           dr2 = cmd2.ExecuteReader();

            while (dr2.Read())
            {
                if (stfname.Text == dr2["stfname"].ToString())
                {

                    stfpost.Text = dr2["post"].ToString();
                    stfadd.Text = dr2["address"].ToString();
                    stfmobile.Text = dr2["mobile_no"].ToString();
                    stfsal.Text = dr2["salary"].ToString();


                    stfpost.Enabled = false;
                    stfadd.Enabled = false;
                    stfmobile.Enabled = false;
                    stfsal.Enabled = false;
                  

                }
                else
                {  
                    stfpost.Text = "";
                    stfadd.Text = "";
                    stfmobile.Text = "";
                    stfsal.Text = "";
                    save1.Text = "Save";

                    stfpost.Enabled = true;
                    stfadd.Enabled = true;
                    stfmobile.Enabled = true;
                    stfsal.Enabled = true;

                    save1.Enabled = true;
                    edit2.Enabled = false;
                }
            }
        }

        private void candel3_Click(object sender, EventArgs e)
        {
            this.Close();
        }

        private void edit2_Click(object sender, EventArgs e)
        {
            try
            {

                stfname.Enabled = true;
                stfpost.Enabled = true;
                stfadd.Enabled = true;
                stfmobile.Enabled = true;
                stfsal.Enabled = true;

                save1.Enabled = true;
                edit2.Enabled = false;
                save1.Text = "Update";



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

        private void Delete_Click(object sender, EventArgs e)
        {

            //string constring = "Data Source=localhost\\SQLEXPRESS;Initial Catalog=bar_db;Integrated Security=True";
           // SqlConnection con = new SqlConnection(constring);
            string cmdstring = "delete from crtstaff where stfname = '" + stfname.Text + "'  ";
            Obj.Deletefun(cmdstring);          
           // SqlCommand cmd = new SqlCommand(cmdstring, con);
            //con.Open();
           // cmd.ExecuteNonQuery();
            MessageBox.Show("Staff Member has  Been Deleted ");
          //  con.Close();
            this.Close();
        }
    }
}

Online Exam Page

public partial class QuestionMaster : System.Web.UI.Page
{
    int optionid;
    DAl obj = new DAl();
    int rec;

    protected void Page_Load(object sender, EventArgs e)
    {
        string strgetsubid;
        if (!IsPostBack)
        {
            strgetsubid = Session.Contents["subjectid"].ToString();
            if (strgetsubid == null)
            {
                lblerror.Visible = true;
                lblerror.Text = "Please select subject";
                Response.Redirect("subjectlist.aspx");
                lblerror.Visible = false;
            }
            else
            {
                obj.sqlstr = "select top 20 uniqid,Sno,question,option1,option2,option3,option4,answer,maxmark,explanation from questionmaster7 where f_subjectmaster7='" + strgetsubid + "'";
                obj.dt = obj.getdata(obj.sqlstr);
                obj.dt.Columns.Add("ans");
                obj.dt.Columns.Add("bookmark");
                foreach (DataRow dr in obj.dt.Rows)
                {
                    dr["ans"] = 0;
                    dr["bookmark"] = 0;
                }

                Session["table"] = obj.dt;
                showdata(0);
                Session["recs"] = 0;
                rec = 0;

            }

        }
        else
        {
            obj.dt = (DataTable)Session["table"];
    }
  
        rec = Convert.ToInt32(Session["recs"]);
    }

    protected void btnmovefirst_Click(object sender, EventArgs e)
    {
        rec = 0;
        Session["recs"] = rec;
        showdata(rec);
    }
    void showdata(int recs)
    {
        try
        {
            lblqun .Text = Convert.ToString (recs + 1);
            lblquen .Text = obj.dt.Rows[recs]["question"].ToString();
            rdbtnoption1.Text = obj.dt.Rows[recs]["option1"].ToString();
            rdbtnoption2.Text = obj.dt.Rows[recs]["option2"].ToString();
            rdbtnoption3.Text = obj.dt.Rows[recs]["option3"].ToString();
            rdbtnoptin4.Text = obj.dt.Rows[recs]["option4"].ToString();
            try
            {
                optionid = Convert.ToInt32(obj.dt.Rows[recs]["ans"].ToString());
                if (Convert.ToInt32(obj.dt.Rows[recs]["bookmark"].ToString()) == 1)
                {
                    chkbox.Checked = true;
                }
                else
                {
                    chkbox.Checked = false;
                }
              
                    if (optionid == 1)
                    {

                        rdbtnoption1.Checked = true;
                    }
                    else if (optionid == 2)
                    {
                        rdbtnoption2.Checked = true;
                    }
                    else if (optionid == 3)
                    {
                        rdbtnoption3.Checked = true;
                    }
                    else if (optionid == 4)
                    {
                        rdbtnoptin4.Checked = true;
                    }
            }
            catch (Exception ex)
            {
            }
        }
          
        catch (Exception ex)
        {
            lblerror.Text = "not at position";
        }
    }
  
    protected void btnmovelast_Click(object sender, EventArgs e)
    {

        rec = obj.dt.Rows.Count - 1;
        Session["recs"] = rec;
        showdata(rec);

    }
    public void saveans()
    {
        rec = Convert.ToInt32(Session["recs"]);
        obj.dt = (DataTable)Session["table"];
        obj.dt.Rows[rec]["ans"] = optionid;
        if (chkbox.Checked == true)
        {
            obj.dt.Rows[rec]["bookmark"] = 1;

        }
        else
        {
            obj.dt.Rows[rec]["bookmark"] = 0;
        }
        setbuttoncolor(rec);
        Session["table"] = obj.dt;
    }
    protected void btnmovenext_Click(object sender, EventArgs e)
    {
       savecurrentvalue();
        rec = Convert.ToInt32(Session["recs"]);
        rec = rec + 1;
        Session["recs"] = rec;
        showdata(rec);

    }
    public void setbuttoncolor(int id)
    {
        DataTable dt = (DataTable)Session["table"];
        if (dt.Rows[id]["bookmark"].ToString() == "1" && Convert.ToInt32(dt.Rows[id]["ans"].ToString())!= 0)
        {
            setcolor (id,System .Drawing .Color .Blue );
        }
        if(dt.Rows [id]["bookmark"].ToString ()=="0" && Convert .ToInt32 (dt.Rows [id]["ans"].ToString ()) == 0)
        {
            setcolor (id,System .Drawing .Color .Red );
        }
        if (dt.Rows[id]["bookmark"].ToString ()=="1" && Convert .ToInt32 (dt.Rows [id]["ans"].ToString ()) == 0)
        {
            setcolor (id,System .Drawing .Color .Yellow );
        }
      
            if(dt.Rows [id]["bookmark"].ToString ()=="0" && Convert .ToInt32 (dt.Rows [id]["ans"].ToString ())!= 0)
        {
            setcolor (id,System .Drawing .Color .Green );

        }
    }
 
    public void setcolor(int id, System.Drawing.Color color)
    {
        switch (id)
        {
            case 0: Lbtn1.BackColor = color;
                break;
            case 1: Lbtn2.BackColor = color;
                break;
            case 2: Lbtn3.BackColor = color;
                break;
            case 3: Lbtn4.BackColor = color;
                break;
            case 4: Lbtn5.BackColor = color;
                break;
            case 5: Lbtn6.BackColor = color;

                break;
            case 6: Lbtn7.BackColor = color;

                break;
            case 7: Lbtn8.BackColor = color;
                break;
            case 8: Lbtn9.BackColor = color;

                break;
            case 9: Lbtn10.BackColor = color;
                break;
            case 10: Lbtn11.BackColor = color;
                break;
            case 11: Lbtn12.BackColor = color;
                break;
            case 12: Lbtn13.BackColor = color;
                break;
            case 13: Lbtn14.BackColor = color;
                break;
            case 14: Lbtn15.BackColor = color;
                break;
            case 15: Lbtn16.BackColor = color;
                break;
            case 16: Lbtn17.BackColor = color;
                break;
            case 17: Lbtn18.BackColor = color;
                break;
            case 18: Lbtn19.BackColor = color;
                break;
            case 19: Lbtn20.BackColor = color;
                break;
            default:
                break;
        }
    }

    private void id(string qid)
    {
        obj.dt.Rows[rec]["ans"] = qid.ToString();
    }

    protected void btnmoveperious_Click(object sender, EventArgs e)
    {
        savecurrentvalue();
        rec = Convert.ToInt32(Session["recs"]);
        rec = rec - 1;
        Session["recs"] = rec;
        if (rec < 0)
        {
            return;
        }
        else
        {
            unselect();          
            showdata(rec);

        }
    }
public void unselect()
{
    rdbtnoption1.Checked = false;
    rdbtnoption2 .Checked =false ;
    rdbtnoption3 .Checked =false ;
    rdbtnoptin4 .Checked =false ;
}
    protected void Lbtn2_Click(object sender, EventArgs e)
    {
        savecurrentvalue();
        rec = 1;
        Session["recs"] = rec;
        showdata(rec);
}

    private void savecurrentvalue()
    {
        if (rdbtnoption1.Checked == true)
        {
            optionid = 1;
        }
        else if (rdbtnoption2.Checked == true)
        {
            optionid = 2;
        }
        else if (rdbtnoption3.Checked == true)
        {
            optionid = 3;

        }
        else if (rdbtnoptin4.Checked == true)
        {
            optionid = 4;
        }
        saveans();
        unselect();
    }

 protected void Lbtn1_Click(object sender, EventArgs e)
    {
        savecurrentvalue();
        rec = 0;
        Session["recs"] = rec;
        showdata(rec);
    }

    protected void Lbtn3_Click(object sender, EventArgs e)
    {
savecurrentvalue();

        rec = 2;
        Session["recs"] = rec;
        showdata(rec);

          
    }
    protected void Lbtn4_Click(object sender, EventArgs e)
    {
        savecurrentvalue();
        rec = 3;
        Session["recs"] = rec;
        showdata(rec);

    }
    protected void Lbtn5_Click(object sender, EventArgs e)
    {
        savecurrentvalue();
        rec = 4;
        Session["recs"] = rec;
        showdata(rec);

    }
    protected void Lbtn6_Click(object sender, EventArgs e)
    {
        savecurrentvalue();
        rec = 5;
        Session["recs"] = rec;
        showdata(rec);

    }
    protected void Lbtn7_Click(object sender, EventArgs e)
    {
        savecurrentvalue();
        rec = 6;
        Session["recs"] = rec;
        showdata(rec);

    }
    protected void Lbtn8_Click(object sender, EventArgs e)
    {
        savecurrentvalue();
        rec = 7;
        Session["recs"] = rec;
        showdata(rec);
    }
    protected void Lbtn9_Click(object sender, EventArgs e)
    {
        savecurrentvalue();
        rec = 8;
        Session["recs"] = rec;
        showdata(rec);

    }
    protected void Lbtn10_Click(object sender, EventArgs e)
    {
        savecurrentvalue();
        rec = 9;
        Session["recs"] = rec;
        showdata(rec);

    }
    protected void Lbtn11_Click(object sender, EventArgs e)
    {
        savecurrentvalue();
        rec = 10;
        Session["recs"] = rec;
        showdata(rec);

    }
    protected void Lbtn12_Click(object sender, EventArgs e)
    {
        savecurrentvalue();
        rec = 11;
        Session["recs"] = rec;
        showdata(rec);

    }
    protected void Lbtn13_Click(object sender, EventArgs e)
    {
        savecurrentvalue();
        rec = 12;
        Session["recs"] = rec;
        showdata(rec);

    }
    protected void Lbtn14_Click(object sender, EventArgs e)
    {
        savecurrentvalue();
        rec = 13;
        Session["recs"] = rec;
        showdata(rec);

    }
    protected void Lbtn15_Click(object sender, EventArgs e)
    {
        savecurrentvalue();
        rec = 14;
        Session["recs"] = rec;
        showdata(rec);

    }
    protected void Lbtn16_Click(object sender, EventArgs e)
    {
        savecurrentvalue();
        rec = 15;
        Session["recs"] = rec;
        showdata(rec);

    }
    protected void Lbtn17_Click(object sender, EventArgs e)
    {
        savecurrentvalue();

        rec = 16;
        Session["recs"] = rec;
        showdata(rec);

    }
    protected void Lbtn18_Click(object sender, EventArgs e)
    {
        savecurrentvalue();

        rec = 17;
        Session["recs"] = rec;
        showdata(rec);

    }
    protected void Lbtn19_Click(object sender, EventArgs e)
    {
        savecurrentvalue();
        rec = 18;
        Session["recs"] = rec;
try
{

        showdata(rec);          
    }
        catch (Exception ex)
        {
            lblerror.Text = "Record is not found";
        }
    }
    protected void Lbtn20_Click(object sender, EventArgs e)
    {
        savecurrentvalue();
        rec = 19;
        Session["recs"] = rec;
showdata(rec);

    

    }

    protected void btnExamend_Click(object sender, EventArgs e)
    {
        int totalmarks = 0;
        foreach (DataRow dr in obj.dt.Rows)
        {
            if (Convert.ToInt32(dr["answer"]) == Convert.ToInt32(dr["ans"]))
            {
                totalmarks += 1;
            }
        }
        lblMark .Text = totalmarks.ToString();
    Session ["totalmarks"]=totalmarks;
    Response .Redirect("Exam Result.aspx");
      
    }
}

Online Exam Subject Insert

public partial class Subjectlist : System.Web.UI.Page
{
    string strsubid;
    DAl obj = new DAl();
    DataTable dt = new DataTable();



    protected void Page_Load(object sender, EventArgs e)
    {
        if (!(IsPostBack))
        {
            string strsub = "select uniqid,subjectname from subjectmaster7 order by subjectname";
            dt = obj.getdata(strsub);
            for (int i = 0; i <= dt.Rows.Count - 1; i++)
            {
                rdobtnlist.Items.Add(dt.Rows[i]["subjectname"].ToString());
            }
        }

    }
    protected void btnsubmit_Click(object sender, EventArgs e)
    {
        DataTable dt = new DataTable();
        obj.sqlstr = "select distinct s.uniqid,subjectname from subjectmaster7 s inner join questionmaster7 q on q.f_subjectmaster7 = s.uniqid where subjectname='" + rdobtnlist.SelectedItem.Text + "'";
        dt = obj.getdata(obj.sqlstr);
        if (dt.Rows.Count > 0)
        {
            strsubid = dt.Rows[0]["uniqid"].ToString();
            Session.Add("subjectid", strsubid);
                Response.Redirect("QuestionMaster.aspx");
        }
        else
        {
           Label2 .Text = "Question not Found";
        
        }
    }
    protected void rdobtnlist_SelectedIndexChanged(object sender, EventArgs e)
    {

    }
}

Site Search

asp:LinkButton runat="server" ID="lbl_name" Text='<%#Eval("Name")%>' CommandArgument='<%#Eval("PK_ID")%>' OnCommand="lbl_name_Command">

Site Search

C# Code

public partial class FindMatch : System.Web.UI.Page
{
    DAL dal = new DAL();
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["Visiter"] == null)
        {
            Response.Redirect("LogIn.aspx");
        }

        Page.Header.Title = "Find Match";
    }

    protected void btn_search_Click(object sender, EventArgs e)
    {
        string[] str=txt_search.Text.Split(' ');

        DataTable dt = dal.GetDataTable("FindmatchWithname '"+str[0]+"'");
        for (int i = 1; i < str.Length; i++)
        {
           dt.Merge(dal.GetDataTable("FindmatchWithname '"+str[0]+"'"));
        }
        grd_searchresult.DataSource = dt;
        grd_searchresult.DataBind();
    }

    protected void lbl_name_Command(object sender, CommandEventArgs e)
    {
        Session["Owner"] = e.CommandArgument.ToString();
        Response.Redirect("VisitorHome.aspx");
    }
}

New DAL Class

using System;
using System.Data;
using System.Configuration;
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;

///

/// Summary description for DAL
///

    public class DAL
    {
        SqlConnection con;
        SqlCommand cmd;
        SqlDataAdapter sda;
        String ConString;


        public DAL()
        {
            ConString = ConfigurationManager.ConnectionStrings["ConnString"].ConnectionString;
            con = new SqlConnection(ConString);
        }

        public void ConnectionOpen()
        {
            if (con.State == ConnectionState.Closed)
            {
                con.Open();
            }
        }
        public void ConnectionClose()
        {
            if (con.State == ConnectionState.Open)
            {
                con.Close();
            }
        }


        public DataTable GetDataTable(String query)
        {
            sda = new SqlDataAdapter(query, con);
            DataTable dt = new DataTable();
            sda.Fill(dt);
            return dt;
        }





        public int PutData(String query)
        {
            cmd = new SqlCommand();
            cmd.CommandText = query;
            cmd.Connection = con;

            con.Open();
            int a = cmd.ExecuteNonQuery();
            con.Close();
            return a;
        }

        public string ExecuteScaler(String query)
        {
            cmd = new SqlCommand();
            cmd.CommandText = query;
            cmd.Connection = con;

            con.Open();
            string s = Convert.ToString(cmd.ExecuteScalar());
            con.Close();

            return s;
        }


        public void FillCombo(DropDownList ddl, String query, String item, String Value, String ZerothElemnt, int SelectedIndex)
        {
            DataTable dt = new DataTable();
            dt = GetDataTable(query);
            ddl.DataSource = dt;
            ddl.DataTextField = item;
            ddl.DataValueField = Value;
            ddl.DataBind();
            ddl.Items.Insert(0, ZerothElemnt);
            ddl.SelectedIndex = SelectedIndex;
        }


        public void FillCombo(DropDownList ddl, String query, String item, String Value, int SelectedIndex)
        {
            DataTable dt = new DataTable();
            dt = GetDataTable(query);
            ddl.DataSource = dt;
            ddl.DataBind();
            ddl.SelectedIndex = SelectedIndex;
        }


        public void FillGrid(GridView grd, String query)
        {
            DataTable dt = new DataTable();
            dt = GetDataTable(query);
            grd.DataSource = dt;
            grd.DataBind();
        }

        public void FillDetailView(DetailsView dv, String query)
        {
            DataTable dt = new DataTable();
            dt = GetDataTable(query);
            dv.DataSource = dt;
            dv.DataBind();
        }
-----------------------------------------------
  public void Fillcombo(System.Windows.Forms.ComboBox cmbo, string display, string value, string sqlstr)
        {
            DataTable dtcombo = new DataTable();
            myconnection();
            cmd.CommandText = sqlstr;
            cmd.Connection = con;
            cmd.CommandType = CommandType.Text;
            adp.SelectCommand = cmd;
            adp.Fill(dtcombo);
            cmbo.DataSource = dtcombo;
            cmbo.ValueMember = dtcombo.Columns[value].ToString();
            cmbo.DisplayMember = dtcombo.Columns[display].ToString();

        }

        public void Deletefun(string qry)
        {
            myconnection();
            cmd.Connection = con;
            cmd.CommandText = qry;
            cmd.CommandType = CommandType.Text;
            adp.DeleteCommand  = cmd;
            cmd.ExecuteNonQuery();
            //adp.InsertCommand.ExecuteNonQuery();
        }



        public void Updatefun(string qry)
        {
            myconnection();
            cmd.Connection = con;
            cmd.CommandText = qry;
            cmd.CommandType = CommandType.Text;
            adp.UpdateCommand  = cmd;
            cmd.ExecuteNonQuery();
            //adp.InsertCommand.ExecuteNonQuery();
        }


        public DataTable  FindFun(string qry)
        {
            dt.Clear();
            myconnection();
            cmd.Connection = con;
            cmd.CommandText = qry;
            cmd.CommandType = CommandType.Text;
            adp.SelectCommand = cmd;
            adp.Fill(dt);
            return dt;

        }


    }

Bishnoi Samaj website

www.bishnoisamaj.com