private string parseinput(string str)
    {
        
        Boolean boolvalue;
        Int32 intvalue;
        float realvalue;
        DateTime datevalue;
        Guid guidvalue;
        if (Boolean.TryParse(str, out boolvalue))
            return "bit";
        else if (Int32.TryParse(str, out intvalue))
            return "int";
        else if (float.TryParse(str, out realvalue))
            return "real";
        else if (DateTime.TryParse(str, out datevalue))
            return "datetime";
        else if (Guid.TryParse(str, out guidvalue))
            return "Guid";
        else
            return "nvarchar";
       
    }

        private void searchdb()
        {
            listBox3.Items.Clear();
            int tablecount = comboBox1.Items.Count;
            for(int i=0; i<tablecount; i++)
            {
                comboBox1.SelectedIndex = i;
                int columncount = listBox1.Items.Count;
                for(int j=0; j < columncount; j++)
                {
                    listBox1.SelectedIndex = j;
                    listBox2.SelectedIndex = j;
                    string tablename = comboBox1.SelectedItem.ToString();
                    string columnname = listBox1.SelectedItem.ToString();
                    string datatype = parseinput(textBox1.Text.ToString());
                    if(listBox2.SelectedItem.ToString( )== datatype)
                    {
                        if (datatype != "int")
                        {
                            cmd.CommandText = "select " + columnname.ToString() + " from " + tablename.ToString() + " where " + columnname.ToString() + " Like '%" + textBox1.Text.ToString() +"%'";
                        }
                        if(datatype == "Guid")
                        {
                            cmd.CommandText = "select " + columnname.ToString() + " from " + tablename.ToString() + " where " + columnname.ToString() + "='" + textBox1.Text.ToString() +"'";
                        }
                         cn.Open();
                         dr = cmd.ExecuteReader();
                if (dr.HasRows)
                {
                    while (dr.Read())
                    {
                        listBox3.Items.Add(dr[0].ToString()+" Column Name:"+columnname.ToString()+"From Table:"+tablename.ToString());
                        Application.DoEvents();
                        listBox4.Items.Add(cmd.CommandText.ToString());
                    }

                }
                cn.Close();